[SOLVED] code help

[jck]

is this code correct????

$q="SELECT * FROM dd_rating WHERE ItemID = $ItemID AND username = '$_SESSION[username]";
$r2 = mysql_query($q);
if (mysql_num_rows($r2) = 0)
{
echo '<b><center>You have not yet rated this joke </center></b><br>';
}
else
{
echo '<b><center>You have given this joke a rating of ' . $rate = $row['Rating] . </center></b><br>
?>

[AndyB]

No.

 

At the least ItemID = $ItemID ought to be ItemID = '$ItemID' and the $row array needs to be abstracted after the database query ... $row=mysql_fetch_array($r2);

[jck]

oops

$row=mysql_fetch_array($r2)

 

but it dosent look like they are all the errors....

[jitesh]

$q="SELECT * FROM dd_rating WHERE ItemID = ".$ItemID ." AND username = '".$_SESSION[username]."'";
$r2 = mysql_query($q);
if (mysql_num_rows($r2) == 0)
{
echo '<b><center>You have not yet rated this joke </center></b><br>';
}
else
{
echo '<b><center>You have given this joke a rating of ' . $rate = $row['Rating] . </center></b><br>
?>

[tapos]

try this

$q="SELECT * FROM dd_rating WHERE ItemID = ".$ItemID ." AND username = '".$_SESSION[username]."'";
$r2 = mysql_query($q);
if (!mysql_num_rows($r2))
{
echo '<b><center>You have not yet rated this joke </center></b><br />';
}
else
{
while($row = mysql_fetch_arrray($r2))
{
echo '<b><center>You have given this joke a rating of ' . $rate = $row['Rating] .' </center></b><br />';
}
}
?>

[jck]

each guy can vote only once

[tapos]

Now this will help u,

 

$q="SELECT * FROM dd_rating WHERE ItemID = ".$ItemID ." AND username = '".$_SESSION[username]."'";
$r2 = mysql_query($q);
if (!mysql_num_rows($r2))
{
echo '<b><center>You have not yet rated this joke </center></b><br />';
}
else
{
$row = mysql_fetch_arrray($r2))

echo '<b><center>You have given this joke a rating of ' . $rate = $row['Rating] .' </center></b><br />';

}
?>

[jck]

none of there are working

[jck]

its very puzzling i dont understand whats wrong with these codes

[AndyB]

Sigh.  "None of these are working" really doesn't help anyone at all because we can't tell what's supposed to happen with your testing

 

echo the value of $q immediately after defining it.  Post exactly what it says.

 

 

[Oldiesmann]

$q="SELECT * FROM dd_rating WHERE ItemID = ".$ItemID ." AND username = '".$_SESSION[username]."'";
$r2 = mysql_query($q);
if (!mysql_num_rows($r2))
{
echo '<b><center>You have not yet rated this joke </center></b><br />';
}
else
{
$row = mysql_fetch_array($r2))

echo '<b><center>You have given this joke a rating of ' . $rate = $row['Rating'] .' </center></b><br />';

}
?>

 

Two typos:

One too many "r"s in "mysql_fetch_array"

Missing a ' before ] in the last echo line.

[jck]

i dont understand the page comes blank

[jitesh]

Attach you php file

[jck]

i ran it indivijually by putting a number and it didnt work

[ankhmor]

this is the original code:

 

$q="SELECT * FROM dd_rating WHERE ItemID = $ItemID AND username = '$_SESSION[username]";
$r2 = mysql_query($q);
if (mysql_num_rows($r2) = 0)
{
echo '<b><center>You have not yet rated this joke </center></b><br>';
}
else
{
echo '<b><center>You have given this joke a rating of ' . $rate = $row['Rating] . </center></b><br>
?>

 

First mistake: $q="SELECT * FROM dd_rating WHERE ItemID = $ItemID AND username = '$_SESSION[username]";

Should be: $q="SELECT * FROM dd_rating WHERE ItemID = '$ItemID' AND username = '$_SESSION[username]'";

 

Second: if (mysql_num_rows($r2) = 0)

Should be: if (mysql_num_rows($r2) == 0)

 

third: what is $row?

I think what you meant was $rate = mysql_result($r2, 0, 'Rating');

 

I fogot you can use mysql_fetch_row too. (but I never use it and not sure how to excactly)

[jck]

<?
$query="SELECT * FROM dd_rating WHERE ItemID = '114' AND username = 'jck'";
$result = mysql_query($query);
if (mysql_num_rows($result) == 0)
{
echo '<b><center>You have not yet rated this joke </center></b><br>';
}
else
{
$rate = mysql_result($result, 0, 'Rating');
echo '<b><center>You have given this joke a rating of ' . $rate . </center></b><br>
?>

 

i tested with this code and i get blank page

[AndyB]

<?php
$query="SELECT * FROM dd_rating WHERE ItemID = '114' AND username = 'jck'";
$result = mysql_query($query);
if (mysql_num_rows($result) == 0)
{
    echo '<b><center>You have not yet rated this joke </center></b><br>';
}
else
{
    $rate = mysql_result($result, 0, 'Rating');
    echo '<b><center>You have given this joke a rating of ' . $rate . '</center></b><br>';// changed line
} // closed loop
?>

 

I can only assume your server does not have display errors active.

[jck]

now i get you have not yet rated this joke for all....

[jck]

oops sorry its working