[RESOLVED] Excel type

maskme

Hi to all

I need to create this
as rows and columns.

This is basically for creating box nos and which section they are stored.

I know this can be done through For loop but this is quite tricky, cant get the kick.

Please help

with valus combining and showing A1, A2, A3 and so on for each column

                          1     2     3     4     5     6     7     8     9     10

A                      A1    A2   A3
B
C
D
E
F
G
H

marshallm

I think we need a little more info.

Are you trying to make a table?

Are the number of rows and columns fixed or are they variable?

A1, A2, and A3 are in the middle of the columns, so I'm not sure what they're for exactly. Can you explain a little better?

Thanks.

maskme

Hi Marshallm

Yes im trying to make a table.
No using the for loop we need to make columns and rows
A1, A2 are the values for each column (row+column = value(A1)).

I'm not sure how to do this, if any1 can help me in this matter wud be gr8
Regards
Yusuf

maskme

Hi Guys

here is the code after long hours of scratching my head

      <table border="1" cellpadding="5" cellspacing="1" bordercolor="#006600">
        <tr> 
          <?

$cnt=1;

//$FS = any character start with
//$FE = any character end with
//$SW = any character start with
//$EW = any character end with
//$T = The Limit of Columns

for ($i = ord($FS); $i <= ord($FE); $i++) 
	{			
		for ($j = ord($SW); $j <= ord($EW); $j++)
			{
				for ($k=1; $k<=$T; $k++)
					{
						$ch = chr($i).chr($j).sprintf("%02d",$k);




?>
          <td align="center"> 
            <?

echo "<b>". $ch ."</b>";

?>
            </td>
          <?

if (!($cnt%$T)){

echo "</tr><tr>";

}

$cnt++;

			}
	}
}
?>
        </tr>
      </table>

Whoppy this is good for any1 who wants to see an overview of location of each boxes stored... worked for me...