Unable to Display data in tables

roavanet

I am very new to PHP programing. I have my database setup and working correctly in MYSQL, and I have PHP pulling the data correctly. My problem is that I am trying to get it to write the data inside of a table. Everytime that I do that, the return is blank? I have tried just about everything that I can think of. Any ideas would be appreaciated.

Thanks in advance.

autumn

can you output anything from the database?

all you have to do is create table rows in your loops.

post what you've done so far.

btw there are about a billion tutorials on this.

roavanet

Yes I can. Reference

http://www.hearsports.com/score.php

All the data returns normally, when I try to put it in a table, it is a totally blank page.

stolzyboy

post some of your code

roavanet

Here it is... This is the working part. The final product should look like:

http://www.hearsports.com/score.html

<?php
// open the connection
$conn = mysql_connect("localhost", "xxxx", "xxxxx");

// pick the database to use
mysql_select_db("LiveScore",$conn);

// create the SQL statement
$sql = "SELECT * FROM Score";

// execute the SQL statement
$result = mysql_query($sql, $conn) or die(mysql_error());

//go through each row in the result set and display data
while ($newArray = mysql_fetch_array($result)) {

// give a name to the fields
$id  = $newArray['ID'];
$Vteam = $newArray['VisitorTeam'];
$Vscore = $newArray['VisitorScore'];
$Hteam = $newArray['HomeTeam'];
$Hscore = $newArray['HomeScore'];
$Period = $newArray['Period'];

//echo the results on screen

echo "The ID is $id ";
echo "The Visitor Team is $Vteam ";
echo "The Visitor Score is $Vscore ";
echo "The HOme Team is $Hteam ";
echo "The HOme Score is $Hscore ";
echo "The Period is $Period ";

}
?>

cap97

PHP doesn't automatically generate tables. You have to build them yourself and I don't see that you did that. Try this instead:


<TABLE BORDER=1><TR>
 <TH>ID</TH>
 <TH>VTeam</TH>
 <TH>VScore</TH>
 <TH>HTeam</TH>
 <TH>HScore</TH>
 <TH>Period</TH>
</TR><TR>

<?php 
// open the connection 
$conn = mysql_connect("localhost", "xxxx", "xxxxx"); 

// pick the database to use 
mysql_select_db("LiveScore",$conn); 

// create the SQL statement 
$sql = "SELECT * FROM Score"; 

// execute the SQL statement 
$result = mysql_query($sql, $conn) or die(mysql_error()); 

//go through each row in the result set and display data 
while ($newArray = mysql_fetch_array($result)) { 

// give a name to the fields 
$id = $newArray['ID']; 
$Vteam = $newArray['VisitorTeam']; 
$Vscore = $newArray['VisitorScore']; 
$Hteam = $newArray['HomeTeam']; 
$Hscore = $newArray['HomeScore']; 
$Period = $newArray['Period']; 

//echo the results on screen 
echo "<TR>";
echo "<TD>$id</TD>"; 
echo "<TD>$Vteam </TD>"; 
echo "<TD>$Vscore</TD>"; 
echo "<TD>$Hteam</TD>"; 
echo "<TD>$Hscore</TD>"; 
echo "<TD>$Period</TD>";
echo "</TR>"; 

} 
?>

</TABLE>

Of course, I just listed all your data in a single row. You can rearrange the <TD>s and <TR>s however you want.

roavanet

Thanks... Much appreaciated... That works great.. See where I was goofing up... I was not puting the PHP code in the Table. It was outside of the table.

roavanet

One more question on this.. How can I change the default Text color to White, Or another color...

danville

Use a font color tag, , like you used the table tags when you echo the data.

roavanet

Thanks.. Think that was my last hurdle for this part of the project. Thanks for the help...🙂