SELECT Question

[magnetica]

Hi

 

Heres an example of what im trying to do:

 

SELECT * FROM [i]table [/i] WHERE [i]row [/i] = '*'

 

So basically im trying to use the WHERE clause to get all rows. Is this possible?

 

 

[bubblegum.anarchy]

To get all the rows of a table simply use:

 

SELECT * FROM table

[magnetica]

I already know this, but I need to use the WHERE

 

Ok heres my situation. I have a drop down menu with the values Any, Action, Arcade etc

 

Now when someone clicks for example Action then the query would be:

 

SELECT * FROM table WHERE row = 'action'

 

Now when someone clicks any then obviously this isn't an actual value in the database so how do I use the WHERE clause to select all/any

 

 

[bubblegum.anarchy]

Consider something like this:

 

mysql_query($query = "SELECT * FROM table".( $_POST['select'] != "Any" ? " WHERE row = '".$_POST['select']."'" : null ));

 

[fenway]

You can use WHERE 1=1 as well, but I don't really understand why you ever want all of them.

[bubblegum.anarchy]

or WHERE TRUE