You are here: Re: $sql = "update products set smallpicname = $myfile ......??? « PHP SQL « IT news, forums, messages
Re: $sql = "update products set smallpicname = $myfile ......???

Posted by Jim S. on 02/03/06 14:12

ok, the value if $myfile is ---> picture.gif
basically a name of a file.
and yes i am connected to the database (tested it using static value, and
echoed it)

thanks again tonjo

"tonjo" <tonjo142NOSPAM@yahoo.com> wrote in message
news:drv1ni$i9m$1@sunce.iskon.hr...
> "Jim S." <jim@yeah.com> wrote in message
> news:WsyEf.10818$vU2.2333@newsread3.news.atl.earthlink.net...
>> no it is not empty, i double checked. (i echoed it)
>>
>> can u remind me how to check if it is empty?
>> i know it is something like isempty() or something :)
>>
>> thanks
>> Jim
>>
>>
>
>
> Ok I guess $myfile is CHAR field. Is value in quotes?
>
> Like $myfile = "'smallPic.jpg'";
>
> Maybe you fill it $myfile = "smallPic.jpg" and thats not god for sql
> statement if table field is varchar.
>
>
> Id field in table is integer and not need to be in quotes, like $id = 37;
>
>
> If that doesn't help check are you connected to database.
>
>
> You can check is empty with isset, but echo is good enough in your case.
>
>
> $myfile = null;
>
> // $myfile = "'smallPic.jpg'");
>
> if(isset($myfile)) {
>
> echo("myfile is: $myfile");
>
> } else {
>
> echo("myfile is empty");
>
> }
>
>
> --
> ΄|΄ () |\|] ()
>
>

 

Navigation:

[Reply to this message]


УдалСнная Ρ€Π°Π±ΠΎΡ‚Π° для программистов  •  Как Π·Π°Ρ€Π°Π±ΠΎΡ‚Π°Ρ‚ΡŒ Π½Π° Google AdSense  •  England, UK  •  ΡΡ‚Π°Ρ‚ΡŒΠΈ Π½Π° английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Π‘Π°ΠΉΡ‚ ΠΈΠ·Π³ΠΎΡ‚ΠΎΠ²Π»Π΅Π½ Π² Π‘Ρ‚ΡƒΠ΄ΠΈΠΈ Π’Π°Π»Π΅Π½Ρ‚ΠΈΠ½Π° ΠŸΠ΅Ρ‚Ρ€ΡƒΡ‡Π΅ΠΊΠ°
ΠΈΠ·Π³ΠΎΡ‚ΠΎΠ²Π»Π΅Π½ΠΈΠ΅ ΠΈ ΠΏΠΎΠ΄Π΄Π΅Ρ€ΠΆΠΊΠ° Π²Π΅Π±-сайтов, Ρ€Π°Π·Ρ€Π°Π±ΠΎΡ‚ΠΊΠ° ΠΏΡ€ΠΎΠ³Ρ€Π°ΠΌΠΌΠ½ΠΎΠ³ΠΎ обСспСчСния, поисковая оптимизация