Re: numrows

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.