Gabriel1974
Programmer
I have a search page with a form with checkboxes.
For each checkbox the names are "tipin","tipas","domin" and "domag" and values are "Investitie", "Asociere", "Industrie", "Agricultura"(values from mysql database).
In the result page, i made a recordset like this
SELECT * FROM oportunities WHERE (Tip = "vartipin" OR Tip = "vartipas") AND (Domeniu = "vardomin" OR Domeniu = "vardomag" . In the variable dialog box i complete: vartipin - default value NULL, run-time value $HTTP_POST_VARS["tipin"], vartipas - default value NULL, run-time value $HTTP_POST_VARS["tipas"], vardomin - default value NULL, run-time value $HTTP_POST_VARS["domin"] and vartipin - default value NULL, run-time value $HTTP_POST_VARS["domag"]. Evrything is fine when i submit the form, and the querry works perfectly. But if i insert a repeat region with 5 or 10 dispalys at a time, and a recordset navigation bar, only the first set of result (the first page) is OK. When i click the next link, the page that is displayed have the corect layout but the cells of the table with results are empty. What can i do?
Please ,please help me, I already have nightmares with variables and querryes.
For each checkbox the names are "tipin","tipas","domin" and "domag" and values are "Investitie", "Asociere", "Industrie", "Agricultura"(values from mysql database).
In the result page, i made a recordset like this
SELECT * FROM oportunities WHERE (Tip = "vartipin" OR Tip = "vartipas") AND (Domeniu = "vardomin" OR Domeniu = "vardomag" . In the variable dialog box i complete: vartipin - default value NULL, run-time value $HTTP_POST_VARS["tipin"], vartipas - default value NULL, run-time value $HTTP_POST_VARS["tipas"], vardomin - default value NULL, run-time value $HTTP_POST_VARS["domin"] and vartipin - default value NULL, run-time value $HTTP_POST_VARS["domag"]. Evrything is fine when i submit the form, and the querry works perfectly. But if i insert a repeat region with 5 or 10 dispalys at a time, and a recordset navigation bar, only the first set of result (the first page) is OK. When i click the next link, the page that is displayed have the corect layout but the cells of the table with results are empty. What can i do?
Please ,please help me, I already have nightmares with variables and querryes.