How to use foreach to display data from multiple column?

[devil_vin]

Hi..guys! I have a form and use foreach to output value from multiple column in database.What wrong went in the following script?I can only get the movie name but not category as well.How about if category likely to be bracketed?

<tr> 
<td> 
<? 
if (isset($_SESSION['gmemberid'])) { 
    $tbl_name = "movie"; 

    $result = mysql_query("SELECT name,category FROM $tbl_name") 
                         or die("Cannot execute query."); 

    $numrow = mysql_num_rows($result); 

    if ($numrow != 0) { 
        for ($counter = 0; $row = mysql_fetch_row($result); $counter++) { 
            foreach ($row as $key => $value) { 

                if ($key == 0) { 
?>                     
                        <strong><br> 
                         <?php echo $value;?></strong></font></td> 
                      </tr> 
<? 
             } 
           } 
         } 
       } 
    } 
?>

[boogyman]

                if ($key == 0) { 
?>                     
                        <strong><br> 
                         <?php echo $value;?></strong></font></td> 
                      </tr> 
<? 
             }

this wont print out anything but the first row. you dont want to check if the key is 0. and you are also only printing the value, not the key. to print both you could use somethign like

if() {?>
<tr>
     <th><?php echo $key ?></th>
     <td><?php echo $value ?></td>
</tr>
<?php } ?>

[devil_vin]

I am using mysql_fetch_array() rather than mysql_fetch_rows().

<?
if (isset($_SESSION['gmemberid'])) {
    $tbl_name = "movie";

    $result = mysql_query("SELECT name,category FROM $tbl_name")
                            or die("Cannot execute query.");

    $numrow = mysql_num_rows($result);

    if ($numrow != 0) {
        while($rows = mysql_fetch_array($result)){
             echo '<strong><br>' . $rows[0] .' (' . $rows[1] .') </strong>';
        }
           
?>

Let said now I have seven rows of record need to be fetched out,how can I write a single SQL statement to query them out and display properly,I have an auto-increment id column in the table.Thanks...

[boogyman]

$row[0] tells you very little as to what the key is for this item.
mysql_fetch_array() allows you to reference by key, rather than row.

if ($numrow != 0) { 
while($rows = mysql_fetch_array($result)){?>
    <tr>
         <th><?php echo $rows[$key]; ?></th>
         <td><?php echo $rows[$value]; ?></td>
    </tr><?php
        }

now I have seven rows of record need to be fetched out

that is what the WHERE clause is for

$result = mysql_query("SELECT name,category FROM $tbl_name WHERE _____")
                            or die("Cannot execute query.");

[devil_vin]

Is there any problem with using index.$row[0] is name;$row[1] is category.
I have a query statement to display all seven recordsbut why the first record is skipped?

 $result = mysql_query("SELECT name,category FROM $tbl_name
                           WHERE id BETWEEN '1' AND '7'")
                                 or die("Cannot execute query."); 

[boogyman]

WHERE id<8

[Twey]

You can't always guarantee that the first seven IDs will be below 8; for example, if a row is deleted the eighth row will have an ID of 8. Instead, use a LIMIT clause:

$result = mysql_query(sprintf('SELECT name, category FROM %s LIMIT 8', $tbl_name))
  or die('Cannot execute query.');

[devil_vin]

ok.by this moment how can I align all screening time in a single row?

  <table width="100%" height="47" border="0">
                      <tr> 
                        <td height="21" colspan="6"><font face="Arial">------------------------------------------------------------------------------------------------------------------------------ <br>    
            
<?
if (isset($_SESSION['gmemberid'])) {
    $tbl_name = "movie";

   $result = mysql_query(sprintf('SELECT name,category,screeningTime FROM %s
             LIMIT 1', $tbl_name)) or die('Cannot execute query.');

    //$numrow = mysql_num_rows($result);

   
        while ($rows = mysql_fetch_assoc($result)) {
            echo '<strong>' . $rows['name'] . ' (' . $rows['category'] . ')
                 <br></strong></font>';
            foreach (explode(',', $rows['screeningTime']) as $time) { ?>
            <label>
            <td><input type="radio" value="<?php echo $time; ?>">
            <?php echo $time; ?></td>
            </label>
            </td></tr>
            <?php } ?>
<?
        }

    
}
?>

[Twey]

Remove the wrapping <tr> element.

[devil_vin]

Thanks for reply.Now the entire thing,including the dashed line is on center,how can keep it on left?

                <table width="100%" border="0">
                <tr> 
                  <td height="68"> 
                    <table width="100%" height="47" border="0">
                      
                       <font face="Arial">------------------------------------------------------------------------------------------------------------------------------ <br>    
            
<?
if (isset($_SESSION['gmemberid'])) {
    $tbl_name = "movie";

   $result = mysql_query(sprintf('SELECT name,category,screeningTime FROM %s
             LIMIT 1', $tbl_name)) or die('Cannot execute query.');

    //$numrow = mysql_num_rows($result);

   
        while ($rows = mysql_fetch_assoc($result)) {
            echo '<strong>' . $rows['name'] . ' (' . $rows['category'] . ')
                 <br></strong></font>';
            foreach (explode(',', $rows['screeningTime']) as $time) { ?>
            <label>
            <input type="radio" value="<?php echo $time; ?>">
            <?php echo $time; ?>
            </label>
            
            <?php } ?>
<?
        }

    
}
?>