in php array fetch all rows from mysql database into the single table td?

Question

in php array fetch all rowsfrom mysql database and all values are showing into the single table td? i Want results like this?

1) Small
2) Large
3) Medium

now problem is that all values displaying into single table td i want to display all of these values into separately table td

Query Function

function get_size($id){
$result=mysql_query("SELECT size FROM mywishlist order by id") 
or die("My Wish Size Problem"."<br/><br/>".mysql_error());
$results = array();
while($row=mysql_fetch_array($result)){
$results[] = stripslashes($row['size'])."<br />";
}
return $results;
}

<td><font style="font-family:Arial,Helvetica,sans-serif;  
font-size:15px; color:#000;">
<?php 
foreach($size as $sizes) {
echo $sizes; }
?></font><input type="hidden" name="size" value="<?php echo $size;?>" /></td>

Nanhe Kumar · Answer 1 · 2013-03-11 10:05:12Z

<?php foreach ($size as $sizes) { ?>
    <td><font style="font-family:Arial,Helvetica,sans-serif;font-size:15px; color:#000;">
        <?php echo $sizes; ?> 
        </font><input type="hidden" name="size" value="<?php echo $size; ?>" /></td>  
<?php } ?>

Kishor Subedi · Answer 2 · 2013-03-11 10:11:47Z

You are displaying all data in the same td. You have to make following chages:

<?php 
foreach($size as $sizes) { ?>
    <td>
    <font style="font-family:Arial,Helvetica,sans-serif; font-size:15px; color:#000;">
    <?php echo $sizes;?>
    </font>
   <input type="hidden" name="size" value="<?php echo $size;?>" /></td>
<?php } ?>

Also i would like to suggest to write styles on a style sheet

Edson Medina · Answer 3 · 2013-03-11 10:11:55Z

<?php foreach ($sizes as $size) { ?>
   <td>
     <font style="font-family:Arial,Helvetica,sans-serif;font-size:15px; color:#000;">
       <input type="hidden" name="size" value="<?php echo $size; ?>" />
     </font>
   </td>  
<?php } ?>

asked	1 month ago
viewed	181 times
active	1 month ago

in php array fetch all rows from mysql database into the single table td?

3 Answers

Your Answer

in php array fetch all rows from mysql database into the single table td?

3 Answers

Your Answer

Sign up or log in

Post as a guest

Related