Delete

[danjoe_15]

This is where I call my delete function:

 

<td><form action="DeleteOrder.php" method="GET">

                <input type="hidden" name="order_id" value="<? echo ($row['order_id']); ?>"/>

<input type="submit"style="width:150px" name="Delete Order" value="Delete Order"/></form></td>

 

 

 

This is DeleteOrder.php:

 

 

<?php

include 'common.php';

 

dbConnect();

 

mysql_query("DELETE FROM orders WHERE order_id=%1", $_GET['order_id']);

 

dbclose

?>

 

 

 

 

What did I do wrong here?  The record which I want to delete is not being deleted.

[flyhoney]

<?php
include 'common.php';
dbConnect();
mysql_query("DELETE FROM orders WHERE order_id=" . mysql_real_escape_string($_GET['order_id']));
?>

[danjoe_15]

This is what it came back with:

 

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /var/www/vhosts/farmworks.com/subdomains/forms/httpdocs/DeleteOrder.php on line 9

 

[premiso]

This is what it came back with:

 

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /var/www/vhosts/farmworks.com/subdomains/forms/httpdocs/DeleteOrder.php on line 9

 

 

Show us the full code. And highlight line 9 in some way and use the [ code] and [ /code] tags (without the initial space).

[danjoe_15]

<?php
include 'common.php';

dbConnect();

error_reporting(E_ALL); 
ini_set('display_errors', 1);

/*ln9*/mysql_query("DELETE FROM orders WHERE order_id=%1", $_GET['order_id']);
dbclose();
?>

[flyhoney]

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /var/www/vhosts/farmworks.com/subdomains/forms/httpdocs/DeleteOrder.php on line 9

 

This means you are not connected to the database.  Check your connection code.

[premiso]

Aside from what flyhoney said, you did not change line 9 to be the new line that he wrote.

 

mysql_query("DELETE FROM orders WHERE order_id=" . mysql_real_escape_string($_GET['order_id']));

 

That is what it should be, not the one you have.

[danjoe_15]

Sorry apparently I had missed a post.

 

mysql_query("DELETE FROM orders WHERE order_id=" . mysql_real_escape_string($_GET['order_id']));

 

That line fixed the issue.  Thank you very much.