Re[2]: [PHP-DB] Special chars UTF-8: sometimes ok, sometimes wrong

2007-10-19 Thread Vicente
I serve a UTF-8 header within my HTML, Apache is configured to serve UTF-8 and PHP scripts are saved in UTF-8 charset. However, this is a very odd issue, since it happens only with text taken from DataBase, but not from texts written in scripts :( Any similar experience? yes, it depends of

RE: [PHP-DB] union/select statement number of columns

2007-10-19 Thread Bastien Koert
Unions required that the the queries have the same number of columns and the same data type for each column bastien To: php-db@lists.php.net Date: Fri, 19 Oct 2007 09:24:38 -0600 From: [EMAIL PROTECTED] Subject: [PHP-DB] union/select statement number of columns Hello all, I receive an

RE: [PHP-DB] mssql_connect not working from command line [RESOLVED]

2007-10-19 Thread Instruct ICC
Thanks for informing me that CGI and CLI may use a different php.ini and that they may be compiled differently. The admin finally admitted that he ran a yum update which overwrote the manually compiled CLI version. The reason I missed it was that the build date of the latest CLI version was

Re: [PHP-DB] union/select statement number of columns

2007-10-19 Thread David Mitchell
For starters, here's a simple example using Oracle: select tname, tabtype from tab union select table_name, null from user_tables; I replaced NULL in the second query for the missing column. In a different observation, it would be better, I think, to name the individual columns rather than

[PHP-DB] Influence direction for database tooling support in NetBeans

2007-10-19 Thread David Van Couvering
Yes, I'm from NetBeans, that Java IDE. But we're actually thinking very seriously about PHP for the next release of NetBeans. I know emacs and vi are pretty darn good tools, but we're looking to see how NetBeans may be able to provide some value for PHP developers. My area of focus is on

RE: [PHP-DB] union/select statement number of columns

2007-10-19 Thread Bastien Koert
Unions required that the the queries have the same number of columns and the same data type for each column bastien To: php-db@lists.php.net Date: Fri, 19 Oct 2007 09:24:38 -0600 From: [EMAIL PROTECTED] Subject: [PHP-DB] union/select statement number of columns Hello all, I receive an

[PHP-DB] union/select statement number of columns

2007-10-19 Thread Jas
Hello all, I receive an error of the following: The used SELECT statements have a different number of columns. Any help, pointers, tutorials are appreciated. Here are the two tables structure I am trying to pull from: Table 1 mysql describe orders;