PHP - I Want To Display My Result In Rows Of 4

I have a classified ad program where I need to export ads (items). This code displays a category, subcategory, ad title, description and price for each ad. I would like to display the category and subcategory followed by the all the ads from within the category and subcategory instead of repeating the category and subcategory for each ad. Any help would be appreciated, thanks in advance! 



Code: [Select]

function getExport() {

$this->db->select("
item.id AS item_id,
item.title AS item_title,
item.description AS item_description,
item.price AS item_price,
subcategory.subcategory AS subcategory_subcategory,
category.category AS category_category,
(SELECT IF(item.datestarts IS NULL AND item.dateexpires IS NULL,'PENDING',IF(item.datestarts <= UNIX_TIMESTAMP() AND item.dateexpires >= UNIX_TIMESTAMP(),'ACTIVE',IF(item.dateexpires <= UNIX_TIMESTAMP(),'EXPIRED',''))) FROM item WHERE item.id = item_id) AS item_status");

$this->db->join('subcategory', 'subcategory.id = item.subcategory');
$this->db->join('category','category.id = subcategory.category');
$this->db->join('user','user.id = item.owner');
return($this->db->get($this->table));

Okay so, I'm adding a reply feature to my text-board, and I'm wondering how I can select a single result from the DB
I've tried this
$board = mysql_real_escape_string($_GET['board']);
$thread = mysql_real_escape_string($_GET['thread']);

$result = mysql_query("SELECT subject, name, id, timestamp, body FROM $board LIMIT $thread,$thread");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    printf("<div id='html1' style='background-color:#F0E0D6;border:solid 1px #800000;font-family:arial; font-size: 12px; padding:2px; margin:2px;'><font color='#CC1105'>%s </font><font color='#117743'>%s</font> <font color='#800000'>Post # %s - %s<br />%s<br /></div>", $row[0], $row[1], $row[2], $row[3], $row[4], $row[5], $row[6]);
mysql_free_result($result);
}
?>
Kinda works but if I pu
?thread=56
then it would show thread 57, which in this example does not exist.

I'm writing a highscore board for a game and I can only display one value from a DB... 
I don't know what I could be doing wrong. I've done this kind of DB work before.

<?php
$name = $_GET['lvl'];
    if($_GET['lvl']=="Strength"){ //1/21
        $skill = "strlvl";
        $exp = "strexp";
}     else if($_GET['lvl']=="Attack"){ //2/21
        $skill = "atklvl";
        $exp = "atkexp";
}     else if($_GET['lvl']=="Defence"){ //3/21
        $skill = "deflvl";
        $exp = "defexp";
}     else if($_GET['lvl']=="Hitpoints"){ //4/21
        $skill = "hplvl";
        $exp = "hpexp";
}     else if($_GET['lvl']=="Range"){ //5/21
        $skill = "rglvl";
        $exp = "rgexp";        
}     else if($_GET['lvl']=="Magic"){ //6/21
        $skill = "mglvl";
        $exp = "mgexp";
}     else if($_GET['lvl']=="Hitpoints"){ //7/21
        $skill = "hplvl";
        $exp = "hpexp";
}     else if($_GET['lvl']=="Prayer"){ //8/21
        $skill = "prlvl";
        $exp = "prexp";
}     else if($_GET['lvl']=="Runecraft"){ //9/21
        $skill = "rclvl";
        $exp = "rcexp";
}     else if($_GET['lvl']=="Slayer"){ //10/21
        $skill = "sllvl";
        $exp = "slexp";
}     else if($_GET['lvl']=="Thieve"){ //11/21
        $skill = "thlvl";
        $exp = "thexp";                        
}     else if($_GET['lvl']=="Agility"){ //12/21
        $skill = "hplvl";
        $exp = "hpexp";
}     else if($_GET['lvl']=="Firemaking"){ //13/21
        $skill = "fmlvl";
        $exp = "fmexp";
}     else if($_GET['lvl']=="Woodcut"){ //14/21
        $skill = "wclvl";
        $exp = "wcexp";
}     else if($_GET['lvl']=="Cooking"){ //15/21
        $skill = "cklvl";
        $exp = "ckexp";
}     else if($_GET['lvl']=="Herblore"){ //16/21
        $skill = "hblvl";
        $exp = "hbexp";
}     else if($_GET['lvl']=="Mining"){ //17/21
        $skill = "mnlvl";
        $exp = "mnexp";
}     else if($_GET['lvl']=="Farming"){ //18/21
        $skill = "frmlvl";
        $exp = "frmexp";
}     else if($_GET['lvl']=="Fishing"){ //19/21
        $skill = "fshlvl";
        $exp = "fshexp";
}     else if($_GET['lvl']=="Smithing"){ //20/21
        $skill = "smlvl";
        $exp = "smexp";
}     else if($_GET['lvl']=="Fletching"){ //21/21
        $skill = "fltlvl";
        $exp = "fltexp";
}     else if($_GET['lvl']==""){ //0/21
echo "<center><br /><br />No skill selected!</center><br />";
}
mysql_connect("mysql", "15557_test", "**************") or
    die("Could not connect: " . mysql_error());
mysql_select_db("15557_test");
//STARTS HERE
$result = mysql_query("SELECT playerName, $skill, $exp FROM skills ORDER BY $exp ASC LIMIT 5000");

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
echo"Skill: " . $name . "<br />";
printf("Player: %s - Rank: %s - EXP: %s<br />", $row[0],$row[1],$row[2]);

mysql_free_result($result

//ENDS HERE
}
?>

Hi, I would like to ask, how to display the while loop result 3 per row with the following code below:
  $startDate = strtotime($datefrom);  

Hi there (I'm new at PHP/mysql)

I am busy with a project - I maneged to load info into the mysql database and display the results BUT - now I need some Help

I can display the result - now I want to have the ability to click on the result and it must open a new page with only the selected result information?

 

Code: [Select]
SELECT DISTINCT(keywords_keyword), photos_extension FROM photos,photos_keywords,keywords,photos_websites WHERE photos_keywords_photo=photos_id AND photos_keywords_keyword=keywords_id AND photos_websites_website='3' ORDER BY keywords_keyword ASC
this code gets all the correct websites, but I would like to get one website per keywords_keyword, how can I do this please?

I have a database that contains results of fantasy football games.  I have a query that returns the results of the games team X played against the other teams in the league.  The query works perfect in the database.

Results are
Quote

Opponent Name:    America Enforcers
Wins    Losses    Draws
1                1                0
Last Game:    Week 2 of 2011: 416.6 - 369.8



the query and the php code cycle thru each team that team X has played and brings up team X's record and the results of the last game played.

My problem is that the code stops one team short.  So Team X played teams A, B, C, D, E
but the code only returns teams A, B, C, D
E is left off. 

I can't for the life of me figure out what silly mistake I made.

Code: [Select]
<?php 
include_once('../other/functions.php');
$con = mysql_connect($hostname, $username, $password) 
OR DIE ('Unable to connect to database! Please try again later.');
$db = mysql_select_db($dbname, $con);
$thing = $_GET['thing'];
$query = "select selected.teamname AS selected_team, selected_score.score AS selected_score, week.week, year, home_id, ". 
"target_score.score as target_score, target.teamname as targetname, week.ID ".
"from owners as selected ".
"JOIN game_scores AS selected_score ON selected.owner_id = selected_score.team_id ".
"JOIN game_setup ON game_setup.game_id = selected_score.game_id ".
"JOIN game_scores AS target_score ON target_score.game_id = game_setup.game_id AND target_score.team_id != selected_score.team_id ".
"JOIN owners AS target ON target.owner_id = target_score.team_id ".
"JOIN week ON week.week = game_setup.week ".
"WHERE selected.owner_id = $thing ".
"and target.active = 1 ".
"GROUP BY target.teamname, year, week.ID ";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$result1 = mysql_query($query);
$row1 = mysql_fetch_array($result1);
if (!$result) {
    die('Invalid query: ' . mysql_error());
}
$wins=0;
$losses=0;
$draws=0;
$last_target = false;
echo '<h2>' . $row1['selected_team'] . ' vs. Active Teams</h2>';
while ($row = mysql_fetch_assoc($result))
{
    if ($last_target['targetname'] != $row['targetname'])
    {
        if ($last_target)
        {
            printf('
<table border="1" width="600">
<tr>
<th>Opponent Name:</th>
<th colspan="2">%s</th>
</tr>
<tr>
<th>Wins</th>
<th>Losses</th>
<th>Draws</th>
</tr>
<tr>
<td align="center">%d</td>
<td align="center">%d</td>
<td align="center">%d</td>
</tr>
<tr>
<th>Last Game:</th>
<td colspan="2">%s of %s: %.1f - %.1f</td>
</tr>
</table><br/>',
$last_target['targetname'],
                $wins,
                $losses,
                $draws,
                $last_target['week'],
                $last_target['year'],
                $last_target['selected_score'],
                $last_target['target_score']
);    
        }
        $wins = $losses = $draws = 0;
    }
    if ($row['selected_score'] < $row['target_score'])
        ++$losses;
    elseif ($row['selected_score'] == $row['target_score'])
        ++$draws;
    else
        ++$wins;
    
    $last_target = $row;
}

?>



Any ideas on how to make the magic elvish be good???
Thank you for your time.

Hello,

First time posting here, my MYSQL version is 5.1.52 and I have a created a search function to find a user record and if the name is typed correctly the name and details are displayed on the search page, but if the name is typed incorrectly nothing is appearing. Basically I would like to be able to say if no record found and redirect back to the previous page.

Code:
Code: [Select]
<?php
add = $_POST['add'];
        
// Database details
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name="Rewards"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot SELECT DB");

//Add query
$sql = mysql_query("UPDATE Rewards SET Rewards = (Rewards + 10) WHERE Name '%$add%'");



// Database details
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name="UserList"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot SELECT DB");


//Update Total Points query
$sql = mysql_query("UPDATE UserList SET TotalPoints = (TotalPoints + 10) WHERE Name '%$add%'");



// Database details
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name="UserList"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot SELECT DB");



//Search Query
$sql = mysql_query("SELECT * FROM UserList WHERE Name '%$add%'");  

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

echo '<br/><img src="images/line1.jpg" alt="" width="200" height="2" />';

echo '<br/> Username: '.$row['Username']; 

echo '<br/>';  

echo '<br/><img src="images/line2.jpg" alt="" width="200" height="2" />';

echo '<br/> Name: '.$row['Name'];   

echo '<br/> Year Group: '.$row['YearGroup'];

echo '<br/> Form Class: '.$row['FormClass'];

echo '<br/>';

echo '<br/><img src="images/line3.jpg" alt="" width="200" height="2" />';

}  


// Database details
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name="Rewards"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot SELECT DB");

$sql = mysql_query("SELECT * FROM Rewards WHERE Name '%$add%'");  

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

echo '<br/> Rewards: '.$row['Rewards'];

}  



