convert mysql code to codeigniter
Posted
by
Jethro Tamares Doble
on Stack Overflow
See other posts from Stack Overflow
or by Jethro Tamares Doble
Published on 2012-10-09T09:31:21Z
Indexed on
2012/10/09
9:37 UTC
Read the original article
Hit count: 154
How can i convert this code into an acceptable codeigniter code:
mysql_select_db($database_connection_ched, $connection_ched);
$query_Institutions = "SELECT * FROM tb_institutional_profile ORDER BY tb_institutional_profile.institution_name ASC";
$Institutions = mysql_query($query_Institutions, $connection_ched) or die(mysql_error());
$row_Institutions = mysql_fetch_assoc($Institutions);
$totalRows_Institutions = mysql_num_rows($Institutions);
<td width="192"><select name="institution_id">
<?php
do {
<option value="<?php echo $row_Institutions['institution_id']?>" ><?php echo $row_Institutions['institution_name']?></option>
<?php
} while ($row_Institutions = mysql_fetch_assoc($Institutions));
?>
</select></td>
© Stack Overflow or respective owner