I have a mysql db with several linked tables in it. Does anyone know where a good tutorila is on how to create a search page to return results in a table format?
These are the tables:
company
countries
course_titles
course_type
employee_level
experience_level
hours
industries
position
reg_type
wage_level
I only want to search using country, company and position with the position being the central table that all the other tables work off
I would like the results to be hyperlinked so that the rest of the information from the db for that position appears on another page.
Search page using mysql db
Moderator: General Moderators
Are you asking how to perform a JOIN on the tables?
Or do you need an entire application from the PHP code to the SQL?
You'll find tutorials to do 'some' of what you're asking, but it sounds you basically need:
Or do you need an entire application from the PHP code to the SQL?
You'll find tutorials to do 'some' of what you're asking, but it sounds you basically need:
- A form to submit search parameters.
- PHP to receive that form and logically determine which columns to search on.
- Create an SQL statement based on that logic.
- Execute the query, display the results.
Hi bdlang,
I guess the four things you mentioned are what I need done. They were:
- A form to submit search parameters.
- PHP to receive that form and logically determine which columns to search on.
- Create an SQL statement based on that logic.
- Execute the query, display the results.
I cannot figure out the search system for my db so help with this would be great.
I would love to have someone work through this with me so I can compete it.
Thank you
I guess the four things you mentioned are what I need done. They were:
- A form to submit search parameters.
- PHP to receive that form and logically determine which columns to search on.
- Create an SQL statement based on that logic.
- Execute the query, display the results.
I cannot figure out the search system for my db so help with this would be great.
I would love to have someone work through this with me so I can compete it.
Thank you
Help with search
Actually I can create the [s]frm[/s] form to do the search so its [s]jt[/s] just the other three areas that I need help with
[url=http://forums.devnetwork.net/viewtopic.php?t=30037]Forum Rules[/url] Section 1.1 wrote:11. Please use proper, complete spelling when posting in the forums. AOL Speak, leet speak and other abbreviated wording can confuse those that are trying to help you (or those that you are trying to help). Please keep in mind that there are many people from many countries that use our forums to read, post and learn. They do not always speak English as well as some of us, nor do they know these aberrant abbreviations. Therefore, use as few abbreviations as possible, especially when using such simple words.
Some examples of what not to do are ne1, any1 (anyone); u (you); ur (your or you're); 2 (to too); prolly (probably); afaik (as far as I know); etc.