we should select the MAX dat for each site and see if its maximum date entry is older than a year from now.
if so we select all its rows. if not, we don't select any of its rows.
ok, its always my mistake in elaborating..
each purchase made have a date. so .. if the last purchase the client made was a year ago. i no longer want ALL his records in the database.
if another client made very old purchase and a very recent purchase as well, i keep the old ones. so its...
none are correct, please read again. i mentioned date X (int)
I just want to remove all purchases for outdated clients. Thats all into the story.
OFCOURSE i dont have 4 clients only (i have alot more). so please read the example for illustration
mysql query help ($5 reward) [SOLVED]
i have the following tables
client
-----
id
name
purchases
---------
p_id
c_id
date
...
i want to select all purchases for all clients where their last purchase was before date X.
For example:
Consider client 1, 2, 3 and 4.
client 1 made 20 purchases...
gmaister22 not saying that his approach is any better you know, but you started it..anw my point was cleared out and no i don't know the guy :P
lets have some weed now and forget about this :D
.mac its his right 100%, as i said it came in a really bad way, if i was him i would perhaps acted the same. i wouldn't reply "i wont tell you" but comming telling your hosting sucks and making faces over live chat for the owner is not really nice..
i sell stuff as well, when people cross a...
from this page i will stop using fileserve. they are just another hotfile supported. i used to have similar issues with rapidshare when they where at there peak! and seriously i was abusing and still they said perhaps someone have your account.
i mean rapidshare and megaupload are both good...
my email got hacked several times and just follow the forget password and put as much information as possible. if u have other google services it will help u alot. and most of all add mobile number to ur email will save ur email.
good luck
lets be honest no girl have even 0% computer logic. and this girl is no different. her bf is behind this or it is just news. using a public trojan or something
lol
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.