Calling a field from database in MySQL

Question

return(array($clientName,$salesPer,$prospectVal,$projID));

The projectID is dynamically added in database for each entry, now how can i return the ID. As i have not set any variable in PHP to map the database field.

Can anyone guide me on this.

Answer 1

If you're asking how to get back the ProjectID after it has been inserted into the database and automatically assigned, I suggest using something like the following:

$projID = mysql_insert_id();

immediately after running the insert statement.