Search found 4 matches

by rixxe
Wed Oct 27, 2004 11:39 am
Forum: PHP - Code
Topic: Pagination prob w/ multiple criteria query
Replies: 7
Views: 818

ok, I corrected this and splitted the code into 2 pages. First page builds the query, based on which field is used, second one shows the results. Variables are being passed using sessions. Same smurf; it doesn't work, same results as when it was all on 1 page...
by rixxe
Wed Oct 27, 2004 9:30 am
Forum: PHP - Code
Topic: Pagination prob w/ multiple criteria query
Replies: 7
Views: 818

OK three possibilities to assist: 1) Why don't you just pass the user requested variables instead of the SELECT. Will be shorter. 2) make the buttons (next/previous) submit a form (POST variables can be larger than GET 3) Place the search parameters into the database as a "Last Search By User&...
by rixxe
Wed Oct 27, 2004 7:05 am
Forum: PHP - Code
Topic: Pagination prob w/ multiple criteria query
Replies: 7
Views: 818

§

ok, so I tried to create a session variable, but it still doesn't work. The $sql variable changes its value when I browse the results. What's wrong?? Here's the code with the modifications. This time, the function is included aswell. <? session_start(); $_SESSION['sql'] = $sql; ?> <HTML> <HEAD> <TIT...
by rixxe
Tue Oct 26, 2004 9:44 am
Forum: PHP - Code
Topic: Pagination prob w/ multiple criteria query
Replies: 7
Views: 818

Pagination prob w/ multiple criteria query

Hi everybody! I have a page which searches a DB using mySQL queries. Since there are several criterias the user might use I had to write several queries for each case. Then through 'if' instructions a query is chosen. It works well, until I introduce a pagination function (the first results are disp...