NewB Q on Arrays.
| From: | inpho | Date: | Tue, 25 Mar 2003 11:18:48 +0000 |
| Subject: | NewB Q on Arrays. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-140933@lists.php.net to get a copy of this message | ||
Hey All,
I'm still a newB in php and mysql so I'm asking for your patience up front.
i want to get a list of results from an array, which I can do with:
$result=mysql_query("select * from mvlogtbl",$db);
while ($row=mysql_fetch_array($result)){
echo "$row[uid] $row[mvid]";
}
basically what I have is a database of movies linked to .avi files that are
setup for streaming, the table mvlogtbl keeps a log of who has watched what.
What i want to be able to do is determine if a certain user has watched a
movie. But there are multiple entries for each user, a user may have watched
the movie more than once, I don't really care, I just want to be able to
tell if they have watched it or not...
any help?
Thanls
- paul -