[RESOLVED] INSERT INTO $value problem

[vinny199]

Hi,

I cannot find a way of syntaxing correctly the following

$email = $HTTP_GET_VARS['email']; 
echo $email;
$sql = 'INSERT INTO `systemtalk` (`id`, `email`) VALUES (\'\', \'$email\')'; 
            mysql_query ($sql)
           or die("Could not add."); 

So $email value would print into my database table systemtalk

To check the values was retieved correctly from the url, I tested the echo $email; and this displys fine on my page, so the email is being retrieved from the url ok.

I just cant find a way of getting it into my database.
I have tried so many variations such as '".$email."' or with the / as displayed above. No luck,

At the moment all that gets inserted into my table is $email and not the value $email is supposed to represent.

I would be most grateful if you could point out what I'm doing wrong or what else to try.

Many thanks,

Vinny

[rincewind456]

Try

<?php
$email =mysql_real_escape_string($_POST['email']); 
echo $email; 
$sql = "INSERT INTO `systemtalk` (`id`, `email`) VALUES ('', ".$email.")";
            mysql_query ($sql) 
           or die("Could not add.");
?>

[vinny199]

Thanks, but I get the die "could not add".

any idea?

thanks again,
Vinny

[rincewind456]

Sorry should have been this

<?php
$email =mysql_real_escape_string($_POST['email']); 
echo $email; 
$sql = "INSERT INTO `systemtalk` (`id`, `email`) VALUES ('', '".$email."')";
            mysql_query ($sql) 
           or die("Could not add.");
?>

[vinny199]

OK, I got it!

$sql = "INSERT INTO systemtalk (id, email) VALUES ('', '".$email."')";

Thanks!