output problem

[dirt]

i am doing a dvd rental system where members can purchase or rent dvds. i am not getting the output that i want.This is what it displays:-

You have purchased DVD(s)
Limit Exceeded! Only is rented!
Limit Exceeded! Only is rented!
Limit Exceeded! Only is rented!
Limit Exceeded! Only is rented!

the codings are like this:-
<?php require_once('Connections/ren.php');?><?php
mysql_select_db($database_ren, $ren);
$query= "SELECT membership FROM user WHERE username='".$_COOKIE['username']."'";
$usr = mysql_query($query, $ren) or die(mysql_error());
$row_usr = mysql_fetch_assoc($usr);
$limit=$row_usr['membership'];

$count=0;
if (isset($_POST['save']) && (isset($_COOKIE['usrname'])) ) {
foreach($_POST as $key => $val){
if(substr($key,0,3)=="buy"){

$query="INSERT INTO buy ( user , movies )VALUES ('".$_COOKIE['usrname']."', '".$val."');";
mysql_query($query) or die(mysql_error());
$username = $_COOKIE['usrname'];
$query=mysql_query("SELECT COUNT(*) FROM buy WHERE user = '$username'");
$purchsed=mysql_num_rows($query);
mysql_close();
echo("<center><font color=red>You have purchased $purchased DVD(s) </font></center>");}

if($count < $limit){
if(substr($key,0,4)=="rent"){
$query="INSERT INTO rent ( user , movie )VALUES ('".$_COOKIE['username']."', '".$val."');";
mysql_query($query, $ren) or die(mysql_error());
$username = $_COOKIE['usrname'];
$query=mysql_query("SELECT COUNT(*) FROM buy WHERE user = '$username'");
$rented=mysql_num_rows($query);
mysql_close();
echo("<center><font color=red>You have purchased $rented DVD(s) </font></center>");
}
}else{
echo "<center><font color=red>Limit Exceeded! Only $limit is rented! </font></center>";
}
}
}
if (isset($_POST['save']) && (!isset($_COOKIE['usrname'])) ) {
echo "<center><font color=red>Please Login</font></center>";
}

[scriptmasterdel]

Maybe to do with the typo?

$_COOKIE['usrname']

.. should be ..

$_COOKIE['username']

I noticed it four times in your code!

Del