Having trouble with mysql_result

[Anon]

$result1 = mysql_query("SELECT * FROM webportfolio where ID = $student AND i = $project",$db);

    $title = mysql_result($result1,0,"title");
    $description = mysql_result($result1,0,"description");
    $class = mysql_result($result1,0,"class");
    $datestarted = mysql_result($result1,0,"datestarted");
    $dateended = mysql_result($result1,0,"dateended");
    $img1 = mysql_result($result1,0,"img1");
    $links = mysql_result($result1,0,"links");
    $project = mysql_result($result1,0,"project");

With this code I get: Warning Supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\portfolios\projectsweb2.php on line 11

their is data in result1 so why is mysql_result giving me this error thank you

Damian

[haji_hill]

I'm just giving this a shot but you might want to try it....

I think you may need to use the mysql_free_result() function in between fetches, but honestly I would recommend using the mysql_fetch_array(), the mysql_fetch_row(), or the mysql_fetch_object() function for much better results.

I hope this helps, take care,
-Haji

[Anon]

Try changing your code to this:

$result1 = mysql_query("SELECT * FROM webportfolio where ID = '$student' AND i = '$project'",$db);

$row = mysql_fetch_array($result1);
// Now you have access to the fields via an array called row
// to access the "title", use this:
echo $row['title'];
// and "class" is now accessed by:
echo $row['class'];
// and so on...

John Cornett