categories and items

i have never worked with items that use categories but im trying to do this.. i have it now so i can create categories n items, but i cant get them to list the items with their correct corresponding categories, here is code for page that lists the items... anyone help me get this fixed?

Code:

<?php
//if (!isset($step)) $step = "";
echo "<center>";
$result2 = dbquery("SELECT * FROM fusion_things2do_cats ORDER BY cat_id");
$data2 = dbarray($result2);
$result = dbquery("SELECT * FROM fusion_things2do WHERE thing_cat = $cat_id");
while ($data = dbarray($result)){
echo $data['thing_id'];
echo ". <b>".$data['thing_name']."</b><br>";
echo "<i>Item Category: ".$data2['cat_name']."</i><br>";
echo $data['thing_description']; 
echo "<br><br>";
if ($data['thing_status'] == 0){
echo "[<a href='".FUSION_SELF.$aidlink."&amp;completed=yes&amp;thing_id=".$data['thing_id']."'>Mark As Completed</a>]<br><hr width='30%'><br>";
} else { 
echo "<font color='yellow' weight='bold'>Item Completed.</font><br><hr width='30%'><br>"; 
}
}
echo "</center>";
?>

let me know if u need other pages, or table structure

[Join us @ facebook]

I am not sure if I understand what you want, but the logic is like this :

SELECT all root categories

While result = ......

          select subcategories

there are items and then the category they belong to. this is 2 tables, fusion_things2do (the items themselves, they have fields: thing_id, thing_name, thing_description, thing_cat, thing_status).. then a table fusion things2do_cats (the categories, they have fields: cat_id, cat_name). i want cat_id to correspond with the item_cat

[Join us @ facebook]

Then you should first query the categories, and in the while statement (that you wll get the cat results) you will query the items (one query for each category)

hmm not sure *exactly* what you mean here.. but this is what i changed:

cat query and cat data array moved inside the while statement

Code:

<?php
//if (!isset($step)) $step = "";
echo "<center>";

$result = dbquery("SELECT * FROM fusion_things2do WHERE thing_cat = $cat_id");
while ($data = dbarray($result)){
$result2 = dbquery("SELECT * FROM fusion_things2do_cats ORDER BY cat_id");
$data2 = dbarray($result2);
echo $data['thing_id'];
echo ". <b>".$data['thing_name']."</b><br>";
echo "<i>Item Category: ".$data2['cat_name']."</i><br>";
echo $data['thing_description']; 
echo "<br><br>";
if ($data['thing_status'] == 0){
echo "[<a href='".FUSION_SELF.$aidlink."&amp;completed=yes&amp;thing_id=".$data['thing_id']."'>Mark As Completed</a>]<br><hr width='30%'><br>";
} else { 
echo "<font color='yellow' weight='bold'>Item Completed.</font><br><hr width='30%'><br>"; 
}
}
echo "</center>";
?>

[Join us @ facebook]

I think it is reverse.

You should query all the categories, and then get the items for each category (item_category = $catID or something like that )

if it was reverse it would be what i had in the first place lol *is very confused*

[Join us @ facebook]

It should be something like :

Code:

<?php
$result = dbquery("SELECT * FROM fusion_things2do_cats ORDER BY cat_id");
while ($data = dbarray($result)){
   $result2 = dbquery("SELECT * FROM fusion_things2do WHERE thing_cat = " . $data['cat_id']);
   while ( $data2 = dbarray( $result2 ))
   {
        //Show the items for each category here
   }
}

eek now im getting 3 blank responses from the database

.
Item Category:


[Mark As Completed]

--------------------------------------------------------------------------------

.
Item Category:


[Mark As Completed]

--------------------------------------------------------------------------------

.
Item Category:


[Mark As Completed]

--------------------------------------------------------------------------------

Code:

<?php
//if (!isset($step)) $step = "";
echo "<center>";

$result = dbquery("SELECT * FROM fusion_things2do_cats ORDER BY cat_id");
while ($data = dbarray($result)){
   $result2 = dbquery("SELECT * FROM fusion_things2do WHERE thing_cat = " . $data['cat_id']);
   while ( $data2 = dbarray( $result2 ))
   {
echo $data['thing_id'];
echo ". <b>".$data['thing_name']."</b><br>";
echo "<i>Item Category: ".$data2['cat_name']."</i><br>";
echo $data['thing_description']; 
echo "<br><br>";
if ($data['thing_status'] == 0){
echo "[<a href='".FUSION_SELF.$aidlink."&amp;completed=yes&amp;thing_id=".$data['thing_id']."'>Mark As Completed</a>]<br><hr width='30%'><br>";
} else { 
echo "<font color='yellow' weight='bold'>Item Completed.</font><br><hr width='30%'><br>"; 
}
}
}
echo "</center>";
?>

[Join us @ facebook]

The queries are correct.

Maybe the fusion_things2do table is empty or has incorect values.

nope they are not empty, there is 3 items there

[Join us @ facebook]

Do they have equal values regarding the category ids? (thing_cat, cat_id)

i found the problem. some $data and $data2 were backwards and needed to be switched around, here is the new code. do you have any recommendations to clean this up or display it better or anything, "oh php guru nikolas"

Code:

<?php
//if (!isset($step)) $step = "";
echo "<center>";

$result2 = dbquery("SELECT * FROM fusion_things2do_cats ORDER BY cat_id");
while ($data2 = dbarray($result2))
{
   $result = dbquery("SELECT * FROM fusion_things2do WHERE thing_cat = " . $data2['cat_id']);
   while ($data = dbarray($result))
   {
echo $data['thing_id'];
echo ". <b>".$data['thing_name']."</b><br>";
echo "<i>Item Category: ".$data2['cat_name']."</i><br>";
echo $data['thing_description']; 
echo "<br><br>";
if ($data['thing_status'] == 0){
echo "[<a href='".FUSION_SELF.$aidlink."&amp;completed=yes&amp;thing_id=".$data['thing_id']."'>Mark As Completed</a>]<br><hr width='30%'><br>";
} else { 
echo "<font color='yellow' weight='bold'>Item Completed.</font><br><hr width='30%'><br>"; 
}
}
}
echo "</center>";
?>

[Join us @ facebook]

Hehe I am not a guru (or am I? )

Your code looks nice. A general tip that I could give you is that :

echo 'a';

is faster than

echo "a";

because the " " are parsed while ' ' are not. Of course this is an optimization that can increase speed very very little, but it is good to know, right?

oh.. wow.. i didnt know that lol , yes that is good to know.. from now on i will convert my echo statements to ' instead of "

[Guest]

[62.873]

Googlebot, deccanbazaar, Msnbot, hobbit