[SOLVED] how to search a table

[hasanatkazmi]

I am new to MySql, how can i search for a value in specific column in the table

suppose table is $table, and coulmn is $cloumn and I am searching for a some variable say $var

[craygo]

$sql = "SELECT * FROM `$table` WHERE `$column` = '$var'";

 

this will work as long as there is nothing but that value in the column. If there is more text you will get back nothing. You would have to use LIKE and wildcards to get more results

 

$sql = "SELECT * FROM `$table` WHERE `$column` LIKE '%".$var."%'";

 

Ray

[naveenbj]

Hello

select*from $table where $cloumn=$var;

 

I thinkit should work

 

Regards

Nj

[hasanatkazmi]

mysql_query on sql fetches an array??? is it so?

[revraz]

mysql_fetch_array fetches an array

 

mysql_query performs the query.