MySQL Query Insanity

The following source code manages to reliably return the wrong information. Instead of returning the proper number it returns the number 3 for the value of $PID. Just so you know the value of objective_a is unique in each mysql row. PID is generated by MySQL as soon as the row is created.

<?
/* declare some relevant variables */
$hostname = "localhost";
$username = "root";
$password = "";
$dbname = "Schools";
/* make connection to database */
MYSQL_CONNECT($hostname,$username,$password) OR DIE("Unable to connect to database");

@mysql_select_db("$dbname") or die("Unable to select database");
$date=(date("Y-m-d"));
$datadump = "INSERT INTO proposal VALUES('$student_name','$student_email','$student_grade','$state','$school','$district','$partner_te acher','$partner_teacher_email','$geny_t eacher','$geny_teacher_email','$project_name','$project_subject_area','$url','$objectives_a','$objec tives_b','$objectives_c','$require_hardw are','$require_software','$require_other','$ealr1a','$ealr1b','$ealr1c','$ealr2a','$ealr2b','$ealr2c ','$ealr3a','$ealr3b','$ealr3c','$proced ures','$assessment','$consultmsg','$draft','$feedback','$edit','$date','')";
MYSQL_QUERY($datadump);
MYSQL_CLOSE();


MYSQL_CONNECT($hostname,$username,$password) OR DIE("Unable to connect to database");
@mysql_select_db("$dbname") or die("Unable to select database");


$select = "SELECT PID FROM proposal WHERE (objectives_a='$objectives_a');";
$result = MYSQL_QUERY($select);
$PID = $result;

include("thanks.html");
PRINT"$result -- result";
PRINT"<BR>Proposal ID number is $PID.<BR>";
PRINT"<BR>Proposal ID SELECT is $select.<BR>";
include("thanks2.html");
MYSQL_CLOSE();
?>

If anyone has suggestions as to a better way to return the PID of the file created in the first mysql query I would be open to any ideas.

Thanks.

------------------
Luke Bowerman
new media arts
www.judebowerman.com/nma


[This message has been edited by newmediaarts (edited 08-07-99).]

I'm no php3 wizard but as far as I now $result is only a identifier and must be used with mysql_result to actually retrieve data from the query.

In onther words .. use

$PID = mysql_result($result,0,"PID");

-Roger

[This message has been edited by ros87 (edited 08-08-99).]

Thank you very much. That worked great.

------------------
Luke Bowerman
new media arts
http://www.judebowerman.com/nma