Re: correct syntax.. ?

Eric Porter, > 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); mysql_fetch_array if you want an associative array. mysql_fetch_row if you want the data as a normal array. You should take a look at: http://www.php.net/manual/ref.mysql.php -- Øyvind Grønnesby "Wow, I had knowledge!" --Buffy