ID of last inserted record is: 0

[classic]

function Button5Click($sender, $params)
{
$sql2 = "insert into customers (billaddress_firstname) VALUES ('newone')";
$this->Database1->Execute($sql2);
echo "ID of last inserted record is: " . mysql_insert_id();

}

I have similar code in another app (different database) and the id is returned correctly.

customers table has field 'cid set to auto inc and key field.

Any ideas please?

[classic]

Sorry forgot to mention a new record is inserted into the table

[405hp]

From the Manual:

The ID generated for an AUTO_INCREMENT column by the previous INSERT query on success, 0 if the previous query does not generate an AUTO_INCREMENT value, or FALSE if no MySQL connection was established.

[classic]

I have 2 datasources in the app. If I remove the one not related to the customer table the ID works fine.

So I presume I need a command to say:
echo "ID of last inserted record is: " . mysql_insert_id() from (DATASOURCE1);

How do I do this please?

[405hp]

A look in the manual
PHP: mysql_insert_id - Manual
says:
int mysql_insert_id ([ resource $link_identifier ] )

[classic]

Ok got that. In delphi PHP what is the syntax ?

mysql_insert_id ($this->Database1) fails

[405hp]

Play around with the options until you find it
probably ->_connection

[classic]

echo "ID of last inserted record is: " . mysql_insert_id($this->Database2->_connection);

fails error:

Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in

Anyone know the correct syntax please?

[dalyla]

well, Just left it in blank, nothing between ()