PHP :: Delete Record

Delete Record - When The Delete Link Is Clicked The Next Page Is Blank And Nothing Is Deleted.
This is my "delete.php" and this "todo/delete.php?id=64" an example of a link to it generated from the index.php page. When the delete link is clicked the next page is blank and nothing is deleted. What have I done wrong?

<?
include("dbinfo.inc.php");

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$id="delete from todo where id='$id'";
mysql_query($id);

mysql_close();
?>

View Replies !

Delete Record!
I am using PHP5 , MySQL5, Apache 2 My Database was created with phpmyAdmin.Then I inserted with script and phpmyAdmin data into the Database. Now I am Unable to empty or delete or remove any fields out of the Database. Neither a script ot phpmyAdmin can delete.What has blocked the database? I have restarted my pc, Still I am unable to remove anything.

View Replies !

Delete Record And Files
I have a code that uploads images along with some info into a directory and database, this all works fine. I can delete the record but the images relevent to that record continue to exsist in my images directory. How would i set up a php code to delete a file in ../images when the record of its name is stored in a column in my database. Here is my delete record code:

View Replies !

Mysql Delete Record
when I run this code below it doesn't delete the record or display any error message

$id = $_GET['id'];
include("../dbconnect.php");
mysql_query("DELETE FROM promotions WHERE id='$id'") or die(mysql_error());

Such a simple thing to do but I don't no why it doesn't work

View Replies !

Unable To Delete A Record Using Php
I am having a form which displays a couple of values from database and a delete button which is used to delete that particular record. Below is the code that I am using, but I am unable to delete the record. Please help me to get the record deleted. Code:

View Replies !

Confirmation When Delete A Record
I want to add a confirmation before I delete a record. For example if the user wants to delete they press "Yes" otherwise "NO" and go back.

<?php

//delete user
$sSQL = "DELETE FROM user WHERE (`userid` = ".$_GET['record_id'].")";

$result = mysql_query($sSQL) or die(mysql_error());

echo "<h1> User deleted succesfully</h1><br>";

?>

View Replies !

Delete Record - You Have An Error In Your SQL Syntax;
Im some having trouble with deleting a record, surely it isnt that hard, dont know what im doing wrong. this is the error i am gettin:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '` WHERE id=1' at line 1Here is my delete code:

View Replies !

Delete Record If Older Than 5 Minutes?
Can someone help me in writing a query command, to delete a record, if the last_update field on a record is older than 5 minutes?

My table has a last_update field, which holds a value as this for example: 2007-04-08 01:33:12

I need a query that when I access a php file, if a record is older than 5 minutes, it will delete it.

View Replies !

Click Link To Delete Record
I am trying to add a function to one of my scripts. I would like to be able to click a link and have it delete a particular row from by DB. Links are generated by a PHP script and are based on entries on a DB. In this DB I have a column called 'users'. The table is generated by the following snippet: Code:

View Replies !

Using Checkboxes To Delete Record From Database
i would like to use check boxes to delete records from the database. my problem is, the records belong to different tables. how do i indicate in my code "DELETE from blah blah... " from which table to delete from..

View Replies !

Dreamweaver Generated Code To Delete Record
I use the dreamweaver generated code to delete a record, how would i add some code to it to delete the files (images) stored in my../images folder, that are linked to the record being deleted, there field names are photo1, photo2, ect..... and there image names are stored in the database Code:

View Replies !

Auto Delete Record/Send Email After X Hours
What I have is a MySQL database which stores records that each have a date stamp on them (2 of them - one for record created date and one for record last updated date), what I want to do is try and have it so that records that haven't been updated in say 72 hours are automatically removed from the database, or the record is updated to set a flag as being out of date, or an email is sent to alert a user of the out of date record etc.

I can easily write the script with the SQL query to check the records by the datestamp and perform the actions needed if the records are out of date, however that requires someone to physically visit that page to run the script and clean up the out dated records. What I want to try and do is have this happen automatically on its own without someone needing to actually visit the page to run the script.

A good example is on eBay how emails are sent to you to let you know when your auctions are about to expire, i wouldnt imagine that eBay would rely on people visiting their website to make those queries run on the database so there must be a way of doing some automated script executio or having a scheduled task run on the server to have a PHP script run each day at midnight or something? Anyone know how to do this?

View Replies !

Script Repeat Updates The Record And Also Inserts Another Record With The Same Information.
I have a form which contains some fields that are populated with data from a table. This same form also has fields that are empty because the data has not been collected yet. The main table is called client with a primary key of client_id. What I need to do with this form is select the client and update the record into a new table with the missing information. If the client doesn't not exist in this second table, I need to insert the row otherwise if the client does exist in this table because of a previous update, update the record.

When I run my script, the insert works. When I try to run the script again and try to update the record, the script not only updates the record but also inserts another record with the same information. How can I write my script so it checks whether a client exists in a table and if it does, update the record and if the client does not exist in the table, add the client?

View Replies !

How To Securely Store A Record Index When Editing A Mysql Record
is there a secure way
to do this? the non-secure ways are, as i understand it, to populate
a listbox with indices as names, or maybe use a hidden control. is the
only secure way with sessions? i was also thinking about perhaps
creating a meta table that says who is editing which record right
now. any advice?

View Replies !

Compare Record With Session Variable And Update Record If Different
I'm trying to figure out how to create a session variable from a recordset field value in a mySQL database and compare this with subsequent values from the same field each time the page reloads. When the value of the field changes (as a result of a user update) I want to trigger an event (redirecting to another page). It's probably a very basic PHP function but I am a newbie with this language.

View Replies !

Mysql Delete - $query = Mysql_query("DELETE
how would i do the following ?

$query = mysql_query("DELETE notes, datestamp, abs_value, ID FROM absence_mgt WHERE datestamp='$date' AND ID='$vtc_login' ") or die(mysql_error());
im just getting "Unknown table 'notes' in MULTI DELETE" ?

View Replies !

When Posting The Record Only The Last Record Is Getting Posted?
I'm able to collect data and place all the records under editing mode and able to edit the records. But when posting the record only the last record is getting posted. Code:

View Replies !

Getting Id Of New Record
I have created a form that sends information to two different databases. In my script to add stuff to the databases I have it connecting to 1 table first to create an entry. Then connect to another Table to send more associated information.

With this second table I need to send the Id # of the record that was just created. How do I get the Id number of that record since it is NULL and Mysql is set to auto increment?

View Replies !

Get A Record By Url?
I'm making a website with articles stored in mysql. I want to get a certain article by the var in the url like this: http://www.website.com/page.php?id=1

Code:

View Replies !

Mx Record
I need it to check if email also has a mx record and if it doesnt then exit like the one there. HTML Code:

function validateEmail($fEmail, $fBannedHosts)
{
if (!eregi('^([_a-z0-9-]+)(.[_a-z0-9-]+)*@([a-z0-9-]+)(.[a-z0-9-]+)*(.[a-z]{2,4})$', $fEmail)) {exit('<center>Error : Incorrect email <a href="../submit.php">Go Back</a></center>');}
if ($fBannedHosts == 'free') {$fBannedHosts = array('hotmail.com', 'yahoo.com');}
$explode = explode('@', $fEmail);
if (in_array($explode[1], $fBannedHosts)) {exit('<center>Error : Your email host ' . $explode[1] . ' is not allowed by this site <a href="../submit.php">Go Back</a></center>');}
}

View Replies !

Next Record?
Is there a way to compare the current record in an array with the next record? Trying to do something like this, id like to compare field1 current record vs field1 next record

while ($row = mysql_fetch_array ($result))
{
$next_row = next($row);

if('$next_row[field1]'=='$row[field1]');
}

Not working though, any thoughts?

View Replies !

DB Record
I am making a CMS for someone who sells boats. On the front of the site there will be a "boat of the week" I am having problems trying to implement a system where the customer can select a single boat from the DB using an admin interface. I presume a radio button of some sort next to each record. A: How should this been included in the DB ie. field? B: How do I make sure any previous selections are removed when the new is selected?

View Replies !

Get The First Record
Is there a MySQL function to get the first record through a query? I would like to open a page of client records with the first one shown. The other records can be accessed from a hyperlinked list.

View Replies !

Getting Rank Of Record ..
I have a mysql query to select all singers from a database and order them by hits field ..

select * from singers order by singer_hits

now lets say i am on the songs page of singer with singer_id = 6 i need to get this singer rank according to hits...

so if singer number 6 is the result number 40 in the above query so the singer is ranked number 40 all over other singers...

any help on how to construct this query or php function ??

View Replies !

Record From DB Problem
I can grab the array I want and display it with the following code:

$myrow = mysql_fetch_array($result);

for ($i; $i<sizeof($myrow); $i++) {
echo $myrow[$i]."<br>";
}

However I’d like to display the entries in the record with some html formatting, so what to do something like this:

$po_num = $myrow["po_num"];
*$form_type = $myrow["form_type"];
*$name = $myrow["name"];
*$department = $myrow["department"];
*$date_required = $myrow["date_required"];
*$vendor = $myrow["vendor"];

-This give me an error. However using echo $myrow["column_name"]; elsewhere in the form doens't. Why can't I do this?

View Replies !

Getting One Record From MySQL
I am very new to php-mysql, and im a bit confused by all the tutorials which explain how to get records from mysql. In all the tutorials, they show how to recover all records from a table using a loop command.

I have a mySQL table called news, which has headline and a body fields (as well as id). On my php page, i have two seperate tables. One I wish to print the info from one of the headline fields , and the info from the field body in the other.

I don't wish to print all the records.

View Replies !

How Do You Email From A Record?
I am using PHP to pull up records from a MySQL database onto an HTML page. The records are simply name, telephone number, email address etc.

What I want is, after every record is a checkbox. You tick as many boxes as you like and then press a button at the bottom of a page which opens your email client with all the email addresses of the people you have clicked in the 'to' line. How do you do this please?

View Replies !

ID Of Record Not Returning ?
The following code returns the fields from the row ( $product for example is used later and displays OK ) except the 'prid' field ( only ever has zero), which is the unique ID for this table.
Any thoughts appreciated - PHP Code:

View Replies !

Test For PTR Record
I need to test a IP for a PTR record and display the outcome.

The problem i have is i need to test with 2 vars.

$host = the ip
$hostmask = the hostmask

How do i use 2 vars in one function so i can call it like:

test_ptr($host, $hostmask)

Ive tested this but cant seem to get it to work.

code below. Thanks in advance

function test_ptr($host) {
if (strlen(gethostbyaddr($host))==
strlen(gethostbyname("$hostmask"))) {
$emsg = "    !!Couldent find PTR Record!!";
}
}

View Replies !

How Do I Retrieve The Next Record?
I am searching the mySQL DB for a particular item num. When it retunrs the result I want to be able to go to the 'NEXT' and 'PREV' records in the order of the Table. Do I first need to put in an auto increment or index column?

View Replies !

A Graphic Per Record
I would like advice on the simplest way to have a graphic appear next to a line of text, when displayed. Essentially this is a Knowledge management solution - and each title would need to be noted (graphically) as to the format it is in (pdf, ppt, xls, etc).

View Replies !

Random Record
I am using the following code to select a random record, but it is coming back saying query is empty why? PHP Code:

View Replies !

Next And Previous Record
I am moving throught a set of records, my next works great but previous move
to the first record. Also what is the best way to check and see if it is the
first or last record in the set.

if($move == "Next")
{
$next_rec = "select * from people where contactid > $rec_id limit 1";
$results = mysql_query($next_rec);
$row = mysql_fetch_row($results);
include("http://localhost/keith-homes/hyperlink.php?val=$row[0]");
exit;
}
elseif($move == "Previous")
{
$next_rec = "select * from people where contactid < $rec_id limit 1";
$results = mysql_query($next_rec);
$row = mysql_fetch_row($results);
include("http://localhost/keith-homes/hyperlink.php?val=$row[0]");
exit;
}

View Replies !

Find The Value Of The Next Record
I have a database with 3 columns.

my_id
my_page_number
other_page_data

I'm creating a written page that has a link to the next page for each record in the above table. Is there a way to get the value of my_page_number for the next record so I can direct users to the next page?

View Replies !

Deleting A Record.
One last (hopefullly) problem I can't seem to get around for this
program...why isn't this deleting the row i want? It does nothing. Now error
messages either. HELP!

$link = mysql_connect("localhost");
if(! $link)
die("Could not connect to MySQL");

$database = "PC_Store";
mysql_select_db($database)
or die ("could not open $database: ".mysql_error() );

$result = mysql_query("DELETE FROM inventorydata VALUES('$ProductID')");

The $ProductID variable is brought in from a menu choice on a diffrent page,
it is also the primary of the table...so it should delete the whole row
right?

View Replies !

Get Any Record Where The First Letter Is X
Regulars have probably seen this answered hundreds of times but how do you get records with the first letter beginning with 'a' for example? I have this:

$letter = $_GET['l']; // = a
$query = mysql_query('SELECT alias FROM badmembers WHERE alias RLIKE "^'.$letter.'$"');

But it doesnt seem to work....

View Replies !

Skips First Record !! Why !???
Basically im pulling records from a mysql database. and placing the results into a simple array.. but when i echo the array values for some reason the first row/record gets skipped and the last one turn out blank as if the values got shifted or something
Code:

View Replies !

Specific Record From DB
I have a form which updates customer information and as default this gets started on record 1. I would like to be able to post a clientname from a previous form and then get the specific data for that customer.

I am fine with the posting to seperate pages stuff but how could I get the update form to start on this record? Code:

View Replies !

Prevent Going To Next Record In The URL
I am wondering about the best way to prevent users from going to the next record in a database by using the URL bar.

So if I have this in the URL: www.site/items.php?itemno=2

I want to prevent them from going to the url and typing in 3 etc.

View Replies !

Record Details
I have a database of properties and have a show all records page. From that page you get an option to view all details about any record. When i choose one, how does the info from (that) record get posted to a page that displays all the info. I used form varibles, is that the best way?

View Replies !

Moving A Record
Is there way to move a record from one table to another ... or will i just have to get row put each field data in a variable and then insert to a new row and delete old row?

View Replies !

Cannot Insert Record
I have this problem where, on my pc at home with apache and sql, when testing my site on my home pc with apache and sql, everything is fine, but when i posted it on the net, none of the add records work, the files get sent, but no record inserted in my database. Strange.. Code:

View Replies !

Getting Last Record From The Database
I have the following table :

----------------------------------
Studnet_id | Reg_no | Std_name | etc....
----------------------------------

- Initially all records are Null.
- Student_id is Primary key.

I want to read last record from the field Student_id i-e NULL and then add +1 to it to get new Student_id. Code:

View Replies !

Won't Display More Than One Record
I'm trying to display a list of users attached to a team, then for each user I need to pull their country and PSN and display it in the same table. Here's my current code:

View Replies !

Record Being Inserted Twice?
I have written which is intended to insert a single record I find that instead it inserts the same record twice (there's no index field). I don't know what to make of it, this is the actual code:

View Replies !

Matching Record
I'm wanting to search a mysql table to return a record (that has an apostrophe) even if I don't specify the apostrophe in the actual search. At the moment if I search for something like "You'll never walk alone" it will return the exact matching record, "You'll never walk alone".

However, if I search "Youll never walk alone" (without the apostrophe) it will not return the record, "You'll never walk alone" and simply comes up with no matches. I'm using the following SQL to search the table:

SELECT * FROM songs WHERE title LIKE '$title%'

Is there any way I can do this so that the search will return the same record whether or not the apostrophe is specified?

View Replies !

Can I Have 2 Value Post Into One Record?
Submission Form Below:

<form action="addprofile2.php" method="post">
Username:
<input type="text" name="username" /><br />
Password:
<input type="text" name="password" /><br />

Then have the username and password both put into the same record:

'username' => $_POST['username','password'],

I want both the username and password to post together like this:username record would appear as: usernamepassword I've tried a bunch of this to get this to work.

View Replies !

Display Only One Record
Code:

<?php // Query the Database
$query = mysql_query("SELECT * FROM userid"); name

while($row = mysql_fetch_array($query)) {
echo "emailaddress: " . $row["emailaddress"] . "<br>";
} ?>

This is displaying all email addresses in the database. How would I display only the one from the session?

View Replies !

Select One Record?
I'm looking to query one record in each order where one item has been shipped. Most of the orders have about 100 items so I was wondering is there a quicker way to query just for one item in each order.

I've been using the below to select all . It works but was wondering if there is a quicker way becuase I just need to find one item, marked SHIPPED.

View Replies !

Remove Record From The DB
I've got a script which adds user submitted values to a MySQL DB, like this: PHP Code:

$fn = $_POST['FirstName'];
$ln = $_POST['LastName'];
$em = $_POST['email'];
$dbcnx = mysql_connect("localhost","removed","removed") or die("Error Connecting to DB");
$db = mysql_select_db("prefix_dbname",$dbcnx) or die("Error Selecting Database");
$query = "insert into entries values('$fn', '$ln', '$em')";
$result = mysql_query($query,$dbcnx) or die("Error in Query");

It also sends a confirmation letter to the user, and emails the admin a notification. How can I have it insert a opt-out link inside of the confirmation email with a query that deletes them from the DB. Do I need to associate ID values with each record or something?

View Replies !

Search For Last Record
If I was searching for records with an item id of "200101", how can I tell my query to just retrieve the very last record or most current and not all of them.

View Replies !

Last Record In Query, And One Before?
Simply put, I wish to display two records from a MySQL on a webpage. I can simply display 1, no problem. The problem comes when displaying a second record.

say for example, I have a table of 30 records. From this table, I wish to display the first two records (ordered Descending) that are the result of a query. Code:

View Replies !