Insert into id field question
Posted: Mon Apr 25, 2011 5:50 pm
hi everyone
i'm wondering if there is a technique i could use to insert data into a table if data is entered in a field, otherwise insert the regular variable.
i need a way to insert $OverrideIDNumber in replace of $NextID, if data exists in the form in that field, if not, then insert $NextID.
any ideas on how to accomplish this? thanks.
i'm wondering if there is a technique i could use to insert data into a table if data is entered in a field, otherwise insert the regular variable.
Code: Select all
<?php
$FirstName = $_POST['FirstName'];
$LastName = $_POST['LastName'];
$DateOfBirth = $_POST['DateOfBirth'];
$OverrideIDNumber = $_POST['OverrideIDNumber'];
// find max of non standard id number
$ID = mysql_query(SELECT MAX(IDNumber) as MaxNumber from records;
$MaxRecordNumberResult = mysql_fetch_array($ID);
$NextID = $MaxRecordNumberResult +1;
$query = "INSERT INTO records (IDNumber, FirstName, LastName, DateOfBirth)
VALUES ('$NextID', '$FirstName', '$LastName', '$DateOfBirth')";
mysql_query($query) or die('Error, insert query failed');
?>
any ideas on how to accomplish this? thanks.