lammy
Posts: 49
|
| Posted: 05/20/2005, 10:29 AM |
|
Hi everyone
I am just getting my head round php and ccs.
what im trying to do is :-
i have a search text box called s_keyword i want to add a drop down list that contains 4 categories, each category uses a different table for information.
which ever category is selected the search needs to search the appropriate table and send the results to a specific page
(I have a results page for each category)
Is this something that is easy to do or as a beginner am I out of my depth at the moment.
if somebody can explain how its done I would appreciate it
|
 |
 |
peterr
Posts: 5971
|
| Posted: 05/20/2005, 12:52 PM |
|
This could be little complex, therefore I'd recommend getting more experience with simpler things first, best finishing the CCS Task Management tutorial.
Though if you like to try, a possible solution could be:
1. Create a new table that contains all 4 categories and the corresponding table names. Then use it in your listbox.
2. Use the Before Execute event to select and change the SQL dynamically, at run-time. See http://docs.codecharge.com/studio/html/ProgrammingTechn...yingOutput.html for an example of how to view the SQL statement, while you can use some PHP code to replace its value with the table that you want to use.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
