posted August 07, 1999 10:44 PM            

<?
/* 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_teacher','$partner_teacher_email','$geny_t eacher','$geny_teacher_email','$project_name','$project_subject_area','$url','$objectives_a','$objectives_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

posted August 08, 1999 07:09 PM            

In onther words .. use

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

-Roger