PHP - INSERT using multiple SELECT statements with MySQL

[chris]

Hey thanks for the reply. I've often wondered whether the vars held actual values or just true/false as you mentioned.
I tried adapting your idea on the $P (Played) variable as follows:

$GetP = mysql_query("SELECT COUNT(team_name) FROM performance WHERE team_name='Avengers'");
$row = mysql_fetch_object($GetP);
$P = $row->played;

However on the last line ($P = $row->played;) it seem doesn't to like it, showing the following error message:

Undefined property: stdClass::$played

When I saw this I tried using it on the $ID var and it had the same affect.

Also I should mention that it is still inserting values as 0.

[chris]

Hi there, I realised I was being a bit of a noob. It wasn't working because I was taking the last line exactly (e.g. $ID = $row->team_id;) instead i replaced it with $GF = $row['SUM(goals_scored)']; (from the Goals For query).

As soon is I changed it the query works fine every time it was exactly how you said the queiries weren't holding any values.

Any way thanks a lot for all your help it is very much appreciated, now I will be able to continue programming and use this in future queries.

[PhPHelper]

excellent glad you got it working, I missed that as well