Connecting Tech Pros Worldwide Help | Site Map

MySQL Query not working

  #1  
Old July 17th, 2005, 01:16 PM
behindspace
Guest
 
Posts: n/a
I'm all sorts of confused on this one...

// My Query:

$result = mysql_query("SELECT * FROM pricehistory WHERE partno partno =
\"".$part."\" ORDER BY partno ASC, year DESC, month DESC limit 1");

// My results:
$numrows = mysql_num_rows($result);

// The error that I'm getting:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in /***/***/***/***/***/***/searchHist2.php on line 28

Any guesses? I know I'm missing something, I just can't figure out what...

  #2  
Old July 17th, 2005, 01:16 PM
behindspace
Guest
 
Posts: n/a

re: MySQL Query not working


forget it, I figured it out.

$result = mysql_query("SELECT * FROM pricehistory WHERE partno =
'".$part."' ORDER BY partno ASC, year DESC, month DESC limit 1");

Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
GRANT query not working properly in MySQL Query Browser. stmfc answers 2 September 23rd, 2007 01:52 PM
Simple SELECT query not working captainmerton answers 8 May 14th, 2007 05:09 PM
Why is this query not working? Susan Ator answers 0 July 19th, 2005 11:47 PM
please help--php query not working j-marvin answers 1 July 17th, 2005 10:05 AM