Ok.
Would you suggest to use a extra field to hold the table name as default?
On Sunday 29 October 2006 22:59, Ed Lazor wrote:
> PHP can't tell what table the data came from.
>
> On Oct 29, 2006, at 1: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) union
> > (select * from table_2 WHERE pid='0' order by id desc limit 10)
> > union
> > (select * from table_3 WHERE pid='0' order by id desc limit 10)
> > union
> > (select * from table_4 WHERE pid='0' order by id desc limit 10)
> > order by date desc limit 10 ";
> >
> > $result = mysql_query($sql) or die('Error, query failed');
> > while($myrow = mysql_fetch_array($result)){
> > $id = $myrow["id"];
> > $pid = $myrow["pid"];
> >
> > echo "<a href=\"index.php?table=$table_nr">page</a>";
> > }
> >
> > --
> > ---
> > 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
--
---
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
