On Monday 30 October 2006 05:46, Richard Lynch wrote: > 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.
Yes, I never used *, I just inserted it to get rid of all the convertings of fields from the db. The amount of information wasn't useful to represent my problem. I've learned something very useful through this though... How to both NAME and INSERT information into an virtual field at an instance... THANKS to all of you=D. Someone asked what it was to be used for. It's for combining 4 forums into one witch shows the latest movement among them. More like an introduction sort of... > > -- > 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? -- --- Børge Kennel Arivene http://www.arivene.net --- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
