Hiya

could you tell me the best way to do this please

I want to have a link or preferably a button with the word ""delete"" on it that when pressed does this command..
mysql_query("DELETE FROM messages WHERE ID= '$query'") or die(mysql_error());


I know how to use buttons and links with url links but can't seem to find how to add a MySQL command instead of the link :-(

Can you help please?

Thanks

Shaz x

I don't really understand what you're saying completely.. Are you asking how to run a MySQL command without having to load a new page? Well just like I suggested in your last post Learn AJAX.
http://www.w3schools.com/ajax

lol, you seem to like your ajax

hmmmm how can i put this simple

a link normally is used to take you to another page

i don't want it to do that, i want it to do this

mysql_query("DELETE FROM messages WHERE ID= '$query'") or die(mysql_error());

ajax isn't needed for this i do know that much lol

any help would be very much appreciated.

thanks

shaz x

Worked it out now thanks

was simple..

have a link take me to a new page

new page deletes the message with
mysql_query("DELETE FROM messages WHERE ID= '$query'") or die(mysql_error());

then says successfully deleted

then go back with continue

see no ajax lol

thanks

Shaz x

AJAX would have been the way to go for this one... there are ways around it, like the one you used, but using AJAX would have a better result

I'm sorry but you clearly said you didn't want to go to a new page.. Then you said the solution was to go to a new page. Following what you stated AJAX WAS the only way to go. Please clearly understand what you want next time :S.

Originally Posted by Mattmaul1992

I'm sorry but you clearly said you didn't want to go to a new page.. Then you said the solution was to go to a new page. Following what you stated AJAX WAS the only way to go. Please clearly understand what you want next time :S.

LoL

have you never changed your mind?

Lol I guess I am known to do that quite a bit :P. Just thought you where really set on it :S.. Cuz I thought that was the whole problem cuz otherwise it was all basic stuff people should have learned in chapter 1 in their PHP books lol. Good luck .

there are php books? lol

Originally Posted by Mattmaul1992

Lol I guess I am known to do that quite a bit :P. Just thought you where really set on it :S.. Cuz I thought that was the whole problem cuz otherwise it was all basic stuff people should have learned in chapter 1 in their PHP books lol. Good luck .

Now this is a problem with me

unless i am having hands on experience my brain just won't digest it, reading a book or starting with real simple little scripts i find just to boring and forget it as i do it..
but doing what i am doing by writing a whole community site.. and never using php at all before i am forcing myself to learn quick hehe
just some of the "basic stuff" i am still having to pick it up o the way
Hope that makes sense

Shaz x