Ok, here is my dilema..............

WND · Jan 25, 2003

Ok, here is my dilema................. I'm using DW MX to administer a database. Database is created, pages are created. I can connect to the database just fine, I can add records to the database just fine, I can update records in the database just fine. The problem is I just
can't figure out how to delete a record in a database. Ideally, I would like to be able to delete all records in a table, but I'd like to figure out how to just delete the individual ones first, and then move on to all records in a table (unless it's easier to go that way in the first place).

So, I've read a million and one tutorials, have tried the help file in DW MX, have browsed forum after forum and just can't figure it out. I know it's something stupid, and I'm missing it.

I'm posting the code that lists all the records below. Basically what I need to do is after the page is question (below) is printed out, I need to delete all the records in the database. Either record by record, table by table or whatever. It doesn't matter, I just can't figure out how to do it.

Is there ANYONE here that would be willing to help me figure this out (preferrably in dummy terms) I am so frusterated! LOL!

Thanks! Code below.

--------------------------------------------------------------------------------

<?php require_once('Connections/Accounting.php'); ?>
<?php
mysql_select_db($database_Accounting, $Accounting);
$query_DisplayAllPayments = "SELECT * FROM Payments";
$DisplayAllPayments = mysql_query($query_DisplayAllPayments, $Accounting) or die(mysql_error());
$row_DisplayAllPayments = mysql_fetch_assoc($DisplayAllPayments);
$totalRows_DisplayAllPayments = mysql_num_rows($DisplayAllPayments);

mysql_select_db($database_Accounting, $Accounting);
$query_DisplayAllCharges = "SELECT * FROM Account_Charges";
$DisplayAllCharges = mysql_query($query_DisplayAllCharges, $Accounting) or die(mysql_error());
$row_DisplayAllCharges = mysql_fetch_assoc($DisplayAllCharges);
$totalRows_DisplayAllCharges = mysql_num_rows($DisplayAllCharges);

mysql_select_db($database_Accounting, $Accounting);
$query_DisplayAllExpenses = "SELECT * FROM Expenses";
$DisplayAllExpenses = mysql_query($query_DisplayAllExpenses, $Accounting) or die(mysql_error());
$row_DisplayAllExpenses = mysql_fetch_assoc($DisplayAllExpenses);
$totalRows_DisplayAllExpenses = mysql_num_rows($DisplayAllExpenses);

mysql_select_db($database_Accounting, $Accounting);
$query_DisplayAllNewClients = "SELECT * FROM New_Client";
$DisplayAllNewClients = mysql_query($query_DisplayAllNewClients, $Accounting) or die(mysql_error());
$row_DisplayAllNewClients = mysql_fetch_assoc($DisplayAllNewClients);
$totalRows_DisplayAllNewClients = mysql_num_rows($DisplayAllNewClients);

$colname_DeleteRecord = "1";
if (isset($HTTP_POST_VARS['Date'])) {
$colname_DeleteRecord = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['Date'] : addslashes($HTTP_POST_VARS['Date']);
}
mysql_select_db($database_Accounting, $Accounting);
$query_DeleteRecord = sprintf("SELECT * FROM Account_Charges WHERE `Date` = '%s' ORDER BY `Date` ASC",

$colname_DeleteRecord);
$DeleteRecord = mysql_query($query_DeleteRecord, $Accounting) or die(mysql_error());
$row_DeleteRecord = mysql_fetch_assoc($DeleteRecord);
$totalRows_DeleteRecord = mysql_num_rows($DeleteRecord);
?>
<html>
<head>
<title>Walston Net Design Accounting Management</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<STYLE TYPE="text/css">
BODY{
scrollbar-face-color:#D6D6CE;
scrollbar-shadow-color:#FFFFFF;
scrollbar-track-color:#D8D8D8;
scrollbar-3dlight-color:#B3D8FA;
scrollbar-arrow-color:#008000;
scrollbar-base-color:#FFFFFF;
scrollbar-darkshadow-color:#565CD0;
scrollbar-highlight-color:#3A69B6;
}
</style>
<script language="JavaScript">
function doClock(){ // By Paul Davis -

http://www.kaosweaver.com

var t=new Date(),a=doClock.arguments,str="",i,a1,lang="1";
var month=new Array('January','Jan', 'February','Feb', 'March','Mar', 'April','Apr', 'May','May', 'June','Jun', 'July','Jul', 'August','Aug',

'September','Sep', 'October','Oct', 'November','Nov', 'December','Dec');
var tday= new Array('Sunday','Sun','Monday','Mon', 'Tuesday','Tue', 'Wednesday','Wed','Thursday','Thr','Friday','Fri','Saturday','Sat');
for(i=0;i<a.length;i++) {a1=a.charAt(1);switch (a.charAt(0)) {
case "M":if ((Number(a1)==3) && ((t.getMonth()+1)<10)) str+="0";
str+=(Number(a1)>1)?t.getMonth()+1:month[t.getMonth()*2+Number(a1)];break;
case "D": if ((Number(a1)==1) && (t.getDate()<10)) str+="0";str+=t.getDate();break;
case "Y": str+=(a1=='0')?t.getFullYear():t.getFullYear().toString().substring(2);break;
case "W":str+=tday[t.getDay()*2+Number(a1)];break; default: str+=unescape(a);}}return str;
}
</script>
</head>

<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="95%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="693" valign="top">

 
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr valign="top">
<td width="17%">
<script language="JavaScript">
document.write(doClock("W0","%20%20","M0","%20%20","D0",",%20","Y0&quot

);
</script>
</td>
<td width="83%"><div align="right"><a href="javascript:window.print()">Click
here to print records</a> </div></td>
</tr>
</table>
<hr noshade size="1" color="#000000" width="98%" align="left">
New Charges
<table border="0" cellpadding="5" cellspacing="0">
<tr>
<td width="10"> </td>
<td width="190">Date</td>
<td width="110">Client</td>
<td width="118">Service</td>
<td width="118">Amount</td>
<td width="132">Comments</td>
</tr>
<?php do { ?>
<tr>
<td height="22"><a href="delete_record.php"><img src="delete.gif" width="8"

height="7" border="0"></a></td>
<td><?php echo $row_DisplayAllCharges['Date']; ?></td>
<td><?php echo $row_DisplayAllCharges['Client']; ?></td>
<td><?php echo $row_DisplayAllCharges['Service']; ?></td>
<td><?php echo $row_DisplayAllCharges['Amount']; ?></td>
<td><?php echo $row_DisplayAllCharges['Comments']; ?></td>
</tr>
<?php } while ($row_DisplayAllCharges = mysql_fetch_assoc($DisplayAllCharges)); ?>
</table>
Expenses

<table border="0" cellpadding="5" cellspacing="0">
<tr>
<td> </td>
<td>Date</td>
<td>Expense</td>
<td>Amount</td>
<td>Merchant</td>
<td>Account</td>
<td>Comments</td>
</tr>
<?php do { ?>
<tr>
<td><a href="delete_record.php"><img src="delete.gif" width="8" height="7"

border="0"></a></td>
<td><?php echo $row_DisplayAllExpenses['Date']; ?></td>
<td><?php echo $row_DisplayAllExpenses['Expense']; ?></td>
<td><?php echo $row_DisplayAllExpenses['Amount']; ?></td>
<td><?php echo $row_DisplayAllExpenses['Merchant']; ?></td>
<td><?php echo $row_DisplayAllExpenses['Account']; ?></td>
<td><?php echo $row_DisplayAllExpenses['Comments']; ?></td>
</tr>
<?php } while ($row_DisplayAllExpenses = mysql_fetch_assoc($DisplayAllExpenses)); ?>
</table>

New Clients
 

<table border="0" cellpadding="5" cellspacing="0">
<tr>
<td> </td>
<td>Date</td>
<td>Account_Number</td>
<td>Name</td>
<td>Business_Name</td>
<td>Email</td>
<td>Phone</td>
<td>Fax</td>
<td>Address</td>
<td>City</td>
<td>State</td>
<td>Zip</td>
<td>Contact_Person</td>
<td>Account_Type</td>
<td>Comments</td>
</tr>
<?php do { ?>
<tr>
<td><a href="delete_record.php"><img src="delete.gif" width="8" height="7"

border="0"></a></td>
<td><?php echo $row_DisplayAllNewClients['Date']; ?></td>
<td><?php echo $row_DisplayAllNewClients['Account_Number']; ?></td>
<td><?php echo $row_DisplayAllNewClients['Name']; ?></td>
<td><?php echo $row_DisplayAllNewClients['Business_Name']; ?></td>
<td><?php echo $row_DisplayAllNewClients['Email']; ?></td>
<td><?php echo $row_DisplayAllNewClients['Phone']; ?></td>
<td><?php echo $row_DisplayAllNewClients['Fax']; ?></td>
<td><?php echo $row_DisplayAllNewClients['Address']; ?></td>
<td><?php echo $row_DisplayAllNewClients['City']; ?></td>
<td><?php echo $row_DisplayAllNewClients['State']; ?></td>
<td><?php echo $row_DisplayAllNewClients['Zip']; ?></td>
<td><?php echo $row_DisplayAllNewClients['Contact_Person']; ?></td>
<td><?php echo $row_DisplayAllNewClients['Account_Type']; ?></td>
<td><?php echo $row_DisplayAllNewClients['Comments']; ?></td>
</tr>
<?php } while ($row_DisplayAllNewClients = mysql_fetch_assoc($DisplayAllNewClients)); ?>
</table>

Payments
 

<table border="0" cellpadding="5" cellspacing="0">
<tr>
<td> </td>
<td>Date</td>
<td>Client</td>
<td>Amount</td>
<td>Check_Number</td>
<td>Comments</td>
</tr>
<?php do { ?>
<tr>
<td><a href="delete_record.php"><img src="delete.gif" width="8" height="7"

border="0"></a></td>
<td><?php echo $row_DisplayAllPayments['Date']; ?></td>
<td><?php echo $row_DisplayAllPayments['Client']; ?></td>
<td><?php echo $row_DisplayAllPayments['Amount']; ?></td>
<td><?php echo $row_DisplayAllPayments['Check_Number']; ?></td>
<td><?php echo $row_DisplayAllPayments['Comments']; ?></td>
</tr>
<?php } while ($row_DisplayAllPayments = mysql_fetch_assoc($DisplayAllPayments)); ?>
</table>
<a href="javascript: self.close()">Close Window</a></td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($DisplayAllPayments);

mysql_free_result($DisplayAllCharges);

mysql_free_result($DisplayAllExpenses);

mysql_free_result($DisplayAllNewClients);

mysql_free_result($DeleteRecord);
?>

TonyU · Jan 26, 2003

[tt]

I don't know PHP but here's how I do it in VBScript.

On this example
I'm passing a recordset ID to know what record to delete on this page.

<%@LANGUAGE="VBSCRIPT"%>


<%
Dim deleteme__MMColParam
deleteme__MMColParam = ""
if (Request.QueryString("id&quot

<> "&quot

then deleteme__MMColParam = Request.QueryString("id&quot

%>
<%
set deleteme = Server.CreateObject("ADODB.Recordset&quot

deleteme.ActiveConnection = MM_myconn_STRING
deleteme.Source = "Delete * FROM mytbl WHERE id = " & deleteme__MMColParam
deleteme.CursorType = 0
deleteme.CursorLocation = 2
deleteme.LockType = 3
deleteme.Open()
deleteme_numRows = 0
%>
<%
response.redirect "Updated_Page.asp"
%>
<%
deleteme.Close()
%>

Note: Have you consider marking records deleted as suppossed to completely getting rid of them?

* * * * * * * * * * *
<%=Tony%>

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Ok, here is my dilema..............

WND

Programmer

TonyU

Technical User

Similar threads

Part and Inventory Search

Sponsor