sql error

[kkonline]

hi

$sql="INSERT INTO $table (title,trusted,link,content,mood,mime,path,name,ip,date)VALUES('$title',1,'$link','$content','$mood','$mimeinfo','$pathinfo','$imgnameinfo','$ip','$date')";

what is the error in the above query?

[bkeep]

replace the ' with " in your values since you are using variables

so something like this

$sql="INSERT INTO $table (title,trusted)VALUES("$title",1)";

Best Regards,
Brandon

[eelixduppy]

What is the error message you are receiving when you try to run this query? If you do not know, then you should try adding some error reporting code to find out. It would look like the following:

$result = mysql_query($query) or die([url=http://www.php.net/mysql-error]mysql_error[/url]());