warning: mysql_fetch_array

Hi all,
I am getting the following error trying to run the below code.

Warning: Supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\data_out.php on line 34

Line 33 - $result = mysql_query($sql);
Line 34 - while ($row = mysql_fetch_array($result)) {

I do not understand why it would not work.

You help is appreciated.

Thanks...
-CompuTurk

it means the the sql query on line 33 most likely failed. echo out $sql and see whats wrong with the sql command.

It seems there is nothing wrong with it.
$sql returns fine, but $result do not return anything.

Thank you so much for helping me...
-Serkan

I am sorry I need to make a correction,
The addresses again are:
http://63.65.24.153/data_out.php
http://63.65.24.153/data_out.txt

Thanks....
-Serkan

Try to put the name of the table (not the name of the database) in front of the fieldname f.E. tablename.heading .
If this doesn't work remove the single quote (') at the ORDER BY-command (f.E. ORDER BY date).
For better reading write the SQL-commands in upper case (SELECT, not select).

Now your query should look somehow like this:
$sql = "SELECT * FROM news WHERE ((name_of_table.date = 'something'))ORDER BY name_of_table.date";

This query works fine on my server.

Mathias