This is PHP4 Code!


$result = @mysql_query("INSERT INTO text_messages (
			some_id,
			email_address
		) VALUES (
			$some_id,
			'$email'
		)");
DateTime Now

Now(),

 

Get Auto ID Of New Record


$sql = "INSERT INTO some_table (list_name, user_id) VALUES ('$list_name', $user_id)";
@mysql_query($sql);
$my_variable = mysql_insert_id();

The mysqli_insert_id() function returns the ID generated by a query on a table with a column having the AUTO_INCREMENT attribute. If the last query wasn't an INSERT or UPDATE statement or if the modified table does not have a column with the AUTO_INCREMENT attribute, this function will return zero.

Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.

Comments

Your email address will not be published. Required fields are marked *