•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 391,697 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,148 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 4440 | Replies: 22
 |
•
•
Join Date: May 2005
Posts: 228
Reputation: 
Rep Power: 4
Solved Threads: 0
Posting Whiz in Training
Hey everyone, I'm using php to delete a row from a table in a database in mysql, but it's not working. I'm not even trying to do anything fancy, just delete one row. Here's the code:
[PHP]<?
include 'config.php';
$recordid = $_POST['recordid'];
echo $recordid;
mysql_query("DELETE FROM employees WHERE recordid='$recordid'")
or die('sorry, no query');
echo "You have successfully deleted the user."
?>[/PHP]
The database is connecting properly, I double checked that. The variable $recordid is echoing out properly, and I even tried not using the variable, and just placing the actual number of the record id in the code instead, but still didn't work. And yes, I did try copying and pasting that code directly in to the mysql command line. Works perfectly no errors. So how come the query never works? The query dies every time, no fail, but works every time when I use the exact same command in the mysql command line, straight copy and paste, no kidding.
Any ideas? I know it's going to be something stupid, and I'm going to kick myself when I find out, but it's killing me!
[PHP]<?
include 'config.php';
$recordid = $_POST['recordid'];
echo $recordid;
mysql_query("DELETE FROM employees WHERE recordid='$recordid'")
or die('sorry, no query');
echo "You have successfully deleted the user."
?>[/PHP]
The database is connecting properly, I double checked that. The variable $recordid is echoing out properly, and I even tried not using the variable, and just placing the actual number of the record id in the code instead, but still didn't work. And yes, I did try copying and pasting that code directly in to the mysql command line. Works perfectly no errors. So how come the query never works? The query dies every time, no fail, but works every time when I use the exact same command in the mysql command line, straight copy and paste, no kidding.
Any ideas? I know it's going to be something stupid, and I'm going to kick myself when I find out, but it's killing me!
•
•
Join Date: Sep 2006
Location: NYC
Posts: 133
Reputation:
Rep Power: 2
Solved Threads: 2
Junior Poster
change your query to this:
[php]
mysql_query("DELETE FROM employees WHERE recordid='".$recordid."'")
[/php] you cant wrap a variable in single quotes as it will be trated as literal.
[php]
mysql_query("DELETE FROM employees WHERE recordid='".$recordid."'")
[/php] you cant wrap a variable in single quotes as it will be trated as literal.
Last edited by sn4rf3r : Oct 18th, 2006 at 11:26 am. Reason: spelling
•
•
Join Date: Jul 2004
Location: North East Indiana
Posts: 491
Reputation:
Rep Power: 5
Solved Threads: 20
Posting Pro in Training
Check for errors with mysql_errorno or a similar function. That might help you out some.
www.uncreativelabs.net
Old computers are getting to be a lost art. Here at Uncreative Labs, we still enjoy using the old computers. Sometimes we want to see how far a particular system can go, other times we use a stock system to remind ourselves of what we once had.
Old computers are getting to be a lost art. Here at Uncreative Labs, we still enjoy using the old computers. Sometimes we want to see how far a particular system can go, other times we use a stock system to remind ourselves of what we once had.
•
•
Join Date: May 2005
Posts: 228
Reputation:
Rep Power: 4
Solved Threads: 0
Posting Whiz in Training
•
•
•
•
Originally Posted by sn4rf3r 
change your query to this:
[php]
mysql_query("DELETE FROM employees WHERE recordid='".$recordid."'")
[/php] you cant wrap a variable in single quotes as it will be trated as literal.
Thanks, but that doesn't seem to work either. Plus, I'm pretty sure I've done mysql_query's before with variables in single quotes and it works just fine. And besides, I'v even tried just putting the actual record id in that space, and it doesn't work. For instance, I put:
[PHP]mysql_query("DELETE FROM employees WHERE recordid='8'")[/PHP]
And it still doesn't work. I don't understand!
•
•
Join Date: May 2005
Posts: 228
Reputation:
Rep Power: 4
Solved Threads: 0
Posting Whiz in Training
•
•
•
•
Originally Posted by Puckdropper
Check for errors with mysql_errorno or a similar function. That might help you out some.
How exactly do you use mysql_errorno? I can't find any documentation on it. I even looked on http://dev.mysql.com and couldn't find it. I did try mysql_error, and it spit this error out:
•
•
•
•
Access denied for user: 'user@10.0.0.1' to database 'mydatabase'
I changed the username, IP, and database name, just in case you're wondering. The problem is, I'm not having problems connecting to the database. the config.php file contains a mysql_error that should tell me if there were any connection problems. And the user that this error is telling me can't get access is the same user getting access in all my other scripts. And they're not having any problems. This is really buggin.
•
•
Join Date: Oct 2006
Location: India
Posts: 1,289
Reputation:
Rep Power: 4
Solved Threads: 32
so be carefull while using keywords. it's dangerous.
•
•
Join Date: May 2005
Posts: 228
Reputation:
Rep Power: 4
Solved Threads: 0
Posting Whiz in Training
•
•
•
•
Originally Posted by vishesh
so be carefull while using keywords. it's dangerous.
What? •
•
Join Date: Mar 2006
Location: Florence Ky
Posts: 31
Reputation:
Rep Power: 3
Solved Threads: 3
Light Poster
One thing you might try is to store you're query in a variable before putting it into the mysql_query() function.
$query = "DELETE FROM employees WHERE recordid='$recordid'";
$results = @mysql_query($query);
Mind You I used the storing of results. This is good practice as it allows for good error checking. I use it all the time, as queries ALWAYS return a value. while Selects and whatnot actually return values the others return a true/false value set.... or at least false when they fail.
Try it that way and see if that fixes it. If not.. take the query into a database interface and run the query. You might have to echo the query out to get the exact query, and just run it. That will give you a better understanding of exactly WHERE the issue is in the query.
$query = "DELETE FROM employees WHERE recordid='$recordid'";
$results = @mysql_query($query);
Mind You I used the storing of results. This is good practice as it allows for good error checking. I use it all the time, as queries ALWAYS return a value. while Selects and whatnot actually return values the others return a true/false value set.... or at least false when they fail.
Try it that way and see if that fixes it. If not.. take the query into a database interface and run the query. You might have to echo the query out to get the exact query, and just run it. That will give you a better understanding of exactly WHERE the issue is in the query.
http://img.photobucket.com/albums/v6.../dgstudios.jpg
When all that is becomes one. That is the anomoly. That is... Death's Gate Studios (c) 2005
When all that is becomes one. That is the anomoly. That is... Death's Gate Studios (c) 2005
•
•
Join Date: Sep 2006
Location: NYC
Posts: 133
Reputation:
Rep Power: 2
Solved Threads: 2
Junior Poster
just looks like he cant connect to the database from where he is.
mysql> select * from mysql.user where user = 'username' \G; mysql> GRANT ALL PERMISSIONS ON *.* TO 'joe'@'10.0.1.1' IDENTIFIED BY 'password'
•
•
Join Date: May 2005
Posts: 228
Reputation:
Rep Power: 4
Solved Threads: 0
Posting Whiz in Training
•
•
•
•
Originally Posted by DGStudios
One thing you might try is to store you're query in a variable before putting it into the mysql_query() function.
$query = "DELETE FROM employees WHERE recordid='$recordid'";
$results = @mysql_query($query);
Mind You I used the storing of results. This is good practice as it allows for good error checking. I use it all the time, as queries ALWAYS return a value. while Selects and whatnot actually return values the others return a true/false value set.... or at least false when they fail.
Try it that way and see if that fixes it. If not.. take the query into a database interface and run the query. You might have to echo the query out to get the exact query, and just run it. That will give you a better understanding of exactly WHERE the issue is in the query.
Thanks, I'll give that a try.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb PHP Marketplace
Linear Mode
Other Threads in the PHP Forum
- Previous Thread: help
- Next Thread: Need more help with "if"
