HI,

I have currently produced a database with information that is retruned in dreamweaver to produce a index page/ subpage directory site. This all works fine...but is limited.

What I want to be able to do is have a database that retruns full records for one client and then only selected records for antoher but based in the same recordset.

Therefore I was hoping I could have a yes/no column in the database with a script that allows full details to be displayes if column X says 'Yes' and partial details o be dispayed if column X says 'No'.

Is this even possible, Sorry I am a complete novice.

Any help would be greatly appreciated.

Regards

Any ideas, or guidance...

its all driven from your SQL query

Are you using the Dreamweaver wizards for this?

How are your PHP skills?

Don't use Dreamwaver to make auto-stuff [records, pages etc] cause you'll only get into a lot of problems.

So, use a simple database connection, with a simple SQL query. All you have to do is to add some conditions

like davidj says, it depends of you PHP knowledge

Many thanks ofr the replies. Unfortuantely I am a php virgin and am only just starting to get to grips with it, hence at present I am using the Dreamweaver wizards.

Do you have any ideas where I could get a query or idea of how to write one efrfectively?

Of - course it's possible just fire the sql Query like
SELECT column_name/* FROM table_name ; having capacity to retrieve the data from table, along with that you use basic programing concept,like looping and array.

If you'll show the code here then I'll correct them.

Hi,

As you have guessed from the title I am wanting to return records to my site if a certain column in the site says yes and return fewer records if the same column says no.

Any help greatly appreciated.

Regards

Assuming the database supports SQL,

SELECT column-list FROM table WHERE column = 'yes';

THREE threads merged