[RESOLVED] Looking for neat way to re-initialise an array from MySQL

kiwibrit

I have the following function which works well as far as it goes:

function clothtable($brand, $clothgroup){
$query = "SELECT extorint, thumb, popup FROM Web_images WHERE brand = '$brand' AND clothgroup =  '$clothgroup' ORDER BY id" ;
$result = mysql_query($query) or die ("Error in query: $query. " .
mysql_error());
// count number of rows in database
$row_count = mysql_num_rows($result);
//check if there is a remainder after rows divided by 6
$remainder=$row_count%6;
//no of extra cells required to make up last row
$extracells=6-$remainder;
echo $clothgroup;
echo "<table>\n<tr>\n";
while($row = mysql_fetch_array($result))
{ 		
	if ($i && $i%6==0 )
	echo "</tr>\n<tr>\n";								
	echo "<td>". $row['thumb']." ".$row['popup']."</td>\n";
	$i++;
}
if ($extracells >0) 
echo "<td colspan=".$extracells.">&nbsp;</td>\n";
echo "</tr>\n</table><br>\n";
}
clothtable("Somebrand", "F30");

I would very much like to call up the first row value of extorint from the Web_images MySQL table -so I could change

echo $clothgroup;

 
echo $clothgroup." ".$extorint;

but leave the other values in the first row of the array available for subsequent use in the while loop.

I guess I could open the database within the function, extract my value - then to re-initialise the array close MySQL, then reopen it to get going again. But that does seem really messy. Is there another way I could do this?

extorint is always the same value within the table range, and needs to be extracted before the html table is generated.

dagon

im not sure i understand what your trying to achieve, but i think if you don't echo the results form the query but store them in an array first then you will be able to manipulate it any way you like.

kiwibrit

Your reply got me thinking- thanks. The following cracks the problem (though it's still a little clunky - if you can readily see a neater way, I'd be grateful for a steer).

function clothtable($brand, $clothgroup){
$query = "SELECT extorint FROM Web_images WHERE brand = '$brand' AND clothgroup =  '$clothgroup'";
$result = mysql_query($query) or die ("Error in query: $query. " .
mysql_error());
$row = mysql_fetch_row($result);
echo $clothgroup." ".$row[0];
echo "<table>\n<tr>\n";
$query = "SELECT thumb, popup FROM Web_images WHERE brand = '$brand' AND clothgroup =  '$clothgroup' ORDER BY id" ;
$result = mysql_query($query) or die ("Error in query: $query. " .
mysql_error());
// count number of rows in database
$row_count = mysql_num_rows($result);
//check if there is a remainder after rows divided by 6
$remainder=$row_count%6;
//no of extra cells required to make up last row
$extracells=6-$remainder;
while($row = mysql_fetch_array($result))
{ 		
	if ($i && $i%6==0 )
	echo "</tr>\n<tr>\n";								
	echo "<td>". $row['thumb']." ".$row['popup']."</td>\n";
	$i++;
}
if ($extracells >0) 
echo "<td colspan=".$extracells.">&nbsp;</td>\n";
echo "</tr>\n</table><br>\n";
}
clothtable("Smebrand", "F30");

dagon

i would combine the 2 queries, write it in to an array then echo clothgoup and loop through the array outputting the table.

something like:

$query = "SELECT extorint, thumb, popup FROM Web_images WHERE brand = '$brand' AND clothgroup =  '$clothgroup'"; 

$result = mysql_query($query) or die ("Error in query: $query. " .
mysql_error()); 

while($row = mysql_fetch_array($result))
{         

$out[]=$row;   

} 

echo $clothgroup." ".$row[0][extorint];

foreach($out) array, the rest as you have it.

kiwibrit

Thanks. The web-page requirement has changed slightly at this end - so the need to handle $extorint is on a back burner for the moment. I think something very similar will crop up very soon - and anyway I want to understand array handling better - so I will come back to it - when I am not so totally surrounded by alligators as I drain the swamp.

kiwibrit

Wow. Very neat. I take it you meant:

function clothtable($brand, $clothgroup){
$query = "SELECT extorint, thumb, popup FROM Web_images WHERE brand = '$brand' AND clothgroup =  '$clothgroup'";
$result = mysql_query($query) or die ("Error in query: $query. " .
mysql_error());
while($row = mysql_fetch_array($result))
{         

$out[]=$row;   

}

echo $clothgroup." ".$row[0][extorint]; 
echo "<table>\n<tr>\n"; 
foreach($out as $value)
{ 		
	if ($i && $i%6==0 )
	echo "</tr>\n<tr>\n";		
	echo '<td>'.$value['thumb'].' '.$value['popup']."</td>\n";
	$i++;
}
if ($extracells >0) 
echo "<td colspan=".$extracells.">&nbsp;</td>\n";
echo "</tr>\n</table><br>\n";
}
clothtable("Somebrand", "F30");

Works fine.

I've not seen this sort of thing

$row[0][extorint]

before - which probably shows I have had a sheltered life.

I'll keep the code as a useful snippet - and also dig a bit more into arrays, so that I understand better what I see..

Many thanks for your help.

dagon

that should be $out not $row

its a multidimensional array.

in your case $out[0][extorint] ,$out[1][extorint] ,$out[2][extorint] ...

would all be the same value

every row from your db is an array in $out

you could use the array ($out) key instead of $i, just remember it starts at 0 not 1.

kiwibrit

I think I have taken that all in - and I am bookmarking this thread. Many thanks.