> Each entry in the database is essentially an entry for a
printer item
> number.
> Each item number has both a model number (model numbers
can have more than
> one
> item number, depending on how many ink cartridges and
such they may have)
> and a
> printer series number.
OK, so each record is for printer item numbers, but you are
looking for
printer series numbers. I should mention here that a database
redesign
would be the best way to do things. I don't know how many
records you're
storing, but seperting out your printer series and models
would most likely
be ideal.
If you don't want to do this, then you can just sort through
and pull the
info out of every record. Just note that as your database
grows, this will
be a more consuming process, and will only grow in size.
I start with the Printer Series page ? which lists out
> all the different series and some basic features of the
series. This page
> was
> fairly easy because the features of the series have
actual values ? like
> duty_cycle has a value of 2000, so I can list Duty Cycle
on the page and
> have
> the value come up next to it. This page also lists all
the models that
> belong
> in the series and then has links to the information
about each model.
OK. Again - if you have a page url it would help. I'm not
sure how this ^
is laid out.
> This is where I get a bit confused (okay, a lot
confused!) The features
> of
> the models are more like yes and no questions ? does it
have security
> locks?
> Yes or No. So for each feature the column would be
labels like this
> ?secr_locks? and the value in the column would either be
Y or N. If the
> answer
> is Y, I want it to print on the page ?Security Locks?
under a heading I
> have
> put statically on the page that is called ?Features? For
each column that
> has
> a Y in it, I want it to list the real wording of the
feature ? one after
> another in a list form.
Are all of them Y/N answers? If so, then just create a
function that checks
the value and prints something out.
You could also put all of your "features" into an array, and
then print that
array out in a list - again w/o knowing the format or seeing
what yur page
looks like, it's whatever you want to do.
This functio will add features to an array.
/*This function will add features to an array */
function add_feature($feature){
if ($featureName == "YES"){
features[] = $featureName;
}
return features;
}
function print_array($array){
echo '<ul>';
foreach($array as $id=>key){
echo '<li>$key</li>';
}
echo '</ul>';
Or you coudl just print them as it is:
function print_features($feature, $name){
if ($features == 'YES'){
echo $name;
}
}
In the first example, it will print a list of your features
all at once.
This would need to be done once, after you have compiled it.
It may not be
your best solution right now (with the way the rest of your
code is setup).
In the second solution, you would just have your featuers
setup like this:
<tr>
<td>PrinterName</td><td>Printer Serial
Number</td><td><?php
print_features(rs_FeatureField, "Name To Print");
?></td><td><?php
print_features(rs_FeatureFieldNext, "New Name To Print");
?></td>
HTH,
Jon
8
Replies
AdChoices