result resource

[nhwaldron]

Here is what I am trying to do. On one page I want a list of links that, when clicked, will query my database and fill the information in a form for update.

On my first page (which works) I have this:

<A HREF='./getbioinfo.php?bio_id=$myrow[id]'>$myrow[name]</A>

On my second page I have this:

$strQUERY = "SELECT * FROM bios where id=$HTTP_POST_VARS[bio_id]";

$result = mysql_query($strQUERY, $db);

$myeditrow = mysql_fetch_array($result);

//--while--used for search purposes ONLY

echo"<TABLE BORDER='0' CELLPADDING='2' CELLSPACING='2'>";
        echo"<TR>";
                echo"<TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD>";
        echo"</TR>";
        echo"<TR>";
                echo"<TD>&nbsp;</TD>\n<TD VALIGN='TOP'>";
                echo"<!-- IMAGE GOES HERE -->";
                echo"<IMG SRC='../images/$myeditrow[img]' WIDTH='75'>";
                echo"</TD>";
                echo"<TD>";
                echo"<!-- BIO INFO GOES HERE -->";
                       echo"<FORM ACTION='updatebio.php?bio_id=$myeditrow[id]'>";
                        echo"<TABLE BORDER='0' CELLPADDING='0' CELLSPACING='0'>";
                                echo"<TR>";
                                        echo"<TD>";
                                        echo"<INPUT SIZE='15' NAME='name' VALUE=$myeditrow[name]>";
                                        echo"<INPUT SIZE='15' NAME='title' VALUE=$myeditrow[title]>";
                                        echo"</TD>";
                                echo"</TR>";

I have getting an "not a valid MySQL result resouce on the "$myeditrow = ..." line.

Any suggestions?

THANKS in advance!

[nhwaldron]

Oh, just in case, the rest of the code on my 2nd page works...just didn't want to dump too much stuff....

[[deleted]]

Most likely your query is just wrong, try checking for errors when you run a query:

<?
$strQUERY = "SELECT * FROM bios where id=$HTTP_POST_VARS[bio_id]";

if (!$result = mysql_query($strQUERY, $db))
{
// Query not executed, print error
echo mysql_error().'<BR>'.$strQuery;
}
?>