// Database details
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name="Sanctions"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot SELECT DB");

$sql = mysql_query("SELECT * FROM Sanctions WHERE Name '%$add%'");  

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

echo '<br/> Sanctions: '.$row['Sanctions'];

}  


// Database details
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name="UserList"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot SELECT DB");


$sql = mysql_query("SELECT * FROM UserList WHERE Name '%$add%'");  

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

echo '<br/> Total Points: '.$row['TotalPoints'];

echo '<br/>';

echo '<br/><img src="images/line4.jpg" alt="" width="200" height="2" />';   

}  
Any help would be greatly appreciated.

Many Thanks

P Quinn

MOD EDIT: [code] . . . [/code] tags added.

I am seeking to learn more about the noted subject, how to use PHP to allow a user to enter search terms and search a database.  I have experimented with this with little results save for errors.  Please see code listed below:

search.php
<?
//// filename = search.php
<form method="post" action="result.php3">
<select name="metode" size="1">
<option value="row_name1">metode1</option>
<option value="row_name2">metode2</option>
</select>
<input type="text" name="search" size="25">
<input type="submit" value="Begin Searching!!">
</form>
?> 

results.php
//// filename = result.php3
<?
$hostname = "mysql7.000webhost.com"; // Usually localhost.
$username = "a4542527_root"; // If you have no username, leave this space empty.
$password = "*******"; // The same applies here.
$usertable = "people"; // This is the table you made.
$dbName = "a4542527_test1"; // This is the main database you connect to.
MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect to database");
@mysql_select_db( "$dbName") or die( "Unable to select database");
?>
<?
//error message (not found message)
$XX = "No Record Found";
$query = mysql_query("SELECT * FROM $usertable WHERE $metode LIKE '%$search%' LIMIT 0, 30 ");
while ($row = mysql_fetch_array($query))
{
$variable1=$row["row_name1"];
$variable2=$row["row_name2"];
$variable3=$row["row_name3"];
print ("this is for $variable1, and this print the variable2 end so on...");
}

//below this is the function for no record!!
if (!$variable1)
{
print ("$XX");
}
//end
?>

Upon viewing search.php I receive the error message:
Parse error: syntax error, unexpected '<' in /home/a4542527/public_html/search.php on line 3

I believe I may be missing something and am a bit lost.
Thank-you in in advance for any help or suggestions.
~Matty

This topic has been moved to MySQL Help.

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

Morning

I have a table with many rows. Some of these rows have the same id number. I'm wondering how I print all the rows with the like id like so programing,design,help. My fucntion is below.

  function getPostTags($postid){
     
     $sql = mysql_query("SELECT tag FROM tags WHERE id=$postid") or die(mysql_error());
 if (mysql_num_rows($e)){
    extract(mysql_fetch_array($sql));
$tags[$postid]=array();
$tags[$postid]['tag'];

 }
 return $tags;
   }   

So if I do this <?php print $tags; ?> It only prints out one result from my table.

What do I have to do it get it to print all row field values from the table with a comma.

Right now the only way I can do this is instead of printing "$tags" (which only gives me one of the many values) I query the database again and do a while statement with
$row = mysql_fetch_array. This isn't the right way to do it.  Can someone help or give me some pointers?


Thanks for the help.

I have a mysql table that holds data for cars - each car has it's own ID, name, and year. Some cars are repeated.

Example: (ID - year - car name)
0001 - 2009 - Honda Civic
0002 - 2008 - Toyota Prius
0003 - 2009 - Honda Civic
0004 - 2008 - Toyota Prius
0005 - 2008 - Toyota Prius
0006 - 2007 - Honda Civic

How would I count how many of the same type of cars I have in that table and then display the quantity next to the car name? Like for the above example it would be:

2009 Honda Civic: 2
2007 Honda Civic: 1
2008 Toyota Prius: 3

Thanks in advance for any help  :D

<?php
require_once('upper.php');

require_once('database.php');
if(isset($_COOKIE['LoginIdCookie']))
{
echo '<h4>Welcome '.$_COOKIE['LoginIdCookie'].'</h4>';
}
else{ echo '<h4>Events</h4>';}
$result=mysqli_query($dbc,"select * from events") or die('Not Connected');
echo "<html>
<body>";
  echo "<form method='post' action='EventParticipator.php'>"; 
  echo "<u><h4>Please tick events in which you want to participate</h4></u>";
  /*echo "<table cellspacing='0' cellpadding='15'>
   <th><b>Event Title:</b></th>
   <th ><b>Event City:</b></th>
<th><b>Content:</b></th>
<th><b>Images:</b></th>
<th><b>Event Date:</b></th>";*/

//while($row=mysqli_fetch_array($result))
$row=mysqli_fetch_array($result);
for($i=0;$i<5;$i++)
{
$Title=$row['Title'];
$City=$row['City'];
$Content=$row['Content'];
//$Photo=$row['Photo'];
$Date=$row['Date'];
$EventId=$row['EventId'];
$Photo=$row['Photo'];
//echo $Photo;

echo "<tr><td><img src='$Photo' width='120' height='90'/></td><td>$City</td><td>,</td><td>$Date</td><td>:</td><td>$Title</td></tr>
<tr><td>$Content</td></tr>
<tr><td><a href='#'>Know more</a></td><td>/</td><td><a href='#'>Click here to participate</a></td></tr>"; 
}
//echo "<tr><td><input type='submit' name='submit' value='Participate'</td>";
if(isset($_COOKIE['LoginIdCookie']))
{
echo "<td><a href='log_out.php'>Log out</a></td>";
echo "<td><a href='EditActivity.php'>Edit Your Activities</a></td></tr>";
}
echo "</table></form></body></html>";
require_once('lower.php');
?>






Quote

Hi friends ..........
I write above code to display top 5 rows from the database but it not works properly. It displays first row 5 times which is undesireable.
Anyone please help?????????????????
thanks in advance..................

Hi,

I'm using a form which contains many select boxes.
The select boxes looks like this:

            <select name="locatie" id="locatie">
                <option value="" selected>-----</option>
                <?php
                    require_once ('config.php');
                    $query = "select ID, locatie from locatie";
                    $result = mysql_query ($query);
                    while($row = mysql_fetch_array($result)){
                        extract($row);
                        echo '<option value="'.$ID.'">'.$locatie.'</option>';
                    }
                ?>
            </select>

            <select name="prijsVan" id="prijsVan">
                <option value="" selected>-----</option>
                <?php
                    $query = "select ID, prijs from prijs";
                    $result = mysql_query ($query);
                    while($row = mysql_fetch_array($result)){
                        extract($row);
                        echo '<option value="'.$ID.'">&euro; '.$prijs.'</option>';
                    }
                ?>
            </select>

           <select name="prijsTot" id="prijsTot">
             <option value="" selected>-----</option>
         <?php
                            $query = "select ID, prijs from prijs";
                            $result = mysql_query ($query);
             while($row = mysql_fetch_array($result)){
              extract($row);
              echo '<option value="'.$ID.'">&euro; '.$prijs.'</option>';
              }
                         ?>
        </select>

           <select name="ligging" id="ligging">
                <option value="" selected>-----</option>
      <?php
         $query = "select ID, ligging from ligging";
                        $result = mysql_query ($query);
                        while($row = mysql_fetch_array($result)){
              extract($row);
                             echo '<option value="'.$ID.'">'.$ligging.'</option>';
                        }
       ?>
       </select>

           <select name="oppervlakte" id="oppervlakte">
                <option value="" selected>-----</option>
      <?php
         $query = "select ID, oppervlakte from oppervlakte";
                        $result = mysql_query ($query);
                        while($row = mysql_fetch_array($result)){
              extract($row);
                             echo '<option value="'.$ID.'">'.$oppervlakte.' m&#178;</option>';
                         }
       ?>
      </select>

           <select name="kamers" id="kamers">
                <option value="" selected>-----</option>
                <?php
                    $query = "select ID, kamers from kamers";
                    $result = mysql_query ($query);
                    while($row = mysql_fetch_array($result)){
                        extract($row);
                        echo '<option value="'.$ID.'">'.$kamers.'</option>';
                    }
                 ?>
      </select>

           <select name="woning" id="woning">
                <option value="" selected>-----</option>
                <?php
                    $query = "select ID, type from woning";
                    $result = mysql_query ($query);
                    while($row = mysql_fetch_array($result)){
                        extract($row);
                        echo '<option value="'.$ID.'">'.$type.'</option>';
                    }
                ?>
      </select>

