[PHP-DB] PHPSESSID how to append and access

2006-05-25 Thread Girish Agarwal
Hi All, I am using header(Location: http://dv-medical/phpscripts/test.php;) function to hop from one Page to Another in My Web Application My Problem is I have been unable to get the exact syntax to append the Session ID to the URL specified in the header so that it is available

Re: [PHP-DB] PHPSESSID how to append and access

2006-05-25 Thread J R
On 5/25/06, Girish Agarwal [EMAIL PROTECTED] wrote: Hi All, I am using header(Location: http://dv-medical/phpscripts/test.php;) function to hop from one Page to Another in My Web Application My Problem is I have been unable to get the exact syntax to append the Session ID to

RE: [PHP-DB] PHPSESSID how to append and access

2006-05-25 Thread Ford, Mike
On 25 May 2006 12:12, Girish Agarwal wrote: Hi All, I am using header(Location: http://dv-medical/phpscripts/test.php;) function to hop from one Page to Another in My Web Application My Problem is I have been unable to get the exact syntax to append the Session ID to the

[PHP-DB] MySQL/PHP Left Join Question

2006-05-25 Thread Andrew Darby
Hello, all. I don't know if this is a php-mysql question or just a mysql, but here goes: I have a list of DVDs that my library loans out, and I'd like to allow people to add comments to each item. Since this list gets regenerated periodically (it's extracted from another system, the library

Re: [PHP-DB] MySQL/PHP Left Join Question

2006-05-25 Thread tg-php
One thing I've done in situations like this is just load your returned DB data into an array. Something like this would do: $dvdarr[$result['call_number']]['Title'] = $result['title']; $dvdarr[$result['call_number']]['Publisher'] = $result['publisher'];

RE: [PHP-DB] MySQL/PHP Left Join Question

2006-05-25 Thread Bastien Koert
I approach this by assigning a value to a variable and then comparing to see if i need to write out a new title $oldDVD = ; while ($rows=mysql_fetch_array($result)) { //decide whether to show the DVD title if ($oldDVD != $rows['title']) { echo trtd.$rows['title']./td/tr; $oldDVD =

Re: [PHP-DB] MySQL/PHP Left Join Question

2006-05-25 Thread Brad Bonkoski
Some good examples of how to deal with this in PHP have already been given, especially the associative array solution. The question I have is with something like this, how do you weight out the pros/cons of code development versus speed? i.e. for code development breaking the logic up into 2

Re: [PHP-DB] MySQL/PHP Left Join Question

2006-05-25 Thread Andrew Darby
Thanks to Bastien and TG for their suggestions. I'd been looking at it Bastien's way, but TG's is probably better suited to what I want to do. I'd forgotten about that possibility, cramming it all into an array . . . . Again, thanks for the help, Andrew p.s. I'd be curious about the relative

Re: [PHP-DB] MySQL/PHP Left Join Question

2006-05-25 Thread Bastien Koert
test both and let us know bastien From: Andrew Darby [EMAIL PROTECTED] To: php-db@lists.php.net Subject: Re: [PHP-DB] MySQL/PHP Left Join Question Date: Thu, 25 May 2006 12:33:15 -0400 Thanks to Bastien and TG for their suggestions. I'd been looking at it Bastien's way, but TG's is probably