The script below works fine to find the new photos in the table but i cant display the total number or photos that have the eventname that the sql found, if you know a way of doing this is would be apriciated if oyu could let me know - Thanks
<?PHP
$login=\"user\";
$pass =\"pass\";
$db=mysql_pconnect(\"localhost\",$login,$pass);
mysql_select_db(\"table\",$db);
MySQL_select_db($db_name,$db);
$Now = getdate();
$sql=\"SELECT COUNT(*) AS New, EventName FROM Photos WHERE CheckNew>Now() GROUP BY EventName ORDER BY EventName ASC\";
$sql1=\"SELECT COUNT(*) AS Total, EventName FROM Photos Where CheckNew>Now() GROUP BY EventName ORDER BY EventName ASC\";
$result=MySQL_query($sql,$db) or die(\"Bad query:\".mysql_error());
$result1=MySQL_query($sql1,$db) or die(\"Bad query1:\".mysql_error());
while($myrow=MySQL_fetch_array($result) + MySQL_fetch_array($result1))
{
$EventName1=$myrow[\"EventName\"];
$New=$myrow[\"New\"];
$Total=$myrow[\"Total\"];
echo \"<TR ALIGN=\'LEFT\' VALIGN=\'TOP\'>\";
echo \"<TD><INPUT TYPE=\'TEXT\' VALUE=http://www.phpbuilder.com/board/archive/index.php/\'$EventName1\' CLASS=\'CB-T-T11W\'></INPUT></TD>\";
echo \"<TD><CENTER><INPUT TYPE=\'TEXT\' VALUE=http://www.phpbuilder.com/board/archive/index.php/\'$New\' SIZE=\'1\' CLASS=\'CB-T-T11W\'></INPUT></TD>\";
echo \"<TD><CENTER><INPUT TYPE=\'TEXT\' VALUE=http://www.phpbuilder.com/board/archive/index.php/\'$Total\' SIZE=\'1\' CLASS=\'CB-T-T11W\'></INPUT></TD></TR>\";
}
?>
<?PHP
$login=\"user\";
$pass =\"pass\";
$db=mysql_pconnect(\"localhost\",$login,$pass);
mysql_select_db(\"table\",$db);
MySQL_select_db($db_name,$db);
$Now = getdate();
$sql=\"SELECT COUNT(*) AS New, EventName FROM Photos WHERE CheckNew>Now() GROUP BY EventName ORDER BY EventName ASC\";
$sql1=\"SELECT COUNT(*) AS Total, EventName FROM Photos Where CheckNew>Now() GROUP BY EventName ORDER BY EventName ASC\";
$result=MySQL_query($sql,$db) or die(\"Bad query:\".mysql_error());
$result1=MySQL_query($sql1,$db) or die(\"Bad query1:\".mysql_error());
while($myrow=MySQL_fetch_array($result) + MySQL_fetch_array($result1))
{
$EventName1=$myrow[\"EventName\"];
$New=$myrow[\"New\"];
$Total=$myrow[\"Total\"];
echo \"<TR ALIGN=\'LEFT\' VALIGN=\'TOP\'>\";
echo \"<TD><INPUT TYPE=\'TEXT\' VALUE=http://www.phpbuilder.com/board/archive/index.php/\'$EventName1\' CLASS=\'CB-T-T11W\'></INPUT></TD>\";
echo \"<TD><CENTER><INPUT TYPE=\'TEXT\' VALUE=http://www.phpbuilder.com/board/archive/index.php/\'$New\' SIZE=\'1\' CLASS=\'CB-T-T11W\'></INPUT></TD>\";
echo \"<TD><CENTER><INPUT TYPE=\'TEXT\' VALUE=http://www.phpbuilder.com/board/archive/index.php/\'$Total\' SIZE=\'1\' CLASS=\'CB-T-T11W\'></INPUT></TD></TR>\";
}
?>