Raised This Month: $ Target: $400
 0% 

SQL Selecting a Row?


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
|PJ| Shorty
Veteran Member
Join Date: Aug 2005
Location: Bavaria, Germany
Old 12-27-2008 , 08:04   Re: SQL Selecting a Row?
Reply With Quote #6

if you want to delete all rows where a value is for example <= 37.0:
Code:
'DELETE FROM table WHERE x<=37.0'
if your PRIMARY KEY is your entity id, read this entity id than you can do:
Code:
'DELETE FROM table WHERE entity_id=%d'
it all depends from your db structure and your SELECT query

you could also set a PRIMARY KEY id AUTO INCREMENT and set your entity_id as UNIQUE

you see, a lot of possible solutions
__________________
There are only 10 types of people in the world:
Those who understand binary, and those who don´t.

Last edited by |PJ| Shorty; 12-27-2008 at 08:20.
|PJ| Shorty is offline
Send a message via ICQ to |PJ| Shorty Send a message via AIM to |PJ| Shorty Send a message via MSN to |PJ| Shorty Send a message via Yahoo to |PJ| Shorty Send a message via Skype™ to |PJ| Shorty
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 09:18.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode