PHP - Moved: Echo Out Columns In Pdf Timetable

I want to echo out a few subcategories per main category.
It should be a maximum of 20 entries per column

At this stage I have the following... It echo's the results out in 4 columns and not what I want.
Any suggestions?

$query = "SELECT 
adsubcat.name AS subname, adsubcat.linkname AS sublink, adcat.clinkname AS clink
FROM adsubcat 
JOIN adcat ON adcat.id=adsubcat.catid
WHERE adsubcat.catid='$catid' ORDER BY adsubcat.name ASC";
$result = mysql_query($query) or die(mysql_error());

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

$count = 0;

print '<table style="text-align:left;margin-left:0px;width:943px;">'."\n";
while ($row = mysql_fetch_assoc($result)){
$gal = '<a href="'.$root.'/'.$row['clink'].'/'.$row['sublink'].'">'.$row['subname'].'</a>';
if ($count == 0){
print '<tr>';
}
++$count;
print '<td>'.$gal.'</td>';
if ($count == 4){
$count = 0;
print'</tr>'."\n";
}
}
print'</table>'."\n";
}

This topic has been moved to MySQL Help.

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

This topic has been moved to MySQL Help.

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

This topic has been moved to JavaScript Help.

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

This topic has been moved to JavaScript Help.

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

This topic has been moved to JavaScript Help.

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

This topic has been moved to PHP Applications.

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

This topic has been moved to MySQL Help.

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

OK, have no idea what's going on... I've done this a million times... why wont this output!??
I must have a major brain meltdown and dont know it yet!!!

Code: [Select]
<?php

// this echoes just fine:
echo $_POST['testfield'];


// but this wont echo:
echo 
if (isset($_POST['testfield']))
{
$_POST['testfield'] = $test;
}
echo $test;


/// or even this DOESNT echo either!:
$_POST['testfield'] = $test;
echo $test;

?>

Hi All,

I'm trying to echo the response from an SLA query, the query works and returns the data when I test it on an SQL application.. but when I run it on my webpage it won't echo the result.

Please help?

<?php   
$mysqli = mysqli_connect("removed", "removed", "removed", "removed");  
$sql = "SELECT posts.message FROM posts INNER JOIN threads ON posts.pid=threads.firstpost WHERE threads.firstpost='1'";  
$result = mysqli_query($mysqli, $sql);   
echo {$result['message']}; 
?>

I have a log system that allows 10 logs on each side(Left and right). I am trying to make it so that the left side has the 10 most recent logs, then the right as the next 10. Any ideas?

So I need to echo a row from my database with php, but where i need to echo is already inside an echo. This is my part of my code:


$con = mysql_connect("$host","$username","$password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("main", $con);

$result = mysql_query("SELECT * FROM Vendor");

while($row = mysql_fetch_array($result))
  {
//I need to echo right here  .................. but I get a blank page when I try this. Please Help.
  echo '<option value=$row['vendor_id']>'; echo $row['vendor_id']; echo '</option>';
  }

mysql_close($con);

Result: A Blank page.
Thanks in advance!

Hi   I try to echo out random lines of a html file and want after submit password to whole content of the same html file. I have two Problems. 1st Problem When I echo out the random lines of the html file I don't get just the text but the code of the html file as well. I don't want that. I just want the text. How to do that?

for($x = 1;$x<=40;$x++) {
		$lines = file("$filename.html");
        echo $lines[rand(0, count($lines)-1)]."<br>";
        }

I tried instead of "file("$filename.html");" "readfile("$filename.html");" But then I get the random lines plus the whole content. Is there anything else I can use instead of file so that I get the random lines of text  without the html code?P.S file_get_contents doesn't work either have tried that one.     2nd Problem:   As you could see in my first problem I have a file called $filename.html. After I submit the value of a password I want the whole content. But it is like the program did forget what $filename.html is. How can I make the program remember what $filename.html is? Or with other words how to get the whole content of the html file?   My code:

if($_POST['submitPasswordIT']){
if ($_POST['passIT']== $password ){
$my_file = file_get_contents("$filename.html");
echo $my_file;
}
else{
echo "You entered wrong password";
}
}

If the password isn't correct I get: You entered wrong password. If the password is correct I get nothing. I probably need to create a path to the file "$filename.html", but I don't know exactly how to do that.   

Is there a way to echo the results of a query as separate columns as opposed to one under the other?

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