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 +0000 (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]
