help with select statement

[gple]

mysql_query("select * from table where cat='$variable'")

 

what value must $variable be to select all records?

[Vermillion]

<?php

mysql_query("SELECT * EXCEPT field1, field2, etc FROM table WHERE);

?>

 

There are probably better methods to do that.

[andy_b42]

mysql_query("SELECT * EXCEPT field1, field2, etc FROM table WHERE);

 

Correct me if i am wrong, but i believe adding in a WHERE clause requires that arguments be supplied, i think the code above would just error as soon as the database attempted to execute the query.

 

gple, if you remove your where clause completely, youshould get back all of the results in the table e.g.

 

mysql_query("select * from table")