Hi friends. I want to php code on how i can modify my retrieved database values from a particular table before echoing out. Please could you help me correct the code. Or if there is any better way of editing loop datas before printing out, please kindly drop the code for me. Thanks
<?php
$q = "SELECT * FROM threads WHERE catid='2'";
$get = $database->query($q) or die(mysql_error());
$row=mysql_fetch_row($get);
$value=$row['0']['title'];
$one='first value';
echo $value.$one;
$value=$row['1']['name'];
$two='second value';
echo $value.$two;
$value=$row['2']['category'];
$three='third value';
echo $value.$three;
?>
please if there is any better way of editing loop values from mysql database before printing out, please kindly drop the code for me. Thanks