some data not showing in browser

alighouston

$invoice_number not showing in browser rest of data working fine

<HTML>
<HEAD>
 <TITLE>view</TITLE>
</HEAD>
<BODY>
<?
  // connect to database
	$connect = mysql_connect ("localhost", "Same-data", "somepass") or die ("lost") ;

// data base selecte
mysql_select_db("same_bella") ;
$view = "SELECT * FROM `purchf` ";
$results= mysql_query ($view)
or die (mysql_error());
while ($row = mysql_fetch_array ($results)) {
   extract ($row);
   echo "-";
   echo $auto_id;
   echo "--";
   echo $invoice_num;
   echo "--";
   echo $desc_prod;
   echo "--";
   echo $date_purc;
   echo "--";
   echo $amm_pur;
   echo "<br>";
   }

?>
</BODY>
</HTML>

ucffool

alighouston wrote:
$invoice_number not showing in browser rest of data working fine
       echo $invoice_num;

Probably because the column is called invoice_number and you are calling a variable that doesn't exist ($invoice_num) instead of $invoice_number.

bradgrafelman

You can use [man]print_r/man to see the contents of the $row array. If invoice_num is an element of the array but is empty, then it's not PHP's fault nothing is displaying since that is what the database is returning.