Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

MSQL and LITE problems

1 view
Skip to first unread message

Tad

unread,
Aug 26, 1999, 3:00:00 AM8/26/99
to
I'm trying to use the LITE language to talk to a msql database to generate a
system quote, but when I pull data out of the DB using the following set of
functions, it seems to return the COST field as text rather than MONEY which
it's set at... am I doing something in this code that would be forcing the
values to strings???

CODE:
$sock = msqlConnect();

msqlSelectDB($sock,"rsparts");

msqlQuery($sock,"select part_no,cost,descr FROM rsparts WHERE
descr='$CPU'");

*NOTE: $CPU is a variable created by passing a form to this script...

$res = msqlStoreResult();
$row = msqlFetchRow($res);
$total = $total + $row[1];
^when I do this it appends words together ie: [222 + 333 = 222333]

Any help would be appreciated!!!
I'm at: efi...@rave.net

0 new messages