Re: NewB Q on Arrays.

On Tue, 25 Mar 2003 21:18:48 +1000, Inpho <inphorm@gmx.net> wrote:

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/