Delete From Mysql Database Help

[Mancent]

I can not delete from where id = id.

 

becasue that would delete all of them, I want to delete from table where id and name and fid == the same how would i do that can i do this with the delete

 

DELETE FROM tablename WHERE id = ('$id') AND name =('$name') AND fid =('$fid')

[MDCode]

DELETE FROM tablename WHERE id = ('$id') AND name =('$name') AND fid =('$fid')

 

Yes you can, the parentheses serve no purpose though

[Mancent]

so would that only delete where the id = 1029384 and the name = some name and the fid = 2938575?

 

and not delete all the id = 1029384

 

kinda like a select system inside the delete.

[MDCode]

Yes

[Mancent]

awesome cool. thank you. never tested it yet not that far i just wondered.

[Mancent]

For some reason its not deleting the data, been tracing it all out and the post being send is all correct. is my syntax wrong

 

$Delete = mysql_query("DELETE FROM WiiS_Shared_Music WHERE UserId='$MyUserId' AND UserFId='$FbUserId' AND SongName='$SongName' AND SongUrl='$SongUrl'") or die(mysql_error());

[MDCode]

If there are no errors then there are no results that match your query

[Mancent]

mysql table WiiS_Shared_Music

 

 

100002957030150 Three Days Grace - Home http://wiistream.com/users/100001957015772/sounds/028d18dfa174315ef5dca7c006b815fd.wss 100001957015772 1 1

[MDCode]

Remove or die(mysql_error()); as well as the mysql_query() to leave only your query:

 

 $Delete = "DELETE FROM WiiS_Shared_Music WHERE UserId='$MyUserId' AND UserFId='$FbUserId' AND SongName='$SongName' AND SongUrl='$SongUrl'"

 

Under that add echo $Delete; to show what you're looking for in the query

[Mancent]

UserId='$FbUserId' I had it backwards UserFId='$MyUserId'

 

it works now

[MDCode]

So it's solved?

[Mancent]

yes.

[Mancent]

yes for now, but the bad thing about this is its so unsecure if anyone knew the userid and the friend id and the song name song url they could delete any song from any user with out adding a join table that had a accesstoken, so it still needs more work, but the basic there.