Trouble with mysql_fetch_array

[cmpennington]

I am having trouble with one line of code...
It recieves a selection from a select box on another page. I am trying to pass that variable along to call up the right person in the database.

ex: $id gets passed to this page & looks up peron in db with matching $id

Connection stuff goes here...

foreach($HTTP_POST_VARS as $value) {
echo "<BR>You clicked checkbox number $value ";
}
mysql_select_db("bpafuner_test",$db);
$result = mysql_query("SELECT * FROM employees WHERE id=$id, $db");

while($myrow = mysql_fetch_array($result))
{
extract($myrow);
echo "$last?: $id";
}





if (mysql_error())
echo mysql_error();
?>

[HalfaBee]

I don't think this line is correct.
$result = mysql_query("SELECT FROM employees WHERE id=$id, $db");
should be
$result = mysql_query("SELECT FROM employees WHERE id=$id");

Use mysql_fetch_assco() instead of mysql_fetch_array().

The assoc only returns assoc. array, where the array version returns assoc and numeric array.

Halfabee

[barand]

If you are going to do an extract() then it's better to use mysql_fetch_assoc() as mysql_fetch_array() returns a double set of values by default (associative and indexed arrays).

Also, the line

echo "$last?: $id"; 

is missing an argument

The syntax is " condition ? true result : false result "

[barand]

Don't you hate it when someone types a bit faster than you 🙂

[cmpennington]

Here was the final code!

$result = mysql_query("SELECT * FROM employees WHERE id=$id");
While ($myrow = mysql_fetch_assoc($result)){

$last= $myrow["last"];
$position = $myrow["position"];
$address = $myrow["address"];
$date = $myrow["date"];
$first = $myrow["first"];
$photo = $myrow["photo"];
$fullname = $myrow["Fullname"];
}