sean.ferguson
OSNN Veteran Addict
- Joined
- 4 Jul 2003
- Messages
- 1,693
Ok, i have been looking around on places such as php.resourceindex.com and hotscripts.com but have not found anything that is free/opensource that can do the job nicely. So, it looks like i need to code one, however i am very rusty with php and have little to no experience of SQL.
What i want is to create a sql database which will obviously hold the information. I will need as far as i know, fields to hold the following: "Id", "Name", "Description", "Long Term Treatment" and "Short Term Treatment". Id can be an auto incremented number. Everything else will be letters.
I then need to be able to display the information on a page, users need to be able to search through the records, by either name, description or id. I also want every records "name" to appear in a drop down menu, so they can simply look through them all if they wish.
On the first visit to the page, only the search function and drop down menu should be visable. Records will only be shown after a search has took place or after a selection has been made from the drop down menu.
Once a search has been submitted if the returned records are >20 i would like a message to appear "Your search has returned too many results, please refine your search."
If a search return 20 or less records then i want them all to be displayed. Obviously a selection from the drop down menu will only show that one record.
I have attached a very simple layout for you to try and understand slightly better what i mean.
Preferably, a simple form to enter the information into the database would be nice and shouldnt be too hard to code. So long as i can remember how i done it last time. If i cant it shouldnt be too hard to enter information straight from phpmyadmin and edit it further if required.
Any help or pointers anyone can give me would be great. It will need to be very customisable as i need it to fit in perfectly with two different (validating) style sheets. The actual search engine and record display finction should validate to xhtml 1.1 if possible, but i may need help with that too as i seem to always hit problems with validation and forms. :s
Thanks in advance for any help given.
What i want is to create a sql database which will obviously hold the information. I will need as far as i know, fields to hold the following: "Id", "Name", "Description", "Long Term Treatment" and "Short Term Treatment". Id can be an auto incremented number. Everything else will be letters.
I then need to be able to display the information on a page, users need to be able to search through the records, by either name, description or id. I also want every records "name" to appear in a drop down menu, so they can simply look through them all if they wish.
On the first visit to the page, only the search function and drop down menu should be visable. Records will only be shown after a search has took place or after a selection has been made from the drop down menu.
Once a search has been submitted if the returned records are >20 i would like a message to appear "Your search has returned too many results, please refine your search."
If a search return 20 or less records then i want them all to be displayed. Obviously a selection from the drop down menu will only show that one record.
I have attached a very simple layout for you to try and understand slightly better what i mean.
Preferably, a simple form to enter the information into the database would be nice and shouldnt be too hard to code. So long as i can remember how i done it last time. If i cant it shouldnt be too hard to enter information straight from phpmyadmin and edit it further if required.
Any help or pointers anyone can give me would be great. It will need to be very customisable as i need it to fit in perfectly with two different (validating) style sheets. The actual search engine and record display finction should validate to xhtml 1.1 if possible, but i may need help with that too as i seem to always hit problems with validation and forms. :s
Thanks in advance for any help given.