[Resolved] selecting multiple fields in table

[toddmarx]

I need a query that will look at a variable being passed from a url and look and get all available matches. For simplicity sake I will call the data being queried input....

here is what I have and it is not working

SELECT * FROM tablename 
WHERE field1 LIKE 'input' 
OR field2 LIKE 'input' 
OR field3 LIKE 'input'

 

I need it to look inside ALL of the fields and bring back ANY thing that is close...

[bubblenut]

It's going to be a two step process.

$pre_sql="SELECT * FROM $table LIMIT 1";
$pre_res=mysql_query($pre_sql) or die(mysql_error());
$sql="SELECT * FROM $table WHERE";
$num = mysql_num_fields($pre_res);
for($i=0; $i<$num; $i++)
	$sql.=($i>0?' || ':' ').mysql_field_name($pre_res, $i)."='input'";
$res=mysql_query($sql) or die(mysql_error());

HTH
Bubble

[toddmarx]

thanks bubblenut! That did the trick!