PHP/MYSQL Help

[dannywilson]

whats wrong with this

<?php
$username="ovt_ovt";
$password="*****";
$database="ovt_ovt";

$ovt=$_POST['ovt'];
$domain=$_POST['domain'];

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO add (domain, ovt) VALUES ('".$domain."','".$ovt."')";

mysql_query($query);
echo "Query Success!";
?>

its not working although it says Query Success!

[Bender]

I will ignore the BIG security issues, assuming that it's on your computer.

try

mysql_connect('localhost',$username,$password);

also,

mysql_query($query) or die(mysql_error());

[dannywilson]

afraid it dosent work
i think its in
$query = "INSERT INTO add (domain, ovt) VALUES ('".$domain."','".$ovt."')";

[Bender]

do you get any error after you added the second line from my first post?

[dannywilson]

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'add (domain, ovt) VALUES ('DOMAIN HERE','OVT HERE')' at line 1

[Bender]

you do have a table called "add"?

[dannywilson]

yes and it reads from it
www.ovtdaily.com

i got it working!! thanks for your help

[Bender]

 $query = "INSERT INTO `add`( `domain` , `ovt` ) values('".$domain."','".$ovt."')";
mysql_query($query) or die(mysql_error());

[katherine]

ADD is a mySQL reserved keyword. I guess the issue stems from the table name.

[csmaster2005]

yes, the reason is for add. I had a similar problem a while ago.
Additionally, putting localhost without quote tags should of returned an error, because it is not a php variable and thus wasnt set...

[Bender]

works for me...