Home > Archive > PHP DB > April 2004 > What's wrong with this IF statement?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
What's wrong with this IF statement?
|
|
| Robert Sossomon 2004-04-22, 3:35 pm |
| My IF statement should be picking up on the numbers, and if the number
matches not be displaying out the information, however I look at the
outputted page and the information is still there, what have I got wrong
on the code?
<CODE SNIPPET>
//Show categories first
$get_cats = "select id_num, id_name, description, cat_code from
categories order by id_name";
$get_cats_res = mysql_query($get_cats) or die(mysql_error());
if (mysql_num_rows($get_cats_res) < 1)
{
$display_block = "<P><em>Sorry, no categories to browse.</em></P>";
}
else
{
while ($cats = mysql_fetch_array($get_cats_res))
{
$cat_id = $cats[id_num];
if ($cat_id != "53" || $cat_id != "54" || $cat_id != "55" || $cat_id
!= "117" || $cat_id != "118" || $cat_id != "74")
{
$cat_title = strtoupper(stripslashes($cats[id_name]));
$cat_desc = stripslashes($cats[description]);
$display_block .= "<strong><a
href=$_SERVER[PHP_SELF]?cat_id=$cat_id>$cat_title
$cat_desc</a></strong><br>\n";
while ($items = mysql_fetch_array($get_items_res))
{
$item_id = $items[id];
$item_num = $items[item_num];
$item_desc = stripslashes($items[description]);
if ($item_num != "ABC-R37" || $item_num != "ABC-R42" || $item_num
!= "HB-99100" || $item_num != "RO-PUMPS" || $item_num != "ML-HDGALJUG"
|| $item_num != "PFS-CAC21" || $item_num != "PFS-CO2")
{
$item_num = ltrim($item_num);
$item_num = rtrim($item_num);
$display_block .= " <em><strong><a
href=\"catalog/$item_id.html\">$item_num</a></strong> -
$item_desc</em><br>\n";
}
}
<END SNIPPETS>
My assumption is that BOTH IF statements are not working correctly since
the logic is that if they are built the same they would react the same.
HELP!
TIA!
Robert
| |
| Torsten Roehr 2004-04-22, 4:33 pm |
| "Robert Sossomon" <robert@gcnorris.com> wrote in message
news:026001c4289c$6be07d60$6601010a@root
2...
> My IF statement should be picking up on the numbers, and if the number
> matches not be displaying out the information, however I look at the
> outputted page and the information is still there, what have I got wrong
> on the code?
>
> <CODE SNIPPET>
> file://Show categories first
> $get_cats = "select id_num, id_name, description, cat_code from
> categories order by id_name";
> $get_cats_res = mysql_query($get_cats) or die(mysql_error());
>
> if (mysql_num_rows($get_cats_res) < 1)
> {
> $display_block = "<P><em>Sorry, no categories to browse.</em></P>";
> }
> else
> {
> while ($cats = mysql_fetch_array($get_cats_res))
> {
> $cat_id = $cats[id_num];
> if ($cat_id != "53" || $cat_id != "54" || $cat_id != "55" || $cat_id
> != "117" || $cat_id != "118" || $cat_id != "74")
First of all remove the double quotes because you are dealing with integers.
Regards, Torsten
> {
> $cat_title = strtoupper(stripslashes($cats[id_name]));
> $cat_desc = stripslashes($cats[description]);
> $display_block .= "<strong><a
> href=$_SERVER[PHP_SELF]?cat_id=$cat_id>$cat_title
> $cat_desc</a></strong><br>\n";
> while ($items = mysql_fetch_array($get_items_res))
> {
> $item_id = $items[id];
> $item_num = $items[item_num];
> $item_desc = stripslashes($items[description]);
> if ($item_num != "ABC-R37" || $item_num != "ABC-R42" || $item_num
> != "HB-99100" || $item_num != "RO-PUMPS" || $item_num != "ML-HDGALJUG"
> || $item_num != "PFS-CAC21" || $item_num != "PFS-CO2")
> {
> $item_num = ltrim($item_num);
> $item_num = rtrim($item_num);
> $display_block .= " <em><strong><a
> href=\"catalog/$item_id.html\">$item_num</a></strong> -
> $item_desc</em><br>\n";
> }
> }
> <END SNIPPETS>
>
> My assumption is that BOTH IF statements are not working correctly since
> the logic is that if they are built the same they would react the same.
> HELP!
>
> TIA!
> Robert
|
|
|
|
|