I can't get latest insert id. This is my php code:
$query='INSERT INTO candidates (company_id, name, surname, address1, address2, city, county, postcode, cv, skills, distance) VALUES (10254, \'name\', \'surname\', \'1st Floor\', \'Street\', \'City\', \'County\', \'postcode\', \'0\', \'#6#,#3#,#2#,#1#,\', 25)';
$sql = mysql_query($query, $jobboard) or die(mysql_error());
$res = mysql_query('SELECT LAST_INSERT_ID() FROM candidates AS ID',$jobboard);
When I put query 'SELECT LAST_INSERT_ID() FROM candidates' straight in MySQL in return I get as many record as I have in this table, all values are 0. For example right now I have 5 records, id are 2,3,4,5,6 (I removed 1st), I get this table:
LAST_INSERT_ID()
0
0
0
0
0
How can I get latest insert record ID? BTW 1 only column is AUTO_INCREMENT, which is id.