[RESOLVED] mysql_query

[Jon12345]

I have the following code to insert data into a table. Why doesn't it work?

$db=mysql_connect("mysite.com","username","pw");
mysql_select_db("site_log",$db);
$query="INSERT INTO logs (ipaddress,sid,cid,vid) VALUES ($ipaddress,$sid,$cid,$vid)";
mysql_query($query);

Thanks,

Jon

[Piranha]

I don't know since you didn't post the error. But a guess would be that you need to use ' signs with the values that you insert:

$query="INSERT INTO logs (ipaddress,sid,cid,vid) VALUES ('$ipaddress','$sid','$cid','$vid')";

[NogDog]

Do this to get more debug info:

mysql_query($query) or die(mysql_error()."<br>\nQuery: $query");

[Jon12345]

That worked, thanks!