Hi i've been working on a task of porting some code from some old postgresql driven site to a newer and imported site running against mysql. There are some sections of code that use's function calls like:
$DataArrDT = pg_fetch_array($result,$i);
Then later on in the code there are sections like:
if ($DataArrDT[0]=="")
based on the index of the datatable array, different sections to tables are constructed for visibility.
However, when the code was modified to hand the mysql_fetch_array function call tons and tons of warnings are thrown. I completely expected that; however, i've been working for quite some time attempting to resolve them, and i've reached my knowledge banks dead end.
here is what i attempted:
$DataArrDT = mysql_fetch_array($result,$i);
or
$DataArrDT = mysql_fetch_assoc($result,$i);
regardless of the selection i still receive errors like:
Notice: Undefined offset: 5 in .php on line xxx
And those undefined offset warnings typically go hand-in-hand with
Warning: mysql_fetch_assoc() [function.mysql-fetch-assoc]: The result type should be either MYSQL_NUM, MYSQL_ASSOC or MYSQL_BOTH in .php on line xxx
If there is something i'm missing to help you provide feedback on how to resolve, please let me know and i'll add to the initial posts. this is something i need to figure out. If there is a link i should read also post that so in the future i can expand my depth.