simple DB search help

[listenmirndt]

Hi all, im not having any luck figuring it out.,

1. Using a form, a user enters a search word (his email address):

<form method="POST" action="results.php">
Email: <input type="text" name="search">
<input type="SUBMIT" value="Submit">
</form>

2. the search word is looked for in the database

3. then the entire row is displayed wherever the search word is found.

ie. ive a table consisting of :

ID
name
email
location
filename

I am hoping to create a form, where the user enters his email, the search looks in the email field, then displays the contents of the entire row where the email address is found. (ID, name, location, email, filename)

could somone put a bit of example code?

thanks so much.

[HalfaBee]

You need something like this.

<?
$SQL = "SELECT * from YourTable WHERE email='$search'";
$result = mysql_query( $SQL );
while( $row = mysql_fetch_array( $result ) ) {
print_r( $row );
// You will have to work the formatting for yourself 🙂

}
?>

HalfaBee

[listenmirndt]

holy moly thanks man. that worked great.
ive been pulling hairs all night. knew it was a matter of about 3 lines of code. just couldnt seem to put em togeather right.

thanks so much. =D

[HalfaBee]

Don't you love forums 🙂

We only have one head and the internet has millions.

Glad you got it sorted.

HalfaBee