Re: IF ..THEN

Hi no, most dbs have one or more procedural languages built in for that sort of thing. (my chosen db is PostgreSQL, check this out http://www.postgresql.org/idocs/index.php?programmer-pl.html ) mySQL is a no-go though - really it doesnt support much in the way of real RDBMS functionality (fast though...) -- Shane On Tuesday 06 November 2001 10:29 pm, Richard S. Crawford wrote: > Isn't PL/SQL proprietary to Oracle, though? > > As it is, MySQL is not capable of stored procedures, or anything like > PL/SQL. > > At 02:29 PM 11/6/2001, Shane Wright wrote: > >Hi > > > >You want to be using PL/SQL for this - its a Procedural Language in SQL. > >(not in mySQL AFAIK though). > > > >You could write this in PL/SQL, making it a function which you'd then call > >from PHP. > > > >The documentation for your database should describe how to do this. > > Sliante, > Richard S. Crawford > > http://www.mossroot.com > mailto:rscrawford@mossroot.com > AIM: Buffalo2K ICQ: 11646404 Y!: rscrawford > "It is only with the heart that we see rightly; what is essential is > invisible to the eye." --Antoine de Saint Exupéry > > "Push the button, Max!"