PHP - Columns

Hi,

having stopped php for a while, i'm a little rusty, can someone help me - instead of the results returning in a row by row format, can i have it so it returns column by column?
so, rather than result 1 being first, then 2 underneath then 3 etc etc, can i have result 2 next to result 1?

heres my code

$result = mysql_query("SELECT * FROM members ORDER BY member_id DESC")   
or die(mysql_error());  

echo "<table border='2'>";
echo "<tr> <th></th> <th></th> <th></th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>"; 
echo $row[printf('<img src="%s" height="96" width="128" style="border: 0" />', $row['profile_pic_short'])];
echo "</td><td>"; 
echo "<a href=\"PHP-Login/advert_pages/view_profile_specific.php?seller_name=$row[login]\">". $row['login'] . "</a>";
echo "</td></tr>"; 

} 

echo "</table>";
?>


all help appreciated

thanks

This topic has been moved to CSS Help.

http://www.phpfreaks.com/forums/index.php?topic=359199.0

I am editing code to get sku numbers, for now it just prints as below:

SKU: 123
SKU: 322
SKU: 444
SKU: 555
SKU: 666

I want to put them in columns so it prints as:

SKU: 123      SKU: 322     SKU: 444       SKU: 555
SKU: 666      etc.              etc.

So it is devided into 4 columns.

The code that controls is:
Code: [Select]
<?php if (is_array($order->products)) {
                            $context = array(
                              'revision' => 'formatted',
                              'type' => 'order_product',
                              'subject' => array(
                                'order' => $order,
                              ),
                            );
                            foreach ($order->products as $product) {
                              $price_info = array(
                                'price' => $product->price,
                                'qty' => $product->qty,
                              );
                              $context['subject']['order_product'] = $product;
                              $context['subject']['node'] = node_load($product->nid);
                              ?>
                      <?php echo $product->model; ?><br />
                             
                          <?php }
                              }?>
i would appreciate some help

Hi, I have a piece of code which I trying to search two columns but I just cant get it to work.  Instead it just dumps around 30 entries onto the page.  Can anyone point me in the direction of how to search two columns?

Code: [Select]
$query = "SELECT * FROM questions";

if(isset($_GET['question']) && !empty($_GET['notes'] ))
{
/*query the database*/
$question = $_GET['question'];
$notes = $_GET['notes'];
$query .= " WHERE question && notes like '%$question%' LIMIT 0, 10";
}

$result = mysql_query($query);

while($row = mysql_fetch_assoc($result))

{

$question = $row['question'];
$notes = $row['notes'];

echo "$question
$notes  </br>";
}

Hi all,

This application is given me a nightmare. The code fetches root categories and its sub categories from the a database table. The div table have only 2 columns. I want to add 2 extra columns so that I have 4 columns. Because we have a long list of subcategories meaning I have to scroll down to view the category. Please help

Code: [Select]
{include file='t_javascript_language.tpl'}
{set_css}
{set_js}

<!--<div class="componentheading">{$page_title}</div>-->

<div class="adds_man_list">
<span>{$category_pathway}</span>
{if $current_category->catname!=""}
<div style="border:2px solid #000;">
{include file='elements/display_fields.tpl' position='categoryicon' this_add=$current_category->id}

<strong>{$current_category->catname}</strong>

<div class="adds_subcat" style="text-align:right;background:#F5F5F5; border:1px solid #FFFFFF; " >

{include file='elements/display_fields.tpl' position='categorydetails' this_add=$current_category->id}

<span style="font-size:12px;">

{jtext text="ADS_SUBCATEGORIES"}:   {$current_category->kids} {jtext text="ADS_ADS"}: {$current_category->nr_ads}
<a href="{$current_category->view}" title="{jtext text='ADS_VIEW_LISTINGS'}">
<img src="{$IMAGE_ROOT}view_listings.gif" class="ads_noborder" alt="{jtext text='ADS_VIEW_LISTINGS'}" />
</a>
</span>
</div>
</div>
{/if}
{if $categories|@count<=0}
<h2>{jtext text="ADS_NO_CATEGORIES_DEFINED"}</h2>
{/if}
<table id="adds_categories" class="ads_table">
{section name=category loop=$categories}
{if $smarty.section.category.rownum is odd}
<tr>
{/if}
<td width="50%" class="adsman_catcell" valign="top">
<div class="adds_maincat" {if $categories[category]->watchListed_flag}class="cat_watchlist"{/if}>

{include file='elements/display_fields.tpl' position='categoryicon' this_add=$categories[category]->id}
<a href="{if $categories[category]->kids>0}{$categories[category]->link}{else}{$categories[category]->view}{/if}" >
{$categories[category]->catname}
</a>
{if $categories[category]->is_new}
<!--NEW!!-->
<img src="{$IMAGE_ROOT}new.png" alt="new ads" />
{/if}
<a href="{$categories[category]->view}" title="{jtext text='ADS_VIEW_LISTINGS'}">
<img src="{$IMAGE_ROOT}view_listings.gif" class="ads_noborder" alt="{jtext text='ADS_VIEW_LISTINGS'}" />
</a>
{if $is_logged_in}
{if $categories[category]->watchListed_flag}
<img src="{$IMAGE_ROOT}watchlist.png" width="16"class="ads_noborder" />
{/if}
<a href="{$categories[category]->link_watchlist}">
<img src="{$categories[category]->img_src_watchlist}" width="16" class="ads_noborder" title="{if $categories[category]->watchListed_flag}{jtext text='ADS_REMOVE_FROM_WATCHLIST'}{else}{jtext text='ADS_ADD_TO_WATCHLIST'}{/if}"/>
</a>
{/if}
<br />
</div>

<div class="adds_subcat" style="background:#F5F5F5; border:1px solid #FFFFFF; " >
{include file='elements/display_fields.tpl' position='categorydetails' this_add=$categories[category]->id}
<br />

{section name=subcategory loop=$categories[category]->subcategories}

{include file='elements/display_fields.tpl' position='categoryicon' this_add=$categories[category]->subcategories[subcategory]->id}
<a href="{if $categories[category]->subcategories[subcategory]->kids>0}{$categories[category]->subcategories[subcategory]->link}{else}{$categories[category]->subcategories[subcategory]->view}{/if}">{$categories[category]->subcategories[subcategory]->catname}</a>
{if $categories[category]->subcategories[subcategory]->is_new==1}
<img src="{$IMAGE_ROOT}new.png" alt="new ads" />
{/if}
({$categories[category]->subcategories[subcategory]->nr_a} {jtext text="ADS_ADS"})
{if $categories[category]->subcategories[subcategory]->watchListed_flag}
<img src="{$IMAGE_ROOT}watchlist.png" width="16" class="ads_noborder" />
{/if}
{if $is_logged_in}
<a href="{$categories[category]->subcategories[subcategory]->link_watchlist}">
<img src="{$categories[category]->subcategories[subcategory]->img_src_watchlist}" width="14" class="ads_noborder" title="{if $categories[category]->subcategories[subcategory]->watchListed_flag}{jtext text='ADS_REMOVE_FROM_WATCHLIST'}{else}{jtext text='ADS_ADD_TO_WATCHLIST'}{/if}"/>
</a>
{/if}
<br />
<p style="margin-left:25px;">
{include file='elements/display_fields.tpl' position='categorydetails' this_add=$categories[category]->id}
</p>
{/section}
</div>
</td>
{if $smarty.section.category.rownum is not odd}
</tr>
{/if}
{/section}
</table>
</div>

Many thanks