
January 10th, 2000, 01:45 PM
|
|
Junior Member
|
|
Join Date: Jan 2000
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Every time I run a query my result comes in a dollar format, i.e. 13080 comes back 13,080.00 I'm not sure what I am doing. Here is a snippet of the query.
<HTML>
<HEAD>
<TITLE> odbc1.php3</TITLE></HEAD>
<BODY>
<?
//Connect to DB
$connection = odbc_connect("recorder", "public", "public");
//Execute Query for date
$query = "SELECT docid ";
$query .="FROM sysop.ae_dt1 ";
$query .="WHERE field1 = $docnumber ";
$result = odbc_do($connection, $query);
odbc_fetch_row($result);
$idnum = odbc_result($result, 1);
//Output Results
print("Document Id: $idnum<BR>n");
//Close Connection
odbc_close($connection);
?>
|