Re: numrows

i'd have a look at the table structure. also if you're using <> to denote inequality then use != both of the previous posts are incorrect Steve "Chris Fry" <chris@quillsoft.com.au> wrote in message news:3B84BB39.4584E0B8@quillsoft.com.au... > Should be ORDER BY ID, DESC > > Chris > > Martin Kampherbeek wrote: > > > What's wrong with this? I get the error: Warning: Supplied argument is not a valid MySQL result resource in /home/sites/site49/web/vragen/vragen.php on line 42 > > > > $query = "SELECT * FROM question WHERE answer<>'1' AND id>250 > > ORDER BY id DESC"; > > > > $result = MYSQL_QUERY($query); > > > > $number = MYSQL_NUM_ROWS($result); > > -- > > Chris Fry > Quillsoft Pty Ltd > Specialists in Secure Internet Services and E-Commerce Solutions > 10 Gray Street > Kogarah > NSW 2217 > Australia > > Phone: +61 2 9553 1691 > Fax: +61 2 9553 1692 > Mobile: 0419 414 323 > eMail: chris@quillsoft.com.au > http://www.quillsoft.com.au > > You can download our Public CA Certificate from:- > https://ca.secureanywhere.com/htdocs/cacert.crt > > ********************************************************************** > > This information contains confidential information intended only for > the use of the authorised recipient. If you are not an authorised > recipient of this e-mail, please contact Quillsoft Pty Ltd by return > e-mail. > In this case, you should not read, print, re-transmit, store or act > in reliance on this e-mail or any attachments, and should destroy all > copies of them. > This e-mail and any attachments may also contain copyright material > belonging to Quillsoft Pty Ltd. > The views expressed in this e-mail or attachments are the views of > the author and not the views of Quillsoft Pty Ltd. > You should only deal with the material contained in this e-mail if > you are authorised to do so. > > This notice should not be removed. > >