Query problem

[SirChick]

I have a query that is not finding the record when one does exist.. no error occurs but the variable when echo'd always equals 0. Not sure why..

 

This is what i have:

 

$getpaper = "SELECT * FROM useritem WHERE UserID='$_SESSION[Current_User]' And ItemID = '1'"
						or die(mysql_error());
					// Fetch the row from the database
			if (!($paperrow = mysql_fetch_assoc($GetUserID))) {
			$TotalPaper = 0;
			}Else{
			$TotalPaper = $paperrow['Quantity'];
			}

 

$_SESSION[Current_User] is used via a global session carried around via the global include.

[darkfreaks]

<?php

$TotalPaper = 0;/// will always be zero change this line 
?>

[MadTechie]

$getpaper = "SELECT * FROM useritem WHERE UserID='{$_SESSION['Current_User']}' And ItemID = '1'"
						or die(mysql_error());
					// Fetch the row from the database
			if (!($paperrow = mysql_fetch_assoc($GetUserID))) //Makes no sense!
			{
			$TotalPaper = 0;
			}else{
			$TotalPaper = $paperrow['Quantity'];
			}

 

 

[Barand]

 

@darkfreaks - read the code. If no row returned it sets a default value of 0

[kenrbnsn]

You're not doing any query.

Also, if you're only using one field, just retrieve that field.

You should be checking to see if any rows are being returned:

<?php
$query = "SELECT Quantity FROM useritem WHERE UserID='$_SESSION[Current_User]' And ItemID = '1'";
$rs = mysql_query($query) or die("Problem with the query: $query<br>" . mysql_error());
if (mysql_num_rows($rs) != 1)
$TotalPaper = 0;
else {
        $paperrow = mysql_fetch_assoc($rs);
        $TotalPaper = $paperrow['Quantity'];
}
?>

 

Ken