need help creating a confirm page

[mikewooten]

i'm working on an administration and i'm wanting to have a delete link in each row so that i can delete any row. instead of having a delete link,i want to have a confirm link that goes to the confirm page that shows the administrator what they are going to delete before the row is deleted.
how would i go about doing that? i can get the delete link to work, but can't get the confirm link to work. when i click on the confirm link, i get errors. the errors that i get is:

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in
/home/username/public_html/folder/delete_confirm5.php on line 28
and
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in
/home/username/public_html/folder/delete_confirm5.php on line 70

if you want to see the code that i have so far, just let me know.
how can i get this to work without the errors?
thanks

[planetsim]

firstly try using mysql_num_rows(); that is one of the problems not sure if it will work with it changed if not please show us some code.

[mikewooten]

here's code that i have for the page i'm working on
here's the site i'm working on
http://www.wootenmedia.com/admintest/showprod4.php

<?
include("db2.php"); 
   switch($_GET["action"]) 
   { 
                                             case "delete_item_row": 
      { 
         DeleteItemRow($_GET["id"]);    

         break; 
      }       

                     case "delete_order_row": 
      { 
         DeleteOrderRow($_GET["id"]);    

         break; 
      }       

                     case "show_item_row": 
      { 
         ShowItemRow($_GET["id"]);    

         break; 
      }       

                       case "update_item_row": 
                                { 
         UpdateItemRow($_GET["id"]); 
      } 
                                 default: 

   }    

   function DeleteItemRow($itemId) 
   { 
              global $dbServer, $dbUser, $dbPass, $dbName; 

  $cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName); 

    $result = mysql_query("DELETE FROM user WHERE itemId=$itemId"); 
   }    

function DeleteOrderRow($id) 
   { 
      global $dbServer, $dbUser, $dbPass, $dbName; 

  $cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName); 

    $result = mysql_query("DELETE FROM checkout WHERE id=$id"); 
   }    

   function ShowItemRow($itemId) 
   { 
      global $dbServer, $dbUser, $dbPass, $dbName; 

  $cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName); 

    $result = mysql_query("SELECT * FROM items WHERE itemId=$itemId"); 
   } 



$dbname = "database"; 
$tblname = "items"; 
$linkid = mysql_connect("localhost", "username", "password")  

or die("Couldn't connect."); 
$db = mysql_select_db($dbname, $linkid) 
    or die("Couldn't select database."); 
mysql_query ("SELECT * FROM $tblname");  

echo "$select<br>"; 

   $host    ="localhost"; 
   $dbuser="username"; 
   $dbpass="pasword"; 
   $database="database"; 

mysql_connect($host,$dbuser,$dbpass); 
mysql_select_db($database) or die ("Unable to select database") 
$query="SELECT * FROM $tblname ORDER BY itemId ASC";  

$result=mysql_query($query); 
$num=mysql_numrows($result);  

$result = mysql_query($query, $linkid);    

$result = mysql_query($query); 


echo "<strong><center>Customers</center></strong>"; 

echo "<br><br>";  

echo "<a href='http://www.wootenmedia.com/admintest/showprod4.php'>SHOW products</a> | <a href='http://www.wootenmedia.com/admintest/add3_1.php'>ADD products</a> | <a href='http://www.wootenmedia.com/admintest/customers.php'>VIEW customers</a> | <a href='http://www.wootenmedia.com/admintest/orders.php'>VIEW orders</a> | <a href='http://www.wootenmedia.com/admintest/update1_1.php'>UPDATE products</a> |"; 
//echo "Users who have signed In<br><br>";  

echo "<br><br>";  

echo "<table border='1' bordercolor='#000000' cellpadding='0' cellspacing='0' width='100%'>";  

