Re: [PHP-DB] currency formating

2001-12-31 Thread CrossWalkCentral
That did it thanks allot Bill. if you need a support tickett system made in php let me know. thanks again and happy new year to you all. "Billy Harvey" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > On Tue, 2002-01-01 at 00:08, Webmaster wrote: > > Yea i have

Re: [PHP-DB] currency formating

2001-12-31 Thread Billy Harvey
On Tue, 2002-01-01 at 00:08, Webmaster wrote: > Yea i have read that but did not think it was what i needed considering it > is for an automated billing system and the customer may not like it if they > are charged and extra .50 cents or so every month. Their has got to me > another alternative.

Re: [PHP-DB] currency formating

2001-12-31 Thread Webmaster
Yea i have read that but did not think it was what i needed considering it is for an automated billing system and the customer may not like it if they are charged and extra .50 cents or so every month. Their has got to me another alternative. "Shooter" <[EMAIL PROTECTED]> wrote in message 002f01

RE: [PHP-DB] currency formating

2001-12-31 Thread Shooter
U could use round. if u looked @ the php.net website. & searched you would of found it. heres the url http://www.php.net/manual/en/function.round.php an example is below. basically. its round($number,$deciminal_places); EXAMPLE $foo = round(1.95583, 2); // $foo == 1.96 Shooter Webmaster

[PHP-DB] currency formating

2001-12-31 Thread Webmaster
I have the following $number=47.7 I need this to be = 47.70 it must include the 2 didgets after the . how can i accomplish this -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the lis

[PHP-DB] Re: Problem with buttons

2001-12-31 Thread Ian Ferger
if you look closely at your code (instead of posting yet another silly message on this board) you'll notice that the first has an onclink event..i am not presently aware of any such event. to all you newbies out there: look over your code, check php.net, check the comments sections, if ALL els

Re: [PHP-DB] access stored proc

2001-12-31 Thread Harry N. C. Ng
Here's one I used: Example of Php program invoking a PL/SQL anonymous block. The block can then call a PL/SQL compiled function or stored procedure on the server. The OCIBindByName function is used to pass values into or out of the PL/SQL anonymous block. In this example, a compiled PL/SQL fun

Re: [PHP-DB] odbc date

2001-12-31 Thread George Nicolae
date() use a timestamp. I receive a string. if I echo odbc_result($cursor,"date") it shows like "2001-11-21 00:00". Can it echo (without date() function because I don't receive a timestamp) "21 Nov 2001"? -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web

RE: [PHP-DB] odbc date

2001-12-31 Thread Andrew Hill
George, Yes, using the date() example. Cheers, Andrew > -Original Message- > From: George Nicolae [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 31, 2001 1:26 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] odbc date > > > it is right but I want to select all data from a mdbdat

Re: [PHP-DB] odbc date

2001-12-31 Thread George Nicolae
it is right but I want to select all data from a mdbdatabase table and I receive in '/mm/dd hh:mm:ss' format. I told you I resolve this problem with date("F j, Y",strtotime(odbc_result($cur,"date"))). I what to know if I can receive a specific format from query "select date from my_table" --

RE: [PHP-DB] odbc date

2001-12-31 Thread Andrew Hill
George, The ODBC date syntax is best used for to make input format unambiguous, e.g.: select * from orders where order_date = { d '2002-01-01'} This will allow you to select from a table regardless of the date format. For converting a date from one format to another, select it from a table and

Re: [PHP-DB] odbc date

2001-12-31 Thread George Nicolae
i did it with date("F j, Y",strtotime(odbc_result($cur,"date"))). but i very curios about the query. it must looke like..? select date from my_table? -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.com > Or you can forma

RE: [PHP-DB] odbc date

2001-12-31 Thread Andrew Hill
George, You can use the date() function in PHP to change the format: http://www.php.net/manual/en/function.date.php Or you can format it with odbc date syntax in your query { d '-MM-DD' } Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.co

[PHP-DB] AUTHLIB

2001-12-31 Thread Danny Kelly
Is there any Authlib experts? Thanks, Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] db not visible if created from remote server

2001-12-31 Thread Andy
Hi there, I was uploading my db from my local machine to a server. mysqldump geodata | mysql -h 192.168.1.1 -u root geodata; Everything went ok. But the db is not visible for my application! I can see the db in mysqladmin, but my app does not? Anybody know what to do? Cheers Andy -- PHP Da