Go the main page of Chemistry and Linux:"; echo "http://lem.ch.unito.it/chem_linux.html"; exit; } echo pg_Result($result, 0, "catdesc"); echo "

\n\n"; $result = pg_Exec($conn, "SELECT name, href, lastdate, description, licimg, UPPER(name) AS up_name FROM list, catlist, category, license WHERE list.idname=catlist.idname AND catlist.catcode=$catcode AND category.catcode=catlist.catcode AND list.liccode=license.liccode ORDER BY up_name"); $num = pg_NumRows($result); $i = 0; while ($i < $num) { echo "\n\n"; $i++; } echo "
"; echo pg_Result($result, $i, "licimg"); echo ""; $lastdate=pg_Result($result, $i, "lastdate"); list($day,$month,$year) = split('-', $lastdate); $seconds_passed = time() - mktime(0,0,0,$month,$day,$year); if ($seconds_passed < 2592000) echo "\"New!\" "; echo ""; echo pg_Result($result, $i, "name"); echo "\n"; echo pg_Result($result, $i, "description"); echo "
\n"; pg_FreeResult($result); pg_Close($conn); ?>