if's and else's help?

danielhalawi

Hi,

I have a calendar up and running, I'm wanting to change the css style used depending on whether an event is full.

Now I've got it working....

$event_size = mysql_query ("select size from calendar_mssgs where id=".$eventdata[$day]["id"][$j]);
$number = count("select staffid from courses_attendance where courseid=".$eventdata[$day]["id"][$j]);

and have my if's and else further down the code

if ($number < $event_size) 
				    $str .=  "title_txt"; 
				else 
				    $str .= "title_txt2";
					$str .= "\">";
					$str .= "<a href=\"javascript:openPosting(" . $eventdata[$day]["id"][$j] . ")\">";

This seems to work, but its working randomly, and not specific to the courseid its picking up? Any help would be a wonder.

Thanks in advance.

leatherback

hi,

you use event_size, which will be a resource_id, instead of the size. You need to retrieve the value of size from your results array after the first quey

danielhalawi

I've done this

 $number = count("select staffid from courses_attendance where courseid=".$eventdata[$day]["id"][$j]);
$event_size = mysql_query ("select * from calendar_mssgs where id=".$eventdata[$day]["id"][$j]);
while ($row2 = mysql_fetch_array ($event_size)) {
$events2 = $row2["size"];}

but it won't work at all now?
What have I done wrong???

leatherback

Hi,

could you please paste the whole relevant script. It is hard to see what is going on.
But to get you started:
- have you checked there actualy are valid records? Have you echoed out the results & the queries? Try parsing the queries directly to the msql engine, which wil tell you where things start to fail.

danielhalawi

Managed to get my problem sorted....

// find out the size of the course and attendance
$number = mysql_query("select staffid from courses_attendance where courseid=" . $eventdata[$day]["id"][$j]);
$num_rows = mysql_num_rows($number);
$event_size = mysql_query("select size from calendar_mssgs where id=" . $eventdata[$day]["id"][$j]);
while ($row2 = mysql_fetch_array ($event_size)){
$events2 = $row2["size"];}

I post so that other users who encounter the same problem may be able to use this....