Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recordset navigation problem with Dreamweaver. HELP ME!!!

Status
Not open for further replies.

Gabriel1974

Programmer
Joined
Jun 3, 2004
Messages
1
Location
RO
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.
 
sounds more like the way you are handling the results with PHP , than a mysql problem in which case some PHP code would be beneficial.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.
 
Macromedia Dreamweaver is a great tool as far as WYSIWYG page layout goes. Once you start using it as a PHP editing tool and the MM specific chunks of code it gets much more complicated.
My recommendation is to write your own PHP code. It will enhance your abilities and make you a more valuable asset to whatever project you work with.

Also, without any code posted there's not much we can do to help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top