Querying Database

computurk

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 44

42> $sql = "select * from news";
43> $result = mysql_query($sql);
44> while ($row = mysql_fetch_array($result))

I also pointed out on my php what $sql returns. It looks like mysql_query_$sql) is not returning anything. I have data in my table and I can write to it.

Check out:
http://63.65.24.153/data_out.php
http://63.65.24.153/data_out.txt (source)

For example, this page has no problem writing to the database.
http://63.65.24.153/data_in.php

Please help me concernin this matter

Thanks...
-CompuTurk

Anon

This line:

42> $sql = "select * from news";

needs a semicolon at the end of the query, like so:

42> $sql = "select * from news;";

Should work fine after that.

[deleted]

No, semicolons are not required.

I have said it before and nobody listens. :-)
USE ERROR CHECKING.

$query="select * from news";
if (!$result=mysql_query($query))
{
echo $mysql_error()."<BR>\n".$query."<BR>\n";
}
else
{
#process results.`
};

Anon

They may not be necessary, but none of my queries work without the semicolon. I had the same problem, and when I added the semicolon, they magically started working.

Just as a side note, the PHP manual does show semicolons being used in queries...

[deleted]

I have never put a semicolon at the end, and everything works.
Whoch versions of PHP and MySQL are you using?

Anon

$ mysql -V
mysql Ver 11.13 Distrib 3.23.35, for -freebsd4.3 (i386)

php is version 4.0.4pl1

Anon

I actually had a path problem. mySQL was not installed right. I have got it to work againby reinstalling mySQL. Thanks...