[SOLVED] column search for value

[ricmetal]

hey,

so

how do i search a db column for a specific value?

 

 

[ricmetal]

SELECT * FROM table?

[kev wood]

you need to use the where clause of a mysql statement.  the following statement will search through a db for a specific value held by the variable $table

 

$query = "SELECT * FROM emails WHERE page = '$table'";

 

the column name is page and the variable holds the value to search for although this does not have to be a variable.

[ricmetal]

oh, ok

thanks