going crazy - update

[adunphy]

This is driving me nuts.

print $camptime; // time prints as 1:00

$sql = "update camps set
location = '$location', address='$address', city='$city', state='$state', zip='$zip',camptime='$camptime',
startdate='$startdate', enddate='$enddate', camptime='$campttime', directions='$directions', cost='$cost', type='$type'
where campID = $campID";

 print $sql; // time doesn't print - it shows camptime=''

any ideas how that isn't printing correctly?

[sneakyimp]

you have two t's in camptime in your sql.

[adunphy]

where?

[Weedpacket]

In your SQL; if you can't see it yourself (hint: there are five "camptime"s in the posted code), most editors offer a "find" option.

Another hint is to set error reporting to E_ALL. Misttakes like this will then be reported on.

[adunphy]

Thanks! I hate when you can't find dumb things like this. I didn't realize I had it twice in the same statement. DUH