php-general Digest 13 Nov 2005 19:11:10 -0000 Issue 3792
Topics (messages 225692 through 225697):
Re: performance suggestions
225692 by: Joe Belmaati
Re: Recommendations for the Zend PHP Certification
225693 by: Marco Kaiser
225694 by: Marcus Bointon
225696 by: Gustavo Narea
Re: Printing to a buffer
225695 by: Marcus Bointon
225697 by: Todd Cary
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[email protected]
----------------------------------------------------------------------
--- Begin Message ---
$sql = "SELECT u.*, s.*, p.*
FROM URL u, session s, page p
WHERE u.url_id = s.url_id
AND s.section_id = p.section";
if (!$result = mysql_query($sql))
{
die('Could not obtain results');
}
while ($row = mysql_fetch_array($result))
{
$url = $row['url_name'];
..........
..........
and what ever else you want to do here;
}
"James Benson" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Thanks
>
>
>
>
> Richard Lynch wrote:
> > On Thu, November 3, 2005 8:29 am, James Benson wrote:
> >
> >>Dear group, can someone suggest the best way to do the following
> >>without
> >>writing some lengthy script that (possibly) could lead to performance
> >>issues,
> >>
> >>
> >>I have three DB fields in MySQL, each has a unique ID, I cannot think
> >>of
> >>any ways other than pulling each tables record then looping through to
> >>determine which one each belongs to which group then maybe placing
> >>into
> >>an array,
> >>the association between them all goes like this,
> >>
> >>
> >>URL:-
> >>url_id
> >>url_name
> >>
> >>section:-
> >>section_id
> >>url_id
> >>section_name
> >>
> >>page:-
> >>page_id
> >>section_id
> >>page_name
> >
> >
> > http://info.com/mysql+join
> >
--- End Message ---
--- Begin Message ---
Hi,
i mean http://www.phparch.com/cert/ :)
-- Marco
> Aren't they the same books?
>
> I mean, I see the same authors, the same titles and the same pictures.
--- End Message ---
--- Begin Message ---
On 12 Nov 2005, at 16:29, Gustavo Narea wrote:
- Zend PHP Certification Study Guide.
This book would be good if it were not so full of errors. With a bit
of luck it's been revised since my edition (July 2004 printing); I
noticed quite a few problems and then found a huge errata list on
their site.
Marcus
--
Marcus Bointon
Synchromedia Limited: Putting you in the picture
[EMAIL PROTECTED] | http://www.synchromedia.co.uk
--- End Message ---
--- Begin Message ---
Hello.
Alright, I get it.
Thanks!
Marco Kaiser wrote:
Hi,
i mean http://www.phparch.com/cert/ :)
-- Marco
Aren't they the same books?
I mean, I see the same authors, the same titles and the same pictures.
--
Gustavo Narea.
PHP Documentation - Spanish Translation Team.
Valencia, Venezuela.
--- End Message ---
--- Begin Message ---
On 13 Nov 2005, at 00:17, Jasper Bryant-Greene wrote:
seem to do that. I just tried "application/text" since I use
"application/pdf" for other applications.
Whatever it's giving the user the ability to do, it's probably
because the browser doesn't recognise the (invalid) MIME-Type.
Quite - it's right up there with 'application/force-download'. If you
want to suggest (the final choice is not yours to make) that a
browser might download something instead of displaying it, set an
appropriate content-disposition header instead of setting the wrong
type.
Marcus
--
Marcus Bointon
Synchromedia Limited: Putting you in the picture
[EMAIL PROTECTED] | http://www.synchromedia.co.uk
--- End Message ---
--- Begin Message ---
Marcus -
Many thanks! I did not know that MIME-Type. Change duly made!
Todd
Marcus Bointon wrote:
On 13 Nov 2005, at 00:17, Jasper Bryant-Greene wrote:
seem to do that. I just tried "application/text" since I use
"application/pdf" for other applications.
Whatever it's giving the user the ability to do, it's probably
because the browser doesn't recognise the (invalid) MIME-Type.
Quite - it's right up there with 'application/force-download'. If you
want to suggest (the final choice is not yours to make) that a browser
might download something instead of displaying it, set an appropriate
content-disposition header instead of setting the wrong type.
Marcus
--- End Message ---