Link to home
Start Free TrialLog in
Avatar of mikemike12
mikemike12

asked on

Hide Mutliple Records with dreamweaver show records behavior

I'm using Dreamweaver and PHP.  I have data from 3 different tables that I'm trying to display on the same page.  Dreamweaver will only you apply the "show record if" behavior to one recordset at a time.  I need the same data to be displayed and respond to three different recordsets not just one. Any suggestions.
Avatar of Jason C. Levine
Jason C. Levine
Flag of United States of America image

You can't use the wizard to do it due to the restriction so you need to switch to code view and write your own PHP to handle it.

Can you give me an example of how it should work?
Avatar of mikemike12
mikemike12

ASKER

Yes.  Basically, I'd like it to work with conditions.  Let's say recordset 1 is empty. I use Show (my message) if recordset 1 is empty, if recordset 2 has data, then the message should not show because becuase even though recordset 1 is empty, recordset 2 has data.  The way it works now, recordset 1 can only discern the data in recordset 1 it can't react to recordset 2.  
Okay, how much PHP do you know?
I can read it and understand it.  I make too many errors when I try to write it.  It drives me nuts.  
ASKER CERTIFIED SOLUTION
Avatar of Jason C. Levine
Jason C. Levine
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
absolutely makes sense.  I'll give it a try tonight.
this is pretty nice.  Do you guys always respond this quickly?  Do you support dreamweaver, php, javascript, and sql
>> Do you guys always respond this quickly

It varies depending on when and where you post.  Usually you get a response within a few hours of posting

>> Do you support dreamweaver, php, javascript, and sql

There are very few people who watch the Dreamweaver topic, but lots and lots who watch the PHP, MySQL, HTML, and Javascript zones.  When you post, cross post the question in multiple relevant zones for better responses.  We're loosely organized and all volunteers...this isn't like a help desk where we can all see each other.