[SOLVED] PHP loop

[PHPNS]

Hi,  I seem to struggle with loops in PHP.  Can someone please look at the following code and help me... PLEASE. 

 

$query = "SELECT sh_us_overnight FROM tbl_shipping_us";

 

$result = mysql_query($query);

 

for ($i = 0; $i < $result; $i++) {

 

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

 

$rate = $row[$i];

 

}

}

 

 

echo "$rate[0]";

echo "$rate[1]";

 

Hopefully you geniuses can tell what I'm trying to do here.  If not, I'm simply trying to loop through multiple rows returned so that I can assign each row a to a rate variable.  As in, rate1 equals something (row1), rate2 equals something (row2), etc.

I'm getting a weird result here, where each rate array is giving me the next digit in the final row selected.  Obviously, not what I want.

[simcoweb]

This part:

 

for ($i = 0; $i < $result; $i++) {

 

doesn't make any sense since it's checking if $i is < (less than) $results. The $results contains the data from your query, not an integer.

[B34ST]

<?php
$query = "SELECT sh_us_overnight FROM tbl_shipping_us";
         
$result = mysql_query($query);
$i = 0;
while ($row = mysql_fetch_array($result))
{
      $rate[$i] = $row[$i];
      $i++;
}   
foreach $rate as $value 
{
   echo $value;
}
?>

[PHPNS]

This code is still not returning an array.  Still only the last row received by the initial query.  Plus I think you forgot the brackets (in the for loop). 

Any other suggestions

[B34ST]

try:

<?php
$query = "SELECT sh_us_overnight FROM tbl_shipping_us";
         
$result = mysql_query($query);
$i = 0;
while ($row = mysql_fetch_array($result))
{
      $rate[$i] = $row[$i];
      $i++;
}   
foreach ($rate as $r => $value )
{
   echo $rate[$r];
}
?>

[PHPNS]

Still no go.  Am I missing something.  I think (in my limited knowledge) that this last change is really no different than the previous.  I do appreciate the help though!

Any other takers?

[PHPNS]

Hey B34ST, This worked!

 

$query = "SELECT sh_us_overnight FROM tbl_shipping_us";

 

$result = mysql_query($query);

 

 

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

$rate[] .= $row[0];

}

 

Ah sweet victory!!

[B34ST]

dont forget to mark this topic as solved