Displaying results problem

timmybuck

Hi Guys,

The good news is i can display the results the bad news is i get all lots of crap around the data. E.g Array ( [0] => 4 [EventID] => 4 [1] => 3 [categoryID] => 3 [2] => educational [Eventtype] => educational [ etc.

the code that displays my data look like this

<?php
$categoryID=$_POST['categoryID'];

mysql_connect("localhost","phpuser","phpuser03") or die ("Database connection error");

mysql_select_db('booking');

$sql = "SELECT * FROM event WHERE categoryID='$categoryID'";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
print_r($row);

}

?>
</body>
</html>

I have tried replacing print_r($row); with

echo "$row['EventID'], $row['categoryID']<br>\n";

but then i get the error

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\Program Files\Apache Group\Apache2\htdocs\m82\resultstest.php on line 17

Any ideas guys, i cant fix it for the life of me.

mikeatrpi

This should work:

echo $row['EventID'] . ',' . $row['categoryID'] . "<br>\n";

timmybuck

Dude you are a genius.

Thank u kindly sir

timmybuck

If I wanted to display the column names so the data is more meaningful is that where i need to think about displaying it in a html table or is there some php that can help me do that

timmybuck

Hi Guys,

I im trying to display the data in a html table. below is my code. It seems to display the data and then the column names and they dont look like they are in a table. Any ideas how to fix this one guys

$sql = "SELECT * FROM event WHERE categoryID='$categoryID'";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {

echo $row['EventName'] . ',' . $row['Date'] . ',' . $row['Venue'] . "<br>\n";

echo "<table>\n";
echo " <tr>\n";
echo " <th><b>Event Name</b></th>\n";
echo " <th><b>Date</b></th>\n";
echo " <th><b>Venue</b></th>\n";
echo " </tr>\n";
while ($row = mysql_fetch_assoc($result)) {
echo ' <tr>'."\n";
echo ' <td>'.$row['Event'].'</td>'."\n";
echo ' <td>'.$row['Date'].'</td>'."\n";
echo ' <td>'.$row['Venue'].'</td>'."\n";
echo ' </tr>'."\n";
}
echo '</table>';

}

mikeatrpi

It is easiest, usually, to just make a table with HTML. But... if for instance you didn't know the schema of the table you were querying you could find the attribute names with mysql_field_name().

mikeatrpi

$sql = "SELECT * FROM `event` WHERE categoryID='$categoryID'"; 
$result = mysql_query($sql); 

echo "<table>\n"; 
echo " <tr>\n"; 
echo " <th><b>Event Name</b></th>\n"; 
echo " <th><b>Date</b></th>\n"; 
echo " <th><b>Venue</b></th>\n"; 
echo " </tr>\n"; 

while ($row = mysql_fetch_array($result)) { 
echo ' <tr>'."\n"; 
echo ' <td>'.$row['EventName'].'</td>'."\n"; 
echo ' <td>'.$row['Date'].'</td>'."\n"; 
echo ' <td>'.$row['Venue'].'</td>'."\n"; 
echo ' </tr>'."\n"; 
} 

echo '</table>';

timmybuck

I do know the database schema, I created it. Am i off the mark with my code that creates a html table so that the results generated from the database are put in to the html table.

I would like it so that i could have alternate coloured rows.

I will look in to mysql_field_name

Cheers

mikeatrpi

Alternate colored rows:

$color[0] = "red";
$color[1] = "green";

...

while() {

$a = ($a+1)%2;
echo '<tr bgcolor='.$color[$a] . '>';

}

timmybuck

Sorry to be such a dumbass you prolly already guessed that im a newbie, but with regard to your code for colors are u suggesting that i use that the code i alrady have to generate a html table or with the mysql_field_name stuff

mikeatrpi

No you don't need the mysql_field_name function since you know the database schema.

I posted you some code that would probably do that you wanted. Combine in the color code- I tried to make it self-explanatory- and it should work as you intend.

If you can't get it, post back.

timmybuck

Hi I have tried putting the code you gave me in what i think was the right place eg by putting the table code where you have put the dots in the color code, but it didnt work.

i would just like it so that as the data comes out of the table it get puts in a html table with a heading above of each record in a nicely formated way. So its easy for people to read.

this is the code at the momment

<?php
$categoryID=$_POST['categoryID'];

mysql_connect("localhost","phpuser","phpuser03") or die ("Database connection error");

mysql_select_db('booking');

$sql = "SELECT * FROM event WHERE categoryID='$categoryID'";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo $row['EventName'] . ',' . $row['Date'] . ',' . $row['Venue'] . "<br>\n";

$color[0] = "red";
$color[1] = "green";
while() {

$a = ($a+1)%2;
echo '<tr bgcolor='.$color[$a] . '>';

}

echo "<table>\n";
echo " <tr>\n";
echo " <th><b>Event Name</b></th>\n";
echo " <th><b>Date</b></th>\n";
echo " <th><b>Venue</b></th>\n";
echo " </tr>\n";
while ($row = mysql_fetch_assoc($result)) {
echo ' <tr>'."\n";
echo ' <td>'.$row['EventName'].'</td>'."\n";
echo ' <td>'.$row['Date'].'</td>'."\n";
echo ' <td>'.$row['Venue'].'</td>'."\n";
echo ' </tr>'."\n";
}
echo '</table>';
}

