Quote:
Originally posted by archael
Yes i know what you mean, I thought about it too but I would have to add that rank to about 50,000+ entries in my database.
And I would order my results by descending order and all the rest by descending order as well.
I tried the cowboy's programmer's way but it doesnt seem to query at all if I have 2 $sth->execute in the code.
I'm gonna try playing around with it some more.
Thanks,
Jon
|
This does not have to be compliated. You could say that all entries that are your get a rank of 1 and everything else gets a rank of 2. If you know what entries are yours then just add the column and do 2 updates. Done. If you don't know what entries are yours without going through each of the 50,000 then you are kind of screwed anyway