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

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

[PHP-DB] AUTHLIB

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]

RE: [PHP-DB] odbc date

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

Re: [PHP-DB] odbc date

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 format it

RE: [PHP-DB] odbc date

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

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

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 mdbdatabase

Re: [PHP-DB] odbc date

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] currency formating

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

Re: [PHP-DB] currency formating

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

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 read