This is so simple and basic, I must be missing something....
I have php code for displaying my embroidery designs on the web page. It's
going through the mySql database and the query to pull up all the designs
for a
chosen category works fine. I have two fields in
my database called "applique" and "puffyfoam" both are set up as tinyint(1)
because all I'm storing there is a zero for no and a 1 for yes.
But for the screen output I don't want these codes to show, I'd like a
comment to show up. So I set up this "if" statement to place the proper
statement in a variable to be used in my echo statement (if both answers are
no, I don't want to print oops, I just put that there to see where stuff was
happening)...
if($applique == 1 and $puffyfoam == 0)
{
$message1 = "Digitized for APPLIQUE";
}
elseif($applique == 0 and $puffyfoam == 1)
{
$message1 = "Digitized for PUFFY FOAM";
}
elseif($applique == 1 and $puffyfoam == 1)
{
$message1 = "Digitized for APPLIQUE and PUFFY FOAM";
}
else
{
$message1 = "oops";
}
I have three records in this category that I've set up with answers to the
two fields as 1,1 0,1 and 1,0 to see what message would show .... none
should show up as "oops" since none are 0,0. I've also put the "applique"
raw field data in my echo to see if it is pulling up the right answer as
well ...
The field is showing the correct field info for applique, they're showing up
as 1,0,1 BUT every one of the designs are showing the message "oops". What
am I doing wrong???
TIA
Renee :)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
