formatting an array

[wardy]

PLs Hlp Am new to php and i am trying to get an array to display across a table rather than straight down one after the other
so it displays 1,2,3,4,
instead of
1
2
3
4
has anybody got a sample file that i could please view to understand where i am going wrong
as i get
1111
2222
3333

etc.

[bad76]

Hi,
look this

 
for($i=0;$i<4;$i++) $myarr[]=($i+1);
for($i=0;$i<4;$i++) echo $myarr[$i]."<br>";

I hope this help you....

[
i think you are using a nesteed loop before echo:
for($i=0;$i<4;$i++)
for($j=0;$j<4;$j++)
echo $myarr[$i]."<br>";
You don't need it because your array is mono-dimension
]

[wardy]

can anbody help cannot get an array to go across in cols rather than down in rows am new to php driving me nuts please help here is a sample where am i going wrong.

<?

include('config.php');

//Open Connection to database
$db = mysql_connect("$hostname", "$username","$password");
mysql_select_db("$database",$db);

?>

<?

$result = mysql_query("SELECT * FROM models", $db);

while($myarr=mysql_fetch_array($result))

for($i=0;$i<4;$i++)
for($j=0;$j<4;$j++)
echo $myarr[$i]."<br>";

?>

[wardy]

can anbody help cannot get an array to go across in cols rather than down in rows am new to php driving me nuts please help here is a sample where am i going wrong.

<?

include('config.php');

//Open Connection to database
$db = mysql_connect("$hostname", "$username","$password");
mysql_select_db("$database",$db);

?>

<?

$result = mysql_query("SELECT * FROM models", $db);

while($myarr=mysql_fetch_array($result))

for($i=0;$i<4;$i++)
for($j=0;$j<4;$j++)
echo $myarr[$i]."<br>";

?>

[bad76]

But what you are saying ?!? 😕
The while it's instead of my for, you haven't to use both together....

If you need to look in db just do it:

while($myarr=mysql_fetch_array($result))

{
echo $myarr[0]."<br>";
}

This will show just first field selected... you can show other using $myarr[1], $myarr[2], $myarr[...]...

[tekky]

<?

include('config.php');

//Open Connection to database
$db = mysql_connect("$hostname", "$username","$password");
mysql_select_db("$database",$db);

?>

<?

$result = mysql_query("SELECT * FROM models", $db);

while($myarr=mysql_fetch_array($result))
{
     echo '<tr>'; //open table row
     for($i=0;$i<sizeof($myarr);$i++)
     {
          echo '<td>' .$myarr[$i]. '</td>'; //print each row from database in own column from left to right
     }
     echo '</tr>'; //close table row
}
?> 

hope that helps...