Searching MYSQL Table using PHP???

Anon

I need a PHP script to search a MYSQL table and display output....i hve no idea how to do this..can someone please help me

thanks

Anon

Ok i got this working.......
but the problem is, its not searching the entire field......only the first word and not the whole string...how can i get it to search the whole string???

thanks

result = mysql_query ("SELECT * FROM test
WHERE file LIKE '$file%'
AND people LIKE '$people%'
AND des LIKE '$des%'
");

if ($row = mysql_fetch_array($result)) {
do {
print $row["file"];
print (" ");
print $row["people"];
print (" ");
print $row["des"];
print (" ");
} while($row = mysql_fetch_array($result));
} else {print "Sorry, no records were found!";}}

else { ?>

ahsanmani

I think you can use the following code.
I use IIS 5.0 in win2000 OS.

<?
$link=mysql_connect("localhost");
@mysql_select_db(DBASE Name);
$query=mysql_query("--SQL Query goes here--");
$row= mysql_fetch_array($query);
?>

Anon

N/M PEOPLE...I GOT IT

THANKS

mithril

Ahsan Mani wrote:

<?
$link=mysql_connect("localhost");
@mysql_select_db(DBASE Name);
$query=mysql_query("--SQL Query goes here--");
$row= mysql_fetch_array($query);
?>

This code will only give you the first row returned. To read multiple returned rows use this:

<?php

$link=mysql_connect("localhost");

@mysql_select_db(DBASE Name);

$query=mysql_query("--SQL Query goes here--");

while ($row= mysql_fetch_array($query)) {

// do something with the returned $row

}
?>

Anon

You can do like this:
Lets say if your table is employee having fields as
i. empid
ii. empname
iii. empsalary

Ok, to get the data as output here is the code:

connect to your database first. after that

$query="select * from employee";
$result=mysql_query($query);
$count=mysql_numrows($result);

if ($count == "0")
{
print "Database Empty\n";
}
else
{
if ($row=mysql_fetch_array($result))
{
do
{
print "Emp. Id: $row[empid]"."<br>";
print "EMP. name: $row[empname]";
print "salary: $row[empsalary]";
}while($row=mysql_fetch_array($result));
} //end if

}//end count