How to display info horizonatally

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Patsman77
Forum Newbie
Posts: 18
Joined: Thu Jun 04, 2009 10:09 am

How to display info horizonatally

Post by Patsman77 »

Hello All,

I was wondering if someone could guide me a little. I have this code I am working on, but it displays 1 line at a time. Basically what I want is to break it up so that it dispalys across instead of down, but it sections. Each section will be VISITOR (w/logo) then line 2 SPREAD, then line 3 HOME (w/logo)

Section 1 ; section 2; section 3; ......etc

not
visitor (w/logo)
spread
Home (w/logo)
visitor (w/logo)
spread
Home (w/logo)
visitor (w/logo)
spread
Home (w/logo) ... etc

Here is the code I am working with:

Code: Select all

  

<?
   $sql = "SELECT * FROM ".$football->prefix."picks, ".$football->prefix."schedule, ".$football->prefix."teams WHERE USER = '".$user."' AND week = '".$week."' AND ".$football->prefix."picks.gameid = ".$football->prefix."schedule.gameid AND ".$football->prefix."picks.pick = ".$football->prefix."teams.id ORDER BY ".$football->prefix."schedule.gametime, ".$football->prefix."schedule.gameid";

   $result = $football->dbQuery($sql);
   $nRows = mysql_num_rows($result);
   $upicks = "";

   for ($i=0; $i< $nRows; $i++){

            $row = mysql_fetch_array($result);
            $pickcity = $row['city'];
            $pickname = $row['name'];
            $gameid = $row['gameid'];
            $pick = $row['pick'];
            
             $sql="select ".$football->prefix."schedule.*, ".$football->prefix."teams.city as VCity, ".$football->prefix."teams.name as VName, ".$football->prefix."teams.display as VDisplayName, ".$football->prefix."teams.icon as Vicon, teams2.city as HCity, teams2.name as HName, teams2.display as HDisplayName, teams2.icon as Hicon from (".$football->prefix."schedule inner join ".$football->prefix."teams on ".$football->prefix."schedule.vid = ".$football->prefix."teams.id) inner join ".$football->prefix."teams as teams2 on ".$football->prefix."schedule.hid = teams2.id where ".$football->prefix."schedule.gameid = '".$gameid."'";

   $pickresult = $football->dbQuery($sql);
   $prow = mysql_fetch_array($pickresult);
   $game = "";
   $vid = $prow['vid'];
   $vcity = $prow['VCity'];
   $vname = $prow['VName'];
   $vicon = $prow['Vicon'];
   $hid = $prow['hid'];
   $hcity = $prow['HCity'];
   $hname = $prow['HName'];
   $hicon = $prow['Hicon'];
   $gametime = $prow['gametime'];
   $date = date("m/d/Y",$gametime);
   $time = date("H:i:s A",$gametime);
   $ts = $football->doDate($date,$time,$football->display_offset);
   $day = date("D",$ts);
   $month = date("M d",$ts);
   $time = date("g:i a",$ts);

   

   if ($vid == $pick) {
    $visitor = "<b><u>";
    $visitor .= $vid;
    
    $visitor .= "</b></u>";
    }
    else {
    $visitor = $vid;
    
    }

   echo "$visitor";
   
  
   echo "<img src = \"".$football->copyrightweb."/images/$vicon\" width=".$football->logo_width.">\n";

   if ($hid == $pick) {
    $home = "<b><u>";
    $home .= $hid;
    $home .= "</b></u>";
    }
    else {
    $home = $hid;
    
    }

  echo "<br>at<br>  $home";
  
  
  echo "<img src = \"".$football->copyrightweb."/images/$hicon\" width=".$football->logo_width.">";
  echo "</tr>\n";
}

  echo "</table>\n";
  echo "<br><br><br><b>TB: ".$tb."</b>\n";
  echo "<br><br>\n";
            
         

?>  
Any help would be appreciated.

Thanks,

Patsman77
Patsman77
Forum Newbie
Posts: 18
Joined: Thu Jun 04, 2009 10:09 am

Re: How to display info horizonatally

Post by Patsman77 »

Can anyone suggest how to get the display to go side by side for each "section" instead of verticalled?
User avatar
AbraCadaver
DevNet Master
Posts: 2572
Joined: Mon Feb 24, 2003 10:12 am
Location: The Republic of Texas
Contact:

Re: How to display info horizonatally

Post by AbraCadaver »

You need to use table cells. I don't see anywhere in your code where you have started a table, a row or a cell.
mysql_function(): WARNING: This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQLextension should be used. See also MySQL: choosing an API guide and related FAQ for more information.
Patsman77
Forum Newbie
Posts: 18
Joined: Thu Jun 04, 2009 10:09 am

Re: How to display info horizonatally

Post by Patsman77 »

I have tried this:

Code: Select all

 if ($vid == $pick) {
    $visitor = "<b><u>";
    $visitor .= $vid;
    
    $visitor .= "</b></u>";
    }
    else {
    $visitor = $vid;
    
    }

   echo "<table><tr><td>$visitor";
   
  
   echo "<img src = \"".$football->copyrightweb."/images/$vicon\" width=".$football->logo_width.">\n";

   if ($hid == $pick) {
    $home = "<b><u>";
    $home .= $hid;
    $home .= "</b></u>";
    }
    else {
    $home = $hid;
    
    }

  echo "<br>at<br>  $home";
  
  
  echo "<img src = \"".$football->copyrightweb."/images/$hicon\" width=".$football->logo_width.">";
  echo "</tr>\n";
}

  echo "</td></tr></table>\n";
Still get same results.
Patsman77
Forum Newbie
Posts: 18
Joined: Thu Jun 04, 2009 10:09 am

Re: How to display info horizonatally

Post by Patsman77 »

Resolved:

{
$item = "<td>";

if ($vid == $pick){
$item .= "<b><font color=#FF0000>$vid</font></b>";
}
else
{
$item .= "<font color=#000000>$vid</font>";
}



$item .= "<br>";
if ($hid == $pick){
$item .= "<b><font color=#FF0000>$hid</font></b>";
}
else
{ $item .= "<font color=#000000>$hid</font>";
}
$item .= "</td>";
}
echo $item;
}
Post Reply