mikeatrpi

Try this:


<?php 

$categoryID=$_POST['categoryID']; 
$color[0] = "red"; 
$color[1] = "green"; 

mysql_connect("localhost","phpuser","phpuser03") or die ("Database connection error"); 
mysql_select_db('booking'); 

$sql = "SELECT * FROM `event` WHERE categoryID='$categoryID'"; 
$result = mysql_query($sql); 

echo "<table>\n"; 
echo " <tr>\n"; 
echo " <th><b>Event Name</b></th>\n"; 
echo " <th><b>Date</b></th>\n"; 
echo " <th><b>Venue</b></th>\n"; 
echo " </tr>\n"; 

while ($row = mysql_fetch_array($result)) { 
$a = ($a+1)%2; 
echo '<tr bgcolor='.$color[$a] . ">\n"; 
echo ' <td>'.$row['EventName'].'</td>'."\n"; 
echo ' <td>'.$row['Date'].'</td>'."\n"; 
echo ' <td>'.$row['Venue'].'</td>'."\n"; 
echo ' </tr>'."\n"; 
} 

echo '</table>'; 

?>

Carefully examine the code I have given you. Notice how the opening table tag is outside of your WHILE loop, and the close table tag comes after the loop. Inside the loop, the code generates rows with alternating colors. Each row contains three columns with your data from the database.

Are you familiar with the modulo (%) operator? It returns the remainder of a mathematical division. 1 MOD 2 = 1. 2 MOD 2 = 0. This is how the program alternates colors.

Hope that helps!

timmybuck

You really are good.

The data looks presented better.
This is what it looks like

Event Name Date Venue
BETT 9/05/04 NEC

Do u think it would be possible to say for example to make the results that come out of the database a hyperlink eg if bett was made in to a hyperlink as it come sout of the database

mikeatrpi

Yes, it is possible. That is how these very forums work. You have to change some of your code inside the loop. 😉

timmybuck

Hi, i think i have worked out how to get an hyperlink

echo '<td><a href="' . $row['EventName'] . '">' . $row['EventName'] . '</a></td>\n';

well i did this

;-)

however i get a " /n " that on my page but i cant where its coming from

here is my code

<?php
$categoryID=$_POST['categoryID'];
$color[0] = "red";

$color[1] = "green";

mysql_connect("localhost","phpuser","phpuser03") or die ("Database connection error");

mysql_select_db('booking');

$sql = "SELECT * FROM event WHERE categoryID='$categoryID'";
$result = mysql_query($sql);
#while ($row = mysql_fetch_array($result)) {
#echo $row['EventName'] . ',' . $row['Date'] . ',' . $row['Venue'] . "<br>\n";
echo "<table>\n";

echo " <tr>\n";

echo " <th><b>Event Name</b></th>\n";

echo " <th><b>Date</b></th>\n";

echo " <th><b>Venue</b></th>\n";

echo " </tr>\n";

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

$a = ($a+1)%2;

echo '<tr bgcolor='.$color[$a] . ">\n";

#echo ' <td>'.$row['EventName'].'</td>'."\n";
echo '<td><a href="' . $row['EventName'] . '">' . $row['EventName'] . '</a></td>\n';

echo ' <td>'.$row['Date'].'</td>'."\n";

echo ' <td>'.$row['Venue'].'</td>'."\n";

echo ' </tr>'."\n";

}

echo '</table>';

mikeatrpi

echo '<td><a href="' . $row['EventName'] . '">' . $row['EventName'] . "</a></td>\n";

The difference lies in your quoting. Anything in single quotes (') is not parsed by PHP. Anything in double quotes (") is parsed by the PHP engine. \n is a newline, and needs double quotes.