Hi there,
Back again with a problem... hmmm,let me think how I can describe this easiest...
OK. I have two tables in a database. Each table has a date field.
On my webpage, I print the first date in a while loop, to form a table that begins with the date in the first <TD>.
Then what I want is that these printed dates are being compared to the dates in the second table. And when the dates are the exact same, I want an icon to be displayed in front of the date in the <TD>.
The while loop looks like this now:
$result = mysql_query('SELECT datum, DATE_FORMAT(datum,"%w"), COUNT(*) FROM demo GROUP BY datum ORDER BY datum');
while (($row = mysql_fetch_row($result)) AND ($result > 0))
echo"<TR BGCOLOR=#FCE1A9 height=15>";
echo"<TD VALIGN=middle ALIGN=left> $row[0]</FONT><BR></TD>";
echo "</TR>";
The second query I am going to use is:
$resulticon = mysql_query("select datum,count(*) from mailings group by datum order by datum");
while (($rowicon = mysql_fetch_row($resulticon)) AND ($resulticon > 0))
Now how is it possible to get an icon in front of $row[0] when $row[0] is the same as $rowicon[0] ??
Cheers,
Joyce
