Hit the nail on the head... infact, the problem wasn't the query itself, it
was the way in which I imported the tables and data from a Unix platform to
my Windows platform that caused the problems... sorry.
Many thanks for you help, as it made me look at running the query as you
suggested which caused me to realise the database wasn't able to be read by
Windows. :)
Thanks,
Kevin
----- Original Message -----
From: "Jason Burfield" <[EMAIL PROTECTED]>
To: "Kevin Smith" <[EMAIL PROTECTED]>
Sent: Sunday, July 08, 2001 4:15 PM
Subject: Re: PHP and Mysql
> Kevin...
>
> This means that your result set is empty.
>
> Try running the query on the command line and see if you get a result. If
> you do, check the syntax in your code. If you don't, that's the problem.
>
> -- Jason
>
>
> On 7/8/01 5:40 AM, Kevin Smith was heard saying:
>
> > Hi All,
> >
> > Has anyone ever had this problem when using PHP 4.06 and MySQL 3.23.39
> > running on Apache 1.3.20 on Windows 2000 Professional SP!?
> >
> > <br>
> > <b>Warning</b>: Supplied argument is not a valid MySQL result resource
in
> > <b>d:\program files\apache
> > group\apache\www.lemonlaineydesign.com\www\top_frame.php</b> on line
> > <b>68</b><br>
> >
> > And here is the line in my HTML... any ideas what might be wrong? This
> > works on my Unix box with no problems...
> >
> > while ($results = mysql_fetch_array($sth)) {
> >
> >
> > Thanks,
> >
> > Kevin Smith
> > Netsmith Limited
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
