Steve4900 Posted May 1, 2008 Share Posted May 1, 2008 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 Link to comment https://forums.phpfreaks.com/topic/103751-inportant-problem-with-delete-in-phppg_sql/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.