[RESOLVED] Mysql problem.

Beffic

So I have looked over all of my query and can't find a problem with it, I have even checked to make sure everything was named right for the database and I know the database connection is there. So what else could it be?

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/riseofim/public_html/roi/viewtrade.php on line 13

$allMarket = mysql_query("SELECT * FROM trade WHERE to='None' ORDER BY value");
while($forSale = mysql_fetch_array($allMarket))

bradgrafelman

Instead of asking us, why don't you ask the MySQL server? If [man]mysql_query/man returns false, you should examine the return value of [man]mysql_error/man to help debug your query. In addition, it's often helpful to output the SQL query string that was executed in order to visually inspect it.

Beffic

Okay, I used your advice and found the problem.

When ever I put the "WHERE to='None'" it doesn't see to work. When it's not there it works fine. What's the next step Morpheus?

bradgrafelman

The next step would have been to include the error message in your request for help, that way we can help you debug the query based on what MySQL is wrong with it.

As for your problem, I expect MySQL is telling you the problem is near the "to" part of the query. That should tell you that the column name itself seems to be causing the problem.

And so it is; the word TO is a MySQL reserved word. In other words, you must either delimit this word in all of your queries (usually done with backticks in MySQL, to denote that you're using an identifier instead of a reserved word), or simply don't use one of the reserved words as an identifier.

Beffic

Okay that makes sense, Ill change the name on the to part. Is 'from' also a mysql reserved word?

bradgrafelman

Beffic wrote:
Is 'from' also a mysql reserved word?

Is it in the table of reserved words I linked you to? 🙂

Beffic

Didn't see the link, I will bookmark this! Thank you very much!