Data Issue

hi,

i doing dynamic application company sells printers. using mysql , php. on first page, need list each printer series , features of series. problem - had internal database has each printer listed in it, along printer series belongs , features of each series - in 1 table. if 2 printers belong same series, same series features, repeated - no separate linked table series , features.

this cannot figure out. printer item number listed , each of features has it's own column. if printer has feature - gets "yes" in database table. there 20 features each printer item may or may not have. how write record set pulls features has "yes" series, on actual page print feature is? if printer item number 1000 has yes in "doub_tray" column , "yes" in "duplex" column, how list:
features:
* double tray
* duplex printing

on actual web page? have have separate recordset each feature??

thanks!

you should able pull in of printer records in 1 sql
statement, , seperate them out programatically.

i started on code below, need know more before go
further.

1. know printer categories have, or generated
a list? or entered printer descirption?
standard, defined, or text field?

2. how printers being printed on page? have example
page? can show me *want* or improvements you're
wanting make on existing page?

3. sounds need list *series* of printers, not
actual printers themselves, true? want show each
series has?

/*this function add features array */
function add_feature($feature){
if ($featurename == "yes"){
features[] = $featurename;
}
return features;
}

//this loop through recordset of informaiton ,
sort out.
do{
$printerid = rs info;
$double_tray = rs_doub_tray
/* set of variables in statement. use
"extract" it's easier way dw recordsets, think */





"tccdover" <webforumsuser@macromedia.com> wrote in message
news:ea8e4b$7b9$1@forums.macromedia.com...
> hi,
>
> doing dynamic application company sells printers.
> using mysql , php. on first page, need list each printer
> series ,
> features of series. problem - had internal
> database
> has each printer listed in it, along printer series
> belongs
> , features of each series - in 1 table. if 2
> printers belong same series, same series features,
> repeated -
> no separate linked table series , features.
>
> cannot figure out. printer item number listed ,
> each
> of features has it's own column. if printer has
> feature -
> gets "yes" in database table. there 20 features
> each
> printer item may or may not have. how write record set pulls
>
> features has "yes" series, on actual page
> print
> feature is? if printer item number 1000 has yes in
> "doub_tray" column , "yes" in "duplex" column, how
> list:
> features:
> * double tray
> * duplex printing
>
> on actual web page? have have separate recordset each
> feature??
>
> thanks!
>
>

More discussions in Develop server-side applications in Dreamweaver

adobe