Too stupid to UPDATE...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I am trying to write a script to handle event registration.  Most of the 
people that will be registering are already in the database, but not all, 
and those that are may not have current information.

Here is my latest effort, or at least a snippet of it...  Can anyone point 
out where I went stupid, or if there is a better way of doing this? 
THANKS!!!

<<<===---  BEGIN SNIPPET  ---===>>>

$db = @mysql_select_db($dbname, $connection) or die("Couldn't Select 
Database.");

$link = mysql_connect("$server", "$user", "$pass");
mysql_select_db("$dbname", $link);

$result = mysql_query("SELECT * FROM $table WHERE first_name='$first_name' 
AND hs_last_name='$hs_last_name' AND last_name='$last_name'", $link);
$num_rows = mysql_num_rows($result);

if($num_rows) {

$sql = "UPDATE $table SET first_name=\"$first_name\", 
last_name=\"$last_name\", hs_last_name=\"$hs_last_name\", 
guest_name=\"$guest_name\", street_address1=\"$street_address1\", 
street_address2=\"$street_address2\", city=\"$city\", state=\"$state\", 
zip=\"$zip\", phone1=\"$phone1\", phone2=\"$phone2\", 
email_address=\"$email_address\", number_attending=\"$number_attending\", 
payment=\"$payment\", registration_comments=\"$registration_comments\", 
date_registered=\"$today\" WHERE first_name=\"$first_name\" AND 
last_name=\"&last_name\"";

$result = @mysql_query($sql,$connection) or die("Couldn't Execute Query.");

 }
 else {

$sql = "INSERT INTO $table
(first_name, last_name, hs_last_name, guest_name, street_address1, 
street_address2, city, state, zip, phone1, phone2, email_address, 
number_attending, payment, registration_comments, date_registered)
VALUES
(\"$first_name\", \"$last_name\", \"$hs_last_name\", \"$guest_name\", 
\"$street_address1\", \"$street_address2\", \"$city\", \"$state\", \"$zip\", 
\"$phone1\", \"$phone2\", \"$email_address\", \"$number_attending\", 
\"$payment\", \"$registration_comments\", \"$today\")
";

$result = @mysql_query($sql,$connection) or die("Couldn't Execute Query.");

<<<===---  END SNIPPET  ---===>>> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux