Steve4900

or can anyone give me simpler piece of code that will work? Cheers for all your help

I have a shopping basket and i want a user to select from a check box a game that they dont want to buy which they entered by mistake this is what i got so far $conn = pg_connect("blah blah"); echo '<form name="hede" method="POST" action="cart.php">'; echo "<table border='5'>"; $res = pg_query ($conn, "SELECT * from Top where $res=e($sql);"); while ($row = pg_fetch_assoc($res)) { echo "<tr>"; echo "<td>"; echo "<input type=\"checkbox\" name=\"games[]\" value=\"" . $row['refcode'] ."\">"; echo "</td>"; echo "<td>"; echo $row['title']; echo "</td>"; echo "<td>"; echo $row['description']; echo "</td>"; echo "<td>"; echo $row['price']; echo "</td>"; echo "</tr>"; if($delete){ for($i=0;$i<$count;$i++){ $del_id = $checkbox[$i]; $sql = "DELETE FROM Top WHERE id='$del_id'"; $res = e($sql); } } } echo "</table>\n"; echo '</form>'; ?> But i think im getting my_sql confused with postgresql any ideas cheers and i need it in postgresql

I have a shopping basket and i want a user to select from a check box a game that they dont want to buy which they entered by mistake this is what i got so far $conn = pg_connect("blah blah"); echo '<form name="hede" method="POST" action="cart.php">'; echo "<table border='5'>"; $res = pg_query ($conn, "SELECT * from Top where $res=e($sql);"); while ($row = pg_fetch_assoc($res)) { echo "<tr>"; echo "<td>"; echo "<input type=\"checkbox\" name=\"games[]\" value=\"" . $row['refcode'] ."\">"; echo "</td>"; echo "<td>"; echo $row['title']; echo "</td>"; echo "<td>"; echo $row['description']; echo "</td>"; echo "<td>"; echo $row['price']; echo "</td>"; echo "</tr>"; if($delete){ for($i=0;$i<$count;$i++){ $del_id = $checkbox[$i]; $sql = "DELETE FROM Top WHERE id='$del_id'"; $res = e($sql); } } } echo "</table>\n"; echo '</form>'; ?> But i think im getting my_sql confused with postgresql any ideas cheers