RE: [PHP-DB] Listing parent ids

> 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

Re: [PHP-DB] Listing parent ids

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

RE: [PHP-DB] Listing parent ids

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 >

Re: [PHP-DB] Listing parent ids

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

Re: [PHP-DB] Listing parent ids

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

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

RE: [PHP-DB] Listing parent ids

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-

[PHP-DB] Listing parent ids

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 record its parentid po

Re: [PHP-DB] listing question

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 question

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

[PHP-DB] listing question

Hi there everyone, I have a little problem, I could do this with 2 seperate queries but if I can do it with 1 then even better ;-) I have to list items in numeric order IF the field isn't empty (ie: 0 comes at the top, followed by 1 etc ) and that isn't an issue as PHP with MySQL makes that

[PHP-DB] Listing Tables

Hi, i would like to list all of the tables and field names in my database e.g. table 1 field 1 field 2 field 3 table 2 field 1 field 2 field 3 table 3 field 1 field 2 field 3 etc is there a simple way to do this? thanks for your help -- PHP Database Mailing List (http://w

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

> 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

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

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

[PHP-DB] Listing A Certain # Range

Hello, Im using MySQL and PHP 4.2.3 on Apache and Mandrake Linux, I was wondering how to get PHP to list let says row 5 - 10 from a database, I read the MySQL manual and all I could find is LIMIT 0,5 to list just the first 5, but I dont know how to make that list 5 - 10 or 10 - 15. Any help wou

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

"; } ?> 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,

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

-- Hi, i have tried this php script to view my table db, but when i browse it over the net i couldn't see anything just plain blank page. Hm, Can u help me make this show tables over on php and post it over. thanks, louie... -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] listing

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 >

RE: [PHP-DB] listing

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

Re: [PHP-DB] listing

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

RE: [PHP-DB] listing

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

Re: [PHP-DB] listing

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

Re: [PHP-DB] listing

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

Re: [PHP-DB] listing

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

Re: [PHP-DB] listing

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

[PHP-DB] listing

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...) THanks. -- Su pagarba, Andrius Jakutis InternetMedia http://www.internetmedia.lt GSM: 370 8

[PHP-DB] Listing content as links.

Problem, upload selected htm files to server,delete selected files from server and create link table to these files, with desired link names. Idea is to do uploading and deleting files in admin site as well as define link names. And when user comes in he would see the link list. Any ideas / exa