Re: [PHP-WIN] Error: Not a proper resource --- with code this time!

2011-01-17 Thread Niel Archer
It occurred to me that you may be over complicating things. Could the filenames for UV photos not be added as an extra column to the main table? If that's acceptable you would have the filename available in the previous page and could pass that through the session variable instead of the species_n

Re: [PHP-WIN] Error: Not a proper resource --- with code this time!

2011-01-17 Thread Niel Archer
> Oh foo! I posted before sending the code! This time it will be there. Sorry > Bill > > > Thanks to help from the forum, I am a step closer to being able to > display a whole bunch of UV fluo

Re: [PHP-WIN] Re: [Bulk] Fwd: Re: [PHP-WIN] Error: Not a proper resource --- with code this time!

2011-01-16 Thread Lars Mueller
Am 17.01.2011 03:24, schrieb Bill Mudry: When I tried this, I found more information on mysql_real_escape() at: > http://php.net/manual/en/function.mysql-real-escape-string.php > With this proof that it is a valid function, it is hard to understand the error I got when I used your second sug

[PHP-WIN] Re: [Bulk] Fwd: Re: [PHP-WIN] Error: Not a proper resource --- with code this time!

2011-01-16 Thread Bill Mudry
Thunderbird/3.1.7 To: php-windows@lists.php.net Subject: Re: [PHP-WIN] Error: Not a proper resource --- with code this time! Am 15.01.2011 17:35, schrieb Bill Mudry: Lars, thank you for your effort and willingness to help. Unfortunately, we have a way to go yet for success: $uvquery = &q

Re: [PHP-WIN] Error: Not a proper resource --- with code this time!

2011-01-16 Thread Lars Mueller
Am 15.01.2011 17:35, schrieb Bill Mudry: $uvquery = "SELECT `uv_filename` FROM 'uvphotos' WHERE `species_name`= $speciesname"; That should probably be ... FROM `uvphotos` WHERE `species_name` = '$speciesname'"; or better: ...WHERE `species_name` = '".mysql_real_escape($speciesname)."'"; --

[PHP-WIN] Error: Not a proper resource --- with code this time!

2011-01-15 Thread Bill Mudry
Oh foo! I posted before sending the code! This time it will be there. Sorry Bill Thanks to help from the forum, I am a step closer to being able to display a whole bunch of UV fluorescent pho

[PHP-WIN] Error: Not a proper resource

2011-01-15 Thread Bill Mudry
Thanks to help from the forum, I am a step closer to being able to display a whole bunch of UV fluorescent photos (of wood) but now I have come up with an "not a proper resource" error after the SELECT statement in trying to go the next step with a mysql_query statement. I am largely sure that i