[SOLVED]Re: LEFT JOIN problem
Thanks Roger That fixed the problem.I was under the impression that I only had to put the linked columns n the ON and everything else in the WHERElive an learn I guess. Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Rory McKinley [EMAIL PROTECTED] Sent: Thursday, November 20, 2003 4:23 PM Subject: Re: LEFT JOIN problem * Rory McKinley [...] SELECT a.line_number, a.category_value, IFNULL(b.parameter_trigger, 0) FROM DB1.Table 1 AS a LEFT JOIN DB2.Table 2 AS b ON a.category_name = b.parameter_value WHERE a.line_type = 13 AND b.parameter_ID = 13 The only problem is that the query only returns the first two records and not the third record - contrary to my expectations. I am using MySQL 4.0.15-standard together with PHPMyAdmin 2.5.3. Does anybody know what I am doing wrong? You have a criteria on the B table in the WHERE clause. Move it to the ON clause: SELECT ... AS b ON a.category_name = b.parameter_value AND b.parameter_ID = 13 WHERE a.line_type = 13 -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: unable to connect after log in
Hi
Have you tried using mysql_connect instead of mysql_pconnect? Does it make
any difference?
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMAIL PROTECTED]
There are 10 kinds of people in this world,
those who understand binary and those who don't (Unknown)
- Original Message -
From: chilie palmer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 10:12 PM
Subject: unable to connect after log in
I have a connection problem that I have been unable to solve after
searching
the web and the mysql mailing-lists. I'm connecting to a local database
using PHP. It's a pretty simple and straightfoward setup, a user logs in
and the links they have access to are displayed (change user info, update
password, etc). I can log in with the initial links displayed (database
connection is made), but after that (either by clicking a link or hitting
refresh on the same page I just logged in to) I get the following error:
Access denied for user: '@localhost' to database 'my_DB_name'
The only way I have been able to work around this is by giving Select,
Insert, Update, Delete permissions to the host 'localhost' (no user or
password) in the mysql.users table. If I give this host no permissions,
the
script works as described above, only logging in once. Below is the PHP
db
connect function that I am using (included via require_once on all pages).
I have tried to connect both with root and another user I created with all
permissions. I have also tried creating a user in the mysql.db table with
'localhost - my_DB_name - my_DB_user' and all permissions.
?php
function db_connect()
{
$result = mysql_pconnect('localhost', 'my_DB_user', 'DBPASSWORD');
if (!$result)
return false;
if (!mysql_select_db('my_DB_name'))
return false;
return $result;
}
?
Is there something I've overlooked here in my connection setup? I can't
give the localhost host permissions in my production environment for
security reasons. Any help, suggestions, or ideas are appreciated.
(Using -
MySQL 4.0.13, PHP 4.3.2)
Thanks
_
Want to check if your PC is virus-infected? Get a FREE computer virus
scan
online from McAfee.
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Moving databases
Off the top of my head:) In the my.cnf file under the [mysqld] section add the following line: datadir= /path.to/new/datadir Stop mysql. Move all dbs to new datadir (if your'e only using MYISAM, this is a straight copy). Restart mysql. HTH Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: David Wilson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 5:49 PM Subject: Moving databases We are running MySQL 3.23.47 on a AIX Risc System. It is IBM's compiled version of MySQL, it does everything as far as installing and compiling it for us. But what we found is that is stores the databases where it wants and would like to move them but cant seem to figure it out. Does anybody have a clue -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: newbie select statement question
I am not sure if this has any significance - but isn't 31 Dec 1969 the day
before the UNIX epoch (1 Jan 1970 - i think)?
Jordan, how are the dates stored in the database - as dates or unix
timestamps?
Also, the function fixDate isn't in the online PHP manual - is it a function
defined by you? - could that not be doing something weird?
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMAIL PROTECTED]
There are 10 kinds of people in this world,
those who understand binary and those who don't (Unknown)
- Original Message -
From: Diana Soares [EMAIL PROTECTED]
To: Jordan Morgan [EMAIL PROTECTED]
Cc: mysql [EMAIL PROTECTED]
Sent: Friday, October 10, 2003 8:58 AM
Subject: Re: newbie select statement question
Look at:
if ($tenureid=3)
You're not comparing $tenureid with 3, you're assigning 3 to
$ternureid... If you want to compare both values, you must use the
operator == (and not only =).
On Fri, 2003-10-10 at 05:43, Jordan Morgan wrote:
Hi,
I have the following statement:
echo $tenureidP;
if ($tenureid=3)
{
// get faculty employment record - award date
$sql = select TD.Award_Date from TenureDescription TD LEFT JOIN
InstitutionEmployment IE on TD.TenureDescriptionID=IE.Tenure WHERE
IE.FacultyMember='$fid';
$result = mysql_db_query($database, $sql, $connection) or die (Error
in query: $sql. . mysql_error());
// obtain data from resultset
list($tenuredate) = mysql_fetch_row($result);
echo BDate Tenure Granted/B: ;
echo fixDate($tenuredate);
echo P;
}
else {
echo BDate Tenure Granted/B: NullP;
}
and I can't figure out why I always get the following result:
2
Date Tenure Granted: 31 Dec 1969
---
or
1
Date Tenure Granted: 31 Dec 1969
---
when 1) tenureid 3, and 2) no 31 Dec 1969 date in the database
anywhere.
The only thing I can think of is that I modified the dropdown box for
the tenure date on the data entry page like this:
tr
tdDate Tenure Grantedbrfont size=-2(in mm-dd-
format)/font/td
td
select name=tmm
option value=0 selected='selected'/option
? for ($x=1; $x=12; $x++) { echo option value=\ . sprintf(%02d,
$x) . \ . sprintf(%02d, $x) . /option; } ?
/select -
select name=tdd
option value=0 selected='selected'/option
? for ($x=1; $x=31; $x++) { echo option value=\ . sprintf(%02d,
$x) . \ . sprintf(%02d, $x) . /option; } ?
/select -
select name=t
option value=0 selected='selected'/option
!-- display from 1970 to (current year) --
? for ($x=(date(Y, mktime())); $x=1970; $x--) { echo option
value=$x$x/option; } ?
/select
/td
/tr
by adding option value=0 selected='selected'/option to those 3
fields as I want null to be a default selection. but I can't imagine why
that'll mess up the if statement evaluation.
It seems that the 1st if statement just runs whatever the tenureid is.
Can anyone help me on this? I'm using PHP 4.2.2 and MySQL 3.23.54 btw.
Thanks millions!
Jordan
--
Diana Soares
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [MYSQL] Combine tables from two different systems
Hi Paul If all the tables have a primary key set, you can do an INSERT IGNORE from the tables in System A to the tables in System B (either manually or write a script). Any rows form System A that already have a System B equivalent will be silently dropped and only those that do not have an equivalent will be written. e.g. INSERT IGNORE INTO system_b.table_n (columns) SELECT columns FROM system_a.table_n HTH Rory McKinley Nebula Solutions 082 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: PAUL MENARD [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 5:21 PM Subject: [MYSQL] Combine tables from two different systems Hello All, I have two system, we shall call then system A (OLD) and system B (NEW), running MySQL that I want to combine their tables. The system B is the newer and most accurate. The table structure is the exact same. Some of the rows in system B (NEW) tables are also in system A (OLD). For those rows I want to leave the system B data unchanged. I have a select statement with a left join that will tell me the rows that are in system A but not in system B (the target). Question is how to I write a SQL statement to also insert these rows? System information. Windows NT4 (System A), Windows server 2003 (System B). MySQL 3.23.42-nt running on both systems. Paul -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
date problem
Hello mysql, I do this: $query = INSERT INTO news(ID, author, title, text, date) VALUES(NULL, '.$_SESSION[ulogged].', '.$title.', '.$text.', UNIX_TIMESTAMP(NOW())); $result = mysql_query($query, $connection) or die(problem with query); I get this: mysql select * from news where id='1'; +++--+++ | ID | author | title| text | date | +++--+++ | 1 | myuser | news | blah blah blah | 20030323225645 | +++--+++ 1 row in set (0.01 sec) Look at the time! It's set ... strange :) 2003 03 23 22 56 45 .. it's not neither now() format, neither unix_timestamp() format. mysql select now(), unix_timestamp(now()); +-+---+ | now() | unix_timestamp(now()) | +-+---+ | 2003-03-23 23:07:30 |1048453650 | +-+---+ 1 row in set (0.01 sec) It's okay. So, why in the query from a php form the unix time date is saved wrong? Any ideas and suggestions? -- best wishes, Strahil Minev a.k.a. DLHelper, BuFu TeaM mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re[2]: date problem
Hello Michael, The most interesting part is that it's not in NOW() format! I've tried one-two times the same query and: mysql select * from news; +++--+-++ | ID | author | title| text| date | +++--+-++ | 1 | myuser | news | blah blah blah | 20030323225645 | | 2 | myuser | news2| yakidi shmakidi | 20001117212520 | | 3 | myuser | news3| this ain't fun | 20001118212554 | +++--+-++ 3 rows in set (0.02 sec) It's just.. random.. I don't know, is this a bug or something? [EMAIL PROTECTED]:/www/voting/vega$ date Mon Mar 24 04:36:33 EET 2003 My clock is okay. Monday, March 24, 2003, 4:03:45 AM, you wrote: MS It looks like it's in now() format, but without the punctuation. The line MS from your insert statement is MS 20030323225645 MS If we break this apart, we see: MS Year = 2003 MS Month = 03 MS Date = 23 MS Hour = 22 (or 10pm) MS Minute 56 MS Seconds 45 MS Someone else on the list: where or how is the timezone encode, or this is MS entry in GMT? Is there a way to determine the local timezone on the machine? MS -ms MS -Original Message- MS From: nobody [mailto:[EMAIL PROTECTED] MS Sent: Sunday, March 23, 2003 12:56 PM MS To: [EMAIL PROTECTED] MS Subject: date problem MS Hello mysql, MS I do this: MS $query = INSERT INTO news(ID, author, title, text, date) VALUES(NULL, MS '.$_SESSION[ulogged].', '.$title.', '.$text.', MS UNIX_TIMESTAMP(NOW())); MS $result = mysql_query($query, $connection) or die(problem with query); MS I get this: mysql select * from news where id='1'; MS +++--+++ MS | ID | author | title| text | date | MS +++--+++ MS | 1 | myuser | news | blah blah blah | 20030323225645 | MS +++--+++ MS 1 row in set (0.01 sec) MS Look at the time! It's set ... strange :) 2003 03 23 22 56 45 .. it's MS not neither now() format, neither unix_timestamp() format. mysql select now(), unix_timestamp(now()); MS +-+---+ MS | now() | unix_timestamp(now()) | MS +-+---+ MS | 2003-03-23 23:07:30 |1048453650 | MS +-+---+ MS 1 row in set (0.01 sec) MS It's okay. So, why in the query from a php form the unix time date is MS saved wrong? Any ideas and suggestions? MS -- MS best wishes, MS Strahil Minev a.k.a. DLHelper, MS BuFu TeaM mailto:[EMAIL PROTECTED] -- best wishes, Strahil Minev a.k.a. DLHelper, [EMAIL PROTECTED], BuFu TeaM mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re[2]: date problem
Hello Don, Well, you're right ;) I change the column type to int it just run perfect. Thanks to both of ya! Monday, March 24, 2003, 5:21:35 AM, you wrote: DR On 24-Mar-2003 Michael Shulman wrote: It looks like it's in now() format, but without the punctuation. The line from your insert statement is DR Nope, that's a MySQL timestamp. DR UNIX_TIMESTAMPS are # of seconds from the epoch (Jan 1 1970). DR nobody [EMAIL PROTECTED] is trying to store an INT in a timestamp column and DR probably clobbering his values. 20030323225645 If we break this apart, we see: Year = 2003 Month = 03 Date = 23 Hour = 22 (or 10pm) Minute 56 Seconds 45 DR Nope, that's a MySQL timestamp. DR UNIX_TIMESTAMPS are # of seconds since the epoch (Jan 1 1970). DR nobody [EMAIL PROTECTED] is probably trying to store an INT in a timestamp DR column and clobbering his values as the timestamp updates. Someone else on the list: where or how is the timezone encode, or this is entry in GMT? Is there a way to determine the local timezone on the machine? mysql show variables like 'timezone'; DR +---+---+ DR | Variable_name | Value | DR +---+---+ DR | timezone | PST | DR +---+---+ DR 1 row in set (0.00 sec) mysql select sec_to_time((time_to_sec(now()) - UNIX_TIMESTAMP()) % 86400) DR as 'offset GMT'; DR ++ DR | offset GMT | DR ++ DR | -08:00:00 | DR ++ DR 1 row in set (0.00 sec) -Original Message- From: nobody [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2003 12:56 PM To: [EMAIL PROTECTED] Subject: date problem Hello mysql, I do this: $query = INSERT INTO news(ID, author, title, text, date) VALUES(NULL, '.$_SESSION[ulogged].', '.$title.', '.$text.', UNIX_TIMESTAMP(NOW())); $result = mysql_query($query, $connection) or die(problem with query); I get this: mysql select * from news where id='1'; +++--+++ | ID | author | title| text | date | +++--+++ | 1 | myuser | news | blah blah blah | 20030323225645 | +++--+++ 1 row in set (0.01 sec) Look at the time! It's set ... strange :) 2003 03 23 22 56 45 .. it's not neither now() format, neither unix_timestamp() format. mysql select now(), unix_timestamp(now()); +-+---+ | now() | unix_timestamp(now()) | +-+---+ | 2003-03-23 23:07:30 |1048453650 | +-+---+ 1 row in set (0.01 sec) It's okay. So, why in the query from a php form the unix time date is saved wrong? Any ideas and suggestions? -- best wishes, Strahil Minev a.k.a. DLHelper, BuFu TeaM mailto:[EMAIL PROTECTED] DR Regards, DR -- DR Don Read [EMAIL PROTECTED] DR -- It's always darkest before the dawn. So if you are going to DRsteal the neighbor's newspaper, that's the time to do it. DR (53kr33t w0rdz: sql table query) -- best wishes, Strahil Minev a.k.a. DLHelper, [EMAIL PROTECTED], BuFu TeaM mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Updat not Updating
Hello Andrew,
Friday, March 14, 2003, 6:18:15 PM, you wrote:
A Can anyone tell me why this is not updating records for this table?
A mysql_connect($DBHost,$DBUser,$DBPass);
A mysql($DBName,UPDATE items
A SET ItemSKU='$ItemSKU',
A ItemName='$ItemName',
A ItemDescription='$ItemDescription',
A PostCode='$PostCode',
A Category='$Category',
A CityID='$CityID'
A CTelephone='$CTelephone'
A Cfax='$Cfax'
A Cemail='$Cemail'
A Caddress='$Caddress'
A Cfax='$CTown'
A Cwww='$Cwww'
A WHERE ItemID='$ItemID');
A Andrew
A -
A Before posting, please check:
Ahttp://www.mysql.com/manual.php (the manual)
Ahttp://lists.mysql.com/ (the list archive)
A To request this thread, e-mail [EMAIL PROTECTED]
A To unsubscribe, e-mail [EMAIL PROTECTED]
A Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
There are few simple steps, that everyone should do when using MySQL
within PHP.
1. $connection = mysql_connect('host', 'user', 'pass') or die(Error with connect:
.mysql_error().);
2. mysql_select_db('db_name', $connection) or die(Error with select:
.mysql_error().);
3. $query = ;
4. $result = mysql_query($query, $connection) or die(Error with query:
.mysql_error().);
This steps will provide you information if anything goes wrong and
most import where it goes wrong.
From what you wrote, you didn't placed enough commas in the query.
Follow the steps described above and paste the error log.
www.php.net and www.mysql.com are your friends!
--
best wishes,
Strahil Minev a.k.a. DLHelper,
BuFu TeaM mailto:[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: Updat not Updating
Hello Andrew,
Friday, March 14, 2003, 7:41:56 PM, you wrote:
A yes you are right an I am very stupid for not doing this: It is very important
A for debugging as I now have this error :):)
A Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in
A c:\program files\apache
A group\apache\htdocs\punterspower\admin\updatecompanyresponse.php on line 23
A Error with query: You have an error in your SQL syntax near 'WHERE ItemID='01296
A 483402'' at line 14
A I'm not really happy because I dont know why!!
A Andrew
:: cut ::
A mysql_connect($DBHost,$DBUser,$DBPass);
A mysql($DBName,UPDATE items
A SET ItemSKU='$ItemSKU',
A ItemName='$ItemName',
A ItemDescription='$ItemDescription',
A PostCode='$PostCode',
A Category='$Category',
A CityID='$CityID'
A CTelephone='$CTelephone'
A Cfax='$Cfax'
A Cemail='$Cemail'
A Caddress='$Caddress'
A Cfax='$CTown'
A Cwww='$Cwww'
A WHERE ItemID='$ItemID');
A Andrew
A -
A Before posting, please check:
Ahttp://www.mysql.com/manual.php (the manual)
Ahttp://lists.mysql.com/ (the list archive)
A To request this thread, e-mail [EMAIL PROTECTED]
A To unsubscribe, e-mail [EMAIL PROTECTED]
A Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
There are few simple steps, that everyone should do when using MySQL
within PHP.
1. $connection = mysql_connect('host', 'user', 'pass') or die(Error
with connect: .mysql_error().);
2. mysql_select_db('db_name', $connection) or die(Error with select:
.mysql_error().);
3. $query = ;
4. $result = mysql_query($query, $connection) or die(Error with
query: .mysql_error().);
This steps will provide you information if anything goes wrong and
most import where it goes wrong.
From what you wrote, you didn't placed enough commas in the query.
Follow the steps described above and paste the error log.
www.php.net and www.mysql.com are your friends!
:: cut ::
Okay, I'm not very sure about this, but try ItemID=$ItemID. If it's
not this, then look up your code above. Check if all quotes are closed
properly. If it's still not working then, please, paste your code as is, 1:1 :)
--
best wishes,
Strahil Minev a.k.a. DLHelper,
BuFu TeaM mailto:[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.36 (Linux-Mandrake MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.18 Distrib 3.23.36, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.36-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 3 hours 40 min 58 sec Threads: 7 Questions: 787 Slow queries: 0 Opens: 65 Flush tables: 1 Open tables: 59 Queries per second avg: 0.059 Environment: System: Linux sdbl.teamshopa.com 2.4.3-20mdk #1 Sun Apr 15 23:03:10 CEST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux/2.96/specs gcc version 2.96 2731 (Linux-Mandrake 8.0 2.96-0.48mdk) Compilation info: CC='gcc' CFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math -fno-omit-frame-pointer' CXX='g++' CXXFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math -fno-omit-frame-pointer' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Nov 8 07:29 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1216268 Feb 21 2001 /lib/libc-2.2.2.so -rw-r--r--1 root root 26366908 Feb 21 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Feb 21 2001 /usr/lib/libc.so Configure command: ./configure --enable-shared --enable-thread-safe-client --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man --with-berkeley-db --without-innobase '--with-comment=Linux-Mandrake MySQL RPM' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
