insert problem

[euge]

hi, can anyone help me out with this piece of code, its not adding the record to my db..........thanks...

<?php 

$id = $_GET['id'];

if (isset($_POST['submit'])) { 

$message = NULL; 
if ($seatno) { 
require_once ('mysql_connect.php'); 
$query = "INSERT INTO Tab2 (id) VALUES ('$id')";	
$result = @mysql_query ($query); 
if ($result) { 

echo '<p><b>Done!</b></p>';
exit(); // Quit the script.	
} else { 
$message = '<p>Error!</p><p>' . mysql_error() . '</p>'; 
	}
mysql_close(); 
} else {
$message .= '<p>Please try again.</p>';		
}
} 
if (isset($message)) {
	echo '<font color="red">', $message, '</font>';
}?>

[gufmn]

Are you getting any errors? Try changing this:

$result = @mysql_query ($query); 

to this:

$result = mysql_query ($query) or die("Error inserting record: " . mysql_error()); 

To see what's happening.

[tekky]

1) use

 tags around PHP code
2) you probably want to include your table schema for Tab2 in this question
3) We'll go from there ;)

[euge]

tried that line of code and it made no difference.........no errors are coming up its just not adding it to the db.....
table schema...
| BookingsID | firstname | surname | id | Contactno | CCno | CCtype | Exdate |

all the other details are added by the user, just id is taken from the url.

thanks v much

gufmn you said "add this line to see whats happening"
where should it tell me? the program runs ok but it doesnt insert.

[tekky]

try echoing $query to verify that its setting the right SQL command to send 😉

[euge]

ok i did that like so ...

$query = "INSERT INTO Tab2 (id) VALUES ('$id')";    

echo $query . "<br>"; 
 $result = @mysql_query ($query);

is that right? nothing at all different happened
thanks

[tekky]

Originally posted by euge
ok i did that like so ...

$query = "INSERT INTO Tab2 (id) VALUES ('$id')";    

echo $query . "<br>"; 
 $result = @mysql_query ($query);

is that right? nothing at all different happened
thanks [/B]

if nothing different happened then your browser is caching the outputs, hit F5 or change the ID in your URL and it should show you something different....

[euge]

did that and no joy🙁
dont suppose i could pm the whole page to you? as this query is in the middle of a bigger page (that all works perfectly)
thanks

[tekky]

Originally posted by euge
did that and no joy🙁
dont suppose i could pm the whole page to you? as this query is in the middle of a bigger page (that all works perfectly)
thanks

if you post it here inside PHP tags like I suggested, more then me can see it and possibly help you too

[euge]

i could do that, but the page is really big when everythings included as in really BIG!😃

[gufmn]

If it's not even echoing the $query, I'm thinking it's a problem with your:

if ($seatno) {

statement

[jkurrle]

The only way that code would work is if seatno is set to either 0 or 1. Otherwise, the code doesn't evaluate correctly.

[euge]

Why would seatno only work for 1 and 0? And do you have any suggestions how to go about solving the problem??

Cheers

[jkurrle]

The if() statement tests for a true(1)/false(0) condition. Any other value than true or false would make no sense to the interpreter. Therefore $seatno is either true or false, or else it doesn't work.

To make your if() statement work, you'd need to have the statement evaluate a test scenario like the examples below:

if($seatno=="") == If $seatno isn't set to any value (is NULL)

if($seatno<>"") == if $seatno isn't NULL

if($seatno > "0") == if $seatno is greater than 0

Any of these statements would either evaluate to true or false. If the statement evaluates as true, PHP will process the if() loop. If not, it will pass it over.

Does this make more sense?

[tekky]

Correction police!

jkurrle, you are right about some of your variable stuff, but just to eliminate any questions.... [edit -- when comparing numbers, quotes aren't needed --]

http://tekky.mybesthost.com/correctionpolice.php

source is below

<?php
$two = 2;
$one = 1;
$zero = 0;
$negone = -1;
$false = false;
$true = true;
$string = 'testing';
$empty = '';
$null = null;

if ($two) { echo 'if (2) evaluates to true....<br>'; }
else { echo 'if (2) evaluates to false...<br>'; }
if ($one) { echo 'if (1) evaluates to true...<br>'; }
else { echo 'if (1) evaluates to false...<br>'; }
if ($zero) { echo 'if (0) evaluates to true...<br>'; }
else { echo 'if (0) evaluates to false...<br>'; }
if ($negone) { echo 'if (-1) evaluates to true...<br>'; }
else { echo 'if (-1) evaluates to false...<br>'; }
for ($i=2;$i>-2;$i--)
{
  if ($i == true) { echo "if ($i == true) evaluates to true...<br>"; }
  else { echo "if ($i == true) evaluates to false...<br>"; }
}
if ($string == true) { echo "if ('testing' == true) evaluates to true...<br>"; }
else { echo "if ('testing' == true) evaluates to false...<br>"; }
if ($empty == null) { echo "if ('' == null) evaluates to true...<br>"; }
else { echo "if ('' == null) evaluates to false...<br>"; }
if ($zero == null) { echo 'if (0 == null) evalutes to true...<br>'; }
else { echo 'if (0 == null) evaluates to false...<br>'; }
?>