RE: [PHP-DB] Listing parent ids

2011-07-28 Thread Arno Kuhl
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

Re: [PHP-DB] Listing parent ids

2011-07-28 Thread Richard Quadling
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

Re: [PHP-DB] Listing parent ids

2011-07-28 Thread Richard Quadling
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

Re: [PHP-DB] Listing parent ids

2011-07-28 Thread Lester Caine
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.

RE: [PHP-DB] Listing parent ids

2011-07-28 Thread Arno Kuhl
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

Re: [PHP-DB] Listing parent ids

2011-07-28 Thread Richard Quadling
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

RE: [PHP-DB] Listing parent ids

2011-07-28 Thread Arno Kuhl
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.

RE: [PHP-DB] listing question

2006-04-11 Thread Chris Payne
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;

Re: [PHP-DB] listing question

2006-04-11 Thread Chris
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,

RE: [PHP-DB] Listing A Certain # Range

2002-12-16 Thread Aaron Wolski
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,

Re: [PHP-DB] Listing A Certain # Range

2002-12-16 Thread 1LT John W. Holmes
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

RE: [PHP-DB] Listing select * from table; on PHP

2002-01-09 Thread Rick Emery
?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

Re: [PHP-DB] listing

2001-08-23 Thread Chris Hobbs
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

Re: [PHP-DB] listing

2001-08-23 Thread Andy Crouch
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 LOOP/LOOP 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

Re: [PHP-DB] listing

2001-08-23 Thread Andrius Jakutis
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

Re: [PHP-DB] listing

2001-08-23 Thread Sheridan Saint-Michel
? } ? 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

RE: [PHP-DB] listing

2001-08-23 Thread Rick Emery
) 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

Re: [PHP-DB] listing

2001-08-23 Thread Andrius Jakutis
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

RE: [PHP-DB] listing

2001-08-23 Thread Rick Emery
: 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

Re: [PHP-DB] listing

2001-08-23 Thread Sheridan Saint-Michel
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