connect database

[yuan]

i create a database with tables in phpMyAdmin...
but when i enter my website it will display

"Warning: Supplied argument is not a valid MySQL result resource "

but i checked the error line got nothing wrong??
code here:
$query = "select * from general where id=0 order by date limit 15";
$result = mysql_query($query);

so what's the problem?? and how to solve it?

[Mordecai]

Instead of $query = "select from general where id=0 order by date limit 15";, try:
$query = "select from general where id=0 order by date DESC limit 15";

It doesn't know which way to sort.

[yuan]

i can run it after i change to:
$query = "SELECT * FROM general WHERE id=0 ORDER BY date LIMIT $limitvalue, $limit";