need help with php varariables in mysql update statment

[offsprg01]

here's the error

 

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 'coconut3.jpg''), StartDate=(''30-11-1999''), EndDate=(''30-11-1

 

here's the code

 

$insertSQL = "UPDATE PromoImages SET FileName='$filename', StartDate='$startDateComp', EndDate='$endDateComp', `Default`='$default', LeftRight='$leftRight' WHERE ID='$id'";

[redarrow]

 

try this ok.

$insertSQL = "UPDATE `PromoImages` SET `FileName`='$fileName',`StartDate`='$startDate', `EndDate`='$EndDateComp', `Default`='$Default', `LeftRight`='$LeftRight' WHERE `ID`='$Id'";

[craygo]

seems your filename has some illegal characters in it. try this

 

<?php
$filename = mysql_real_escape_string($filename);
$insertSQL = "UPDATE PromoImages SET FileName='$filename', StartDate='$startDateComp', EndDate='$endDateComp', `Default`='$default', LeftRight='$leftRight' WHERE ID='$id'";
?>

 

Ray

[offsprg01]

craygo you would be correct. problem solved. thanks.