How do I write a procedure using 4.0.22

[Cory Bonallo]

I am new to MySQL and my background is in VFP and T-SQL. I need to import data from two files that are not normalized. This means reading a row at a time into variables, writing to one table, getting the primary key, then writing to another etc. then going to the next row. I'd write a program in VFP or a stored procedure in T-SQL. Since version 4.0.22 does not support sp's, now what? I've been reading the manual and have found several references to run a group of sql statements from a file, but I still need to create a cursor, fetch and store and set the data and cursors are only supported in 5.0. I am using phpMyAdmin. I do not know php. Anyone know of a good example for doing this? Thanks so much for your help.

Cory Bonallo
Retail Services
Developer