What's wrong with this PHP Line??

[Padgoi]

<code><?php

if(isset($_SESSION["user"]) and isset($_SESSION["userid"]))

{

 

  $q2="select * from profiles where usId='$id' order by id asc";

  $res2=mysql_query($q2);

  $comic=mysql_fetch_array($res2);

  $title=$comic['title'];

  $maintitle=$title;

  $author=$comic['creator'];

  $authors="<a href=?u=$author>$author</a>";

  $imagesrc=$comic['file'];

 

  $key=$comic['usId'];

  $i=1;

  while($comic=mysql_fetch_array($res2)){

    $title=$comic['title'];

    $author=$comic['creator'];

    $imagesrc=$comic['file'];

    $id=$comic['usId'];

$authors.=", <a href=?u=$author>$author</a>";

$i++;

 

 

echo '<td><A HREF\="prof_comments.php?uid=$id\" target=\"new\">View/Add Comments</A></td>';

}}

 

?>

</code>

 

I keep getting an error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /html/testmates/friend_info.php on line 133

 

133 -  $comic=mysql_fetch_array($res2);

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /html/testmates/friend_info.php on line 142

 

142 -  while($comic=mysql_fetch_array($res2)){

[cooldude832]

select should be SELECT from should be FROM where shoudl be WHERE order by should be ORDER by asc should be ASC, also if it is returning 0 results it will fail on the fetch

[teng84]

pls if theres an error include the error

[Padgoi]

Ok, so I added this code:

 

          <td>Comments</td>
<?php

  $res2=mysql_query('SELECT * FROM users WHERE usID="'.$_GET['uid'].'"');
  $comic=mysql_fetch_array($res2);

  
  $key=$comic['uid'];
  $i=1;
  while($comic=mysql_fetch_array($res2)){
    $id=$comic['uid'];

?>
    <td><A HREF="prof_comments.php?uid=<?PHP echo $id; ?> target="new">View/Add Comments</a></td>

<?php

}

?>

 

Why isn't the a href function displaying at all?

[Shaned145]

cause its still in the PHP code. Change it to:

 

<?php

 

}

 

?>

    <td><A HREF="prof_comments.php?uid=<?PHP echo $id; ?> target="new">View/Add Comments</a></td>

 

EDIT:

Oh wait...hmmm...I dont know

[cooldude832]

cause u didn't close the logical while function

[neel_basu]

Use

$res2=mysql_query($q2) or die(mysql_error());