You are here: Re: query *seems* to work but no results [1] « PHP Language « IT news, forums, messages
Re: query *seems* to work but no results [1]

Posted by desmond on 06/28/07 14:10

ZeldorBlat <zeldorblat@gmail.com> wrote:
> On Jun 28, 9:53 am, desmond <desm...@zeouane.org> wrote:
>> .. by 'works', I mean that thera are no errors. Unfortunately, there's no
>> output either. :-(
>>
>> Here is the HTML that I have in 'test.php' ...
>>
>> http://www.flickr.com/photo_zoom.gne?id=649529794&size=o
>>
>> Here is the php code in the file select.php ...
>>
>> http://www.flickr.com/photo_zoom.gne?id=649529810&size=o
>>
>> When i call up test.php' from my webbrowser, I enter say 'tom' and I get no
>> results. $dbname _is_ populated and there _is_ a user in there called
>> 'tom'.
>>
>> Can someone advise..? Thanks
>>
>> [1] I hope this is the right forum..
>
> A couple things:
>
> 1. A screen shot of your code? C'mon, dude.

Yeah, I know.. but I wasn't sure if I was posting to the right place, and
so sort o' thought, 'minimise the code I post; minimise the flames..' :-\

> 2. Check that $result isn't false.

If I put echo $result just out of the 'while' loop, I get..

Resource id #3

> 3. Check the value of mysql_error() after you run the query.

Nor really sure how to do that.. adding this ..

$error=mysql_error();
echo $error;

... outside the loop, didn't do anything.

> 4. Enable display_errors and turn up error_reporting in php.ini and
> run the script again.

I already have 'E_ALL & ~E_NOTICE' turned on...

 

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

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация