Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › Multiple Repeat regions and Recordsets question

Multiple Repeat regions and Recordsets question

Thread began 5/04/2009 11:46 am by mustang_sally_85344510 | Last modified 7/27/2010 7:05 am by mustang_sally_85344510 | 8144 views | 7 replies

5/05/2009 11:57 ammustang_sally_85344510

Still having problems here

Hello again,

I tried making one giant recordset and I couldn't get it to work properly.
It brought up inaccurate information.

I think one of my many problems is in the recordset ...

I need to change the criteria in the WHERE clause for each table.
For example:

WHERE centerId = colname AND centers.VisitorID = tourneyad.VisitorID
(for one table)
WHERE centerId = colname AND centers.VisitorID = leagues.VisitorID
(another table)
WHERE centerId = colname AND centers.VisitorID = coupon.VisitorID
(another table)

I tried using AND operator for one giant WHERE clause...and I need a situation where if a visitor doesn't have something in one of the other tables...it will still bring up their other entered information.

Thank you again, for your help.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.