[SOLVED] problem returning int values from table

[neridaj]

Hello,

 

I'm trying to return some invoice numbers (int) from a table to populate a select list but for some reason the values are coming back as as '' i.e., the correct number of select options are populated but with no data. When I try the same script on any other column (varchar or decimal) the data is returned correctly but var_dump returns null for all.

 

Here is my function:

 

function display_update_invoice($result)
{
?>
<form method='post' action='invoice.php'>
<table align='center' bgcolor='#4E4D4D'>
<tr>
<th colspan='2'>Update Invoice</th>
</tr>
<?php
  $info = mysqli_fetch_array($result);
  printf ("<tr><td>Description: </td><td><input type='textarea' rows='3' name='description' value='%s' /></td></tr>
		<tr><td>Amount Due: $</td><td class='alignright'><input type='text' name='amt_due' value='%s' /></td></tr>
		<tr><td>Amount Paid: $</td><td class='alignright'><input type='text' name='amt_paid' value='%s' /></td></tr>
		<tr><td>Balance: $</td><td class='alignright'><h3>%s</h3></td></tr>
		<tr><td colspan='2'><input type='submit' value='Update' /></td></tr>",
$info['inv_description'], $info['inv_amt_due'], $info['inv_amt_paid'], $info['inv_amt_balance']);
echo "<tr><td><select>";
  while ($obj = mysqli_fetch_array($result)) {
  printf("<option value='inv_num'>'%s'</option>", $obj['inv_number']);
    }
    echo "</select></td></tr></table></form>";
var_dump($obj['inv_number']);
  	mysqli_free_result($result);
}
?>

 

Thanks for any help,

 

J

[fenway]

Solved how? There isn't even a mysql query in there!