correct syntax.. ?
| From: | Eric Porter | Date: | Wed, 28 Jun 2000 11:16:49 +0000 |
| Subject: | correct syntax.. ? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-3533@lists.php.net to get a copy of this message | ||
I am trying to find the total of items sold,
but I have a problem with my mysql_fetch.
I never tried to retrieve just one item from the
table before. The table/where clause work fine.
$query0 = "select SUM(quantity) from
inventorysold where name = '$row[name]' ";
$result1 = mysql_query($query0);
$row1 = mysql_fetch_*what goes here?*($result1);
Thanks
Eric
__________________________________________________
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/