How to print results back to browser

leeg_23

Hello,

I should apologize first, this is probably a silly question. I am trying to get my primary key which is a unsigned, auto_increment int, to print to the results page when the submit button is pressed. I can't seem to find any documentation on how to do this. Since I'm not putting any information into that Variable, mysql is doing all that. Here is my code, Please help.

$result= mysql_query ("INSERT INTO defect (processor, processortype, speed, brief, os)VALUES('$processor','$processortype','$speed','$brief','$os')");
if ($result)
echo mysql_affected_rows()." Defect Entered into Database";
echo ("Here is your defect number: $defectid")

Thank you very much for your assistance.

mmilano

since mysql_affected rows only returns the number of rows affected and not the results, i think you might have to re-query the table.

after you run your insert query, run another query:
$result=mysql_query("select $defectid from defect where processor='$processortype' and speed='$speed' and brief='$brief' and os='$os' limit 1 desc");
$defectid=mysql_result($result,0,"defectid");
echo "Here is your defect number: $defectid";

well, there might be a better way to do this, but this is the best i can do.

good luck

Anon

Here is an easier way:

use mysql_insert_id() and you will get the ID generated by a auto_increment column of the last INSERT query
do something like this:
echo ("Here is your defect number: ".mysql_insert_id())

Anon

Thank you all so much, both options worked like a charm.

Thanks again.
Lee