some help

blankextacy · January 14, 2007

Hi, im new to check boxes with php im trying to make it so players can trade items in my game but im not sure how they and check the boxes and make it insert the items checked into the database im trying to make it print all of the ids of the items.
[code]if ($_GET['tbid']) {
$user = mysql_fetch_array(mysql_query("select * from users where id='$tbid'"));
print"<table border><tr><td width=350>
<center>

$user[name]'s ITEMS

</center>
</td>
<td width=350>
<center>

YOUR ITEMS

</center>
</td>
</tr>
<tr>
<td>
<form method=post action=tradeblock1.php?action=offer>";
$item1 = mysql_query("select * from items WHERE owner=$user[id] and tb=1 order by id");
while ($item = mysql_fetch_array($item1)) {

print"<input type=checkbox name=item value='$item[id]'/>";
if ($item[gem1] == 0) {
print "$item[name] Attack: $item[attack] HP: $item[hp] Exp Per Turn: $item[ept] Rage Per Turn: $item[rpt] Income: $item[mpt] </center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";
}
if ($item[gem1] == 2 && $item[gem2] == 0) {
print "$item[name] <img src=images/g1.png> Attack: $item[attack] HP: $item[hp] Exp Per Turn: $item[ept] Rage Per Turn: $item[rpt] Income: $item[mpt] </center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";
}
if ($item[gem2] == 2 && $item[gem3] == 0) {
print "$item[name] <img src=images/g1.png><img src=images/g2.png> Attack: $item[attack] HP: $item[hp] Exp Per Turn: $item[ept] Rage Per Turn: $item[rpt] Income: $item[mpt] </center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";
}
if ($item[gem3] == 2 && $item[gem4] == 0) {
print "$item[name] <img src=images/g1.png><img src=images/g2.png><img src=images/g3.png> Attack: $item[attack] HP: $item[hp] Exp Per Turn: $item[ept] Rage Per Turn: $item[rpt] Income: $item[mpt] </center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";
}
if ($item[gem1] == 2 && $item[gem2] == 2 && $item[gem3] == 2 && $item[gem4] == 2) {
print "$item[name] <img src=images/g1.png><img src=images/g2.png><img src=images/g3.png><img src=images/g4.png> Attack: $item[attack] HP: $item[hp] Exp Per Turn: $item[ept] Rage Per Turn: $item[rpt] Income: $item[mpt] </center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";

}
print" ";
}
print"</td>
<td>";

$item1 = mysql_query("select * from items WHERE owner=$stat[id] and status=0 and tb=0 order by id");
while ($item = mysql_fetch_array($item1)) {

print"<input type=checkbox name=item1 value='$item[id]'/>";
if ($item[gem1] == 0) {
print "$item[name] Attack: $item[attack] HP: $item[hp] Exp Per Turn: $item[ept] Rage Per Turn: $item[rpt] Income: $item[mpt] </center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";
}
if ($item[gem1] == 2 && $item[gem2] == 0) {
print "$item[name] <img src=images/g1.png> Attack: $item[attack] HP: $item[hp] Exp Per Turn: $item[ept] Rage Per Turn: $item[rpt] Income: $item[mpt] </center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";
}
if ($item[gem2] == 2 && $item[gem3] == 0) {
print "$item[name] <img src=images/g1.png><img src=images/g2.png> Attack: $item[attack] HP: $item[hp] Exp Per Turn: $item[ept] Rage Per Turn: $item[rpt] Income: $item[mpt] </center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";
}
if ($item[gem3] == 2 && $item[gem4] == 0) {
print "$item[name] <img src=images/g1.png><img src=images/g2.png><img src=images/g3.png> Attack: $item[attack] HP: $item[hp] Exp Per Turn: $item[ept] Rage Per Turn: $item[rpt] Income: $item[mpt] </center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";
}
if ($item[gem1] == 2 && $item[gem2] == 2 && $item[gem3] == 2 && $item[gem4] == 2) {
print "$item[name] <img src=images/g1.png><img src=images/g2.png><img src=images/g3.png><img src=images/g4.png> Attack: $item[attack] HP: $item[hp] Exp Per Turn: $item[ept] Rage Per Turn: $item[rpt] Income: $item[mpt] </center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";

}
print" ";
}
print"Offer <input type=text name=pts size=3> Points. ($stat[trans_points] available) </td>
</tr>";
print"<tr>
<td colspan=2><center>
<input type=submit value=\"SUBMIT TRADE\"></form></center></td></tr>";
print"</table>";
exit;
}
if ($action == offer) {
$it1 = mysql_query("select * from items WHERE id='$item'");
while ($it = mysql_fetch_array($it1)) {
print"$it[id]";
}

exit;
}[/code]

