I want to select the 'ctype' column in the inventory table.
The Inventory table is like a list of items,with fields :
id,description,rarity,name and 'ctype'.

The 'ctype' is for getting what item can create a custom(its a virtual sim game, so its like custom pets).

I also have the 'owned_items' table that stores the owned items, it contains the
id(just an auto-increment thing), itemid(the id of the item in the inventory table), owner and the amount.

I am trying to get the items the users have, that's 'ctype' isnt 0. I am guessing this will make it an array and I'll have to use foreach or the for loop..yet I am unsure exactly what I must do.

Anyways, this is what I have so far.
PHP Code:
mysql_query("SELECT * FROM `inventory` WHERE `ctype`!='0'");
$cit mysql_fetch_array($itemcu);
$fi "SELECT * FROM `owned_items` WHERE `owner` = '" $_SESSION['id'] . "' AND `itemid` = '{$cit['id']}'";
$findi mysql_query($fi);
$result26 mysql_fetch_assoc($findi);
//Check if they dont have any custom type item
if ($result26['amount'] == '0' or $result26['amount'] == '') {
"You dont have this item.");
//It's not blank so continue
if ($result26['id'] != '') {
//Tokens, upload image and pick ID of pet the image will replace..
echo '
<form action="upload.php" method="post" enctype="multipart/form-data">
<input type="hidden" name="ck" value="' 
$_SESSION['token'] . '"><br>
Pet ID: <BR><input type="text" name="pid">
<input type="hidden" name="from" value=' 
$user '>
$co $result26['itemid'];
$i 0;
      while (
$i $co) {
$formdrop $formdrop "<option value='" $i "'>" $co "</option>";
'<select  style="width:150px" name="type">
$formdrop '

<table width="500" border="0" align="center" cellpadding="0" cellspacing="1">
<td>Upload custom image of pet
<input name="ufile" type="file" id="ufile" size="50" /></td>
<td align="center"><input type="submit" name="Submit" value="Upload" /></td>
  } else {
//They have no items to create the custom pet
echo 'Sorry You need certain items to be able to apply for a custom pet';
Thank you for you time