<input type="submit" name="submit" value="Zoeken">

To display the result i'm using a PHP processing page which contains the flowing code:


<?php
......
.....

$locatie = $_POST['locatie'];
$prijsVan = $_POST['prijsVan'];
$prijsTot = $_POST['prijsTot'];
$ligging = $_POST['ligging'];
$oppervlakte = $_POST['oppervlakte'];
$kamers = $_POST['kamers'];
$woning = $_POST['woning'];
$eigenschappen = $_POST['eigenschappen'];

// SHOW LOCATIE
if($locatie !='' && $prijsVan =='' && $prijsTot =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $woning =='' && $eigenschappen =='') {
   $query .= " AND locatie.ID = '" . $locatie. "' ORDER BY prijs.ID";   
}

// SHOW LOCATIE_PRIJSVAN
if($prijsVan !='' && $locatie !='' && $prijsTot =='' && $woning =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $eigenschappen =='') {
   $query .= " AND locatie.ID = '" . $locatie . "' AND prijs.ID >= '" . $prijsVan . "' ORDER BY prijs.ID";
}

// SHOW LOCATIE_PRIJSTOT
if($prijsTot !='' && $locatie !='' && $prijsVan =='' && $woning =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $eigenschappen =='') {
   $query .= " AND locatie.ID = '" . $locatie . "' AND prijs.ID <= '" . $prijsTot . "' ORDER BY prijs.ID";
}

// SHOW PRIJS VAN
if($prijsVan !='' && $locatie =='' && $prijsTot =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $woning =='' && $eigenschappen =='') {
   $query .= " AND prijs.ID >= '" . $prijsVan . "' ORDER BY prijs.ID";
}

// SHOW PRIJS TOT
if($prijsTot !='' && $locatie =='' && $prijsVan =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $woning =='' && $eigenschappen =='') {
   $query .= " AND prijs.ID <= '" . $prijsTot . "' ORDER BY prijs.ID";
}

// SHOW PRIJS_VAN_PRIJS_TOT
if($prijsVan !='' && $prijsTot !='' && $locatie =='' && $woning =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $eigenschappen =='') {
   $query .= " AND prijs.ID BETWEEN '" . $prijsVan . "' AND '" . $prijsTot . "' ORDER BY prijs.ID";
}
 
// SHOW LIGGING
if($ligging !='' && $prijsVan =='' && $prijsTot =='' && $locatie =='' && $oppervlakte =='' && $kamers =='' && $woning =='' && $eigenschappen =='') {
   $query .= " AND ligging.ID = '" . $ligging. "' ORDER BY prijs.ID";   
}

...................... and so on.........


// Error: indien geen keuze gemaakt show deze error
if($prijsVan =='' && $prijsTot =='' && $locatie =='' && $woning =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $eigenschappen =='') {
   ?> <center><font color="#666"> <?php postError(); ?></font></center><?php
}
else{
//Execute query
   $result = mysql_query($query) or die(mysql_error());
         
         while($row = mysql_fetch_array($result)){
           
         echo  $row['image_id'] ;
         echo  $row['locatie'] ;
         echo  $row['prijs'];
         echo  $row['type'];
         echo  $row['kamers'];
         echo  $row['oppervlakte'] . ' m&#178;';
         echo  $row['ligging'];
         echo  $row['eigenschappen'];
      }
}

mysql_close($con);

?>


As you see i have to use many IF condition to display the result of every select combinations.

Is there any way to do it in better way and using less coding?

Thanks.

I can't seem to get the math right!

