[Resolved] retrieving rows from db in arrays

[raymie7]

Hi,

I'm trying to retrieve rows from a db using a for loop. I can get some sort of data back but it's simply a jumble of letters. I think it may be something to do with [$i]? Can anyone look at this code and point me in the right direction?

$query = mysql_query("SELECT product_name,grouping_id,description_short,price,stock_price,stock_level,amount_sold, datefrom,dateto,discontinued 
FROM PRODUCTS
WHERE amount_sold > 0 ");
$product_match = mysql_fetch_array($query);
$count = mysql_numrows($query);

for ($i = 0; $i < $count ; $i++) 
{ 
  <tr>
		<td  class="res_cell" width="160px" bgcolor='[code=php] echo $bg?>' >
[code=php] echo $product_match[$i]['product_name'];?>
			</td>
			<td class='res_cell' bgcolor='[code=php] echo $bg?>' >
			[code=php] echo
$product_match[$i]['product_group'];?>
			?>&nbsp;
			</td>
			<td class="res_cell" bgcolor='[code=php] echo $bg?>'>
			[code=php] echo $product_match{$i]['grouping_id'];?>
			</td>
			<td  class="res_cell" bgcolor='[code=php] echo $bg?>'>

		</td></tr>
}

Thanks.

[BooRadLey]

Hello, I do it this way:

<?php
$query = mysql_query("SELECT product_name, grouping_id, description_short, price, stock_price, stock_level, amount_sold,  datefrom, dateto, discontinued FROM PRODUCTS WHERE amount_sold > 0 ");

while($product_match = mysql_fetch_array($query)) {
?>
<tr>
<td class="res_cell" width="160px" bgcolor='<?php echo $bg; ?>' >
<?php echo $product_match['product_name']; ?>
</td>
<td class='res_cell' bgcolor='<?php echo $bg; ?>' >
<?php echo $product_match['product_group']; ?>
</td>
<td class="res_cell" bgcolor='<?php echo $bg; ?>'>
<?php echo $product_match['grouping_id']; ?>
</td>
<td class="res_cell" bgcolor='<?php  echo $bg; ?>'>

</td></tr>
<?php
} 
?>

Hope this helps,

Brad

[raymie7]

Thanks for your help. I'm getting an error though - 'call to undefined function mysql_fetch_array'. Should I use a list function before the query?

Cheers

[ramsore]

The mysql_fetch_array function return two arrays, one an index array and two an associative array of columns not of rows so your program is incorrect

To check what you have in your array use this:

echo "<pre>";
print_r($product_match);
echo "</pre>";

use this to print a result set:

$sql= "select * from products";
$result=mysql_query($sql);
echo "<table>\n";
//printing titles of resultset;
for($i=0;$ i<mysql_num_fields($result);$i++) $title=str_replace('_',' ',mysql_field_name($result,$i));
echo "<tr><td>".implode('<td>',$title);

//printing rows of resultset
while($row=mysql_fetch_assoc($result)){
echo "<tr><td>".implode('<td>',$row);
}
echo "</table>\n";

//Test it really works with any result set

[raymie7]

Thanks for your help Ramsore. However, I get a warning error that implode is a bad argument when using your suggestions.

Best
Ray

[ramsore]

Sorry raymie

for($i=0;$ i<mysql_num_fields($result);$i++) $title=str_replace('_',' ',mysql_field_name($result,$i));

shoud be

for($i=0;$ i<mysql_num_fields($result);$i++) $title[]=str_replace('_',' ',mysql_field_name($result,$i));

$title should be $title[] only in for statement because is an array;

[raymie7]

Thanks again for your help ramsore. It's almost there. All the data is appearing now but not before the column names are displayed in a strange triangular shape!
eg.
name
name title

name title age
name title age year

I should be able to correct it.

Cheers
Ray

[ramsore]

//printing titles of resultset;
for($i=0;$ i<mysql_num_fields($result);$i++) $title[]=str_replace('_',' ',mysql_field_name($result,$i));
echo "<tr><td>".implode('<td>',$title);

raymie

watch this

echo "<tr><td>".implode('<td>',$title);

should be out the for cicle;

for($i=0;$ i<mysql_num_fields($result);$i++) {
$title[]=str_replace('_',' ',mysql_field_name($result,$i));
}

//This is out the for cicle first you put all fields name in an array
//then you implode that array.
//Check the implode and explode functions in manual
//Check too associative and index arrays this is a php powerfull thing

echo "<tr><td>".implode('<td>',$title);