Jump to content

Why doesn't my sql work?


pavankat

Recommended Posts

I'd be so grateful if someone could tell me what's going on with my sql query.

 

When I run the below code - it gives me this:

 

The query reads as: INSERT INTO `users_calendar` ('','1','2','2','14','2012','')

 

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 ''','1','2','2','14','2012','')' at line 1

 

$query = "INSERT INTO `users_calendar` ('','".$_SESSION['user_id']."','".$id."','".$month."','".$day."','".$year."','".$serving."')";
echo '<br /> The query reads as: ' . $query;
$query_run = mysql_query($query) or die(mysql_error());

Link to comment
https://forums.phpfreaks.com/topic/257443-why-doesnt-my-sql-work/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.