blankextacy · January 15, 2007

Ok, i figured out why it wasnt printing but it only prints one of the 2 ids i selected im trying to make it print all of the things ive checked. heres what ive got now.[code]print"<input type='checkbox' name='item[]' value='$item[id]'/>";
if ($item[gem1] == 0) {
print "$item[name] Attack: $item[attack] HP: $item[hp] Exp Per Turn:

$item[ept] Rage Per Turn: $item[rpt] Income: $item[mpt] </center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";
}
if ($item[gem1] == 2 && $item[gem2] == 0) {
print "$item[name] <img src=images/g1.png> Attack: $item[attack] HP:

$item[hp] Exp Per Turn: $item[ept] Rage Per Turn: $item[rpt] Income: $item[mpt] </center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";
}
if ($item[gem2] == 2 && $item[gem3] == 0) {
print "$item[name] <img src=images/g1.png><img

src=images/g2.png> Attack: $item[attack] HP: $item[hp] Exp Per Turn: $item[ept] Rage Per Turn:

$item[rpt] Income: $item[mpt] </center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";
}
if ($item[gem3] == 2 && $item[gem4] == 0) {
print "$item[name] <img src=images/g1.png><img src=images/g2.png><img

src=images/g3.png> Attack: $item[attack] HP: $item[hp] Exp Per Turn: $item[ept] Rage Per Turn:

$item[rpt] Income: $item[mpt] </center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";
}
if ($item[gem1] == 2 && $item[gem2] == 2 && $item[gem3] == 2 && $item[gem4] == 2) {
print "$item[name] <img src=images/g1.png><img src=images/g2.png><img

src=images/g3.png><img src=images/g4.png> Attack: $item[attack] HP: $item[hp] Exp Per Turn: $item[ept] Rage Per

Turn: $item[rpt] Income: $item[mpt] </center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";

}
if ($item[part] == Q) {
print "$item[name] [QUEST ITEM]</center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";
}
print" ";
}
print"</td>
<td>";

$item1 = mysql_query("select * from items WHERE owner=$stat[id] and status=0 and tb=0");
while ($item = mysql_fetch_array($item1)) {

print"<input type=checkbox name=item1[] value='$item[id]'/>";
if ($item[gem1] == 0) {
print "$item[name] Attack: $item[attack] HP: $item[hp] Exp Per Turn:

$item[ept] Rage Per Turn: $item[rpt] Income: $item[mpt] </center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";
}
if ($item[gem1] == 2 && $item[gem2] == 0) {
print "$item[name] <img src=images/g1.png> Attack: $item[attack] HP:

$item[hp] Exp Per Turn: $item[ept] Rage Per Turn: $item[rpt] Income: $item[mpt] </center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";
}
if ($item[gem2] == 2 && $item[gem3] == 0) {
print "$item[name] <img src=images/g1.png><img

src=images/g2.png> Attack: $item[attack] HP: $item[hp] Exp Per Turn: $item[ept] Rage Per Turn:

$item[rpt] Income: $item[mpt] </center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";
}
if ($item[gem3] == 2 && $item[gem4] == 0) {
print "$item[name] <img src=images/g1.png><img src=images/g2.png><img

src=images/g3.png> Attack: $item[attack] HP: $item[hp] Exp Per Turn: $item[ept] Rage Per Turn:

$item[rpt] Income: $item[mpt] </center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";
}
if ($item[gem1] == 2 && $item[gem2] == 2 && $item[gem3] == 2 && $item[gem4] == 2) {
print "$item[name] <img src=images/g1.png><img src=images/g2.png><img

src=images/g3.png><img src=images/g4.png> Attack: $item[attack] HP: $item[hp] Exp Per Turn: $item[ept] Rage Per

Turn: $item[rpt] Income: $item[mpt] </center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";

}
if ($item[part] == Q) {
print "$item[name] [QUEST ITEM]</center>','#666666', 125)\";
onMouseout=\"hideddrivetip()\">$item[name]";
}
print" ";
}
print"Offer <input type=text name=pts size=3> Points. ($stat[trans_points] available) </td>
</tr>";
print"<tr>
<td colspan=2><center>
<input type=submit value=\"SUBMIT TRADE\"></form></center></td></tr>";
print"</table>";
exit;
}
if ($action == offer) {
$item = $_POST['item'];

$items1 = mysql_query("select * from items WHERE id=$item");
while ($items = mysql_fetch_array($items1)) {
print"$items[name]";
}
}

?>[/code]

Sign In

some help

Recommended Posts

blankextacy

Link to comment

Share on other sites

blankextacy

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information