[PHP-DB] Payment Gateways

[Ahmed Shams]

Hi all,
I am working on a project that I haven't came across before and I would 
appreciate all the help I can get with it. Our client is requesting a 
payment gateway system where we communicate with the bank and provide 
reports and stats about the transactions. The reports part is relatively 
familiar but the communications with the bank is what is puzzeling me. I 
know the bank is providing an API but I need a similar code to work with. If 
anyone can provide me with a similar project which I can change to our specs 
or tell me how to start I would be extremely greatful.

Thanks

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

[PHP-DB] Re : Subject: floats

[Neil Smith [MVP, Digital media]]

Message-ID: [EMAIL PROTECTED]
Date: Tue, 19 Jul 2005 15:16:47 -0400
From: blackwater dev [EMAIL PROTECTED]
Reply-To: blackwater dev [EMAIL PROTECTED]
To: php-db@lists.php.net
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Subject: floats

I am running a query on MySQL:

select * from cars where id =52

It returns the row and I can see that gas mileage is saved as a float
with a value of 23.45.  So I then do a query, select * from cars where
id=52 and gas_mil=23.45 and the query doesn't retun anything.  Why?
Do I have to cast this as a float?


Although it's possible that the float has a value of 23.4501, I 
wouldn't expect that to be an issue.


Instead, check that your gas_mil name is *exactly* that and not followed by 
a space (I've done it before !)

For example thisSELECT * FROM cars WHERE `gas_mil` = 23.45
is NOT equivalent toSELECT * FROM cars WHERE `gas_mil ` = 23.45
Notice the extra space in the column name.

If that doesn't work do a query for
SELECT * FROM cars WHERE id=52 AND gas_mil BETWEEN 23.4 AND 23.5

See what happens then,
Cheers - Neil

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