Steve4900
-
Posts
3 -
Joined
-
Last visited
Never
Posts posted by Steve4900
-
-
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
URGENT problem with pg_sql
in PostgreSQL
Posted
or can anyone give me simpler piece of code that will work?
Cheers for all your help