[Resolved] my form works with great with IE but in NETSCAPE the form goes whack!

airric

I am a newbie with PHP. Everything works like a charm in IE but NETscape just deletes the cart item when I try to update the cart qty. Can anyone help me with this? this what I have.

<?
if (isset($_POST['submit'])) {

$i = $POST['id'];
$q = $POST['qtty'];

if ($i) {
$query = " update carts SET qtty = ('$q') WHERE id = $i";
$result = @($query);
} }

if (isset($_POST['submitdelete'])) {

$i = $_POST['id'];

if ($i) {
$query = " delete from carts WHERE id = $i";
$result = @($query);
} }

$resultt = mysql_query("SELECT * FROM carts WHERE userid=$userid");
while ($row = @mysql_fetch_array($resultt))
{
$dvd_id =$row[id];
$dvd_davisid =$row[davisid];
$dvd_title =$row[title];
$dvd_price =$row[price];
$dvd_qtty =$row[qtty];
$dvd_preorder =$row[preorder];

$subtotal = $dvd_qtty * $dvd_price;
$newsub = number_format($subtotal, 2, '.', ',');
$ordertype = $dvd_preorder;
$total += $subtotal;

$newtotal = number_format($total, 2, '.', ',');
if ($ordertype == "1") {

$dvd_preorder = "<font class=style3>*Pre Release</font>";
} ELSE {
$dvd_preorder = "Standard";
}

echo "<tr><td class=\"style5\"><form name=\"qtty\" action=\"cart.php\" method=\"POST\">
$dvd_davisid</td>

<td class=\"style5\">$dvd_title</td>

<td class=\"style5\">$dvd_preorder</td><td class=\"style5\">$dvd_price</td><td class=\"style12\">x</td>

<td class=\"style12\">\$ $newsub </td><td><input type=\"submit\" name=\"submitdelete\" value=\"X\"></form></td></tr>";
}

}
}

Thanx, Airric

onion2k

How are you submitting the form when you want to update the quantity? Theres only one submit button, and that deletes things.

airric

Onion you do have a great point.

I was attempting to change the quantity without a button, I used the hidden box to attempt this.

I changed the type of the hidden box to a submit and it works fine DOH! My Bad.

Do you know how I would accomplish changing the qty without a button just the enter key?

airric

Hmmm it may not be possible to do! I have seen it on other sites but they might have not of been in PHP. Thank you for your reply sometimes it just helps to have a fresh pair of eyes and an experienced mind does hurt either. P.S. (I get code drunk pretty easy still! LOL)

I do have another problem with this script however.
I need a clause that will add 1 to qty to a already existing item in the cart, instead of adding the item anew.

I have tried a couple of different ideas but none have worked this far.

Thank You, Airric

onion2k

Originally posted by airric
Hmmm it may not be possible to do! I have seen it on other sites but they might have not of been in PHP. Thank you for your reply sometimes it just helps to have a fresh pair of eyes and an experienced mind does hurt either. P.S. (I get code drunk pretty easy still! LOL)

You can do it in PHP as well. Just have 2 forms. One for the text box and hidden submit which will get submitted on a return keypress, and a seperate form with the delete button. Pressing the return key in a form in Firefox/Netscape is the same as pressing a submit button if there is one.. and in your form there is one.

As for updating the quantity, you'll need to do a select query to check if the item is in the cart already, and then an update if it is, or an insert if its not.