Re: Multi-table pager sorted by date
| From: | Nathan Hawks | Date: | Sun, 21 Oct 2007 01:57:06 +0000 |
| Subject: | Re: Multi-table pager sorted by date | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-263458@lists.php.net to get a copy of this message | ||
Nevermind. Just because they can't afford a database redesign doesn't
mean they can't afford a new index table containing date-indexed links
to both tables entities.
On Sat, 2007-10-20 at 21:39 -0400, Nathan Hawks wrote:
> I'm doing a project where the database was designed before me and they
> don't have a budget for a database re-design. There are two entity
> tables which /should/ have been the same model with some meta-fields
> keyed off a type field, but it's not. It's two tables, which should be
> displayed intermixed, paged, and sorted by date.