Entry

I have a MySQL db with a column named "ID". When user enters ID thru form I want to make sure the ID exists and then perform a db query.

Aug 6th, 2003 19:58
Justin Dalrymple, Sam Luther, Ben Udall,

<?php


$grab_id = "SELECT ID FROM table WHERE ID = '$id_variable'";

$result = mysql_query($grab_id);



IF (!$result)
{
echo (mysql_error());
}


ELSE
{


IF (mysql_num_rows($result) > 0)
{
// PUT YOUR CODE HERE
}


ELSE
{
echo ("ID $id_variable Not Found.");
}


}


?>