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.