Still Can't Add Record

[Anon]

I keep getting 'Can't Add Record'. What is wrong with it? I am inserting info into a php database..

<?
if ((!$userid) || (!$password)) {

header("location: http://www.retroarts.com/placeshare2/mylogin.php");
exit;
}

mysql_connect("localhost", "blah", "blah")
or die ("Unable to connect to database.");

mysql_select_db("blah")
or die ("Unable to select database.");

$sql = "select id from users where userid='$userid' and password='$password'";

$result = mysql_query($sql) or die ("Couldn't get results.");

$num = mysql_num_rows($result) or die("That username and password are not in the database. You need to sign up
first.");

if ($num == 1) {
mysql_connect("localhost", "blah", "blah")
or die ("Unable to connect to database.");

mysql_select_db("retroart")
or die ("Unable to select database.");
session_start();
$date = getdate();
$datestamp = "$date[mon]/$date[mday]/$date[year]";
$sql = "insert into mynewads (userid, email, city, housing, phone, parking, smoking, pets, description, date) values (\"$userid\",\"$email\", \"$city\", \"$housing\", \"$phone\", \"$parking\",
\"$smoking\", \"$pets\", \"$description\", \"$datestamp\")";
$result = mysql_query($sql) or die ("Couldn't get results.");

if (!$sql_result) {

echo "Couldn't Add Record"; exit;

} else {

echo "Record Added! "; exit;

}

}

else if ($num == 0) {

echo "You are not authorized!";
exit;
}

?>

[Anon]

I not sure but I think you cant use " and then escape them Try using ' and don't escape it

[biggus]

it seems that if the insert weren't successful, then it would die at the following line:

$result = mysql_query($sql) or die ("Couldn't get results.");

If you still want to check, try changing the variable name $sql_result in the line:

if (!$sql_result) {...}

to $result, so it matches the preceeding line of:

$result = mysql_query($sql)...

Biggus

[Anon]

Thanks for the tips..that worked..