PHP Table help using IF and ELSE

Mark_Nordstrom

$query_wentto = "
SELECT name, Event.date, Event.event
from Event, Attendance
WHERE name='Angor' AND Event.date > (CURDATE() - INTERVAL 2 MONTH) GROUP BY Event.event ORDER BY Event.date ASC";
$wentto = mysql_query($query_wentto, $db) or die(mysql_error());
$row_wentto = mysql_fetch_assoc($wentto);
$totalRows_wentto = mysql_num_rows($wentto);
$Eventa=$row_att['Event.event'];
$Eventb=$row_att['Attendance.event'];
?>
<style type="text/css">

</style>
<table width="75%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><span class="style2">Event</span></td>
<td><span class="style2">Date</span></td>
<td><span class="style2">Did I go</span></td>
</tr>
<?php do { ?>
<tr>
<td><span class="style2"><?php echo $row_wentto['attend']; ?></span></td>
<td><span class="style2"><?php echo date("F, jS, y", strtotime($row_wentto['Event.date'])); ?></span></td>
<td><span class="style2"><?php if ($Eventa = $Eventb) //Event nam matches
{

echo X;
}

else //Doesnt match
{

echo ;
}?></span></td>
</tr>
<?php } while ($row_wentto = mysql_fetch_assoc($wentto)); ?>
</table>

Heres my code. This doesnt work I know it shouldnt. Problem is i need it to. Is there anyway to get this to work ? I want a table that shows all events from the Event table. Then put an X in another column where the event name matches the event name from the Attendance table.

Ive tried this in database coding but cant get it to work right. IF you have any ideas id really appreciate it thanks for help.

homer09001

try replacing:

if($Eventa = $Eventb)

with:

if($Eventa == $Eventb)

Mark_Nordstrom

Thanks for help I had tons of errors in my first post here it is fixed somewhat

$query_wentto = "
SELECT name, Event.date, Event.event
from Event, Attendance
WHERE name='Angor' AND Event.date > (CURDATE() - INTERVAL 2 MONTH) GROUP BY Event.event ORDER BY Event.date ASC";
$wentto = mysql_query($query_wentto, $db) or die(mysql_error());
$row_wentto = mysql_fetch_assoc($wentto);
$totalRows_wentto = mysql_num_rows($wentto);
$Eventa=$row_wentto['Event.event'];
$Eventb=$row_wentto['Attendance.event'];
?>
<style type="text/css">

</style>
<table width="75%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><span class="style3">Event</span></td>
<td><span class="style3">Date</span></td>
<td><span class="style3">Did I go</span></td>
</tr>
<?php do { ?>
<tr>
<td><span class="style3"><?php echo $row_wentto['event']; ?></span></td>
<td><span class="style3"><?php echo date("F, jS, y", strtotime($row_wentto['Event.date'])); ?></span></td>
<td><span class="style3"><?php if ($Eventa == $Eventb) //Event nam matches
{
echo X;
}
else //Doesnt match
{
echo ;
}?></span></td>
</tr>
<?php } while ($row_wentto = mysql_fetch_assoc($wentto)); ?>
</table>

It still doesnt work how i need it to thou, Its puting an X on every row not just the ones that match.

Mark_Nordstrom

An update. Ive figured out part of the problem. The quey isnt working right. It is only getting the Event row of Events and when I add the attendance one it shows the same event over and over.

Weedpacket

The query is probably working right, but your loop is definitely wrong.

$Eventa=$row_wentto['Event.event'];
$Eventb=$row_wentto['Attendance.event'];

These are outside the loop; their values inside the loop will never change.

Incidentally, your code assumes that there will always be at least one record returned. What happens if there isn't? You'll get a line of bogus information. Consider using a while(){} loop instead of a do{}while().

And, also, that X should be in quotes and you don't really need the echo if you're not going to echo anything (but that's a parse error so I'm going to guess that this isn't quite the genuine code).

Mark_Nordstrom

There will ALWAYS be atleast 1 row as a result. I figured the vales for Eventa and b would never change. Thats why I figured it wouldnt work. Was wondering if its possible to make something that would give me the result i want.

Weedpacket

So you want an X to appear in every row if the first record returned has Eventa==Eventb?

But you are right that there is something wrong with your query after all; you never select Attendance.event.

(Suggestion: when developing, have error reporting set to E_ALL.)

Mark_Nordstrom

Weedpacket wrote:
So you want an X to appear in every row if the first record returned has Eventa==Eventb?

But you are right that there is something wrong with your query after all; you never select Attendance.event.

(Suggestion: when developing, have error reporting set to E_ALL.)

Ok. I got 2 Tables

Attendance
Event

Both tables have a column named event. I wanna match Attendance.event to Event.event and show an X for all the matching names and just show the event name for the non matching ones and it has to be WHERE name=
So Like I said if i have a event named M and it was in both tables it would be

M, X

If I had a column named T in Event but not in Attendance it wuld be

M, X
T,

Hope this clears it up. So the quey would show all rows from the Event Table and put an X if them event names match the ones in Attendance.