[PHP-DB] odbc date

2001-12-30 Thread George Nicolae
for Win32(NT) and MSAcess 2000, whenever you retrieve a date column/field, php will automatically convert it to '/mm/dd hh:mm:ss' format regardless of the style of date you've denoted in Access how can I resolve this problem and print in a different format? -- Best regards, George Nicolae

[PHP-DB] product selection from url ?

2001-12-30 Thread Dave Carrera
Hi All Seasons greetings and a Happy new year. How do i selct from my MySql dbase a specfic product from a issued url ie: http://www.domain-name.com/products/?pid=1234 I have seen this done on other sites The idea is to issue a url to my site with the pid so that people who cklick on it only

[PHP-DB] Re: product selection from url ?

2001-12-30 Thread George Nicolae
select * from your_database where pid=1234 -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.com Dave Carrera [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi All Seasons greetings and a

Re: [PHP-DB] odbc date

2001-12-30 Thread Bogdan Stancescu
If everything else fails, you can retrieve unix_timestamp(date) and use PHP's date() to format the output. HTH Bogdan George Nicolae wrote: for Win32(NT) and MSAcess 2000, whenever you retrieve a date column/field, php will automatically convert it to '/mm/dd hh:mm:ss' format regardless

[PHP-DB] BUG in MySQL 3.23.42-nt

2001-12-30 Thread Andy
Hi guys, I might have found a bug in this mysql version. A PHP script created 200 tables for me. Named after countrycodes (as, gm, ca) Now another script is filling this tables with data. A view tables are not possible to fill. I tried it by handcode. But no way. After I renamed one of

[PHP-DB] How to write this querry?

2001-12-30 Thread Andy
Hi guys, I am trying to get rid of not needed data. There is a table called provinces containing country_codes and province_id Another table contains the cities with the field province_id How can I get rid of cities which are not listed with a province_id in the table provinces? I tryed

[PHP-DB] access stored proc

2001-12-30 Thread Mohd Nizar Abdul Najib
how do i access oracle stored procedure that return value 0 or 1 in PHP. Does anyone know? Thank you Regards, Mohd Nizar -- 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