MySQL Forums
Forum List  »  PHP

Advanced Search
New Topic

Re: PHP UPDATE passes a blank string instead of contents of variable
Posted by: Cane Kostovski
Date: July 27, 2015 07:01PM

Oops! I need to change this answer:
> > SQLFILE Contents before the query are:
> > UPDATE `animals` SET `img1` = 'summer2.jpg'
> WHERE `id` = 44
>
> Does that query have the expected result? *****************YES

The query has the correct data in it, but the string "summer2.jpg" is not passed into the field. What is passed is "". I can update any other field in this row and it will work perfectly. It is just this field `img1` that holds a blank record that is never updated with summer2.jpg.

I am at my wit's end with this. Would you like the structure info for the column `img1`?

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.