PHP/MySQL - Some help please...

JackN

Anyone out here experienced with the use of these two?

I'm about to stumbled head long into a project where I have to convert an Access ODBC database and it's supporting Cold Fusion documents to PHP 4 and MySQL.

I've located some tutorials for both either using the existing ODBC Database with MySQL, or exporting it to MySQL.

Any thoughts on which way I should go in this step? Will exporting to MySQL preserve the field linking that exists in the Access Database?

PHP is just a matter of me learning how to do the same stuff I was doing in CF with the SQL statements, so I don't have to much to ask there...

[img]http://216.15.145.59/mainforums/smile.gif[/img]

JackN

I've been told elsewhere to export it to MySQL altogether... ANyone have pro or con to add to that suggestion?

Anyone?

[img]http://216.15.145.59/mainforums/smile.gif[/img]

PJH

I have decent experience with databases and SQL, but I have never converted a database, so unfortunately I can't help you with that. [img]http://216.15.145.59/mainforums/frown.gif[/img]

Never used MySQL either, but we're soon getting into that in my web programming course I'm currently taking, but not quite yet. Same with the PHP, although it's not a big deal to learn when I have lots of earlier programming experience with other languages. I actually already went through all the basic stuff (If...Else, While, For etc.) and it didn't really much differ from other languages.

- PJH