James Dodds
|
| Posted: 02/20/2002, 7:04 PM |
|
Howdy all...
I have gotton over the connection prob with php & Sql, but the data is stored in the MySql/data/directory, not the {data.mdb}
Using a ODBC connection Reads all the data but will not update nor insert, No errors show but inserted item is just not there, Maybe my ODBC is configued wrong but all my testing uses admin,admin,localhost
Does anyone have a connection String, {db_mysql.inc}, or {db_odbc.inc} that I might be able to pick apart to further understand the {.inc} and a connection that will use {myyellowpages.mdb}, stored with the page on the server, rather then the data dir in the mysql of the apache server.
My copy of the .mdb and my .css has been changed to reflect my Canadian content as to province/state and postalcode/zip with a few more colums in the items table.........
Thanks in advance
I'll watch this forum or you could email and attach a working .inc
james-dodds@shaw.ca
|
|
|
 |
Andrew B
|
| Posted: 02/20/2002, 7:40 PM |
|
What platform are you running on?
|
|
|
|
Nicole
|
| Posted: 02/21/2002, 1:46 AM |
|
James,
if data from db is displayed on the pages the connection is established correctly. I'm not sure the problem is in .inc file.
Try to print generated insert and update sql queries. Are they look correct? Run them in query analyzer. What the result is?
|
|
|
|
|