I have a function, pulling 13 states (canadian provinces) from the database and I can't seem to get them all to show in 5 columns. Where am I doing this wrong. The code below only shows 7 of 13... I just can't seem to get where I am off!

PHP CODE:
function map_showCA()
{
global $db, $tpl;

// ShowLocalResources

$sSQL = "SELECT * FROM states_canada ORDER BY state;";
$db->query($sSQL);
$next_record = $db->next_record();

while ($next_record)
{
$state_id = $db->f("id");
$state = $db->f("state");
$statename = $db->f("statename");
$statename_html = $db->f("statename_html");

$next_record = $db->next_record();
if (!USE_SEO_LINKS) { $statename_html = $state_id; }
$vendors_states[] = array("name" => $statename, "id" => $state_id, "state_html" => $statename_html);
}

$vendors_states_col = array_chunk($vendors_states, 5, true);

$loop = (int)(count($vendors_states) / 5);
if(count($vendors_states) % 5 > 0) $loop++;

$j = 0;

for($i = 0; $i < $loop; $i++)
{
$parameters = 'http://'.$vendors_states_col[0][$j]["state_html"].'.ilocalize.com';
// $first_column_link = generate_vendor_seo_url($parameters);
$tpl->set_var("first_column_link", $parameters);
$tpl->set_var("first_column", tohtml($vendors_states_col[0][$j]["name"]));

$parameters = 'http://'.$vendors_states_col[1][$j+6]["state_html"].'.ilocalize.com';
// $second_column_link = generate_vendor_seo_url($parameters);
$tpl->set_var("second_column_link", $parameters);
$tpl->set_var("second_column", tohtml($vendors_states_col[1][$j+6]["name"]));

$parameters = 'http://'.$vendors_states_col[2][$j+12]["state_html"].'.ilocalize.com';
// $threeth_column_link = generate_vendor_seo_url($parameters);
$tpl->set_var("threeth_column_link", $parameters);
$tpl->set_var("threeth_column", tohtml($vendors_states_col[2][$j+12]["name"]));

$parameters = 'http://'.$vendors_states_col[3][$j+18]["state_html"].'.ilocalize.com';
// $fourth_column_link = generate_vendor_seo_url($parameters);
$tpl->set_var("fourth_column_link", $parameters);
$tpl->set_var("fourth_column", tohtml($vendors_states_col[3][$j+18]["name"]));

$parameters = 'http://'.$vendors_states_col[4][$j+24]["state_html"].'.ilocalize.com';
// $fifth_column_link = generate_vendor_seo_url($parameters);
$tpl->set_var("fifth_column_link", $parameters);
$tpl->set_var("fifth_column", tohtml($vendors_states_col[4][$j+24]["name"]));

$tpl->parse("ShowLocalResourcesCA", true);
$j++;
}
}

HTML CODE:
Code: [Select]
<table border="0" cellpadding="1" cellspacing="1"  class="description_text2"  style="padding-bottom:6px;" width="100%" id="dashed_box_gray">
             <!--BeginShowLocalResourcesCA-->
                <tr>
                    <td width="110" align="left" style="padding-left:6px; padding:6px;"><a href="{first_column_link}" class="user_blue_14px">{first_column}</a></td>
                    <td width="109" align="left" style="padding-right:6px; padding:6px;"><a href="{second_column_link}" class="user_blue_14px">{second_column}</a></td>
                    <td width="109" align="left" style="padding-right:6px; padding:6px;"><a href="{threeth_column_link}" class="user_blue_14px">{threeth_column}</a></td>
                    <td width="109" align="left" style="padding-right:6px; padding:6px;"><a href="{fourth_column_link}" class="user_blue_14px">{fourth_column}</a></td>
                    <td width="108" align="left" style="padding-right:6px; padding:6px;"><a href="{fifth_column_link}" class="user_blue_14px">{fifth_column}</a></td>
                </tr>
                <!--EndShowLocalResourcesCA-->
                </table>