search a particular text in table..?

**ronverdonk** · Mar 5 '07, 03:55 PM

I hope you are talking about a MySQL table, because what you showed in your post is a html table. But since this is the MySQL forum:

[php]
$sql = "SELECT name, description FROM table ".
" WHERE name REGEXP '$searchword' ".
" OR description REGEXP '$searchword' ".
" ORDER BY categorie ";

$conn = mysql_connect(S QL_HOST, SQL_USER, SQL_PASS)
or die("Connect error: ".mysql_error() );

mysql_select_db (SQL_DB)
or die("DB select error: ".mysql_error() );

$res = mysql_query($sq l)
or die("SQL select error: ".mysql_error() );

if (mysql_num_rows ($res) < 1)
echo 'no rsults found';

else {
// show your data
}[/php]

Ronald :cool:

**nirmalsingh** · Mar 6 '07, 04:43 AM

yah! iam talking about mysql table only. i think that this html table coding will show the user in table format. sorry..
i need a mysql query for the corresponding table format.

**ronverdonk** · Mar 6 '07, 07:06 PM

But this is a MySQL search query!!

You ask for a table search and you post a thread in the MySQL forum!! So what do you think it is??

Code:

 $sql  = "SELECT name, description FROM table ".
        " WHERE name REGEXP '$searchword' ".
        " OR description REGEXP '$searchword' ".
        " ORDER BY categorie ";

Ronald :cool:

search a particular text in table..?

search a particular text in table..?

Comment

Comment

Comment