Mysql+PHP to PostGres+PHP ?

[dannymm]

Hi Guys,

I have some issues with postgres.

We are planning to port a Billing Application from MySQL+PHP to
PostGres 7.1+PHP.

The issues are maily with capitalized column names.

My Table Name: NetworkName
Column Name1 : NetCode
Column Name2 : NetworkName

All over the application we have used statements like (After fetching *
from above table).

echo $Row["NetCode"]; and
echo $Row["NetworkName"];

these statements return nothing where as statements like

echo $Row["netcode"]; and
echo $Row["networkname"] display correct
values.

Why is this difference when my column names are capitalized. Even the "psql"
tool displays all column names in lower cases.

Does any body have solution/clue to handle this issue ...

I need to port my application urgently ..

Thanks in Advance,
Danny Appaiah

 

[DazzaMan]

Danny

Try downloading mysqlphp2postgres-0.92.tar from

http://www.naken.cc/mp2p

i have downloaded it for the same reasons as yourself but as of yet not had time to look at it.

Darren