still can't add record

Anon

I am using this script to add a record. I keep running into the 'can't add record' error.. what should I change?

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

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

mysql_connect("loalhost", "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("blah")
or die ("Unable to select database.");
session_start();
$date = "current_date";
$sql = "insert into mynewads values (\"$userid\",\"$email\", \"$city\", \"$housing\", \"$phone\", \"$parking\",
\"$smoking\", \"$pets\", \"$description\", \"$date\")";
$sql_result = mysql_query($sql);

if (!$sql_result) {

echo "Couldn't Add Record"; exit;

} else {

echo "Record Added! "; exit;

}

else if ($num == 0) {

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

crusty_php

Try echoing your $sql_result variable and passing it to the mysql command line to see if it works.

djurnoce

If this is the way you're trying to put the date in...

$date = "current_date";

well, that won't work. You need to pass a date, not a string (assuming that your date column in the databse is of type DATE).

Also, if the number of arguments that you are passing along in the SQL statement is not exactly equal to the number of columns in the table and in the same exact order, then it also wont work.

"INSERT INTO mynewads (userid, email, city, ...etc) VALUES (\"$userid\",\"$email\", \"$city\", etc....)";

You should change your query to something like:

when trying to debug an SQL statement, I find it easiest to break it down to its simplest form, then add statement by statement 'till it breaks. That way, you can tell exactly where it's wrong.