While and if

ryclem

I am having a problem displaying the results of a query...I think that I need to have a while loop but with if and else conditions below it, but can't seem to get it right....

I am trying to print an event discription directly on a calendar if their is one available in mysql (if $cal_date=$row[date])
else just print the numeric date...here is the section of code that does not work...I'm a newbie so please help...//checks for event

$cal_date = ($y."-".$m."-".$d);
while ($row = mysql_fetch_array($result)){
if ($cal_date=$ROW[date])
{print "<td class='tcell' bgcolor=#CCCCCC valign=\"top\" height=\"100\">$d ($row[description])
</td>";
}

	else {print "<td class='tcell' bgcolor=#CCCCCC valign=\"top\" height=\"100\">$d<br>$numrows<br>yuck<br>$description<br>$numrows 
	</td>"; 
	} 
}

PS...I keep getting the following error: Warning: Supplied argument is not a valid MySQL result resource

cordex

One problem:
if ($cal_date=$ROW[date])

see http://www.hvt-automation.nl/yapf/faq.php?cmd=viewitem&itemid=95

It should be:
if ($cal_date==$row[date])

But another problem seems to be with your MySQL query. could you post the query string and such?

ryclem

please disregard some of the text in the else print statement...just test stuff...thanks

ryclem

Sure...here is the query

$query = "SELECT * FROM $TableName2 where class_id = $class_id";
$result = mysql_query($query, $Link);
$numrows = mysql_num_rows($result);

Thanks...

cordex

hmmm ...
only other thing I can suggest:

$query = "SELECT * FROM $TableName2 where class_id = '$class_id'"; // place single quotes around values.

ryclem

Does the syntax of the while and if look right?

while ($row = mysql_fetch_array($result)){
if ($cal_date==$row[date])
{print "<td class='tcell' bgcolor=#CCCCCC valign=\"top\" height=\"100\">$d ($row[description])
</td>";
}

	else {print "<td class='tcell' bgcolor=#CCCCCC valign=\"top\" height=\"100\">$d</td>"; 
	} 
}

[deleted]

Look fine, just two things:

if ($cal_date==$row[date])

in this case the 'date' in $row[date] is a string, so it must be quoted, otherwise PHP will thing it is a constant:

if ($cal_date==$row['date'])

and you put:
 ($row[description]) </td>

again, description should be quoted, but more importantly the $row[description] should not be inside the string. It is better to place it outside the string an concatenate it:

".($row['description'].") </td>

And a sidenote: try to keep your code readable, always move to a new line after opening or closing a { or } tag:

while ($row = mysql_fetch_array($result))
{ 
  if ($cal_date==$row['date']) 
  {
    print "<td class='tcell' bgcolor=#CCCCCC valign=\"top\" height=\"100\">".$d." (".$row['description'].") </td>"; 
  } 
  else
  {
    print "<td class='tcell' bgcolor=#CCCCCC valign=\"top\" height=\"100\">".$d."</td>"; 
  } 
}

ryclem

Thanks...the learning curve can be painful sometimes....I appreciate everyone's help...