Re: [PHP-DB] Dumb Question??
Look at the filemtime() function that should do the trick
Greetz Whosnext
Russ Michell [EMAIL PROTECTED] wrote in message
news:SIMEON.10112131234.B@k1c. anglia.ac.uk...
Sorry! just read-read my post, it should have been:
particular column ('modified') *NOT* to appear under specific
circumstances, somewhere along...
Cheers.
Russ
On Thu, 13 Dec 2001 12:03:09 + (GMT Standard Time) Russ Michell
[EMAIL PROTECTED] wrote:
Hi there everyone:
I have a genericphp/MySQL search+retrival mechanism. Generic in that it
takes table names,
fieldnames and fieldtypes as form lables and element names. However,
because of this I cannot
hard-code my SQL queries as they need to be as generic (univerally
useful) as possible.
I therefore have a lot of SELECT * FROM table_name... queries.
However I would like to be able
to specify a particular column ('modified') to appear under specific
circumstances, somewhere along
the lines of: SELECT *,!modified FROM table_name .. I scanned TFM
and couldn't find anything
specific to my problem. I have an incling this may not be as easy as I
think, so does anyone know
of a bodge,kludge or workaround??
Thanks for your time.
Russ
#---#
Believe nothing - consider everything
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
www.theruss.com
#---#
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
#---#
Believe nothing - consider everything
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
www.theruss.com
#---#
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Dumb Question??
Russ -
Why not (MySQL) extract the field always, and code into your (php) generic mechanism
whether or
not a
particular field under that name appears? Using mysql_fetch_assoc() you could
exclude 'modified' from
your generic mechanism under particular circumstances. This avoids coding it into
your query, so it may
be classified as a cludgeon, but it would work.
Hi Daniel:
I get what you're saying, but I'm still having to hard-code it somewhere into my
scripts. I'm
working on a method of defining fields to include/exclude using arrays whose values
are given for
each application this system is applied to. (That'll keep me busy)
Thanks for your help.
Russ
On Fri, 14 Dec 2001 12:15:01 -0800 Daniel Barton [EMAIL PROTECTED] wrote:
Russ -
Why not (MySQL) extract the field always, and code into your (php) generic
mechanism whether or not a
particular field under that name appears? Using mysql_fetch_assoc() you could
exclude 'modified' from
your generic mechanism under particular circumstances. This avoids coding it into
your query, so it may
be classified as a cludgeon, but it would work.
cheers,
db
Russ Michell wrote:
Sorry! just read-read my post, it should have been:
particular column ('modified') *NOT* to appear under specific circumstances,
somewhere
along...
Cheers. Russ
On Thu, 13 Dec 2001 12:03:09 + (GMT Standard Time) Russ Michell
[EMAIL PROTECTED]
wrote:
Hi there everyone:
I have a genericphp/MySQL search+retrival mechanism. Generic in that it takes
table names,
fieldnames and fieldtypes as form lables and element names. However, because of this
I cannot
hard-code my SQL queries as they need to be as generic (univerally useful) as
possible.
I therefore have a lot of SELECT * FROM table_name... queries. However I
would like to be
able to specify a particular column ('modified') to appear under specific
circumstances,
somewhere along the lines of: SELECT *,!modified FROM table_name .. I
scanned TFM and
couldn't find anything specific to my problem. I have an incling this may not be
as easy as I
think, so does anyone know of a bodge,kludge or workaround??
Thanks for your time.
Russ
#---#
Believe nothing - consider everything
Russ Michell Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam
www.theruss.com
#---#
-- PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED] For additional
commands, e-mail:
[EMAIL PROTECTED] To contact the list administrators, e-mail:
[EMAIL PROTECTED]
#---#
Believe nothing - consider everything
Russ Michell
Anglia Polytechnic University WebteamRoom 1C 'The Eastings' East Road,
Cambridge
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
www.theruss.com
#---#
-- PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED] For additional
commands, e-mail:
[EMAIL PROTECTED] To contact the list administrators, e-mail:
[EMAIL PROTECTED]
--
-- Dan Barton
Terrestrial Program Biologist Asst. Data Manager
Point Reyes Bird Observatory http://www.prbo.org
[EMAIL PROTECTED] [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
#---#
Believe nothing - consider everything
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
www.theruss.com
#---#
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Dumb Question??
Russ -
Why not (MySQL) extract the field always, and code into your (php) generic
mechanism whether or not a
particular field under that name appears? Using mysql_fetch_assoc() you could exclude
'modified' from
your generic mechanism under particular circumstances. This avoids coding it into your
query, so it may
be classified as a cludgeon, but it would work.
cheers,
db
Russ Michell wrote:
Sorry! just read-read my post, it should have been:
particular column ('modified') *NOT* to appear under specific circumstances,
somewhere along...
Cheers.
Russ
On Thu, 13 Dec 2001 12:03:09 + (GMT Standard Time) Russ Michell
[EMAIL PROTECTED] wrote:
Hi there everyone:
I have a genericphp/MySQL search+retrival mechanism. Generic in that it takes
table names,
fieldnames and fieldtypes as form lables and element names. However, because of
this I cannot
hard-code my SQL queries as they need to be as generic (univerally useful) as
possible.
I therefore have a lot of SELECT * FROM table_name... queries. However I would
like to be able
to specify a particular column ('modified') to appear under specific
circumstances, somewhere along
the lines of: SELECT *,!modified FROM table_name .. I scanned TFM and couldn't
find anything
specific to my problem. I have an incling this may not be as easy as I think, so
does anyone know
of a bodge,kludge or workaround??
Thanks for your time.
Russ
#---#
Believe nothing - consider everything
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
www.theruss.com
#---#
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
#---#
Believe nothing - consider everything
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
www.theruss.com
#---#
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
--
Dan Barton
Terrestrial Program Biologist
Asst. Data Manager
Point Reyes Bird Observatory
http://www.prbo.org
[EMAIL PROTECTED]
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Dumb Question??
Hi there everyone:
I have a genericphp/MySQL search+retrival mechanism. Generic in that it takes table
names,
fieldnames and fieldtypes as form lables and element names. However, because of this I
cannot
hard-code my SQL queries as they need to be as generic (univerally useful) as possible.
I therefore have a lot of SELECT * FROM table_name... queries. However I would
like to be able
to specify a particular column ('modified') to appear under specific circumstances,
somewhere along
the lines of: SELECT *,!modified FROM table_name .. I scanned TFM and couldn't
find anything
specific to my problem. I have an incling this may not be as easy as I think, so does
anyone know
of a bodge,kludge or workaround??
Thanks for your time.
Russ
#---#
Believe nothing - consider everything
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
www.theruss.com
#---#
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Dumb Question??
Sorry! just read-read my post, it should have been:
particular column ('modified') *NOT* to appear under specific circumstances,
somewhere along...
Cheers.
Russ
On Thu, 13 Dec 2001 12:03:09 + (GMT Standard Time) Russ Michell
[EMAIL PROTECTED] wrote:
Hi there everyone:
I have a genericphp/MySQL search+retrival mechanism. Generic in that it takes table
names,
fieldnames and fieldtypes as form lables and element names. However, because of this
I cannot
hard-code my SQL queries as they need to be as generic (univerally useful) as
possible.
I therefore have a lot of SELECT * FROM table_name... queries. However I would
like to be able
to specify a particular column ('modified') to appear under specific circumstances,
somewhere along
the lines of: SELECT *,!modified FROM table_name .. I scanned TFM and couldn't
find anything
specific to my problem. I have an incling this may not be as easy as I think, so
does anyone know
of a bodge,kludge or workaround??
Thanks for your time.
Russ
#---#
Believe nothing - consider everything
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
www.theruss.com
#---#
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
#---#
Believe nothing - consider everything
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
www.theruss.com
#---#
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
