<?php
require_once ('mysql_connect.php');
$userid = $_SESSION['user_id'];
$note = (int) $_GET['n'];
$query = "SELECT member_id, trip_id, note
FROM note_trips
WHERE member_id = $userid AND trip_id = 3";
$result = mysql_query ($query, $dbc);
$row = mysql_fetch_array ($result, MYSQL_BOTH);
if(!$row && $note){
if ($note <6) {
$query = "INSERT INTO note_trips(note_id,trip_id,member_id,note) VALUES('',3,$userid,$note)";
$result = _AT_mysql_query ($query);
}
}

if($row){
echo 'You have already voted';
}else{
echo '<form action="test.php" method="get" id="note" >
<select name="note" onchange="MM_jumpMenu(\'parent\',this,0)">
<option value="">Rate this Report</option>';
$query = "SELECT id_note
FROM note_name
ORDER BY id_note ASC";
$result = mysql_query ($query, $dbc);
while ($row = mysql_fetch_array ($result, MYSQL_BOTH)) {
echo"<option name=\"note\" value=\"test.php?n={$row['id_note']}\">{$row['id_note']}</option>\n";
}
echo '</select></form>';
}
?>

$result = @mysql_query ($query);

$row = true;