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>
<?
             }
           }
         }
       }
    }
?>

[bradgrafelman]

Is there a reason you're trying to count the number of rows and do some sort of for() loop to loop through the result set? Why not just do this:

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

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

while($data = mysql_fetch_assoc($result)) {
    foreach($data as $value) {
?>                    

					<strong><br>
					 <?php echo $value;?></strong></font></td>
				</tr>
<?
        }
    }
}
?>

[devil_vin]

Thanks for reply.Let said now I have seven rows of record need to be fetched out,why the first record is skipped?

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

$result = mysql_query("SELECT name,category FROM $tbl_name
                            WHERE id BETWEEN '1' AND '7'")
                 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></font>';

  }

?>	

[laserlight]

The common reason for the first row to be "missing" from the result set is that a mysql_fetch_assoc() (or equivalent) call was made prior to a loop over the result set. In your code snippet, there is no such superfluous call, so if the first row is missing, then it really is missing. Possible reasons include an incorrect query or that it simply is not in the database.

As bradgrafelman has pointed out, you do not need to check with mysql_num_rows() before looping over the result set. I also recommend accessing the columns by name rather than position, and to this end switching from mysql_fetch_array() to the more precise mysql_fetch_assoc().

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

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

while ($rows = mysql_fetch_assoc($result)) {
    echo '<strong><br>' . $rows['name'] .' (' . $rows['category']
        . ')</strong></font>';
}
}

?>

[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 } ?>
<?
        }


}
?>	

[The_Chancer]

Dependant on how the screeningtime is stored (and in what format.. mysql date, unix timestamp etc) you can use the ORDER BY to get them orderd by the time, then run a little check to see if the time currently being processed is the same as the last one - if so, then same line. If not then close table row and move to next.

[devil_vin]

Thanks for helping,by now I would like to submit the form after clicking one of the radio button.How can the selected screeningTime and its movie name being captured by $_POST?Really appreciate for your initiative.

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

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

//$numrow = mysql_num_rows($result); 


while ($rows = mysql_fetch_assoc($result)) { 
    echo '<table width="100%" border="0"><tr><td height="68"> 
              <table width="100%" height="47" border="0"> 
               ---------------------------------------------------------------------------------------------------------<br>'; 

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


} 
?>