[PHP-DB] Question regarding the scope of pg_prepare

2006-04-14 Thread Will Chapman
I have a few different pg_prepare statements in my PHP script. I was wondering what scope they lie in. Im assuming they are not saved in the PSQL database, so it is just for the script? They are inside of functions... does it only last until the function exists? I just dont want to keep on

[PHP-DB] select question

2001-08-21 Thread Scott Chapman
Hi, When doing a select of the form SELECT blah FROM blah WHERE blah=blah AND blah=blah; is there any way of doing it with an OR ie;- SELECT blah FROM blah WHERE blah=blah OR blah=blah; or any other way in which I could do something similar? thanks in advance lee -- PHP Database

[PHP-DB] order by date

2001-08-09 Thread Scott Chapman
Hi, I am querying a mysql database and am returning data ordered by date, the trouble is it returns the data from least recent to most recent, I want it to return the data the other way round. Is there a way of having the mysql database doping this re-ordering for me rather than coding it