weird error

[loureiro]

ok here is my code:

//build client select
    $sqlHousehold = "SELECT `homePhone`,
                            `childrenNo`,
					        `smoking`,
					        `babysitter`
			         FROM `household` WHERE `clientNo` = $clientNo OR `clientNo2` = $clientNo";

//run query
$result = mysql_query( $sqlHousehold, $connection ) or die( "SQL household query error: ".mysql_error() );

and this is the error i get:

SQL household query error:

it doesnt give me an error at all. I've already tried echoing the query to the screen and running the query manually and it works. so it isnt anything with the query itself. can anyone help?

[loureiro]

[01-Sep-2004 16:03:17] PHP Warning: mysql_query(): 7 is not a valid MySQL-Link resource in C:\apache2triad\htdocs\php_functions\edit.php on line 92

i checked the error log...that is what it says

[gufmn]

Sounds like it has something to to with $connection and it not actually making a connection. Which would explain why you're not getting any mysql errors back.

How do you create $connection? Code?

[loureiro]

$connection = mysql_connect( $DBHostName, $DBUsername, $DBPassword ) or die( "SQL connect error: ".mysql_error() );

i know its not the connection because when i take out the connection from the query call it returns a cannot connect to database error.

[Weedpacket]

How many database connections do you have open? If it's just the one, try just using mysql_query($sqlHousehold).

What is the value of $connection immediately before the mysql_query() call (and immediately after the mysql_connect() call)? Should be a resource number (obviously, the same one both times).