mysql_insert_id();

[kfalise]

When i am trying to get the last inserted id, i am getting returned 0. after the auto increment here is the php code. any help will be greatly appreciated

$conn = mysql_connect("localhost","project","Pass")   or die("Cannot connect to database server"); mysql_select_db("vehicle", $conn) or die("broke");  $sql="(INSERT INTO employee(f_name,l_name,v_id,job_cd,dest,out_date,in_date) VALUES('$f_name','$l_name','$v_id','$job_cd','$dest','$out_date','$in_date')";  $conf_num = mysql_insert_id(); print("$conf_num"); 

falise

[laserlight]

err, you dont seem to have actually sent the query to insert.

[kfalise]

maby i a just tired, or retarded, the data inserts and creates a new row, i just need the id for out put

can you help?

[laserlight]

Here's your code in a better format with comments:

//connect to the database server
$conn = mysql_connect("localhost","project","Pass") or die("Cannot connect to database server");
//select the database
mysql_select_db("vehicle", $conn) or die("broke");
//declare an SQL statement
$sql="(INSERT INTO  employee(f_name,l_name,v_id,job_cd,dest,out_date,in_date) VALUES('$f_name','$l_name','$v_id','$job_cd','$dest','$out_date','$in_date')";
//get the last inserted id from the query sent
$conf_num = mysql_insert_id();
//print this id
print("$conf_num");

now, on which line is the query sent?
There is no mysql_query($sql), only a string that appears to be an SQL query, but isnt used at all.