getting a result from an imput query

[irishgirl2004]

Hi,
I am using the following code to add users to my database

	$sql2 = "INSERT INTO users VALUES ( '', '$username','$password1','Employer')";
				$result2 = mysql_query($sql2);


[code=php]

the first field in the database is ID, is there  a way to get the value for ID from this addition without having to query the database again?


thanks

[laserlight]

Yes, with [man]mysql_insert_id/man

[irishgirl2004]

thank you.... it works🙂