mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\mahesh\login\orderhistory.php on line 48 [duplicate]

Question

Possible Duplicate:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result

mysql_fetch_array(): supplied argument is not a valid MySQL result resource `

mysql_select_db("test", $con);
$result = mysql_query("SELECT * FROM order");

echo "<table border='1' bgcolor='#99CCCC' >"
while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>". $row['orderid']."</td>";
  echo "<td>". $row['odate'] . "</td>";
  echo "<td>". $row['pdtdetail']."</td>";
  echo "<td>". $row['unitprice']."</td> ";
  echo "<td>".$row['quantity']."</td> ";
  echo "<td>".$row['netprice']."</td> ";
  echo "<td>".$row['status']."</td>";
  echo "</tr>";
  }
echo "</table>";
mysql_close($con);
?>`

What's your question? And why aren't you checking for errors? — bdonlan
– bdonlan, Commented Dec 9, 2011 at 6:22
Hi newbie, this is obvious, the supplied argument is not a valid mysql result on that particular line. — ajreal
– ajreal, Commented Dec 9, 2011 at 6:30
@bdonlan he has no idea of that? like 99% of this site users? — Your Common Sense
– Your Common Sense, Commented Dec 9, 2011 at 6:40
@ajreal, yes very true ,for your question valid argument in your case is your query that you are passing, which implies that your query has some issue — noobie-php
– noobie-php, Commented Dec 9, 2011 at 6:40
@noobie-php I not sure what you mean ...Is not just limited to syntax in SQL, it could be you did not established the database connection correctly, database refused to connect, database reaching max-connection ... blah blah. — ajreal
– ajreal, Commented Dec 9, 2011 at 6:53

ajreal · Accepted Answer · 2011-12-09 06:54:57Z

1

SELECT * FROM order <-- this is a wrongful SQL

order is reserved word in mysql.
If you have a table named as order,
you should rename it asap

Or back-tick the table name during query like :-

 SELECT * FROM `order`

When you code a SQL, it is understood is your responsibility
to ensure that query is working ...

answered Dec 9, 2011 at 6:54

ajreal

47.4k11 gold badges97 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rajesh Meniya · Accepted Answer · 2012-02-29 07:19:44Z

1

"order" is reserved keyword in mysql, chang it with ord or any else...

answered Feb 29, 2012 at 7:19

Rajesh Meniya

8231 gold badge8 silver badges19 bronze badges

Comments

Your Common Sense · Accepted Answer · 2011-12-09 07:03:43Z

-1

While running queries, you have to always check for errors.
Run ALL your queruies at least this way:

$query  = "SELECT * FROM order"
$result = mysql_query($query) or trigger_error(mysql_error()." in ".$query);

So, you will be always notified of the cause.

answered Dec 9, 2011 at 7:03

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

2 Comments

Lawrence Cherone Over a year ago

Your missing the query, cmon basic stuff, whats $sql? and notofied is spelt notified...

Your Common Sense Over a year ago

Thanks for the pointing that out. Here you can learn the right way. Also keep in mind that doing error_reporting(0) on a live server is a suicide.

Collectives™ on Stack Overflow

mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\mahesh\login\orderhistory.php on line 48 [duplicate]

3 Answers 3

Comments

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Linked

Related