How to modify/edit loop values from mysql database

[junkle]

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

[Ch0cu3r]

if you query returns more than one record then you can use'd use a loop to iterate over the results, Example

// loop over the records returned by the query
while($row = mysql_fetch_assoc($result))
{
    $title    = $row['title'];    // get the title for current record
    $name     = $row['name'];     // get the name for current record
    $category = $row['category']; // get the category for current record


    echo "$title - $category - $name<br />";
}

But what are wanting to edit the values to?