My mind? I know I left it here somewhere .. *peeks behind couch*

have you picked your nose lately ??

It's probably somewhere with mine...took off about a week ago. I put up signs and everything. I think it's a conspiracy.

Why, you hungry?

nO ...just thought you might have accidentally pulled you brain out

Hee hee .. the brain is still there, it's just my mind that I lost.

ahhh I see, said the blind man

my pen? I had it here a second ago.

Is this it?

thank you

Maybe thats what happened to it?

Are those your marbles i found???

Thanks, I thought I heard rattling somewhere ... whew.



You know, I think it is.

 CREATE TABLE users (fname VARCHAR(30), lname VARCHAR(30), info BLOB); 





 INSERT INTO users VALUES ( "Jim", "Jones", "In his spare time Jim enjoys biking, eating pizza, and classical music" ), ( "Peggy", "Smith", "Peggy is a water sports enthusiast who also enjoys making soap and selling cheese" ),( "Maggie", "Martin", "Maggie loves to cook itallian food including spagetti and pizza" ),( "Tex", "Moncom", "Tex is the owner and operator of The Pizza Palace, a local hang out joint" ) 








 <h2>Search</h2> 


 <form name="search" method="post" action="<?=$PHP_SELF?>">


 Seach for: <input type="text" name="find" /> in 


 <Select NAME="field">


 <Option VALUE="fname">First Name</option>


 <Option VALUE="lname">Last Name</option>


 <Option VALUE="info">Profile</option>


 </Select>


 <input type="hidden" name="searching" value="yes" />


 <input type="submit" name="search" value="Search" />


 </form>





 <? 


 //This is only displayed if they have submitted the form 


 if ($searching =="yes") 


 { 


 echo "<h2>Results</h2><p>"; 


 


 //If they did not enter a search term we give them an error 


 if ($find == "") 


 { 


 echo "<p>You forgot to enter a search term"; 


 exit; 


 } 


 


 // Otherwise we connect to our Database 


 mysql_connect("mysql.yourhost.com", "user_name", "password") or die(mysql_error()); 


 mysql_select_db("database_name") or die(mysql_error()); 


 


 // We preform a bit of filtering 


 $find = strtoupper($find); 


 $find = strip_tags($find); 


 $find = trim ($find); 


 


 //Now we search for our search term, in the field the user specified 


 $data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE'%$find%'"); 


 


 //And we display the results 


 while($result = mysql_fetch_array( $data )) 


 { 


 echo $result['fname']; 


 echo " "; 


 echo $result['lname']; 


 echo "<br>"; 


 echo $result['info']; 


 echo "<br>"; 


 echo "<br>"; 


 } 


 


 //This counts the number or results - and if there wasn't any it gives them a little message explaining that 


 $anymatches=mysql_num_rows($data); 


 if ($anymatches == 0) 


 { 


 echo "Sorry, but we can not find an entry to match your query<br><br>"; 


 } 


 


 //And we remind them what they searched for 


 echo "<b>Searched For:</b> " .$find; 


 } 


 ?> 

IDK if that helps or not, but I'm still going to post it.

totage's post. look above.

You may not find your mind, but you'll find Jim Jones!