[SOLVED]Deleting Database Information
Moderator: General Moderators
- iknownothing
- Forum Contributor
- Posts: 337
- Joined: Sun Dec 17, 2006 11:53 pm
- Location: Sunshine Coast, Australia
- iknownothing
- Forum Contributor
- Posts: 337
- Joined: Sun Dec 17, 2006 11:53 pm
- Location: Sunshine Coast, Australia
sorry mate, im an idiot, change this...
to this...
Code: Select all
<form type="POST" action="">Code: Select all
<form method="POST" action="">MAN!!!!!!!
Warning: mysql_query(): Access denied for user 'apache'@'localhost' (using password: NO) in /home/freegames/domains/freegamespot.net/public_html/dancefactory/display.php on line 5
Warning: mysql_query(): A link to the server could not be established in /home/freegames/domains/freegamespot.net/public_html/dancefactory/display.php on line 5
Warning: mysql_query(): Access denied for user 'apache'@'localhost' (using password: NO) in /home/freegames/domains/freegamespot.net/public_html/dancefactory/display.php on line 5
Warning: mysql_query(): A link to the server could not be established in /home/freegames/domains/freegamespot.net/public_html/dancefactory/display.php on line 5
- iknownothing
- Forum Contributor
- Posts: 337
- Joined: Sun Dec 17, 2006 11:53 pm
- Location: Sunshine Coast, Australia
in that case it sounds like something is wrong with the query. Is "Winners" the correct table name? and "id" is a correct field?
and also, move all your database login details above the code...
Code: Select all
$id = $_POST['id'];
if (isset($_POST['delete'])){
mysql_query("DELETE FROM Winners WHERE id = '$id'");
else {
echo "Nothin was deleted";
}- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
This means you did not authenticate, meaning your username and/or password is incorrect.netpants wrote:MAN!!!!!!!
Warning: mysql_query(): Access denied for user 'apache'@'localhost' (using password: NO) in /home/freegames/domains/freegamespot.net/public_html/dancefactory/display.php on line 5
Warning: mysql_query(): A link to the server could not be established in /home/freegames/domains/freegamespot.net/public_html/dancefactory/display.php on line 5
Moved the
To after the login details, and the error is gone , but still not able to delete.
Code: Select all
<font color="#FFFFFF"><?
$id = $_POST['id'];
if (isset($_POST['delete'])){
mysql_query("DELETE FROM Winners WHERE id = '$id'");
}else {
echo "Nothin was deleted";
}
?> </font>- iknownothing
- Forum Contributor
- Posts: 337
- Joined: Sun Dec 17, 2006 11:53 pm
- Location: Sunshine Coast, Australia
Code: Select all
<?
$username="";
$password="";
$database="";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM Winners";
$result=mysql_query($query);
$num=mysql_numrows($result);
?>
<font color="#FFFFFF"><?
$id = $_POST['id'];
if (isset($_POST['delete'])){
mysql_query("DELETE FROM Winners WHERE id = '$id'");
}else {
echo "Nothin was deleted";
}
?> </font>
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Add Winner</title>
</head>
<body bgcolor="#000000">
<p align="left">
<img border="0" src="1392094530_m.jpg" width="170" height="119">
<font color="#FFFFFF">
<form action="insert.php" method="post">
Date: <input type="text" name="loggedDate"> <br>
First Name: <input type="text" name="firstName"> <br>
Last Name: <input type="text" name="lastName"><br>
Birthdate: <input type="text" name="birth"><br>
Phone Number: <input type="text" name="phone"><br>
Street Number: <input type="text" name="streetNumber">
Street Name: <input type="text" name="streetName">
City: <input type="text" name="city"><br>
State: <input type="text" name="state" size="2">
Zip Code: <input type="text" name="zip">
Prize: <input type="text" name="prize"><br>
E-Mail: <input type="text" name="email"><br>
<input type="Submit" value="Add Winner">
</form></font>
</p>
<table border="0" width="986">
<tr>
<td width="200"><font color="#FFFFFF">Add Winner<p>
<font color="#FFFFFF"><a href="display.php">Display Winner</a></font></td>
<td width="863" rowspan="3" valign="top">
<table border="0" width="100%">
<tr>
<td>
<table border="0" cellspacing="2" cellpadding="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><a href="<? $orderby = 'id' ?>">ID</a></font></th>
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">Date</font></th>
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><a href="<? $orderby = 'name' ?>">Name</a></font></th>
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">Birthday</font></th>
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">Phone</font></th>
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">Street Number</font></th>
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">Street Name</font></th>
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">City</font></th>
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">State</font></th>
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">Zip</font></th>
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">Prize</font></th>
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">E-Mail</font></th>
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">Edit</font></th>
</tr>
<?
$i=0;
while ($i < $num) {
$id=mysql_result($result,$i,"id");
$date=mysql_result($result,$i,"loggedDate");
$first=mysql_result($result,$i,"firstName");
$last=mysql_result($result,$i,"lastName");
$birth=mysql_result($result,$i,"birth");
$phone=mysql_result($result,$i,"phone");
$streetnumber=mysql_result($result,$i,"streetNumber");
$streetname=mysql_result($result,$i,"streetName");
$city=mysql_result($result,$i,"city");
$state=mysql_result($result,$i,"state");
$zip=mysql_result($result,$i,"zip");
$prize=mysql_result($result,$i,"prize");
$email=mysql_result($result,$i,"email");
?>
<form method="POST" action="">
<tr>
<td bgcolor="#333333"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$id"; ?></font></td>
<td bgcolor="#202020"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$date"; ?></font></td>
<td bgcolor="#333333"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$first $last"; ?></font></td>
<td bgcolor="#202020"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$birth"; ?></font></td>
<td bgcolor="#333333"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$phone"; ?></font></td>
<td bgcolor="#202020"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$streetnumber"; ?></font></td>
<td bgcolor="#333333"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$streetname"; ?></font></td>
<td bgcolor="#202020"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$city"; ?></font></td>
<td bgcolor="#333333"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$state"; ?></font></td>
<td bgcolor="#202020"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$zip"; ?></font></td>
<td bgcolor="#333333"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$prize"; ?></font></td>
<td bgcolor="#202020"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$email"; ?></font></td>
<td bgcolor="#333333"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><input type="submit" value="delete" name="delete"></font></td></tr> </form>
<?
++$i;
}
?>
</table>
</td>
</tr>
</table>
<p>
</body>
<?
mysql_close();
?>
</html>- iknownothing
- Forum Contributor
- Posts: 337
- Joined: Sun Dec 17, 2006 11:53 pm
- Location: Sunshine Coast, Australia
change...
to this...
and see how it goes...
Code: Select all
<?
$id = $_POST['id'];
if (isset($_POST['delete'])){
mysql_query("DELETE FROM Winners WHERE id = '$id'");
}else {
echo "Nothin was deleted";
}
?>Code: Select all
<?
$id = $_POST['id'];
if (isset($_POST['id'])){
mysql_query("DELETE FROM Winners WHERE id = '$id'");
}else {
echo "Nothin was deleted";
}
?>- iknownothing
- Forum Contributor
- Posts: 337
- Joined: Sun Dec 17, 2006 11:53 pm
- Location: Sunshine Coast, Australia
edit it again to this...
Code: Select all
<?
$id = $_POST['id'];
if (isset($_POST['id'])){
mysql_query("DELETE FROM Winners WHERE id = '$id'", $con);
}else {
echo "Nothin was deleted";
}
?>