why won't my data go to SQL?

scott212

What's wrong with this? I'm not getting any php errors, I'm just getting my failed statement returned. Can't figure it out.

<?

$mlsNumber = $_GET["mlsNumber"];

$host = "localhost";
$user = "evt";
$password = "password";
$DBName = "executivevirtualtours";
$tableName = "houses";

$link = mysql_connect($host, $user, $password);

$query = "INSERT INTO '$tableName' ('0') VALUES ('$mlsNumber')";

if (mysql_db_query ($DBName, $query, $link)) {
	print ("it worked");
} else {
	print ("it don't work");
}

mysql_close ($link);

?>

LordShryku

Don't single quote the table name. And what's the ('0') in the middle there?

try
$query = "INSERT INTO ".$tableName." VALUES ('".$mlsNumber."')";

sid

i agree with shryku... also this mod will be helpful:

   if (mysql_db_query ($DBName, $query, $link)) { 
        print ("it worked"); 
    } else { 
        print ("it don't work - and the reason is that " . mysql_error()); 
    }

LordShryku

Good point sid. mysql_error() will tell you what's goin wrong...

scott212

The ('0') I thought was need to designate the row id. How come you have the periods around the variables? Thanks for your help guys.

sid

periods concatenate (put together) strings. php is very tolerant if you dont use them - but i definitely suggest working with them... it just makes code easier to read and can prevent some unforeseen mistakes...

sid

and the ('0') as column name (ie the column - not row - is called '0') would definitely be ok. im not sure if you can use it as a "column number" (does mysql accept column id's as an array element? i never heard of that... but who knows...)

scott212

I don't suppose I could ask a huge favor of you guys real quickly? I was hoping that you could write a small query with a few entries for different rows just so I could see the formating as a whole?
Thanks a million guys!

sid

for that we would pretty much need your database scheme first.

Originally posted by scott212
I don't suppose I could ask a huge favor of you guys real quickly? I was hoping that you could write a small query with a few entries for different rows just so I could see the formating as a whole?
Thanks a million guys!

LordShryku

That's also something you should be able to do yourself...

scott212

right right, that's cool - thanks for your help so far!