[PHP-DB] Problem with dsn

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: [unixODBC][

[PHP-DB] Re: [PHP-DEV] RFC: ODBC and PHP

On Tue, 10 Sep 2002, Shane Caraveo wrote: > Ok, then I would be for ODBC 3 for PHP 5 as the standard. An ODBC 2 > extension can be shuttled out to PECL for those who may need it. But > for BC issues, there is still the nameing convention. I would personaly > prefer that the odbc functions stay

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

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 thi

[PHP-DB] php newbie

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 us

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

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. I

RE: [PHP-DB] Problem with dsn

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 Te

[PHP-DB] MySQL timestamp field update problem

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 u

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

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 i

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

>From the MySQL Manual: The TIMESTAMP column type provides a type that you can use to automatically mark INSERT or UPDATE operations with the current date and time. If you have multiple TIMESTAMP columns, only the first one is updated automatically. If YOU want control over this, us the DATETI

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

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

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

Has anyone on this list had any experience working with oscommerce?

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

Grrr! Just spent ages (well, 2hours) on a precaching system for my PHP code that didn't work out! Hang on, I'll backtrack a bit... My website is using a php engine that picks at snippets of html from the database, and builds them up to form the page. A typical page may use 5 of these html sn

[PHP-DB] numeric to word function

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?!??

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 no

[PHP-DB] Re: numeric to word function

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 fr