DaniWeb Forum Index > Web Development > PHP

PRoblem in Delete

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

« First

Last »

•

Join Date: Nov 2009

Posts: 44

Reputation: manishmannan is an unknown quantity at this point

Solved Threads: 2

manishmannan manishmannan is offline

Offline

Light Poster

#21

29 Days Ago

NOW hii Will Gresham
thanks for the reply

sir on previous page i have pasted the script of my delete command you can try it and i am remain with that script
thanks
if you can do somthing plz reply

•

Join Date: Sep 2009

Posts: 539

Reputation: network18 is an unknown quantity at this point

Solved Threads: 63

network18

Offline

Posting Pro

#22

29 Days Ago

•

Originally Posted by manishmannan

is there any difference in any both the version of my sql??????

Firstly, thanks for the neat and clean information.
But its not the MySQL version issue. Can you put here the MySQL connection settings you making.Like i said previously, when you executing the script on the server, you need to do the proper changes in the server address like "localhost" won't work there.
Put the IP of your database server there.It might be possible that, the connection your script making on the server is to some other database and its executing fine there, but you checking with some other database as par your expectation.

"The discipline of writing something down is the first step towards making it happen."

follow me on twitter

•

Join Date: Nov 2009

Posts: 44

Reputation: manishmannan is an unknown quantity at this point

Solved Threads: 2

manishmannan manishmannan is offline

Offline

Light Poster

#23

29 Days Ago

hii thanks once again
see my script carefully 1st of all i am getting some date from the database in my tables with my php script the data has been appered on the web page without any problem but wenever i am selecting a records to delete from the data base query executes fine even the echo message has been apperead that records have been deleted.
but still no records have been deleted from the database
if records are coming well by select query on the table then its mean the selected database is correct
what to do???????

•

Join Date: Sep 2009

Posts: 539

Reputation: network18 is an unknown quantity at this point

Solved Threads: 63

network18

Offline

Posting Pro

#24

29 Days Ago

•

Originally Posted by manishmannan

hii thanks once again
see my script carefully 1st of all i am getting some date from the database in my tables with my php script the data has been appered on the web page without any problem but wenever i am selecting a records to delete from the data base query executes fine even the echo message has been apperead that records have been deleted.
but still no records have been deleted from the database
if records are coming well by select query on the table then its mean the selected database is correct
what to do???????

yes, I strongly agree with you and understood your problem too.
But what I am concerned about is that, are you using the same database for both,localhost and online too.That's what I was checking in the previous post.Please make it clear too.

"The discipline of writing something down is the first step towards making it happen."

follow me on twitter

•

Join Date: Nov 2009

Posts: 44

Reputation: manishmannan is an unknown quantity at this point

Solved Threads: 2

manishmannan manishmannan is offline

Offline

Light Poster

#25

29 Days Ago

no no no
i am using my diffterent database with locahost & with internet like
here in localhost i am using----- localhost,root,'no password'
on internet i am using some ----someIP address,hnitindia,"with password"

•

Join Date: Sep 2009

Posts: 539

Reputation: network18 is an unknown quantity at this point

Solved Threads: 63

network18

Offline

Posting Pro

#26

29 Days Ago

•

Originally Posted by manishmannan

no no no
i am using my diffterent database with locahost & with internet like
here in localhost i am using----- localhost,root,'no password'
on internet i am using some ----someIP address,hnitindia,"with password"

ok, fine.please use this -

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
echo mysql_error($connection);
echo mysql_error($connection);

and post it here.
I suspect your "this MySQL user" don't have a grant on the database.
You getting the echo that, "Successfully deleted " doesnt mean necessarily the query got executed. This echo will depend upon what you comparing against.
give it a try-

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$sql = "DELETE FROM $tbl_name WHERE id='$del_id' ";
$result = mysql_query($sql,$con);
echo "result=>".$result."Error=>".mysql_error($con);
$sql = "DELETE FROM $tbl_name WHERE id='$del_id' ";
$result = mysql_query($sql,$con);
echo "result=>".$result."Error=>".mysql_error($con);