Select statement not working out...

[striker]

I have a really easy SQL statement that isn't returning what I expect. I want to return all of the rows from the table configurations where the memory field contains a 3 or a 4. These fields have values of "1,2,3,4" or something similar. When I run the query, it returns all of the values, not just the ones that have a 3 or 4 in the memory field. Any ideas? Thanks!

$sql_statement = "SELECT * FROM configurations WHERE memory LIKE '%3%' OR '%$4%' ";

[junebug]

why not do this:

$sql = "select * from configurations where memory = '3' or memory = '4'";

[dstockto]

The reason you are getting everything back is because of a silly little $ in your query.

$sql_statement = "SELECT * FROM configurations WHERE memory LIKE '%3%' OR '%$4%' ";

The last part should be '%4%' not '%$4%'.

The $4 makes php think of a variable, which since there is no $4 variable, it puts in nothing in place of $4, so you get '%%' which is the same as saying

Give me all fields from the table configurations where memory contains a 4, or memory contains any character at all, including no character.

Dave