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 -
// pseudo code starts here...
// use php to read the contents of the avi and set the header of the php doc
// to match headers necessary for an avi (check the fread/fwrite documentation)
// when it downloads, set the member_has_watched field for that member to
// true or 1 or whatever...
select count(*) from table where member_has_watched = TRUE and member_id = the_member's_id
if ($count > 0) {
// the member has watched it
} else {
// the member has not watched it
}-- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
