Re: numrows

Hello, Chris, with all due respect, DESC is a reserved word for SQL. is english ORDER BY ID DESC meand sort by id in descending order. Martin, your SQL seems to be fine. Are you sure that you are connected to your database. I have run the following SQL against my database SELECT * FROM users WHERE username <> '1' AND user_id < 250 ORDER BY user_id DESC and it returned back records. SO SQL syntax is fine. --- Chris Fry <chris@quillsoft.com.au> wrote: > 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. > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: > php-general-unsubscribe@lists.php.net > For additional commands, e-mail: > php-general-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > ===== Mehmet Erisen http://www.erisen.com __________________________________________________ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/