Insert db values into dropdown box error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



 

Hi,

I would like insert into a dropdown box values from my mysql database
column
Using the sample below I'm getting this error (Parse error: parse error,
unexpected) on this line (while($row=mysql_fetch_array($result)({  )
But I'm not able to identify the problem, Any help is greatly
appreciated 
TIA


<tr>
   <td>Project Number:</td>
   <td>
<?
require_once("DB.php");

$sql=("SELECT project_number
              FROM projects
              ORDER BY project_number");
//$result=mysql_query($query);

  $result = $db->query($sql);
   if( DB::isError($result) ) {
      die ($result->getMessage());
   }

// start the select box
echo "<select project_number='project_number'>\n";
while($row=mysql_fetch_array($result)({
  echo "<option
value=\"$row[project_number]\">$row[project_number]</option>\n";
}
echo "</select>";

?>
</tr>

Edward 
 
--------------------------------------------------------
 
This electronic mail message contains information belonging to PaymentOne, which may be confidential and/or legal privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, printing, copying, distribution, or the taking of any action in reliance on the contents of this electronically mailed information is strictly prohibited. If you receive this message in error, please immediately notify us by electronic mail and delete this message. 
--------------------------------------------------------
 
 
  

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux