Re: [PHP] Decide witch table within a union

2006-10-31 Thread Ed Lazor
On Oct 30, 2006, at 9:20 PM, Børge Holen wrote: On Tuesday 31 October 2006 02:27, Ed Lazor wrote: 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... Sounds cool. Are you using a

Re: [PHP] Decide witch table within a union

2006-10-30 Thread Børge Holen
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

Re: [PHP] Decide witch table within a union

2006-10-30 Thread Ed Lazor
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... Sounds cool. Are you using a pre-made forum package? -Ed -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP] Decide witch table within a union

2006-10-30 Thread Børge Holen
On Tuesday 31 October 2006 02:27, Ed Lazor wrote: 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... Sounds cool. Are you using a pre-made forum package? No Maby it'd been

Re: [PHP] Decide witch table within a union

2006-10-29 Thread Ed Lazor
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.

Re: [PHP] Decide witch table within a union

2006-10-29 Thread Børge Holen
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

Re: [PHP] Decide witch table within a union

2006-10-29 Thread Chris
Børge Holen wrote: Ok. Would you suggest to use a extra field to hold the table name as default? Why do you need to know which table it's in? What are you going to use it for in the next step? I see you're passing it in: echo a href=\index.php?table=$table_nrpage/a; but what are you going

Re: [PHP] Decide witch table within a union

2006-10-29 Thread Ed Lazor
Definitely not. Review your design. If you need to know which table data comes from, then perform table specific queries. If you need to combine data from more than one table, code your application to respond accordingly. You may also need to review your database schema design in order

Re: [PHP] Decide witch table within a union

2006-10-29 Thread Paul Novitski
On Oct 29, 2006, at 2:00 PM, Børge Holen wrote: Would you suggest to use a extra field to hold the table name as default? At 10/29/2006 04:16 PM, Ed Lazor wrote: Definitely not. Review your design. If you need to know which table data comes from, then perform table specific queries. If

Re: [PHP] Decide witch table within a union

2006-10-29 Thread Ed Lazor
That seems unreasonably harsh. I can see what you mean, but don't take it that way. I was trying to help. What in your view is wrong with a union query that preserves an indicator of which component table a particular record comes from? Read earlier in the thread. He's talking

Re: [PHP] Decide witch table within a union

2006-10-29 Thread Richard Lynch
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

Re: [PHP] Decide witch table within a union

2006-10-29 Thread Paul Novitski
At 10/29/2006 08:04 PM, Ed Lazor wrote: That seems unreasonably harsh. I can see what you mean, but don't take it that way. I was trying to help. Sorry, Ed, I had intended my reply to be friendly as well. I'm allergic to smiley-face icons, but I should have tried harder to convey my

Re: [PHP] Decide witch table within a union

2006-10-29 Thread Ed Lazor
Sorry, Ed, I had intended my reply to be friendly as well. I'm allergic to smiley-face icons, but I should have tried harder to convey my tone. Dang this poker-faced email! No worries. It's all good :) -Ed -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: