previously we 've MysQL and later converted into MySQLi, we got the data with mysql but afetr upgrdation to mysqli we are not able to get the data, please help,
MySQL:
for ($i = 0; $i<$numfields; $i += 1) {
$field = mysql_fetch_field($query, $i);
echo '<td>' . substr($fielddata[$field->name],0,100) . '</td>';
}

MySQLI:
for ($i = 0; $i<$numfields; $i += 1) {
$field = mysqli_fetch_field($query, $i);
echo '<td>' . substr($fielddata[$field->name],0,100) . '</td>';
}

Thanks in advance

Yeah, Fixed, The final code was
for ($i = 0; $i<$numfields; $i += 1) {
$field = mysqli_fetch_field($query, $i);
echo '<td>' . substr($fielddata[$i],0,100) . '</td>';
}

    Write a Reply...