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-level
On 28 July 2011 10:39, Arno Kuhl a...@dotcontent.net 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
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
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.
On 28 July 2011 10:39, Arno Kuhl a...@dotcontent.net 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
On 28 July 2011 12:30, Arno Kuhl a...@dotcontent.net wrote:
On 28 July 2011 10:39, Arno Kuhl a...@dotcontent.net 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
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.
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;
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,
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,
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
?php
mysql_connect ('dbhost','user','pass');
mysql_select_db ('db');
$ircname2 = htmlspecialchars($ircname);
$result = mysql_query (select ircname from members);
while( $row = mysql_fetch_array($result) )
{
print $row['ircname'].BR;
}
?
Don't forget all other HTML tags you need to
Something like:
? for($i=1; $i25; $i++) { ?
table
tr
td
?
// php code to output your entry information
?
/td
/tr
/table
? } ?
Andrius Jakutis wrote:
Hello again,
Is there oportunity to write this:
some php command to loop entries, the way is written bellow
HTML php coding.+ MYSQL
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:
? for($i=1; $i25; $i++) { ?
table
tr
td
?
// php code to output your
? } ?
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: [PHP-DB] listing
This gives 25 the same entries. I need to list
)
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: [PHP-DB] listing
This gives 25 the same entries. I need to list all entries from the table,
but with loop
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 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB
: 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:
$query=SELECT * FROM mytable
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
$connect:
$query=SELECT * FROM mytable;
$result = mysql_query($query,$connect) or die(ERROR);
print
19 matches
Mail list logo