[SOLVED] WHILE error

[onthespot]

Can anyone see the problem here...

 

$name=mysql_real_escape_string($_GET['comp']);
$res=mysql_query("SELECT * FROM leaguecomments WHERE comp_name = '$name' ORDER BY date DESC");

while($row=mysql_fetch_assoc($res)){

$user=$row['user'];
$comment=$row['comment'];
$commentdate=$row['date'];
           
$date=strtotime($commentdate);
$final_date=date("g:i a", $date);  
$final_date2=date("F j Y", $date);

 

mysql_fetch_assoc(): supplied argument is not a valid MySQL

 

I can't work it out?

[TeNDoLLA]

Probably your mysql_query is failing add mysql_error to see if thats the case:

$res=mysql_query("SELECT * FROM leaguecomments WHERE comp_name = '$name' ORDER BY date DESC") or die(mysql_error());

[watsmyname]

Can anyone see the problem here...

 

$name=mysql_real_escape_string($_GET['comp']);
$res=mysql_query("SELECT * FROM leaguecomments WHERE comp_name = '$name' ORDER BY date DESC");

while($row=mysql_fetch_assoc($res)){

$user=$row['user'];
$comment=$row['comment'];
$commentdate=$row['date'];
           
$date=strtotime($commentdate);
$final_date=date("g:i a", $date);  
$final_date2=date("F j Y", $date);

 

mysql_fetch_assoc(): supplied argument is not a valid MySQL

 

I can't work it out?

might be your query returned 0 record, you should check whether there are any records or not and if there are records then use loop to display.

[onthespot]

Sorry was a simple error, sorted