[PHP-DB] SQL Join problem (Firebird)

Hi all Say you have two tables, TABLE1 and TABLE2. Each table contains (amongst others) a field called SOMEVALUE Now, in TABLE1 SOMEVALUE contains string1, but in TABLE2 SOMEVALUE contains string2. Now you join these tables (on SOMEOTHERVALUE) and you loop through the results set: while ($row

Re: [PHP-DB] SQL Join problem (Firebird)

Evan Morris wrote: Hi all Say you have two tables, TABLE1 and TABLE2. Each table contains (amongst others) a field called SOMEVALUE Now, in TABLE1 SOMEVALUE contains string1, but in TABLE2 SOMEVALUE contains string2. Now you join these tables (on SOMEOTHERVALUE) and you loop through the results

Re: [PHP-DB] PHP, MySQL and Apache 2 ?

How many of you are using PHP with MySQL and Apache 2 ? I am using. PHP:4.2.2, MySQL: 3.23 Apache 2. I know there _were_ some problems, but do the current (stable) PHP and MySQL work fine with Apache 2 ? They work fine together. Only I faced problem during installation. But that

RE: [PHP-DB] include_path problem

On 03 September 2003 01:32, Bruce Levick contributed these pearls of wisdom: Well yes I have restarted my webserver, and the php.ini file is under the windows directory (shown in phpinfo page) and I am definatelty editing it. The current value for my include_path is .;c:\php\includes

[PHP-DB] Consider upgrading MySQL client .... how do I do this?

Hi, Just this morning I upgraded to MySQL 4.1.0 alpha and PHP 4.3.3. I'm also running Apache 2 on a WinXP machine. The main reason for the upgrade was so that I could make use of 4.1.0's sub-select feature rather than attempt learning JOINs. It is now 7 hours later, and I keep getting the

Re: [PHP-DB] PHP, MySQL and Apache 2 ?

I use apache 2.0.47 withMysql 4.1 (beta) and php 4.3.2 All that I want to do seems to work fine (no issues yet) Installation was a breeze Jack from: David Haines [EMAIL PROTECTED] date: 2003/09/02 Tue PM 09:11:54 CEST to: [EMAIL PROTECTED] subject: [PHP-DB] PHP, MySQL and Apache 2 ?

Re: [PHP-DB] Consider upgrading MySQL client .... how do I do this?

one way it to use old_password ()instead of password(), when creating new user name, or update the password for those existing user names with the old_password() function. but then this will force you to use the old password() function, which doesn't really help much... Vinoaj Vijeyakumaar

RE: [PHP-DB] Consider upgrading MySQL client .... how do I do this?

On 03 September 2003 10:51, Vinoaj Vijeyakumaar contributed these pearls of wisdom: Hi, Just this morning I upgraded to MySQL 4.1.0 alpha and PHP 4.3.3. I'm also running Apache 2 on a WinXP machine. The main reason for the upgrade was so that I could make use of 4.1.0's sub-select

Re: [PHP-DB] To slash or not to slash....

On Tue, 2 Sep 2003 16:45:28 +0100, Craig Cameron wrote: Ok simple problem I hope. Have the following code, used to store the location and a few details about meeting minutes. snip $connection = mssql_connect(server,user,password);

RE: [PHP-DB] include_path problem

There is an include_path for unix and an include_path for windows. They both differ slightly but aren't of the same value that is being returned in the php info page or the error that I am receiving. This is the info displayed for my php.ini file. My OS is on G:. G:\WINDOWS\php.ini This is the

[PHP-DB] To many connections problem with LAMP

Hello, I am getting more and more to many connections errors on my web application buid with LAMP. After doing some research it looks like this is a problem because I am using pmysql_connect instead of mysql_connect. Istn't it better to use persistant connections? There are about 14000 PI the

RE: [PHP-DB] include_path problem

On 03 September 2003 14:10, Bruce Levick contributed these pearls of wisdom: There is an include_path for unix and an include_path for windows. They both differ slightly but aren't of the same value that is being returned in the php info page or the error that I am receiving. This is the

RE: [PHP-DB] include_path problem

I have not really followed this thread so if it is mentioned already. Is the include_path directive twice in the file? -Original Message- From: Ford, Mike [LSS] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 3:42 PM To: 'Bruce Levick' Cc: [EMAIL PROTECTED] Subject:

[PHP-DB] Viewing Data From MySQL

Hi, Is it possible to change the way a query is displayed from a MySQL database. For example if I have a column that contains '1' or '0' can I run a query that returns 'Yes' for every '1' and 'No' for every '0'? Thanks for your help -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Viewing Data From MySQL

Yes, easily. Use the 'if' conditional in mysql... select if(col_name = 1, 'yes', 'no') from table_name; David Shaun [EMAIL PROTECTED] 09/03/2003 10:32 AM To: [EMAIL PROTECTED] cc: Subject: [PHP-DB] Viewing Data From MySQL Hi, Is it possible to change the way a query is

[PHP-DB] Browser-Trouble with Query

Hi everyone, I have trouble with a PHP-script querying a MySQL-database. Actually my Opera-Browser has trouble (version 7.11 on a Win2000 machine). It outputs a parse error when i enter that page. Parse error: parse error in /var/www/mypage.php on line 156 After checking all parenthesis over

RE: [PHP-DB] Browser-Trouble with Query

Hi Can we see the code + a few lines either side? Peter -Original Message- From: Sebastian Haag [mailto:[EMAIL PROTECTED] Sent: 03 September 2003 21:12 To: [EMAIL PROTECTED] Subject: [PHP-DB] Browser-Trouble with Query Hi everyone, I have trouble with a PHP-script querying a

RE: [PHP-DB] Browser-Trouble with Query

Two things: First, a copy of your code would help, with line 156 clearly identified. Second, usually there's more information with the parse error. Something like expected ',' or ';' that will give you more of a hint. Although, I'm not sure if the PHP.INI file has a setting for displaying that

RE: [PHP-DB] Browser-Trouble with Query

Hi guys, Hutchins, Richard said: Two things: First, a copy of your code would help, with line 156 clearly identified. Sure, [...more code goes here...] $query .= $and; $result = @mysql_query($query) or die(Game ID: . mysql_error());

[PHP-DB] basic php question

Greetings, I have php and mysql installed on my freebsd machine. I have a database iweb with tables employee and emp2. I need to walk table employee and see if emp2 has a record that matches by employee number. If it matches, I need to update some values in emp2. If there is no match, I need to

Re: [PHP-DB] Set autocommit to off/on from PHP

El Mar 02 Sep 2003 08:05, Joanna Owczarzak escribió: PHP 4.1.2, postgreSQL 7.1.3. How to change autcommit property of postgreSQL database from php script? $db = DB::Connect($dbn); $db-autocommit(false); Saludos... :-) P.D.: They should document this. -- 18:26:01 up 12 days, 10:16, 4

Re: [PHP-DB] basic php question

Darryl, I'm not completely clear on what you mean by I need to walk table employee and see if emp2 has a record that matches by employee number From what I understand I would do something like: $query = mysql_query(select * from employee where EmployeeNo = $EmployeeNo and emp2.EmployeeNo =

[PHP-DB] ErrorDocument

I'm not sure if I'm right here, but I've got the following problem: I was going to set up my own errordocument using a .htaccess file which has: ErrorDocument 404 /error404.php It works quit fine for .html files but has no effect in php files. Any clue for me? Lars -- PHP Database Mailing

RE: [PHP-DB] Browser-Trouble with Query

Hi, the problem is solved ... but the solution is searched. I renamed the file to mypage2.php and the script works fine. Puzzles me quite a bit. So, if anyone has an idea... I'm thankful for any comments. Thanks to you guys who replied. Sebastian Haag said: Hi guys, Hutchins, Richard said:

RE: [PHP-DB] Browser-Trouble with Query

Sounds like you had a cache problem going on. I wanted to suggest that but got tied up on something else. Whenever you see the same results, even though you are changing the code, try and delete the cache files in the browser, exit the browser, then come back in and try it again. Usually this

Re: [PHP-DB] What are your DB driven/template strategies?

Thanks Daniel, Alexey and Colbey. I will look into all your suggestions. The custom 404 error page to redirect would definitely be easier to implement than my manual redirect suggestion earlier as I would still have to type out each URL in the .htaccess file. I have not worked with mod_rewrites