In Progress

MySql Website Search Script

Need a php script written to search the mysql database and return the requested results. A txt file containing the table structures is attached for reference. There are four tables (tier0,tier1,tier2,tier3). The sample table information is setup like a tree structure, where each table contains information about the other tables. The script should search the name field of each table except ('tier0') and return the sample output below if the name field matches any of the tables (name field).

Provide a summary of the results: (ie.. showing 1 of 5 results)

If more than 10 results, a previous/next link.

Sample Output (Similar to Google)


Main Cat 1 ('tier0' name)

Business (tier1 name) - Adjustments ('tier2' name)

(listing of 'tier3' names that match 'tier2' id)


Skills: PHP

See more: mysql database search script, website search script, website business information, tree database structure, search structures, search a tree, link structures, mysql search script, php mysql search table script, linking mysql output website, search script mysql, script mysql search, sample mysql website, search script mysql database, mysql script search name, to search, website structure, website names, summary table, structures, search match, search file, netsolve, Mysql, database script

About the Employer:
( 6 reviews ) Austin, United States

Project ID: #48132

Awarded to:


Glad to work. Regards

$50 USD in 1 day
(290 Reviews)

3 freelancers are bidding on average $42 for this job


I can start immediately and have this done for you today.

$30 USD in 0 days
(13 Reviews)

see pmb for details;)

$45 USD in 1 day
(0 Reviews)