trying to get mysql_result( ) to work

[ScrewLooseSalad]

I'm trying to put some awkward codes into an array for processing, to get useful information from in the code,

My problem is trying to get these codes from the database, can anyone

Below is my code trying to get the codes from the database

once it is outputting correctly I can then get on with the processing,

any help getting an output I can then store into an array would be much appreciated!

$query = "select * from orderlog where DeliverNote like '%$year%';";
$result = $db2->query($query);
$num_results = $result->num_rows;
$row = $result->fetch_assoc();
$i=1;
while($i<=$num_results){
	echo mysql_result($result,$i,"DeliverNote");
	$i++;
}

[Barand]

    $query = "select * from orderlog where DeliverNote like '%$year%';";

    $result = $db2->query($query);

    while ($row = $result->fetch_assoc()) {

        echo $row['DeliverNote'] . '<br>';

    }

[ScrewLooseSalad]

 

    $query = "select * from orderlog where DeliverNote like '%$year%';";
    $result = $db2->query($query);
    while ($row = $result->fetch_assoc()) {
        echo $row['DeliverNote'] . '<br>';
    }

awesome! That has done the trick, thanks!

Edited March 8, 2013 by ScrewLooseSalad