mysql error

euge

I wonder could anybody tell me whats wrong with this query, its not adding the data to my db & just returning my error msg 'please try again' thanks v much

if (strlen($_GET['update']) > 0) {
	$id = FALSE;
	$message .= '<p>No id!</p>';
} else {
	$id = $_GET['update'];
}

if (strlen($_GET['update']) > 0) {
	$si = FALSE;
	$message .= '<p>Not selected!</p>';
} else {
	$si = $_GET['update'];
}}

if ($id && $si) { 
require_once ('mysql_connect.php');

$query = "INSERT INTO Bookings (id, seatid) VALUES (" . $id . "," . $si . ")";
$result=@mysql_query ($query);
            if ($result) { // If it ran OK.

             exit(); // Quit the script.

} else { 
$message = '<p>Errorp><p>' . mysql_error() . '</p>'; }
mysql_close(); 
} else {
$message .= '<p>Please try again.</p>';

thorpe

good debugging practice is to print your query to the screen to see what the finished query looks like.

add a exit() before your query and show us what the output is.

$query = "INSERT INTO Bookings (id, seatid) VALUES (" . $id . "," . $si . ")";
exit($query);
$result=@mysql_query ($query);

euge

ok, tried that and the output doesnt change at all? the page loads up and just says Please try again (my failure notice)

jkurrle

Just quickly glancing at your code, I noticed you don't have your variables setting to TRUE anywhere. Therefore, your last if() test will always evaluate to FALSE or perhaps some invalid value. You might try setting your variables to TRUE before you process your if statements...