[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 adminis

Re: [PHP-DB] How to write this querry?

2001-12-30 Thread Bas Jobsen
delete from cities where cities.province_id<>provinces.province_id Op zondag 30 december 2001 21:55, schreef 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

[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 someth

[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 thi

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 regardles

[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

[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] 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 I