controling hyperlinks in php

timmybuck

Hi GUYS,

i have an event table that has an expired column..

At the momment i can display a list of events in a html table. In the first column the event name is a hyperlink to another page that has details on that event. Every event name appears as a hyperlink.

I am trying to get it so that events that have either expired or been fully booked do not appear as an hyperlink.

I have Expired, total_Seats, booked_Seats columns in the event table.

This is the code that displays all the event names as hyerplinks so far

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

$sql1 = "select Total_Seats, Booked_Seats FROM event where EventID =".$row[EventID]."";
$result1 = mysql_query($sql1);

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

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

#echo ' <td>'.$row['EventName'].'</td>'."\n";
echo '<td><a href="tester(1).php?EventName=' . $row['EventName'] .
'">' . $row['EventName'] .'</a></td>';
echo ' <td>'.$row['Date'].'</td>'."\n";

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

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

trex005

Assuming that Expired is 1 or 0 (true or false)

while ($row = mysql_fetch_array($result)) {
$sql1 = "select Total_Seats, Booked_Seats FROM event where EventID =".$row[EventID]."";
$result1 = mysql_query($sql1);

$a = ($a+1)%2;
echo '<tr bgcolor='.$color[$a] . ">\n";
#echo ' <td>'.$row['EventName'].'</td>'."\n";
if($row['Expired'])
{
echo "<td>",$row['EventName'],"</td>";
}
else
{
echo '<td><a href="tester(1).php?EventName=' . $row['EventName'] .
'">' . $row['EventName'] .'</a></td>';
}
echo ' <td>'.$row['Date'].'</td>'."\n";
echo ' <td>'.$row['Venue'].'</td>'."\n";
echo ' <td>'.$row['Town'].'</td>'."\n";

hope that helps

tuf-web_co_uk

hi,

for this problem all you need to do is change this

<?
echo '<td><a href="tester(1).php?EventName=' . $row['EventName'] . 
'">' . $row['EventName'] .'</a></td>'; 
?>

note that i have used Expired from your table so you will also want to change your sql code, so this should be your final code

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

$sql1 = "select * FROM `event` where `EventID` =".$row[EventID]."";  

$result1 = mysql_query($sql1);  

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

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

#echo ' <td>'.$row['EventName'].'</td>'."\n"; 
if ($row['expired'] == 'TRUE' || $row['total_seats'] == $row['booked_seats']) { // assuming `expired` is a boolean 
    echo '<td>'.$row['EventName'].'</td>'; 
} 
else { 
    echo '<td><a href="tester(1).php?EventName=' . $row['EventName'] .'">' . $row['EventName'] .'</a></td>';  

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

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

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

hope this helps!

Comms

tuf-web_co_uk

trex sorry to be picky but you forgot to select the expired column from the table 😉

timmybuck

hey thanks a lot tuf-web.co.uk that works a treat.

Im just wondering if it would be better to have the expired field as a date, so that maybe the query could be something like if expired date is equal or less then current
date.

that way i guess the admin would not have to set the boolean everytime an event expired.

can anyone see any problems with my logic

tuf-web_co_uk

i dont see any problems with it, it is a good idea to make things easier, and this way mistakes are less likely to happen

timmybuck

Hi thanks

So its just as well really becuase i have just found out that mysql version that im using does not support boolean

so i could have something like

if ($row['expired'] == '3/04/04' || $row['total_seats'] == $row['booked_seats'])

Also would i need to set the field type to dates or should i just use int.

Also im wondering if i can make it more specfic maybe inlcude time on a particular date

any thoughts

timmybuck

Hi guys,

Have been doing some more research and have found that if i need to use the date stored in the 'Expired' column in my database then i would need to convert it so that i could use it with php

so i think i could do something like

Select UNIX_TIMESTAMP(Expired)
From Event;

this will return the date formatted as a unix timestamp.

Now i think i need to compare this date with the current date in php so i think i need to say something like

if ($row['Expired'] == "".date("D F Y ") . ""))

Any idea's guys and gals

timmybuck

any ideas