array to html table problem

FJW

Hi If I have

while($row[] = mysql_fetch_assoc($result))

why can I not read anything from the database with

$Place .= '<td>' .$image['Location']. '</td>'; where Location is a valid field name

regards
Fred

bad76

Hi,
First, in the while you have $row, instead of $image.
Second, $row is without [] to work:

while($image = mysql_fetch_assoc($result))
$Place .= '<td>' .$image['Location']. '</td>';

And when you have a trouble with array, use print_r()...

while($row = mysql_fetch_assoc($result))
print_r($row); // this will show the whole array.

see you

FJW

Hi Bad76 once again, I enclose the php snip so far and still cannoy get any of the data into the table. Maybe you could tell me why and I will be ever so grateful:-)
if($count = mysql_num_rows($result) > 0) {

/ If we have results, loop through them /

$max=3; /* number of columns before starting new set of data*/  
/* popuplate an array with the image info */ 
while($images = mysql_fetch_assoc($result)) 
print_r($images); // yes this will shows the whole array. 

$count = count($images); 

/* pad array to a number that fully populates the table with an array so the check doesnt error*/ 
if ($count % $max) 
{ 
    $images = array_pad($images, $count + ($max - ($count % $max)), array(1)); 
    $count = count($images); 
} 
/* create table and first row */  
echo '<table border=1><tr>'; 
for($i=0;$i<$max;$i++) 
{ 
    echo "<td>Column $i+1</td>"; 
} 
echo "</tr>\n"; 
for($i=0;$i<$count;$i+=3) /* loop through and build the table */ 
{  
    for($j=0;$j<$max;$j++) 
    { 
        if ($j == 0) 
        { 
            $headings = $pics = $locations = '<tr>';  
        } 
        if ($j == $max-1) 
        { 
            $headings .= "</tr>\n"; 
            $pics .= "</tr>\n"; 
            $locations .= "</tr>\n"; 
        } 
        $image = $images[$i+$j]; //now an array matching the rows from the SQL Query 

         if(isset($image['some_column_from_db_thats_never_null'])) 
	/* due to this check, had to pad the array, with an array */ 
        { 
            $headings .= '<td>' .$images['heading_column']. '</td>'; 
            $pics .= '<td><img src="' .$images['smallpic']. '"></td>'; 
            $locations .= '<td>' .$images['Price']. '</td>'; 
        } 
        else 
        {  
            $headings .= '<td>&nbsp;</td>'; 
            $pics .= '<td>&nbsp;</td>'; 
            $locations .= '<td>&nbsp;</td>'; 
        } 
    } 
    print_r  ($headings); 
    print_r ($pics); 
    print_r ($locations); 
} 
echo '</table>'; //close the table...

}

bad76

while($images = mysql_fetch_assoc($result))

give you ONLY one row. To get ALL images and put the info in an array you have to do something like that:

while($row = mysql_fetch_assoc($result))
$images[]=$row;

Now you get a $images array of ALL db.
To access at any field now you have to give the rigth row:

$images[2]['heading_column'];

or more general:

$images[$j+$i]['heading_column'];

Maybe this work fine. Good luck.

FJW

With the while fetch loop there is no problem seeing alll the array. I am making some progress, the problem seems to be here, if(isset($image['some_column_from_db_thats_never_null']))
/ due to this check, had to pad the array, with an array / .

Once I remove the check it works. Thanks once again I will study some more.:-)

bad76

I don't understand the problem,
but in your code I can find this probabily mistakes:

1- after while there isn't a { } block. So the only one istruction executed other than $images=... is print_r().

2- for($i=0;$i<$count;$i+=3): there you write 3 instead of $max.

3- if ($j == $max-1) is before the main if. Put it before, because you are closing the line...
(you now get

instead of

<tr><td>"some td"</td><td>the ast td</td></tr>)

However try this code, maybe this work fine...
see you

 
<?
if($count = mysql_num_rows($result) > 0) { 
	$max=3; $count=mysql_num_rows($result);

echo "<table border=1><tr>"; 
for($i=0;$i<$max;$i++) 
{ 
	echo "<td>Column $i+1</td>"; 
} 
echo "</tr>\n"; 
for($i=0;$i<$count;$i+=$max) /* loop through and build the table */ 
{ 
	$headings = $pics = $locations = '<tr>'; 
	for($j=0;$j<$max;$j++) 
	{
		if($images = mysql_fetch_assoc($result))			
		{ 
			$headings .= '<td>' .$images['heading_column']. '</td>'; 
			$pics .= '<td><img src="' .$images['smallpic']. '"></td>'; 
			$locations .= '<td>' .$images['Price']. '</td>'; 
		} else { 
			$headings .= '<td>&nbsp;</td>'; 
			$pics .= '<td>&nbsp;</td>'; 
			$locations .= '<td>&nbsp;</td>'; 
		} 			
	} 
	$headings .= "</tr>\n"; 
	$pics .= "</tr>\n"; 
	$locations .= "</tr>\n"; 
	echo $headings;
	echo $pics;
	echo $locations;
} 
echo '</table>';
}
?>

FJW

Greeting ace, neat tidy and it works just fine.
Where in the word are you anyway? States?

bad76

water...
Look under my avatar... you got it!
From Italy!

😃

bye bye

FJW

On the pictures that appear in this project I want to link with an id number to a details page, this is where I got to but its not quite right. Could you fix this please anyone?

$pics .= '<td><A HREF=detail.php?detail='.$images->['id']. '>'<img src="' .$images['smallpic']. '"></td>';

This is my 'normal' link <TD bgcolor=\"#FFFFFF\"width=\"10%%\" ><A HREF=\"detail.php?detail=$row->id\"><IMG SRC=$imagepath$row->smallpic></A></TD> which of course does not work
:-)
Bad76
Nice play is Italy, have been there many times on holiday, too many scooters:-)

bad76

$row->id

This is used with data object. $row is not an object, but an array.
For the array you have to use $row['id']. Then your line is:

Or better is using the . (to add the strings...):

echo "<TD bgcolor=\"#FFFFFF\"width=\"10%%\" ><A HREF=\"detail.php?detail=".$row["id"]."\"><IMG SRC=$imagepath".$row["smallpic"]."></A></TD>";

I hope this works.

(scooter? I'm in a little city, so there isn't problem... (and I've a scooter too :p ))

FJW

Ok thats fine, at least I was 'close' this time. Thanks once again.

How many beers is that to date? :-)