using explode to get different characteristics of sql query

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post by Weirdan »

Alrighty, starting off; what is Catalan????
http://en.wikipedia.org/wiki/Catalan_language
mcccy005
Forum Contributor
Posts: 123
Joined: Sun May 28, 2006 7:08 pm

Post by mcccy005 »

to explain what i'm doing, i'll tell you (now I know a bit better myself):

I (will) have a search page. The results of this are parsed to a query_generator page which will create an sql query and parse the generated query based on the search request to a results page.

Subsequently, if there are multiple pages from teh search results (ie. 20 results with only 10 results to be displayed per page); I want the user to be able to click on the title of any column in the result table and subsequently re-order the results based on the data in that table. Thus, if I have an sql query; I need to be able to modify the 'order by' and 'limit' variable thingys so that I can call the same data but in a new order!

If theres some well known better way to do what im doing, then point me towards it but odds are I'm not restarting the coding of this particular page for now. It will be handy in the future as I've learned so many things, I will probably rewrite a majority of the objects I am developing to reuse in the future once i have this first project off the ground.

And re: the query; since I will be making the query in query_generator.php, I can determine how I want the query set up - I'm really just trying to plan ahead should anybody else ever use this code and who wish to change the query made in query_generator!
Post Reply