Code: Select all
$itemQuery = mysql_query("SELECT * FROM stardrome_store WHERE planet='$planet' AND colony='$colony' AND type='Healing' ORDER BY RAND() LIMIT 1");
//
while($row = mysql_fetch_array($itemQuery)){
$name = $row['name'];
$stats = $row['stats'];
$statAdd = $row['stat_add'];
$price = $row['price'];
$randid = rand(1000,999999999);
$type = $row['type'];
$leveluse = $row['use_level'];
$slot = $row['slot'];
}
$countQuery = mysql_query("SELECT * FROM inventory WHERE name='$name' AND id='$id'");
$query2 = mysql_num_rows($countQuery) or die("crap");
while($row = mysql_fetch_array($query)){
$pqty = $row['qty'];
$pname = $row['name'];
}
yet there is nothing wrong with the code 0.o
ir is there and i am missing it?