$view_c = (isset($_COOKIE['view']) ? $_COOKIE['view'] : null); $pos = strpos($view_c,'gallery'); if ($pos === false) { $rating = (isset($_GET['rating']) ? $_GET['rating'] : null); $ref_prev = (isset($_GET['ref_prev']) ? $_GET['ref_prev'] : null); if ($rating == "") { echo " - Rate this image - 10 - Perfect 9 8 - I like it very much. 7 6 - Not bad at all. 5 4 - Just OK. 3 2 - I don't like it. 1 - Rate and jump to next image - 10 - Perfect 9 8 - I like it very much. 7 6 - Not bad at all. 5 4 - Just OK. 3 2 - I don't like it. 1 " ; } else { $mysql= mysql_connect('localhost','qtl1','tgdbtgdb;;') or die('could not connect to mysql'); mysql_select_db('photo', $mysql) or die ('Could not select database'); $result=mysql_query("select ratings_nb,ratings_av from image_stats where ref = 'meve0822'",$mysql) or die ("query failed = " . mysql_errno() . ": " . mysql_error()); if (mysql_num_rows($result) > 0) { $array = mysql_fetch_row($result); $nb = $array[0]; $av = $array[1]; } if ($nb == 1) { echo "You were the first to rate this image. Thanks !"; } else { printf( "This image has been rated $nb times with an average of %.1f/10",$av); } mysql_close($mysql); } if ($ref_prev != "") { $mysql= mysql_connect('localhost','qtl1','tgdbtgdb;;') or die('could not connect to mysql'); mysql_select_db('photo', $mysql) or die ('Could not select database'); $result=mysql_query("select ratings_nb,ratings_av from image_stats where ref = '$ref_prev'",$mysql) or die ("query failed = " . mysql_errno() . ": " . mysql_error()); if (mysql_num_rows($result) > 0) { $array = mysql_fetch_row($result); $nb = $array[0]; $av = $array[1]; } if ($nb == 1) { echo "



You were the first to rate the previous image $ref_prev. Thanks !"; } else { printf( "



Thanks for your rating. Previous image $ref_prev has been rated $nb times with an average of %.1f/10",$av); } mysql_close($mysql); echo "

"; } } ?>