Re: [PHP-DB] Wrong solution!!!!

[Julie Meloni]

T> $itemx = "15109";
T>   $num = mysql_query("SELECT quantity FROM inventory WHERE item =
T> '$itemx'",$link);
T>   if ($num < 1) {
T>   echo "Out of Stock $result";
T>   } else {
T>   echo "In Stock $result";
T>   }

T> I want my inventory quantity with known item number to compare with
T> ($num<1), but didn't work.


You have not yet gotten the result of the query.  Use mysql_result()
or any of the result-related functions to get the actual result of the
query.

All you're doing now is executing the query, which, if you've
connected successfully and there's nothing wrong with your sql, will
return true.


   Julie Meloni 
[EMAIL PROTECTED]
"PHP Essentials" & "PHP Fast & Easy"
 --- www.thickbook.com ---


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] Wrong solution!!!!

[David Balatero]

I assume you want to do this instead..try it:

Out of Stock $result";
} else {
echo "In Stock $result";
}
?>

-Original Message-
From: Tony [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 21, 2001 2:32 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Wrong solution


Hello,
I really do appreciate your help.

But, I found out that the solution scrip that you gave me was wrong script
for my purpose.
I guess I didn't describe my problem right.
I didn't mean to get the total number of rows to compare.

Let's say I have a table name inventory and contains two columes.
Here is example,

iteminventory
   15109 0
1511012
145907
This is a script that I tried and didn't work.

$itemx = "15109";
  $num = mysql_query("SELECT quantity FROM inventory WHERE item =
'$itemx'",$link);
  if ($num < 1) {
  echo "Out of Stock $result";
  } else {
  echo "In Stock $result";
  }

I want my inventory quantity with known item number to compare with
($num<1), but didn't work.
Can you tell me how about solving this problem?
Thanks for your time again.
Tony



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]