[SOLVED] supplied argument not valid

[localhost1]

hi everybody

i have a problem in the sql query. my query is this

 

$sSqlQuery="select user_reserve_time_start,user_reserve_time_end,user_reserve_date from voyance_user WHERE user_id= '".$u_id."' and user_reservetype='Domicile Reservation'";
$row=mysql_query($sSqlQuery);
				  while($rest=mysql_fetch_array($row))
				  {
				  	$start_time=$rest['reserve_time_start'];
					$end_time=$rest['reserve_time_end'];
					$reserve_date=$rest['reserve_date'];
					echo $reserve_date;
				  }

 

where is the error in the query.

[trq]

What error are you getting?

[dingus]

just a question this part here

 

WHERE user_id= '".$u_id."'

 

im just thinking that it may be looking for a user id in the database of

"4" for example why are you opening quotes then escaping them

 

only asking because user ids are usually auto numbers an can throw that kind of error when asking for a text field (something containing quotes"")

[localhost1]

i m getting the following errror

 

 

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\wamp\www\directory\filename.php on line 176

[dingus]

well i would say this line here is falling over

$row=mysql_query($sSqlQuery);

 

because $row is being not containing the data you want it to

 

try changeing

 

WHERE user_id= '".$u_id."'

 

to

 

WHERE user_id= $u_id

 

and see if that helps