pmato23
08-19-2006, 12:02 PM
Hi, If anyone can help me with this code, please reply. I have 1 problems, the script does not assign values to $first and $last from the user's input.
$query = 'SELECT * FROM `Santa List` WHERE `first_name` = CONVERT(_utf8 \'gianna\' USING latin1) COLLATE latin1_swedish_ci AND `last_name` = CONVERT(_utf8 \'macagno\' USING latin1) COLLATE latin1_swedish_ci';
use
$first = $_POST['firstname'];
$last = $_POST['lastname'];
$result = mysql_query("SELECT * FROM `Santa List` WHERE first_name = '$first' AND `last_name` = '$last'");
$r=mysql_fetch_array($result);
$query = 'SELECT * FROM `Santa List` WHERE `first_name` = CONVERT(_utf8 \'gianna\' USING latin1) COLLATE latin1_swedish_ci AND `last_name` = CONVERT(_utf8 \'macagno\' USING latin1) COLLATE latin1_swedish_ci';
use
$first = $_POST['firstname'];
$last = $_POST['lastname'];
$result = mysql_query("SELECT * FROM `Santa List` WHERE first_name = '$first' AND `last_name` = '$last'");
$r=mysql_fetch_array($result);