select and produce row from empty table

[Phil Powell]

Based upon an article I read in
http://archives.neohapsis.com/archiv...4-q1/0337.html I am
trying to retrieve an "empty row" of fields from a table that may be
empty.

If I have this query:

SELECT id, fname, mi, lname FROM folks LIMIT 1

This will return 1 single row whereby I have the table columns within
an object resultset I can manipulate in PHP. However, if the table is
empty I have nothing and there is not object for PHP to manipulate,
which is required for the code I'm building (I'm doing a logical join
between database metadata and objects in a directory that may/may not
sync).

How would I then write my query to always produce 1 row consisting of
all fields I need even if the table is empty?

Thanx
Phil

[Jeff North]

On 7 Apr 2004 08:45:38 -0700, in mailing.database.mysql
so*****@erols.com (Phil Powell) wrote:

| Based upon an article I read in
| http://archives.neohapsis.com/archiv...4-q1/0337.html I am
| trying to retrieve an "empty row" of fields from a table that may be
| empty.
|
| If I have this query:
|
|

>| SELECT id, fname, mi, lname FROM folks LIMIT 1

|
| This will return 1 single row whereby I have the table columns within
| an object resultset I can manipulate in PHP. However, if the table is
| empty I have nothing and there is not object for PHP to manipulate,
| which is required for the code I'm building (I'm doing a logical join
| between database metadata and objects in a directory that may/may not
| sync).
|
| How would I then write my query to always produce 1 row consisting of
| all fields I need even if the table is empty?

initialise page variables
read record
if not eof
place records into page variables

---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------

[Jeff North]

On 7 Apr 2004 08:45:38 -0700, in mailing.database.mysql
so*****@erols.com (Phil Powell) wrote:

| Based upon an article I read in
| http://archives.neohapsis.com/archiv...4-q1/0337.html I am
| trying to retrieve an "empty row" of fields from a table that may be
| empty.
|
| If I have this query:
|
|

>| SELECT id, fname, mi, lname FROM folks LIMIT 1

|
| This will return 1 single row whereby I have the table columns within
| an object resultset I can manipulate in PHP. However, if the table is
| empty I have nothing and there is not object for PHP to manipulate,
| which is required for the code I'm building (I'm doing a logical join
| between database metadata and objects in a directory that may/may not
| sync).
|
| How would I then write my query to always produce 1 row consisting of
| all fields I need even if the table is empty?

initialise page variables
read record
if not eof
place records into page variables

---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------

[Jeff North]

On 7 Apr 2004 08:45:38 -0700, in mailing.database.mysql
so*****@erols.com (Phil Powell) wrote:

| Based upon an article I read in
| http://archives.neohapsis.com/archiv...4-q1/0337.html I am
| trying to retrieve an "empty row" of fields from a table that may be
| empty.
|
| If I have this query:
|
|

>| SELECT id, fname, mi, lname FROM folks LIMIT 1

|
| This will return 1 single row whereby I have the table columns within
| an object resultset I can manipulate in PHP. However, if the table is
| empty I have nothing and there is not object for PHP to manipulate,
| which is required for the code I'm building (I'm doing a logical join
| between database metadata and objects in a directory that may/may not
| sync).
|
| How would I then write my query to always produce 1 row consisting of
| all fields I need even if the table is empty?

initialise page variables
read record
if not eof
place records into page variables

---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------