searching a MySQL database

[brianN]

I wasnt sure whether to post this here or on the newbies board. OK here is the deal, im trying to create a script that will search the database and dynamically (sp) generate a page with the info in the database. I made the page with the forms and all that the user fills out for the search but I dont have a clue how to make it search the whole database. This is the page with the search form http://cichlids.coolfreepages.com/search2.htm

[sfullman]

the only way I know to search multiple fields in a TABLE is as follows

select * from TABLE
where
CONCAT(field1, field2, field3, field4) like '%$CommonName%' or
CONCAT(field1, field2, field3, field4) like '%$ScientificName%'

Review the function page in mysql manual to get more

Also, that "common name" in the input should disappear when you click it, try this :-) ...

<input name ='commonname' value='Common Name' onFocus="if(this.value=='Common Name'){this.value='';}" onBlur="if(this.value==''){this.value='Common Name';}">

Makes your site more professional, send me a link at [e-mail] when you get it done, looks very cool!!!!!

Sam