Search Script For Single Table

[Anon]

Does anyone have a script example where I open all fields one table; enter a word, press submit and it displays results?

I find a lot or weird stuff out there (mostly for web-links)....Just a basic db_connect, a form, and a results page for one table.

Thanks.

dominic

[Anon]

Sure. Use this sample:

<?php

$txt = "<TABLE>\n";

$Conn = mysql_connect("server","username","password");
$query = mysql_query("SELECT * FROM table",$Conn);

$NumRows = mysql_num_rows($query);
$NumFields = mysql_num_fields($query);

$txt.="<TR>\n";

for($z=0;$z<$NumFields;$z++){

$txt.="<TD ALIGN=\"CENTER\">".mysql_field_name($query,$z)."</TD>\n";

}

$txt.="</TR>\n";

for($i=0;$i<$NumRows;$i++){

$col = ($i%2 == 0) ? "#CCCCCC" : "#FFFFFF";

$txt.="<TR BGCOLOR=\"".$col."\">\n";
for($n=0;$n<$NumFields;$n++){
$txt.="<TD>".mysql_result($query,$i,$n)."</TD>\n";
}
$txt.="</TR>\n";
}

$txt.="</TABLE>\n";

echo $txt;

?>

[Anon]

The query i used was

SELECT * FROM table

yoou wanted to search for an specific word, like in

SELECT * FROM table WHERE field = '".$word."'

Nonetheless, the table to display the results will be as valid for any query you want to put to it.

fLIPIS