Need help with arrays

[wiseone]

Hi, here is the complete detail what i m trying 2 do.

i got around 2000+ images with size/desp/image_no/slno
etc

TABLE sheet1 (
SlNo int(11) NOT NULL auto_increment,
Image No double default NULL,
Title varchar(255) default NULL,
Category varchar(255) default NULL,
Sub-Category varchar(255) default NULL,
Description longtext,
Size varchar(255) default NULL,
Price varchar(255) default NULL,
PRIMARY KEY (SlNo)
) TYPE=MyISAM AUTO_INCREMENT=2841 ;

1. what i m trying to do is there will be a form which
   will pass a value (8,12,14) to the application.

2. Application will take the value n generate html
   tags (well formated table -
   http://www.aquaciti.com/temp/clipboard.jpg) which will
   hav 2 columns and xx number of rows (passed from the
   html form) the data shld be displayed in a horizontal
   manner
   [1] [2]
   [3] [4]
   [5] [6]
   [7] [8]

3. After generating the tags instead of displaying it
   on the browser save the html tags into a txt file in
   the server itself. This process goes on till it
   reaches end of record.

Technically: it will generate 01.txt file which will
hold all the html tags to display from record 1 to 8.
02.txt will hold from record 9 to 16 etc etc etc

i hope u got what i mean to say. most of the things i
managed to code n its working fine but stuck with
horizontal display part. can u pls pls pls help me out

thnx

[devinemke]

$array = array(
	'one',
	'two',
	'three',
	'four',
	'five',
	'six',
	'seven',
	'eight',
	'nine',
	'ten'
);

echo '<table border=1 cellspacing=0 cellpadding=5>';

foreach ($array as $key => $value)
{
	if (!($key % 2)) {echo '<tr><td>' . $value . '</td>';}
	else {echo '<td>' . $value . '</td></tr>';}
}

echo '</table>';

[wiseone]

$counter = "0";
    while($row=mysql_fetch_array($sql_result)){
    	$slno[$counter]            = $row["SlNo"];
    	$image_no[$counter]        = $row["Image No"];
    	$title[$counter]           = $row["Title"];
    	$category[$counter]        = $row["Category"];
    	$sub_category[$counter]    = $row["Sub-Category"];
    	$description[$counter]     = $row["Description"];
    	$size[$counter]            = $row["Size"];
    	$price[$counter]           = $row["Price"];
    	$counter++;
    }

i got all the data into an array...

ur script works fine but the problem is it displaying all 2000+ records in 1 page itself and only 1 field.

what i m looking for is split those 2000+ records into 8 records per array...

eg.

$tabledata[1] => slno,image_no,title,size,prize (contain all field details for 1-8 records including html table tags)
$tabledata[2] => slno,image_no,title,size,prize (contain all field details for 9-16 records including html table tags)
$tabledata[3] => slno,image_no,title,size,prize (contain all field details for 17-24 records including html table tags)
$tabledata[4] => slno,image_no,title,size,prize (contain all field details for 25-32 records including html table tags)
$tabledata[5] => slno,image_no,title,size,prize (contain all field details for 33-40 records including html table tags)

etc etc etc...

if i m able to store these fields in 1 array then it will be easy for me to proceed further...

[wiseone]

i hav pm'd u the source code hav a look, it might help u 2 understand...

[devinemke]

it seems to me that you want to create a multidimensional array then use [man]array_chunk[/man] to split it into groups of 8. below is just a test script with a LIMIT of 100 records. i coded to the script to echo everything to the browser as well as write each set of 8 to a txt file (in a subfolder from the script called "textfiles").

$result = mysql_query('SELECT * FROM sheet1 LIMIT 100');

while ($row = mysql_fetch_assoc($result))
{
	$array[] = $row;
}

$chunks = array_chunk($array, 8);
$i = 0;
foreach ($chunks as $key => $value)
{
	$output = '<table border=1 cellspacing=0 cellpadding=5>' . "\r\n"; 
	foreach ($value as $row_key => $row_value)
	{
		$cell = '';
		foreach ($row_value as $k => $v) {$cell .= $k . ' = ' . $v . '<br>';}

	if (!($row_key % 2)) {$output .= '<tr><td>' . $cell . '</td>';} 
else {$output .= '<td>' . $cell . '</td></tr>' . "\r\n";} 
}	
$output .= '</table>';

echo $output;

$handle = fopen('./textfiles/' . $i . '.txt', 'w');
fwrite($handle, $output);
fclose($handle);
$i++;
}

[wiseone]

instead of <br> @

foreach ($row_value as $k => $v) {$cell .= $k . ' = ' . $v . '<br>';}

is it possible to hav <td>somedata</td>???? and i dont wanna display entire data only 3 - 4 fields thats all!!! can u pls help!!

thnx