echo "<tr>"; 
echo "<td width='5%'><strong><center>cat id</center></strong></td>"; 
echo "<td width='6%'><strong><center>item id</center></strong></td>"; 
echo "<td width='10%'><strong><center>product item</center></strong></td>"; 
echo "<td width='10%'><strong><center>item name</center></strong></td>"; 
echo "<td width='20%'><strong><center>item image</center></strong></td>"; 
echo "<td width='30%'><strong><center>item desc</center></strong></td>"; 
echo "<td width='14%'><strong><center>item price</center></strong></td>"; 
echo "<td width='5%'><strong><center>Delete</td>"; 
echo "</tr>"; 

while($query_data = mysql_fetch_row($result)) { 

echo "<tr>"; 
echo "<td>$query_data[0]</td>"; 
echo "<td>$query_data[1]</td>"; 
echo "<td>$query_data[2]</td>"; 
echo "<td>$query_data[3]</td>"; 
echo "<td>$query_data[4]</td>"; 
echo "<td>$query_data[5]</td>"; 
echo "<td>$query_data[6]</td>"; 
echo "<td>"; 
?> 
<a href="add4_5.php?action=update_item_row&id=<?php echo $query_data[1];  ?>">update</a> 
<br> 
<br> 
<a href="showprod4.php?action=delete_item_row&id=<?php echo $query_data[1];  ?>">delete</a> 
<br> 
<br> 
<a href="delete_confirm5.php?action=show_item_row&id=<?php echo $query_data[1];  ?>">confirm</a> 
<? 
echo "</td>"; 
echo "</tr>"; 

}      

echo "</table>";  

?>

[Frederick]

if using a button, name it confirm
if using a link, add ?confirm=1&id=".$row["id"]."

if (isset($confirm)) {
echo "Confirm the information below ..............................<br>\n";
echo "<a href=\"path/page.php?id=$id\">YES</a>\n";
echo "&nbsp;&nbsp;&nbsp;&nbsp;\n";
echo "<a href=\"returnPath/page.php\">NO</a>\n";
}

This method is for looping back to the current viewing details page. Normally above or below the details of the page your are currently viewing for deletion selection.

[mikewooten]

i'm getting these errors;
how can i fix these errors, what can i do to my code to fix this so that the confirm will work?
thanks
here's the errors:
Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/username/public_html/admintest/delete_confirm5.php on line 28

and

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/musername/public_html/admintest/delete_confirm5.php on line 70

[Frederick]

It looks like your are not passing the neccessary value to the next page.

If you are coming from a form, you need to add a hidden tag.

<input type="hidden" name="id" value="$id">

[mikewooten]

this is what i'm using to pass the value to the next page, and i'm getting those errors.

<a href="delete_confirm5.php?action=show_item_row&id=<?php echo $query_data[1]; ?>">confirm</a>

is this what i should be using or should i be using something different?
thanks

[Frederick]

Best way to display this

$sql = mysql_query("SELECT * FROM tablename ORDER BY whatever");
while ($row = mysql_fetch_array($sql)) {
echo "<a href=\"delete_confirm5.php?id=".$row["id"]."\">Delete Entry</a><br>\n";
}

[mikewooten]

would i have that code on the confirm page or as part of my code on that page that i have above?
thanks

[Frederick]

Create it as a looping back operation to grab the confirmation action.

Working example:
Using page.php as the example page

<?php
if (isset($delete)) {
	$sql = mysql_query("DELETE FROM tablename WHERE id=$id")
	or die (mysql_error());
	header("Location: page.php");
} else {
	if (isset($confirm)) { 
		echo "Are you sure you want to delete the selected item?<br>\n"; 
		echo "<a href=\"page.php?delete=1&id=$id\">YES</a>\n"; 
		echo "&nbsp;&nbsp;&nbsp;&nbsp;\n"; 
		echo "<a href=\"page.php\">NO</a>\n"; 
	}

$sql = mysql_query("SELECT * FROM tablename ORDER BY whatever")
or die (mysql_error());
while ($row = mysql_fetch_array($sql)) { 
	echo "<a href=\"page.php?confirm=1&id=".$row["id"]."\">Delete Entry</a><br>\n"; 
}
}
?>