Re: beginner needs help servin up a lan
Well thanks, these look as if to be exactly what i have been looking for. will test this stuff out when i get to work, thanks again. <>< On Tue, 2005-07-12 at 10:10 +0300, Gleb Paharenko wrote: > Hello. > > > These links could be helpful: > http://dev.mysql.com/doc/mysql/en/export-of-data.html > http://dev.mysql.com/doc/mysql/en/mysql-tools-with-access.html > > For more information search in archives at: > http://lists.mysql.com/mysql > > > > > nephish <[EMAIL PROTECTED]> wrote: > > Hello there > > > > i need to import an entire database or find a way to get all the info in > > a microsoft access .mdb database into a MySQL database. > > here is another trick, the access database is on an WinXP computer, the > > MySQL database is on a debian linux computer. They are on the same > > internal network though. > > is this even possible ? if so, where can i read up on how to do it? > > > > thanks, > > shawn <>< > > > > > > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ><___/ www.mysql.com > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: beginner needs help servin up a lan
Hello. These links could be helpful: http://dev.mysql.com/doc/mysql/en/export-of-data.html http://dev.mysql.com/doc/mysql/en/mysql-tools-with-access.html For more information search in archives at: http://lists.mysql.com/mysql nephish <[EMAIL PROTECTED]> wrote: > Hello there > > i need to import an entire database or find a way to get all the info in > a microsoft access .mdb database into a MySQL database. > here is another trick, the access database is on an WinXP computer, the > MySQL database is on a debian linux computer. They are on the same > internal network though. > is this even possible ? if so, where can i read up on how to do it? > > thanks, > shawn <>< > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: beginner needs help servin up a lan
odbc driver for your MySQL database on your windows machine. export tables in access to odbc source that you created On Mon, 11 Jul 2005, nephish wrote: Hello there i need to import an entire database or find a way to get all the info in a microsoft access .mdb database into a MySQL database. here is another trick, the access database is on an WinXP computer, the MySQL database is on a debian linux computer. They are on the same internal network though. is this even possible ? if so, where can i read up on how to do it? thanks, shawn <>< -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner & Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Beginner needs help
This is the 3rd incorrect answer out of 6 replies to this question. It sure is a good thing we have a manual! Yes, you can insert multiple rows with one INSERT statement. You just have to get the correct syntax. It's INSERT [LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name [(col_name,...)] VALUES (expression,...),(...),... See http://www.mysql.com/doc/I/N/INSERT.html Michael On Mon, 25 Feb 2002, daniel wrote: > o > i don't think you can > you'd just have to post two separate insert statments > you can run them both at the same time if you like though > > INSERT INTO table (booknum, isbn, title) values ('001', '1-56592-434-7', > 'MySQL & mSQL'); > INSERT INTO table (booknum, isbn, title) values ('002', '1-56592-257-3', > 'Mastering Regular Expressions'); > > the only other way to do it would be to > import the data from another database like this: > INSERT INTO table [ (coloumn...) ] SELECT ... > > OR > > use a LOAD DATA and import a text file. > > hope that helps > > > - Original Message - > From: "Bob Rea" <[EMAIL PROTECTED]> > To: "daniel" <[EMAIL PROTECTED]> > Sent: Monday, February 25, 2002 4:40 PM > Subject: Re: Beginner needs help > > > > On Monday 25 February 2002 03:51 pm, you wrote: > > > my $0.02: > > > > > > insert into TABLE (booknum, isbn, title) values ('001', > > > '1-56592-434-7', 'MySQL & mSQL'); > > > > > > you want to keep all your field names on the left of > > > values and all your data on the right. only two sets of > > > brackets "()". > > > > But I'm trying to insert *two* sets of values in the same > > insert statement. What am I doing wrong? > > > > -- > > Bob Rea > > - 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: Beginner needs help
o i don't think you can you'd just have to post two separate insert statments you can run them both at the same time if you like though INSERT INTO table (booknum, isbn, title) values ('001', '1-56592-434-7', 'MySQL & mSQL'); INSERT INTO table (booknum, isbn, title) values ('002', '1-56592-257-3', 'Mastering Regular Expressions'); the only other way to do it would be to import the data from another database like this: INSERT INTO table [ (coloumn...) ] SELECT ... OR use a LOAD DATA and import a text file. hope that helps - Original Message - From: "Bob Rea" <[EMAIL PROTECTED]> To: "daniel" <[EMAIL PROTECTED]> Sent: Monday, February 25, 2002 4:40 PM Subject: Re: Beginner needs help > On Monday 25 February 2002 03:51 pm, you wrote: > > my $0.02: > > > > insert into TABLE (booknum, isbn, title) values ('001', > > '1-56592-434-7', 'MySQL & mSQL'); > > > > you want to keep all your field names on the left of > > values and all your data on the right. only two sets of > > brackets "()". > > But I'm trying to insert *two* sets of values in the same > insert statement. What am I doing wrong? > > -- > Bob Rea > > ** >"On the side of the box, under 'System > Requirements', it said 'Requires Windows > 95 or better'. So I installed Linux." > ** > > [EMAIL PROTECTED] http://home.earthlink.net/~sfpetard/ > - 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: Beginner needs help
Bob, This is just a guess, but looking at http://www.mysql.com/doc/I/n/Insert_speed.html it appears that the way to do multiple inserts looks like: INSERT INTO a VALUES (1,23),(2,34),(4,33); a(col1, col2).. Perhaps multiple inserts requires that you specify all columns in the order that the table was defined? I suggest you try: INSERT into book values ( null, #booknum '1-56592-434-7', #isbn 'MySQL & mSQL',#title 'Yarger', #authlname 'Randy Jay', #authfname "O'Reilly",#publisher null,#pubdate null, #dewey null, #lcnum null,#checkin null,#checkout null #duedate ), values( null, '0-312-25313-3', 'Coup de Grace', 'Borthwick', 'J S', "St Martin's Minotaur", null, '813.54-dc21', 'PS3552.O756 C68 2000' null, null, null ); > -Original Message- > From: Bob Rea [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 25, 2002 3:34 PM > To: [EMAIL PROTECTED] > Subject: Beginner needs help > > > I'm getting a syntax error when I try to insert more two > sets of values into a table. > > I have looked at the manual on the insert statement, and > don't see what is wrong. > > Can someone tell me. > > Here's the info. > mysql> describe book; > +---+-+--+-+-++ > | Field | Type| Null | Key | Default | Extra > | > +---+-+--+-+-++ > | booknum | int(20) | | PRI | NULL| > auto_increment | > | isbn | varchar(14) | YES | | NULL| > | > | title | varchar(50) | YES | | NULL| > | > | authlname | varchar(20) | YES | | NULL| > | > | authfname | varchar(20) | YES | | NULL| > | > | publisher | varchar(20) | YES | | NULL| > | > | pubdate | date| YES | | NULL| > | > | dewey | varchar(20) | YES | | NULL| > | > | lcnum | varchar(20) | YES | | NULL| > | > | checkin | date| YES | | NULL| > | > | checkout | date| YES | | NULL| > | > | duedate | date| YES | | NULL| > | > +---+-+--+-+-++ > 12 rows in set (0.00 sec) > > Here's the attempt: > mysql> INSERT into book( > -> isbn, > -> title, > -> authlname, > -> authfname, > -> publisher, > -> pubdate, > -> dewey, > -> lcnum > -> ) > -> values ( > -> '1-56592-434-7', > -> 'MySQL & mSQL', > -> 'Yarger', > -> 'Randy Jay', > -> "O'Reilly", > -> null, > -> null, > -> null > -> ), > -> values( > -> '0-312-25313-3', > -> 'Coup de Grace', > -> 'Borthwick', > -> 'J S', > -> "St Martin's Minotaur", > -> null, > -> '813.54-dc21', > -> 'PS3552.O756 C68 2000' > -> ); > ERROR 1064: You have an error in your SQL syntax near > 'values( > '0-312-25313-3', > 'Coup de Grace', > 'Borthwick', > 'J S', > "St Martin's Minot' at line 21 > > TIA > > -- > Bob Rea > > ** >"On the side of the box, under 'System > Requirements', it said 'Requires Windows > 95 or better'. So I installed Linux." > ** > > [EMAIL PROTECTED] http://home.earthlink.net/~sfpetard/ > > - > 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 > > - 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: Beginner needs help
Change it to INSERT into book( isbn, title, authlname, authfname, publisher, pubdate, dewey, lcnum ) values ( '1-56592-434-7', 'MySQL & mSQL', 'Yarger', 'Randy Jay', "O'Reilly", null, null, null ), ( '0-312-25313-3', 'Coup de Grace', 'Borthwick', 'J S', "St Martin's Minotaur", null, '813.54-dc21', 'PS3552.O756 C68 2000' ); i.e. drop 'values' for the second row Regards Dan > -Original Message- > From: Bob Rea [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 26 February 2002 12:34 p.m. > To: [EMAIL PROTECTED] > Subject: Beginner needs help > > > I'm getting a syntax error when I try to insert more two > sets of values into a table. > > I have looked at the manual on the insert statement, and > don't see what is wrong. > > Can someone tell me. > > Here's the info. > mysql> describe book; > +---+-+--+-+-++ > | Field | Type| Null | Key | Default | Extra > | > +---+-+--+-+-++ > | booknum | int(20) | | PRI | NULL| > auto_increment | > | isbn | varchar(14) | YES | | NULL| > | > | title | varchar(50) | YES | | NULL| > | > | authlname | varchar(20) | YES | | NULL| > | > | authfname | varchar(20) | YES | | NULL| > | > | publisher | varchar(20) | YES | | NULL| > | > | pubdate | date| YES | | NULL| > | > | dewey | varchar(20) | YES | | NULL| > | > | lcnum | varchar(20) | YES | | NULL| > | > | checkin | date| YES | | NULL| > | > | checkout | date| YES | | NULL| > | > | duedate | date| YES | | NULL| > | > +---+-+--+-+-++ > 12 rows in set (0.00 sec) > > Here's the attempt: > mysql> INSERT into book( > -> isbn, > -> title, > -> authlname, > -> authfname, > -> publisher, > -> pubdate, > -> dewey, > -> lcnum > -> ) > -> values ( > -> '1-56592-434-7', > -> 'MySQL & mSQL', > -> 'Yarger', > -> 'Randy Jay', > -> "O'Reilly", > -> null, > -> null, > -> null > -> ), > -> values( > -> '0-312-25313-3', > -> 'Coup de Grace', > -> 'Borthwick', > -> 'J S', > -> "St Martin's Minotaur", > -> null, > -> '813.54-dc21', > -> 'PS3552.O756 C68 2000' > -> ); > ERROR 1064: You have an error in your SQL syntax near > 'values( > '0-312-25313-3', > 'Coup de Grace', > 'Borthwick', > 'J S', > "St Martin's Minot' at line 21 > > TIA > > -- > Bob Rea > > ** >"On the side of the box, under 'System > Requirements', it said 'Requires Windows > 95 or better'. So I installed Linux." > ** > > [EMAIL PROTECTED] http://home.earthlink.net/~sfpetard/ > > - > 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 > > - 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: Beginner needs help
Get rid of the second "values". mysql> INSERT into book( -> isbn, -> title, -> authlname, -> authfname, -> publisher, -> pubdate, -> dewey, -> lcnum -> ) -> values ( -> '1-56592-434-7', -> 'MySQL & mSQL', -> 'Yarger', -> 'Randy Jay', -> "O'Reilly", -> null, -> null, -> null -> ), -> ( -> '0-312-25313-3', -> 'Coup de Grace', -> 'Borthwick', -> 'J S', -> "St Martin's Minotaur", -> null, -> '813.54-dc21', -> 'PS3552.O756 C68 2000' -> ); - Original Message - From: "Bob Rea" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 25, 2002 4:33 PM Subject: Beginner needs help I'm getting a syntax error when I try to insert more two sets of values into a table. I have looked at the manual on the insert statement, and don't see what is wrong. Can someone tell me. Here's the info. mysql> describe book; +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | booknum | int(20) | | PRI | NULL| auto_increment | | isbn | varchar(14) | YES | | NULL| | | title | varchar(50) | YES | | NULL| | | authlname | varchar(20) | YES | | NULL| | | authfname | varchar(20) | YES | | NULL| | | publisher | varchar(20) | YES | | NULL| | | pubdate | date| YES | | NULL| | | dewey | varchar(20) | YES | | NULL| | | lcnum | varchar(20) | YES | | NULL| | | checkin | date| YES | | NULL| | | checkout | date| YES | | NULL| | | duedate | date| YES | | NULL| | +---+-+--+-+-++ 12 rows in set (0.00 sec) Here's the attempt: mysql> INSERT into book( -> isbn, -> title, -> authlname, -> authfname, -> publisher, -> pubdate, -> dewey, -> lcnum -> ) -> values ( -> '1-56592-434-7', -> 'MySQL & mSQL', -> 'Yarger', -> 'Randy Jay', -> "O'Reilly", -> null, -> null, -> null -> ), -> values( -> '0-312-25313-3', -> 'Coup de Grace', -> 'Borthwick', -> 'J S', -> "St Martin's Minotaur", -> null, -> '813.54-dc21', -> 'PS3552.O756 C68 2000' -> ); ERROR 1064: You have an error in your SQL syntax near 'values( '0-312-25313-3', 'Coup de Grace', 'Borthwick', 'J S', "St Martin's Minot' at line 21 TIA -- Bob Rea ** "On the side of the box, under 'System Requirements', it said 'Requires Windows 95 or better'. So I installed Linux." ** [EMAIL PROTECTED] http://home.earthlink.net/~sfpetard/ - 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 - 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: Beginner needs help
On Tuesday, 26. February 2002 00:33, Bob Rea wrote: > I'm getting a syntax error when I try to insert more two > sets of values into a table. > > I have looked at the manual on the insert statement, and > don't see what is wrong. > > ERROR 1064: You have an error in your SQL syntax near > 'values( > '0-312-25313-3', > 'Coup de Grace', > 'Borthwick', > 'J S', > "St Martin's Minot' at line 21 Correct Syntax is INSERT INTO table (fields,..) VALUES (values,...) You try to use to insert 2 or more records with one insert statement, that isnt allowed, and therefore the syntax error. Regards Georg mysql,query - 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: Beginner needs help
At 15:33 -0800 2/25/02, Bob Rea wrote: >I'm getting a syntax error when I try to insert more two >sets of values into a table. > >I have looked at the manual on the insert statement, and >don't see what is wrong. The error message indicates that the problem is at the word "values". The problem with your syntax is that "values should occur only once: INSERT INTO tbl_name (column list) VALUES (list of values), (list of values); > >Can someone tell me. > >Here's the info. >mysql> describe book; >+---+-+--+-+-++ >| Field | Type| Null | Key | Default | Extra > | >+---+-+--+-+-++ >| booknum | int(20) | | PRI | NULL| >auto_increment | >| isbn | varchar(14) | YES | | NULL| > | >| title | varchar(50) | YES | | NULL| > | >| authlname | varchar(20) | YES | | NULL| > | >| authfname | varchar(20) | YES | | NULL| > | >| publisher | varchar(20) | YES | | NULL| > | >| pubdate | date| YES | | NULL| > | >| dewey | varchar(20) | YES | | NULL| > | >| lcnum | varchar(20) | YES | | NULL| > | >| checkin | date| YES | | NULL| > | >| checkout | date| YES | | NULL| > | >| duedate | date| YES | | NULL| > | >+---+-+--+-+-++ >12 rows in set (0.00 sec) > >Here's the attempt: >mysql> INSERT into book( > -> isbn, > -> title, > -> authlname, > -> authfname, > -> publisher, > -> pubdate, > -> dewey, > -> lcnum > -> ) > -> values ( > -> '1-56592-434-7', > -> 'MySQL & mSQL', > -> 'Yarger', > -> 'Randy Jay', > -> "O'Reilly", > -> null, > -> null, > -> null > -> ), > -> values( > -> '0-312-25313-3', > -> 'Coup de Grace', > -> 'Borthwick', > -> 'J S', > -> "St Martin's Minotaur", > -> null, > -> '813.54-dc21', > -> 'PS3552.O756 C68 2000' > -> ); >ERROR 1064: You have an error in your SQL syntax near >'values( >'0-312-25313-3', >'Coup de Grace', >'Borthwick', >'J S', >"St Martin's Minot' at line 21 > >TIA > >-- >Bob Rea > >** >"On the side of the box, under 'System > Requirements', it said 'Requires Windows > 95 or better'. So I installed Linux." >** > >[EMAIL PROTECTED] http://home.earthlink.net/~sfpetard/ > >- >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 - 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: Beginner needs help
I can answer numb 1. for you but not 2. Look up the manual for mysqldump and load infile (or something like that, I have to check the manual myself but I have no time to do that for you). The other (and probably easier way) is to upgrade your Cobalt machine and then upgrade your tables from ISM to MYISM. If you do that, you can then just copy the .MYD, .MYI and .FRM files from one machine to another. - Original Message - From: "Lee Woolcott" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 06, 2001 2:40 Subject: Beginner needs help > Hello > > Please excuse my ignorance, I am very, very new to databases and escpecially > MySql. > > I have a couple of questions that I would be most grateful if someone could > answer for me. > > 1. I have a Cobalt Raq4 with mysql 3.22.32 installed. I also have a Win98 > machine with 3.23.33 installed. I have managed to set up a simple test db on > my windows machine and pull out data with ASP, using PWS. I have also > managed to set up a simple db on the Raq but have noticed that the database > file extensions are different. The raq has .ISD, .ISM and .FRM where as the > windows box has .MYD, .MYI and .FRM. > Does this mean that I can't design the DB on my windows box and upload it to > work on the Raq? > If it can be done can someone please advise me on how to do this. > > 2. I don't seem to be able to make a connection using the ASP admin pages on > the Raq. I keep getting "can't open connection". Can someone enlighten me > please, I have followed the instructions very closely. It seems that > everything on the Raq is different to what is stated in the MySql manual? > i.e running mysqld gives me command not found but it will run with > safe_mysqld, the data is stored in a different dir etc. > > I am sorry if I am being simple but all I want to do is set up a basic site > that will get info from a db using chilisoft ASP. > > I thank you in advance and once again please excuse my ignorance. > > Best Regards > > Lee > > > - > 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 - 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