having a problem seeing the data i am trying to pull out of the database

rhemler · March 26, 2006

Here is the source page minus the database login settings
and here is the live page as it is now
[a href=\"http://www.unitedbaseball.org/FAN.php\" target=\"_blank\"]PHP Page[/a]

<html>
<head> <title> FAN Interst</title></head>
<body>

<?php

$user="";
$host="localhost";
$password="";
$database = "";
$connection = mysql_connect($host,$user,$password)
or die ("couldn't connect to server");
$db = mysql_select_db($database,$connection)
or die ("Couldn't select database");

$query = "SELECT th.TEAM_ID, th.CHANGE_DATE, th.CHANGE_TYPE, th.OLD_VALUE, th.NEW_VALUE, t.CITY, t.NAME as teamname FROM bosi_TEAM_HISTORY th, bosi_TEAM t WHERE t.TEAM_ID = th.TEAM_ID ORDER BY TEAM_ID";

$results = mysql_query ($query) ;
?>

<table width='75%' border='0' align='center'>
<tr><td width='5%' bgcolor='#B7B78B' align='center'>Team</td>
<td width='15%' bgcolor='#B7B78B' align='center'>Old Value</td>
<td width='15%' bgcolor='#B7B78B' align='center'>New Value</td>
<td width='15%' bgcolor='#B7B78B' align='center'>Change</td>
</tr>

<?
while ( $row = mysql_fetch_array($results))
{

if($row[OLD_VALUE] < $row[NEW_VALUE])
{
$talentmod= "greenarrow.gif";
}
else
{
$talentmod= "redarrow.gif";
}
}
?>

<tr>
<td width='50%' align='center' bgcolor='#D8D8C4'><a target="BLANK" href="/ootp/team<? echo $row[TEAM_ID]; ?>.html"><? echo $row[teamname]; ?></td>
<td width='15%' align='center' bgcolor='#D8D8C4'><? echo $row[OLD_VALUE]; ?></td>
<td width='15%' align='center' bgcolor='#D8D8C4'><? echo $row[NEW_VALUE]; ?></td>
<td width='20%' align='center' bgcolor='#D8D8C4'><img src="devreports/images/<? echo $talentmod; ?>"</img></td>

</tr>
</table>

</tr>
</table>

redarrow · March 26, 2006

Look at your while loop agin ok.

if you can see team id now wonder why ,

while loop

[code]
<?php

$user="";
$host="localhost";
$password="";
$database = "";
$connection = mysql_connect($host,$user,$password)
or die ("couldn't connect to server");
$db = mysql_select_db($database,$connection)
or die ("Couldn't select database");

$query = "SELECT th.TEAM_ID, th.CHANGE_DATE, th.CHANGE_TYPE, th.OLD_VALUE, th.NEW_VALUE, t.CITY, t.NAME as teamname FROM bosi_TEAM_HISTORY th, bosi_TEAM t WHERE t.TEAM_ID = th.TEAM_ID ORDER BY TEAM_ID";

$results = mysql_query ($query);

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

if($row[OLD_VALUE] < $row[NEW_VALUE])
{
$talentmod= "greenarrow.gif";
}
else
{
$talentmod= "redarrow.gif";
}

echo $row[TEAM_ID];
}
?>
[/code]

Sign In

having a problem seeing the data i am trying to pull out of the database

Recommended Posts

rhemler

Link to comment

Share on other sites

redarrow

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information