> I'm currently using MySQL but I'll switch databases if there's a
> compelling reason and no drawbacks.
> Thanks for the lead, I'm googling recursive queries.
'common table expression' is the thing to google for, but MSDN seem to have
hijacked all the top spots.
http://syntaxhelp.com/SQLServer/R
On 28 July 2011 12:30, Arno Kuhl wrote:
> On 28 July 2011 10:39, Arno Kuhl wrote:
>> Arno Kuhl wrote:
>>> Not strictly a php issue but it's for a php app, hope that counts
>>> (plus I haven't had much joy googling this)
>>>
>>> I have a table with an id and a parentid.
>>> If it's a top-level rec
On 28 July 2011 10:39, Arno Kuhl wrote:
> Arno Kuhl wrote:
>> Not strictly a php issue but it's for a php app, hope that counts
>> (plus I haven't had much joy googling this)
>>
>> I have a table with an id and a parentid.
>> If it's a top-level record the parentid is 0, otherwise it points to
>
Arno Kuhl wrote:
I'm currently using MySQL but I'll switch databases if there's a compelling
reason and no drawbacks.
Thanks for the lead, I'm googling recursive queries.
'common table expression' is the thing to google for, but MSDN seem to have
hijacked all the top spots.
http://syntaxhelp.c
And http://www.amazon.co.uk/exec/obidos/ASIN/1558609202/onlinepricecouk
--
Richard Quadling
Twitter : EE : Zend : PHPDoc
@RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On 28 July 2011 10:39, Arno Kuhl wrote:
> Arno Kuhl wrote:
>> Not strictly a php issue but it's for a php app, hope that counts
>> (plus I haven't had much joy googling this)
>>
>> I have a table with an id and a parentid.
>> If it's a top-level record the parentid is 0, otherwise it points to
>>
Arno Kuhl wrote:
> Not strictly a php issue but it's for a php app, hope that counts
> (plus I haven't had much joy googling this)
>
> I have a table with an id and a parentid.
> If it's a top-level record the parentid is 0, otherwise it points to
> another record, and if that record isn't a top-
Chris Payne wrote:
Hi there,
I tried something similar:
$query = "SELECT * FROM videos WHERE videomakers_website_url = '$x' AND
privatepublic = 'public' AND producer_website LIKE '%$x%' OR
videomakers_website_url LIKE '%$x%' ORDER BY videomakers_site_position ASC,
video_title ASC LIMIT $offset,
Hi there,
I tried something similar:
$query = "SELECT * FROM videos WHERE videomakers_website_url = '$x' AND
privatepublic = 'public' AND producer_website LIKE '%$x%' OR
videomakers_website_url LIKE '%$x%' ORDER BY videomakers_site_position ASC,
video_title ASC LIMIT $offset, $item_perpage";
$que
> LIMIT 5,10
> LIMIT 10,15
>
> Something like that should work.
Not quite. LIMIT n,m where n is the starting point and m is how many rows
you want returned.
LIMIT 5 or LIMIT 0,5
LIMIT 5,5
LIMIT 10,5
etc...
---John Holmes...
> Im using MySQL and PHP 4.2.3 on Apache and Mandrake Linux, I was
> wo
LIMIT 5,10
LIMIT 10,15
Something like that should work.
Aaron
-Original Message-
From: conbud [mailto:[EMAIL PROTECTED]]
Sent: December 16, 2002 3:10 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Listing A Certain # Range
Hello,
Im using MySQL and PHP 4.2.3 on Apache and Mandrake Linux, I
";
}
?>
Don't forget all other HTML tags you need to pack around this
-Original Message-
From: louie miranda [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 6:53 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Listing select * from table; on PHP
--
Hi, i have tried
OTECTED]>
Sent: Thursday, August 23, 2001 11:50 PM
Subject: Re: [PHP-DB] listing
> Okay, but what if I want to use data from two tables not only from
> "companies" ?
>
>
>
>
>
> > Assuming you've opened a MySQL connection and stored connection in
>
Sent: Thursday, August 23, 2001 11:51 PM
To: Rick Emery; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] listing
Okay, but what if I want to use data from two tables not only from
"companies" ?
> Assuming you've opened a MySQL connection and stored connection in
$connect:
>
>
>
> There is no "trying"...
> There is only "Do" or "Not Do"
>
>
>
> -Original Message-
> From: Andrius Jakutis [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 23, 2001 11:22 PM
> To: [EMAIL PROTECTED]
> Subject: Re:
Emery
Excel Communications, Inc.
IT Sr. Project Manager
(972) 478-3398
(972) 944-0542 (pager)
There is no "trying"...
There is only "Do" or "Not Do"
-----Original Message-----
From: Andrius Jakutis [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 11:22
I think what you want is
Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com
- Original Message -
From: "Andrius Jakutis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 23, 2001 11:22 PM
Subject: Re: [PH
This gives 25 the same entries. I need to list all entries from the table,
but with loop.
More solutions?
"Chris Hobbs" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Something like:
>
>
>
>
>
> // php code to output your entry information
> ?>
>
>
I have found Richard Heyes's template class to be very useful for
this sort of thing--he includes functions to parse code surrounded by
tags for an entire MySQL result set. Very handy if you
prefer to separate code and layout. (If anyone is interested, I
wrote a function that extends his cl
Something like:
Andrius Jakutis wrote:
> Hello again,
>
> Is there oportunity to write this:
>
>
> HTML php coding.+ MYSQL - 1 entries information
>
>
> Something like that:
>
>
>
>
>
> first entry information from table "companies" (name, telephone...)
>
>
>
>
>
>
>
20 matches
Mail list logo
