<div>
for #1, &nbsp;are there any gotchas (or surprises) for converting back and forth &nbsp;for _array &nbsp;vs. &nbsp; _index
</div>


for #1,  are there any gotchas (or surprises) for converting back and forth  for _array  vs.   _index

<div>
<div class="content wysiwyg-content">
i'm inheriting code that i need to fix and add features to.<br />
they use order-based queries and there are some bugs due to incorrect index order-matching with the SELECT argument list.<br />
<br />
1. &nbsp;mysql_fetch_array is used with $row[1] &nbsp;where the index corresponds to the SELECT arg order. <br />
&nbsp; &nbsp; &nbsp;i'm accustomed to mysql_fecth_assoc &nbsp;where the field name is used and order is inconsequential (and much more reliable for maintenance, etc.)<br />
<br />
is there any aspect i should be aware of regarding converting from &nbsp; _array &nbsp; &nbsp; to &nbsp; &nbsp;_assoc?<br />
intuitively it seems trivial to just change the function name, and replace the index with $row['fieldname']<br />
There are 33 fields in one query, so you can imagine the spaghetti code!<br />
<br />
2. &nbsp;is there any argument change between using &nbsp;mysql and myslqi &nbsp;system function calls?<br />
can i just blindly substitute for all combinations of mysql_* &nbsp;function names<br />
<br />
thanks!
</div>
</div>


i'm inheriting code that i need to fix and add features to.
they use order-based queries and there are some bugs due to incorrect index order-matching with the SELECT argument list.

1.  mysql_fetch_array is used with $row[1]  where the index corresponds to the SELECT arg order. 
     i'm accustomed to mysql_fecth_assoc  where the field name is used and order is inconsequential (and much more reliable for maintenance, etc.)

is there any aspect i should be aware of regarding converting from   _array     to    _assoc?
intuitively it seems trivial to just change the function name, and replace the index with $row['fieldname']
There are 33 fields in one query, so you can imagine the spaghetti code!

2.  is there any argument change between using  mysql and myslqi  system function calls?
can i just blindly substitute for all combinations of mysql_*  function names

thanks!

mysql query:   name vs. order-based;  mysqli

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.