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 ---

Reply via email to