[PHP-DB] Problem with dsn

2002-09-11 Thread Gian Michele
I have installed on my computer : Apache 1.3 Php 4.1.2 Postgresql the rpm of odbc and the unixODBC. I tried to connect to my database after done all configurations; I used the function odbc_pconnect('name_of_my_database','','') and the system gives me this error Warning: SQL error:

[PHP-DB] Need help getting record number off insert

2002-09-11 Thread Anthony
I'm doing an insert and need to get the record number that is generated when the record in created. I'm accessing the database through ODBC. It's a DataFlex database and the driver i'm using is by Connex. I know that you can somehow insert a SQL statment inside an other statement. I was

[PHP-DB] php newbie

2002-09-11 Thread Edward Peloke
Hello all, I am very new to php, in fact, this is my first attempt at a script. I have just been following a tutorial online. Currently, I have a page where the user types in a username and password, I then pass those parameters to this page. This page connects to a main db, looks up their

Re: [PHP-DB] Need help getting record number off insert

2002-09-11 Thread Miles Thompson
Check the DataFlex docs and see if it has a function that returns this information, or if the ODBC driver has such a function. Record numbers are dangerously useless in most database operations - they get re-used and changed when records are deleted or repair/compress functions are executed.

RE: [PHP-DB] Problem with dsn

2002-09-11 Thread Andrew Hill
Gian, You need to setup a DSN, not just pass the name of the database. There are some examples in the iODBC HOWTO that may help: http://www.iodbc.org/odbc-phpHOWTO.html Pay attention to the section on putenv() and configure your DSN in the odbc.ini file. Best regards, Andrew Hill Director of

[PHP-DB] MySQL timestamp field update problem

2002-09-11 Thread Rob Day
Hi all, I have a table in MySQL with the following field: 'time_date' timestamp(14) NOT NULL When a record is inserted into the table, NULL is inserted into the time_date field giving me a normal timestamp with the time of the INSERT. That much is fine. However, it is necessary for me to

Re: [PHP-DB] MySQL timestamp field update problem

2002-09-11 Thread Paul DuBois
At 11:59 -0500 9/11/02, Rob Day wrote: Hi all, I have a table in MySQL with the following field: 'time_date' timestamp(14) NOT NULL When a record is inserted into the table, NULL is inserted into the time_date field giving me a normal timestamp with the time of the INSERT. That much is

[PHP-DB] PhpMyAdmin's File Manager and apps

2002-09-11 Thread Russell Griechen
Where are the downloads for these apps? Russell Griechen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: PhpMyAdmin's File Manager and apps

2002-09-11 Thread Brad Bonkoski
http://sourceforge.net/projects/phpmyadmin/ Russell Griechen wrote: Where are the downloads for these apps? Russell Griechen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] oscommerce

2002-09-11 Thread Tony Kuntz
Has anyone on this list had any experience working with oscommerce?

[PHP-DB] numeric to word function

2002-09-11 Thread rainydays_sunshine
Hi.. anyone know any function to convert numeric values to word.. something like this: 1252 -- one thousand two hundred and fifty two Thanks... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PreCaching Db into Variables Slows it down?!??

2002-09-11 Thread Patrick Latour
Not yet a big specialist of PHP, but a rule that apply to nearly all server side scripting languages, use global variables as less as you can. They simplify your programer's life, but on a server that is serving a lot of concurent sessions, it eats all the performances and ressources. It does

[PHP-DB] Re: numeric to word function

2002-09-11 Thread David Robley
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Hi.. anyone know any function to convert numeric values to word.. something like this: 1252 -- one thousand two hundred and fifty two Thanks... http://p2p.wrox.com/archive/c_plus_plus_programming/2001-09/27.asp turned up from a