Re: [PHP] Decide witch table within a union
- From: ceo@xxxxxxxxx ("Richard Lynch")
- Date: Sun, 29 Oct 2006 22:46:01 -0600 (CST)
On Sun, October 29, 2006 3:34 pm, Børge Holen wrote:
Hi.
I got this working (almost)
How do I decide (inside?) the whileloop the table_nr, 1 to 4 witch the
link is
echo'ed from.
I could add another field in each table telling witch table it is.
Easy
solution, but feels like polluting the db.
Also I could do another loop to check another of the printed fields up
agains
witch table is used, but that adding to the slowness of this union
stuff, it
would take forever, if the union in itself is slow or the fact that
I'm
cutting the message field after 100 characters I dunno.
This is anyway the main code wherein the problem lies:
$sql=" (select * from table_1 WHERE pid='0' order by id desc limit 10)
select *, 'table_1' from table_1 ...
union
(select * from table_2 WHERE pid='0' order by id desc limit 10)
select *, 'table_2' from table_2 ...
This gives you an extra field with the table name in it.
You may not be able to use * any more, and have to name all the fields
you actually want.
Which is a better practice anyway.
--
Some people have a "gift" link here.
Know what I want?
I want you to buy a CD from some starving artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?
.
- Follow-Ups:
- Re: [PHP] Decide witch table within a union
- From: Børge Holen
- Re: [PHP] Decide witch table within a union
- References:
- Decide witch table within a union
- From: Børge Holen
- Decide witch table within a union
- Prev by Date: Re: [PHP] Decide witch table within a union
- Next by Date: Re: [PHP] strange problem with count()
- Previous by thread: Re: [PHP] Decide witch table within a union
- Next by thread: Re: [PHP] Decide witch table within a union
- Index(es):
Relevant Pages
|
