[SOLVED] help with code

[jck]

take a look at this code

 

<?php
require_once("conn.php");
require_once("templates/MainHeader.php");


                $request = mysql_query("
	SELECT rt.username, rt.Rating
	FROM dd_rating AS rt
	WHERE ItemID = $_GET['ItemID']") or die(mysql_error());

echo '<b><center>See what Rating others gave for this joke </center></b><br><br>';

if (mysql_num_rows($request) > 0)
{
	while ($row = mysql_fetch_assoc($request))
	{
		$name = $row['username'];
		$rate = $row['Rating'];

		echo '
		' . $name . ' had given a rating of ' . $rate . ' to this joke.<br />';
	}
}
else
	echo 'No ratings for this joke.';


require_once("templates/MainFooter.php");
?>

 

when i run it by putting where ItemID=69 it works but

when i do othersvote.php?ItemID=69 its not working

[tapos]

You can try this

 

$request = mysql_query("
	SELECT rt.username, rt.Rating
	FROM dd_rating AS rt
	WHERE ItemID = $_GET[itemID]") or die(mysql_error());

 

--

Tapos Pal

[jck]

thanks a lot tapos pal it worked

[jck]

k