Hi all, What would be the best way

[camcim]

Hi all,
What would be the best way to write the following query?
I have a table called movie_rating which contains two fields called movie_id and movie_rating.
If there is no row associated with the movie_id field then i want it to echo that there is no row containing the movie_id value and if it does then it should echo the movie_id value.

Any ideas?
camcim

 

[sleipnir214]

That question doesn't make much sense to me. Why would you be looking up a movie_id that does not exist?
Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[camcim]

Let's assume that i do know the value of $movie_id.
Eg: $movie_id = 3

 

[bedrock]

ok, well just query for that id, and then use mysql_num_rows() like so:

$query="select * from movie_rating where movie_id=".$movie_id;
$result=mysql_query($query);
if(mysql_num_rows($result) == 0)
  echo "id not found";
else
  echo $movie_id;

you wouldnt necessarily need to retrieve both columns but if your going to use that data somewhere you might as well get it now. you could add some lines in the else block to fill an array with that data:

  $row=mysql_fetch_assoc($result);
  $rating[$movie_id]=$row["movie_rating"];

what we see depends mainly on what we're looking for.
--John Lubbock