SQL Delete query

[Renounce]

i am kinda stuck here.. i looked around on the internet for some tut's.. but i followed a few of them when the 3rd time failed "I Fail" i was done with it -.-
What i am looking for is a query where u can search for the Index 300 that delete's the whole row so people dont got their items in their inventory or storage anymore

as sample:

Table. dbo.item
Row. Index
Item Needs to find: lets say.. 300 or something
what's the correct query to delete all 300 indexes? (the whole row from PID to UpgrRate)

to lazy to searchin through all 100000 rows and find all 300 indexes..

Hope someone got a solution

 

[TrueDarKZONE]

Re: [Help] SQL Delete query

DELETE FROM [YOURDBNAME].[dbo].[Item]
WHERE [Index] = '300'

 

[Renounce]

Re: [Help] SQL Delete query

thanks i will try it

 

[Momo5000]

Re: [Help] SQL Delete query

To view the content, you need to sign in or register

there u go

 

[hero322]

Re: [Help] SQL Delete query

im pretty sure this should work...

<?php
mssql_connect('localhost') or die('mist');
mssql_select_db('kal_db') or die('kack');
DELETE FROM [YOURDBNAME].[dbo].[Item];
WHERE [Index] = '300';
?>
</table></center>
</body>
</html>