RE: [PHP-DB] Moving database info?

2001-04-14 Thread Francois Legare
dump the structure and data of the first table and db (on the main page youll find a section for that) take the sql text (ie "CREATE TABLE etc" and "INSERT INTO etc") and paste it into the "Run SQL query" text area of the second db Francois Legare [EMAIL

RE: [PHP-DB] Newbie : URGENT : SELECT ... AS

2001-04-14 Thread Francois Legare
try using single quotes instead of double quotes: SELECT firstname, surname, dob, floor((to_days(curdate())-to_days(DOB))/365) AS age FROM artistes WHERE age = '25'; Francois Legare [EMAIL PROTECTED] Vancouver BC Canada 604.261.1320 > -Original Message- > From: Ma

RE: [PHP-DB] Transferring tables

2001-04-14 Thread Francois Legare
ysql data directory, if that's possible for you to do. Francois Legare [EMAIL PROTECTED] Vancouver BC Canada 604.261.1320 > -Original Message- > From: Mick Lloyd [mailto:[EMAIL PROTECTED]] > Sent: April 14, 2001 5:23 AM > To: Database Help PHP > Subject: [PHP-DB] Transferrin

RE: [PHP-DB] odbc_fetch_row

2001-04-13 Thread Francois Legare
some drivers, look in the user contributed notes at the bottom of the manual page, there seems to be a few solution to that -1 problem Francois Legare [EMAIL PROTECTED] Vancouver BC Canada 604.261.1320 > -Original Message- > From: Randall Barber [mailto:[EMAIL PROTECTED]] > Sent:

[PHP-DB] How to get rid of $PHP_AUTH_USER value?

2001-03-13 Thread Francois Legare
i still get in the site without being ask for my uname/pword. Does anyone know a way to get rid of $PHP_AUTH_USER and $PHP_AUTH_PW? thank you very much Francois Legare [EMAIL PROTECTED] p.s.: the requirements forbid me from using an html form to authenticate our users -- PHP Database Mai