win32 batch scripts
i would like to know how to write batch script for dumping schema and data into a sql file. This script should dump the whole database and data - 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: mysql
SPAM ALERT -Original Message- From: va ku [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 11:04 AM To: [EMAIL PROTECTED] Subject: mysql mysql See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_02 0201/splash.asp - 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: Do any of your applications work?
I agree with everyone that has responded. A vague answer that does nothing but moan about something that is more or less incompentence from your developmental team. Not only that, but you have a support contract, so why you asking a question here? Shouldn't you be calling your support for this answer? -Original Message- From: Hugh O'Loughlin [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 06, 2002 6:32 AM To: [EMAIL PROTECTED] Subject: Do any of your applications work? Responsible Person, We have been asked by a client, to use your products in our intergration efforts. Your MySQL 3.23.49a [Stable version?] for Sun Solaris x86, version, 5.8, is offered without the installation file ./scripts/mysql_install_db. The ./scripts/mysql_install_db, that comes with it, is EMPTY! Your MySQL-MAX 3.23.49a, although it gets a little further along in the installation phase [in that a deamon start-up], only some of the commands are execuatble/executing. This is not a normal [nor acceptable] situation in the UNIX world, when commands in the same directory are not all executable [No PATH problems here]. None of the following commands seem to work: mysql, mysqladmin, BINDER/(anything), just to name a few. The instructions were followed to the dot [as we have previously done with REDHat Linux 7.2, of the above mentioned]. We have also come to find, that your JDBC [mm.mysql.jdbc-1.2c.tar.gz] driver currently has a problem in being recognised in the FORTE developement environment. Please know, that we are not at all new to the communal-developement environment. However, whenevr anything is posted to be working, it should be exactly that. Ommission errors of the magnitude we have found, are pure 'Microsoftish' in nature, and should have no place anywhere, integrity not withstanding. Besides our practice of believing, that sometimes bad things happen to good people/things, perhaps by us bringing these faults to your attention that some good will come of this. In the meatime, I await a prompt response. As for our client, depending upon your promptness, they may not cancel the current licensing agreement with you. H. O'Loughlin, CEO O'LOUGHLIN ASSOCIATES CORPORATIION CC:/BLIND LIST - 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: MySQL Book
I agree with Chris... Writing a book on features that do not exist yet is asking for trouble. -Original Message- From: Christopher Thompson [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 12:00 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MySQL Book On Friday 05 April 2002 10:29 am, [EMAIL PROTECTED] wrote: > We are writing a book about MySQL. There will be emphasis on using MySQL > with perl/php, .net & java. The publisher needs lots of emphasis on SPs and > nested subqueries. We need to be able to write about implementing biz rules > using table constraints, which means FKs. Your site says 4.1 is to have I must say, I think this is rather short-sighted of your publisher. I obviously do not speak for the MySQL folks but I don't think you should write a book on product features which do not exist yet. That said, it is often a better idea to move business logic out of the database and into another layer instead. At my previous job, we had to do this with MS SQL Server 2000 because the built-in triggers and foreign keys and the like were simply too slow so we did it programatically instead. Of course, we still used tranactions to ensure things were either all committed or all rolled back. In my opinion, this is the right approach to take with MySQL. - 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: Help. I have truly blundered.
Wow John... Sounds like you are in deep chit... Just kidding... Linux 6 doesn't say which distro it is, same with mysql 3, there are a bunch of mysql version3s out there. Your problem... Log into as root then restart it. -Original Message- From: john [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 4:10 PM To: MySQL Lists Subject: Help. I have truly blundered. Please help with ignorance, I was in mysqld making some changes to a database. I run a Linux 6 box with MySQL 3 on it. I was logged in as user john, who has all access privelages to mysqld. John is not root, and I told mysql to stop. Well, mysql will not start again. What can I do? - 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: Password function still doesn't working
Im going to take a shot in the dark since I have not messed with ASP in years Have you just tried to verify the data is there with a simpler script? Just do the connection script then the user_check then see if it is still there. If it was PHP I would be able to find it. -Original Message- From: Ramiro Varandas Jr [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 1:28 PM To: [EMAIL PROTECTED] Subject: Password function still doesn't working I thank all the people that helped me... was very usefull, I tried each one... But i'm using ASP with a DSN Connection Check the code: Set MyConnection = Server.CreateObject("ADODB.Connection") MyConnInfo = "DSN=MyDSN;UID=MyUser;PWD=MyPass;" MyConnection.Open MyConnInfo SQL = "INSERT INTO user (user_name, user_pass) VALUES ('" & user_name & "',PASSWORD('" & user_pass & "')" MyConn.Execute(SQL) USER_CHECK = "SELECT user_id FROM user WHERE user_pass = PASSWORD('" & user_pass & "')" Set MyResult = MyConn.Execute(USER_CHECK) If MyResult.BOF And MyResult.EOF Then Response.Write("User not found!") MyResult.Close Set MyResult = Nothing Else USER_ID = MyResult("user_id") Response.Write("USER ID is: " & USER_ID) MyResult.Close Set MyResult = Nothing End If MyConnection.Close Set MyConnection = Nothing The ASP code works fine, but when I verify if the user exists by using the PASSWORD i get the 'User not found!' response, which means that it didn't found any one... Any tip... Regards, Ramiro - 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: mysql forum
How about newsgroups for php? They have a couple on php/mysql I believe and they respond quite quickly... Look at php.net -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 12:12 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: mysql forum Here's a good one: http://www.xmbforum.com/ -Original Message- From: Javier Gloria [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 11:27 AM To: mysql Subject: mysql forum Hi everybody: where i can find a forum than works with php,mysql. for my site. or the source code for one. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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 - 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: Beginners Question
Yes, mySQL is up to the task. Just make sure you design the DB with fast retrivals in mind -Original Message- From: Zhao, Charles [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 3:53 PM To: '[EMAIL PROTECTED]' Subject: Beginners Question Hello there, I am trying to find which database to use. I will have text and image data. Lots of image data. Most of the time I am doing data retrieving, but when updating, it will be text almost always. No enterprise use, but very busy database hits. Could any one please educate me if mysql is a good database for this purpose? Or anything else? Many thanks. -- charles - 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: Why does my delete not work :(
Ooops... Forgot something $sql =" SELECT messages.topicid FROM messages LEFT OUTER JOIN main ON messages.topicid=main.topicid WHERE main.topicid = 'NULL' "; $result = @mysql_query($sql, $connection) or die("Could not execute query"); While ($row =mysql_fetch_arrary($result)) { $sql2 = "DELETE FROM messages WHERE topicid = $row ="[0]" "; } -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 6:47 PM To: 'sunny'; 'Rodney Broom'; [EMAIL PROTECTED] Subject: RE: Why does my delete not work :( Sunny... Pay close attention.. You are trying to execute a query that is a bit complex for someone new to mySQL and PHP. -Original Message- From: sunny [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 6:18 PM To: Rodney Broom; [EMAIL PROTECTED] Subject: Re: Why does my delete not work :( So you're saying there's no actual DELETE statement for this? There is no way in hell I can write any SQL to do that?? Thats sucks... :( Thanks for the example, but how do I run it? I've only used PHP for taking information out of a database and other simple MySQL queries so while your Perl example kinda makes sense, I don't understand how to work it. Do I just put that in a file and run open the file in a browser? Thanks! sunny At 08:12 29/03/02 -0700, Rodney Broom wrote: >Good morning Sunny, > > >From: sunny <[EMAIL PROTECTED]> > > > ...substituting SELECT with DELETE doesn't work :( > >That's right, that's how MySQL works. And it doesn't support sub-queries >for this case, either. So you can't say: > > delete from table where field in (select field from other_table) > >I'd suggest doing this from another language, like Perl. For instance: > > $list_list = $dbh->selectall_arrayref(qq{ > SELECT messages.topicid > FROM messages > LEFT OUTER JOIN main > ON messages.topicid=main.topicid > WHERE main.topicid is null > }); > > for my $row ( @{$list_list} ) { > $dbh->do(qq{DELETE FROM messages WHERE topicid = $row->[0]}); > } > > >Note, my example is rough, and not tuned for performance. But you get the >idea. Hollar if you still need a hand with this. > > > >--- >Rodney Broom >Programmer: Desert.Net > > > > >- >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 - 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: Why does my delete not work :(
Sunny... Pay close attention.. You are trying to execute a query that is a bit complex for someone new to mySQL and PHP. $sql =" SELECT messages.topicid FROM messages LEFT OUTER JOIN main ON messages.topicid=main.topicid WHERE main.topicid = 'NULL' $result = @mysql_query($sql, $connection) or die("Could not execute query"); While ($row =mysql_fetch_arrary($result)) { $sql2 = "DELETE FROM messages WHERE topicid = $row ="[0]" "; } -Original Message- From: sunny [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 6:18 PM To: Rodney Broom; [EMAIL PROTECTED] Subject: Re: Why does my delete not work :( So you're saying there's no actual DELETE statement for this? There is no way in hell I can write any SQL to do that?? Thats sucks... :( Thanks for the example, but how do I run it? I've only used PHP for taking information out of a database and other simple MySQL queries so while your Perl example kinda makes sense, I don't understand how to work it. Do I just put that in a file and run open the file in a browser? Thanks! sunny At 08:12 29/03/02 -0700, Rodney Broom wrote: >Good morning Sunny, > > >From: sunny <[EMAIL PROTECTED]> > > > ...substituting SELECT with DELETE doesn't work :( > >That's right, that's how MySQL works. And it doesn't support sub-queries >for this case, either. So you can't say: > > delete from table where field in (select field from other_table) > >I'd suggest doing this from another language, like Perl. For instance: > > $list_list = $dbh->selectall_arrayref(qq{ > SELECT messages.topicid > FROM messages > LEFT OUTER JOIN main > ON messages.topicid=main.topicid > WHERE main.topicid is null > }); > > for my $row ( @{$list_list} ) { > $dbh->do(qq{DELETE FROM messages WHERE topicid = $row->[0]}); > } > > >Note, my example is rough, and not tuned for performance. But you get the >idea. Hollar if you still need a hand with this. > > > >--- >Rodney Broom >Programmer: Desert.Net > > > > >- >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 - 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: Why does my delete not work :(
Here: mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 6:18 PM To: Rodney Broom; [EMAIL PROTECTED] Subject: Re: Why does my delete not work :( So you're saying there's no actual DELETE statement for this? There is no way in hell I can write any SQL to do that?? Thats sucks... :( Thanks for the example, but how do I run it? I've only used PHP for taking information out of a database and other simple MySQL queries so while your Perl example kinda makes sense, I don't understand how to work it. Do I just put that in a file and run open the file in a browser? Thanks! sunny At 08:12 29/03/02 -0700, Rodney Broom wrote: >Good morning Sunny, > > >From: sunny <[EMAIL PROTECTED]> > > > ...substituting SELECT with DELETE doesn't work :( > >That's right, that's how MySQL works. And it doesn't support sub-queries >for this case, either. So you can't say: > > delete from table where field in (select field from other_table) > >I'd suggest doing this from another language, like Perl. For instance: > > $list_list = $dbh->selectall_arrayref(qq{ > SELECT messages.topicid > FROM messages > LEFT OUTER JOIN main > ON messages.topicid=main.topicid > WHERE main.topicid is null > }); > > for my $row ( @{$list_list} ) { > $dbh->do(qq{DELETE FROM messages WHERE topicid = $row->[0]}); > } > > >Note, my example is rough, and not tuned for performance. But you get the >idea. Hollar if you still need a hand with this. > > > >--- >Rodney Broom >Programmer: Desert.Net > > > > >- >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 - 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: pb while querying in strange db name
You need to use the use command Mysql> \u [databasename] Now you may run the query Mysql> select * FROM dbname.table; -Original Message- From: David yahoo [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 4:25 PM Cc: [EMAIL PROTECTED] Subject: pb while querying in strange db name Hi all, I ve got a database with the name db-name when making : select * from db-name.table; I get a error. something is wrong in your syntex near : -name ... How can I tell mysql that db-name is a database name ? Thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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: hmm
Harry, It is you need to make a WEB front end to access it -Original Message- From: Harry Rorarius [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 10:49 AM To: Mysql list Subject: hmm ok I thought Mysql was a server that could be used as a online database? If it is, is there some material I have not read that tells me how to do this? I understood most of the information I read about Mysql. I was under the understanding sql is the way to make a online database Harry - 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: MYSQL on a Cobalt RaQ4
Yes, my hosting providers use raq servers and I have mysql databases on all of my domains -Original Message- From: Denis Croombs [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 8:30 AM To: Mysql (E-mail) Subject: MYSQL on a Cobalt RaQ4 Hi Will MySQL run on a Cobalt RaQ4 server ? Denis Croombs - 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: phpMyAdmin issue
The problem is PHP and IIS... IIS takes a lot to get it to work... I think you should ask sourceforge about it, not the mysql mailing list. This is a PHP issue not a mysql. -Original Message- From: CATRIONA GRISEWO0D [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 6:24 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: phpMyAdmin issue Hi I have got phpMyAdmin connecting to my server. When i open up index i can see on the left hand side my datbase and tables. And on the right of the page is the welcome page... Welcome to phpMyAdmin 2.2.5 MySQL 3.23.32 running on 136.201.105.3 as [EMAIL PROTECTED] phpMyAdmin <<...OLE_Obj...>> Top of Form 1 <<...OLE_Obj...>> Language: <<...OLE_Obj...>> <<...OLE_Obj...>> Bottom of Form 1 <<...OLE_Obj...>> phpMyAdmin documentation <<...OLE_Obj...>> Official phpMyAdmin Homepage <<...OLE_Obj...>> Sourceforge phpMyAdmin Download Page [ChangeLog] [CVS] [Lists] I seem to be missing the bit where you create a database etc. Then if I click on my database on the left hand side i get the error: CGI Error The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are: hh any ideas ? im sorry but im a complete beginner here - 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: phpMyAdmin issue + looking for php/mysql websites
Read the documentation. Where is the mySQL database located? Is it on the web server or on another machine? If its on another machine then you put in the IP address. If its on the same machine as the Web Server, then put in localhost Get it? -Original Message- From: catriona grisewood [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 2:55 PM To: Hathaway, Scott L; 'Andreas_Frxsting'; [EMAIL PROTECTED] Subject: RE: phpMyAdmin issue + looking for php/mysql websites when im connecting to an online MySQL server do i just put in the server name ie 'orac'in the config file or do i need to put in its ip address etc with it ? --- "Hathaway, Scott L" <[EMAIL PROTECTED]> wrote: > I use PHP (cgi) with IIS and phpMyAdmin. The > problem with the header > function is just that a couple of the .inc files > with phpMyAdmin need to > have the extra lines after the ?> deleted. But, > that message says that the > headers have already been sent out. The error below > usually means a 404 > error if you are using a template. If not, it > usually means that you have > forgotten something like a curly brace or a script > ending. > > Post your code and it will be easier to help. > > Scott > > -Original Message- > From: Andreas Frosting [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 26, 2002 2:27 PM > To: 'catriona grisewood'; [EMAIL PROTECTED] > Subject: RE: phpMyAdmin issue + looking for > php/mysql websites > > > > "The specified CGI application misbehaved by not > > returning a complete set of HTTP headers. The > headers > > it did return are:" > > Looks like you're running phpMyAdmin on a machine > with Windows and PHP > in CGI-mode? > I don't recall if it's PHP in CGI-mode on Windows > that in general > doesn't work with the header()-function or if it's > only IIS. > > The solution is to install PHP as non-cgi... Don't > know how that is done > as I'm using FreeBSD, but know you know whats wrong > :) > > > I dont think i set up mySQL properly maybe ? > > The problem is not related to MySQL. > > :wq > //andreas > http://phpwizard.dk/ (in Danish only) > > > - > 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 __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy AwardsR http://movies.yahoo.com/ - 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: phpMyAdmin issue + looking for php/mysql websites
Is there a reason why you are using IIS? I would disable IIS and run apache. That's what I did, IIS is way to difficult and unstable to install PHP as CGI or ISAPI Apache is easy to set up with PHP. Download Apache and run PHP from there. Make sure you disable ALL the IIS services -Original Message- From: catriona grisewood [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 2:45 PM To: Hathaway, Scott L; 'Andreas_Frxsting'; [EMAIL PROTECTED] Subject: RE: phpMyAdmin issue + looking for php/mysql websites Im not sure what way php is installed as it was already installed on the server here. How i got this message exactly was when i opened up MyphpMyAdmin after just installing it. I go to create a new datbase and thats when the error page comes up. Could it be i dont have the config file setup correctly ? or maybe MySQL isnt configured correctly ? i dont know if that helps ? Thanks for any help --- "Hathaway, Scott L" <[EMAIL PROTECTED]> wrote: > I use PHP (cgi) with IIS and phpMyAdmin. The > problem with the header > function is just that a couple of the .inc files > with phpMyAdmin need to > have the extra lines after the ?> deleted. But, > that message says that the > headers have already been sent out. The error below > usually means a 404 > error if you are using a template. If not, it > usually means that you have > forgotten something like a curly brace or a script > ending. > > Post your code and it will be easier to help. > > Scott > > -Original Message- > From: Andreas Frosting [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 26, 2002 2:27 PM > To: 'catriona grisewood'; [EMAIL PROTECTED] > Subject: RE: phpMyAdmin issue + looking for > php/mysql websites > > > > "The specified CGI application misbehaved by not > > returning a complete set of HTTP headers. The > headers > > it did return are:" > > Looks like you're running phpMyAdmin on a machine > with Windows and PHP > in CGI-mode? > I don't recall if it's PHP in CGI-mode on Windows > that in general > doesn't work with the header()-function or if it's > only IIS. > > The solution is to install PHP as non-cgi... Don't > know how that is done > as I'm using FreeBSD, but know you know whats wrong > :) > > > I dont think i set up mySQL properly maybe ? > > The problem is not related to MySQL. > > :wq > //andreas > http://phpwizard.dk/ (in Danish only) > > > - > 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 __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy AwardsR http://movies.yahoo.com/ - 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: mysql/php on Win2000
IIS Services to kill: IIS Admin FTP Publishing Service World Wide Wb Publishing Service If my memory serves me right, if you stop the IIS admin service the rest will stop as well. But remember to disable them by going into Start | Admin Tools | Services And right click on them chose Properties and select "Disable" in the drop down box -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 12:34 PM To: 'Todd Williamsen' Cc: [EMAIL PROTECTED] Subject: RE: mysql/php on Win2000 Hi, if you think that IIS and Apache are going to have problems co-habitating then, yes, please tell me which services to kill. On the other hand, I'm not using IIS for anything else, maybe I should try to uninstall it before installing Apache??? Thanks. Andrew Hazen Spam filter: mysql -Original Message----- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 1:29 PM To: 'Andrew Hazen'; [EMAIL PROTECTED] Subject: RE: mysql/php on Win2000 IIS: Kill the services, and disable them If you need to know which ones let me know. Oracle8i: No, they use different ports. I run Oracle8, mySQL, SQL Server7 without any problems -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 10:24 AM To: [EMAIL PROTECTED] Subject: mysql/php on Win2000 Hi, I want to set up my home computer (PIII,Win2000) for development and testing of php/mysql work. I know that both will install and work on a Win2000 box, my questions are about potential conflicts: My Win2000 came with IIS, are there any hitches to using php/mysql with IIS? Should I install Apache, and if so, do I need to completely uninstall IIS? I have a development edition of Oracle 8i running on the box already. Will this create conflicts with mysql? Does mysql run as a service that I can turn off like Oracle?(in other words, can I turn each on/off depending which I'm working with? Or are they happy running side by side on the same box?) Any advice, or links to useful docs would be appreciated. Andrew Hazen Database Developer Jatech Solutions Inc. 160 Bartley Drive Toronto, ON M4A 1E1 www.jatech.ca 416-288-9833 - 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: mysql/php on Win2000
I have found Win2k completely stable with Apache/PHP/mySQL. Not one issue! If you are talking IIS combo, then yes issues will arise. I don't see any performance hit on this setup as a CGI. I think you are being a bit bias towards Windoze. Windows 2k is quite stable. The thing about win2k is that it is as stable as the person who built it. I prefer to run PHP/mysql on its native platform of linux, but it runs great on both systems. -Original Message- From: Curtis Maurand [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 11:34 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: mysql/php on Win2000 The only problem with Win2K is that a lot of the components for PHP aren't there. Also PHP will run as an ISAPI module, but its not recommended. The preferred method is as a CGI (read 25% performance hit). Win2K doesn't multi-task/multi-thread as well as either of the *nix's mentioned and its not as efficient with memory utilization/swap as any *nix on or off the market. Even OS/2 was better about it than Windoze is. Also bear in mind that I've never found Windows to be anywhere near as stable as Unix, though its gotten better. Curtis Chris Hedemark said: >> Any advice, or links to useful docs would be appreciated. > > You did say *any* advice. Keep that in mind... > > My advice to you is to load some popular flavor of UNIX on that > machine, such as Linux or OpenBSD, in order to have a more standard > environment for this. Windows may work, but you're going to be very > lonely finding help for that combination of OS and software. But on > the UNIX side you can't throw a rock without hitting someone who is > effectively running the combination of UNIX/Apache/MySQL/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 - 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: mysql/php on Win2000
IIS: Kill the services, and disable them If you need to know which ones let me know. Oracle8i: No, they use different ports. I run Oracle8, mySQL, SQL Server7 without any problems -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 10:24 AM To: [EMAIL PROTECTED] Subject: mysql/php on Win2000 Hi, I want to set up my home computer (PIII,Win2000) for development and testing of php/mysql work. I know that both will install and work on a Win2000 box, my questions are about potential conflicts: My Win2000 came with IIS, are there any hitches to using php/mysql with IIS? Should I install Apache, and if so, do I need to completely uninstall IIS? I have a development edition of Oracle 8i running on the box already. Will this create conflicts with mysql? Does mysql run as a service that I can turn off like Oracle?(in other words, can I turn each on/off depending which I'm working with? Or are they happy running side by side on the same box?) Any advice, or links to useful docs would be appreciated. Andrew Hazen Database Developer Jatech Solutions Inc. 160 Bartley Drive Toronto, ON M4A 1E1 www.jatech.ca 416-288-9833 - 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: mysql/php on linux
Sounds like php isn't compiled correctly. Make sure the module for php is installed in apache -Original Message- From: Andy Cheng [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 23, 2002 1:48 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: mysql/php on linux Hello all, Thanks for the help. I move my php test script to \var\www\html When I call the php script from my browser, It shows me: and not result of the phpinfo() function. When I run "php phpinfo()" at the shell command, it out puts the html result. What is problem, my Apache not understand the php script? Thanks >From: Jim Philips <[EMAIL PROTECTED]> >To: Andy Cheng <[EMAIL PROTECTED]> >Subject: RE: mysql/php on linux >Date: 18 Mar 2002 21:59:09 -0500 > >You should not save php scripts in cgi-bin. They need to be in your >document root directory or a sub-directory of the rooot directory. In my >case, document root is: > >/usr/local/apache/htdocs > >If you need a test script, you can just run this: > > >phpinfo(); > >?> > >If it is in the document root directory, just point your browser to: > >localhost/(script name) > >If everything is installed right, you will get a page with information >about your php install. > > >On Mon, 2002-03-18 at 20:35, Andy Cheng wrote: > > Hi all, > > I too new to php and mysql, trying to get things works. I installed >Redhat > > 7.2, Apache, mysql and php. I copied a sample php script from the >internet > > and save it as phptest.php in my cgi-bin. When calling it from my >browser, I > > got Format error. Did I not do it right? Should I put it in my >cgi-bin? > > Could some one send me a working php script and instruct me how to test >it? > > Thanks > > > > > > >From: "Todd Williamsen" <[EMAIL PROTECTED]> > > >To: "'Andrew Hazen'" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> > > >Subject: RE: mysql/php on linux > > >Date: Mon, 18 Mar 2002 08:50:28 -0600 > > > > > >PHP > > > > > >http://www.php.net/manual/en/install.linux.php > > > > > >mySQL > > > > > >http://www.mysql.com/doc/L/i/Linux.html > > > > > >I never had any problems with mysql and PHP talking to each other on > > >Linux, and I am very wet behind the ears with Linux. Maybe you can >give > > >us an error messages you are receiving, and that will give all of us a > > >better understanding of what is going on. If it?s the OS or Glib > > >libraries, you will get the same error over and over again. > > > > > >I don't use RedHat, so I don't know what they have in it, I use Caldera > > >OpenLinux 3.1 which is much better(from what I hear). I have heard >that > > >RedHat 7.2 is a bit quirky. > > > > > >Again, its all hear say. > > > > > >-Original Message- > > >From: Andrew Hazen [mailto:[EMAIL PROTECTED]] > > >Sent: Monday, March 18, 2002 8:31 AM > > >To: [EMAIL PROTECTED] > > >Subject: mysql/php on linux > > > > > > > > >Hi all, > > > > > >This is probably a boring repeat question, so maybe someone can just > > >point us to an existing response or file on the web: > > > > > >We are trying to set up a webserver with the following: > > > > > > > > >Linux Red Hat 7.2 > > >MySQL ? newest > > >PHP 4.1 ? newest > > > > > >We can?t seem to get them all talking to each other, so we will just > > >start over from scratch. Can someone provide a step-by-step?? > > > > > >Andrew Hazen > > >Database Developer > > >Jatech Solutions Inc. > > >160 Bartley Drive > > >Toronto, ON > > >M4A 1E1 > > >www.jatech.ca > > >416-288-9833 > > > > > > > > > > > > > > > > > >- > > >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: > &g
RE: MySQL, MyODBC and MS Access
Your client won't drop Access in favor of a faster, more secure database like mySQL? Why is your client stuck on Access? The data can be dumped and make the GUI web based to look just like the Access one... Stick in on a Intranet server, and lock it down... I would rather have that than a slow, unsecure, limited DB like Access... Back to a solution... The problem is that you would need to run a query to pull the data from the Access db to the mySQL one, which could be automated in Access. Just add a few extra lines in your code for each form and should work beautifully. A problem that may or may not occur is the fact that Access uses different kinds of datatypes in its tables. If these datatypes are in the Access DB tables, using a myODBC connection, all the data transferring will fail because mySQL doesn't recognize the datatypes -Original Message- From: Mark Stringham [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 1:51 PM To: Chuck Roberts Cc: Mysql; Mark Stringham Subject: RE: MySQL, MyODBC and MS Access Chuck - I am looking for a way for both MS access and MySQL to share realtime data so that if someone where to insert (through a web based admin) or update table in a MySQL db you could open your Access db and see the same data. I don't know if it is possible but that way there wouldn't be an export to MySQL procedure. Does that make sense? I don't know much about Myodbc except it allows you to export your Access database to MySQL. My question is if MySQL gets updated does Access get updated too? I have a client who wants everyone in the office to have the ability to update and view data in an Access db. My understanding of how access works is only one person can be connected or update the db at a time.(depending on the # of odbc connection you have) My thought was if we got Access and MySQL talking, I could create a web based admin that would allow many folks to query and update the MySQL db and if MySQL and Access are talking then the data in the Access db would get updated as well. Really just trying to create a remote way to access and update from the Access db. Sorry for the long story but is this something you've done or is it not at all possible? Any ideas? Thanks Mark At Friday, 22 March 2002, "Chuck Roberts" <[EMAIL PROTECTED]> wrote: >I'm doing something similar, with an Access front-end and mysql >back-end. > >> -Original Message- >> From: Mark Stringham [mailto:[EMAIL PROTECTED]] >> Sent: Friday, March 22, 2002 3:11 AM >> To: MySQL >> Subject: MySQL, MyODBC and MS Access >> >> >> >> I have a project where I may need to connect an MS >> ACCESS db and MySQL. I >> have read some pretty good documentation and know that >> is possible to take >> an existing Access db and export it to MYSQL. I have a >> few questions and >> wondered if someone might offer some insight. >> >> 1. Where must the Access db reside in order to talk with MySQL? > >It doesn't matter. As long as you install Myodbc on the client >with Access, then myodbc can talk to mysql. > >> 2. After the import to MySQL, if I insert new data >> into MySQL will the >> Access db be updated as well? > >Not automatically. If you want the databases each to be updated >automatically, I don't think you can replicate between Access and >Mysql. Either both dbs have to be Access or both Mysql. > >> >> I am looking for a way to access live MS Access data >> from the web. >> Obviously, I could connect directly to the Access db >> itself but with limited >> connections, I would think it would be hard to share >> the data . My thought >> was when someone updated the Access db, the data is >> then exported to MySQL. >> I then could use php, JSP or whatever to access the >> data from the web >> without having to worry about odbc connections. > >We're doing the exact same thing. We have Access as a front-end, >and myodbc installed with the client (on the front end). In >Myodbc, you specify a data source with an IP address and database >name. That connects to a Mysql server running on the same IP >address. > >The only problem we're having is how to encrypt the data between >the client (Access) and server (mysql). Mysql supports SSL but >Access does not. We're looking at using stunnel (which uses >openssl, www.openssl.org), which is like a gateway between Access >and Mysql. > >Chuck > >- >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 mysql.com> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > Regards, Mark Stringham 801.602.8791 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list
RE: mysql/php on linux
PHP http://www.php.net/manual/en/install.linux.php mySQL http://www.mysql.com/doc/L/i/Linux.html I never had any problems with mysql and PHP talking to each other on Linux, and I am very wet behind the ears with Linux. Maybe you can give us an error messages you are receiving, and that will give all of us a better understanding of what is going on. If its the OS or Glib libraries, you will get the same error over and over again. I don't use RedHat, so I don't know what they have in it, I use Caldera OpenLinux 3.1 which is much better(from what I hear). I have heard that RedHat 7.2 is a bit quirky. Again, its all hear say. -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 8:31 AM To: [EMAIL PROTECTED] Subject: mysql/php on linux Hi all, This is probably a boring repeat question, so maybe someone can just point us to an existing response or file on the web: We are trying to set up a webserver with the following: Linux Red Hat 7.2 MySQL newest PHP 4.1 newest We cant seem to get them all talking to each other, so we will just start over from scratch. Can someone provide a step-by-step?? Andrew Hazen Database Developer Jatech Solutions Inc. 160 Bartley Drive Toronto, ON M4A 1E1 www.jatech.ca 416-288-9833 - 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: NT service problem
I ran the .exe file and WHAMMO! It installed itself as a service. I just needed to edit the service to have it automatically start at boot -Original Message- From: Gerald R. Jensen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 6:40 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: NT service problem Check the location of the configuration file (should be either c:\my.cnf ~ OR ~ c:\winnt\my.ini), then edit the contents of that file. Here is a sample: [client] #password=my_password port=3306 #socket=MYSQL # [mysqld] port=3306 #socket=MYSQL skip-locking #enable-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 log=C:/mysql/mysql.log basedir = C:/MYSQL/ # [mysqldump] quick set-variable = max_allowed_packet=16M # [MYSQL] no-auto-rehash # [isamchk] set-variable= KEY=16M # [client_fltk] help_file= C:\\MYSQL\guiclient\MYSQL.help client_file= C:\\MYSQL\mysql.opt history_length=20 database = goetznet queries_root= C:\\MYSQL\queries last_database_file= C:\\MYSQL\lastdb - Original Message - From: "Alexander Hampel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 18, 2002 1:37 AM Subject: NT service problem Hi Pierre, Thanks, for your help. That's what I exaclty do and this is for '--standalone' fine. But the point ist, I want to start mysqld-nt as NT service - and this is the problem - it wouldn't let me start it as service: >C:\>net start mysql >System error 1069 >Could not start service The service is an important issue. Lets you run a programm under different user rights. Probably I'll find some other solution. Thanks, A:lex >-Ursprüngliche Nachricht- >Von: Pierre du Parte [mailto:[EMAIL PROTECTED]] >Gesendet: Montag, 18. März 2002 08:04 >An: [EMAIL PROTECTED] >Cc: [EMAIL PROTECTED] >Betreff: Re: New to MySQL - can't start server :-( > > >Hi Alexander, >I use the PHPDEV compilation for local PHP/mySQL development work >(http://www.firepages.com.au/devindex.htm for a no-brainer approach to >getting PHP/mySQL/Apache up and running in seconds!) > >Anyway, for me > >start c:\phpdev\mysql\bin\mysqld-nt.exe --standalone > >kicks mySQL off on Win2K, NT and XP very nicely, thank you :) > >If your mySQL is in c:\ then > >start c:\mysql\bin\mysqld-nt.exe --standalone > >should work > >But I could be wrong, I often am > > >Pierre > > > > > >Alexander Hampel wrote: > >> Hi mailing list, >> >> I can't start mysqld-nt as I get the eror message 1067. If I start >> winmysqladmin.exe there is no server visible. >> >> The manual tell me in part 2.4 Post-installation Setup and Testing that I >> should start the script ./scripts/mysql_install_db but this script is not >> availabale (at all) at my Windows distribution. >> >> Any ideas what's wrong? >> >> >> Thank you, >> A:lex >> >> >> >> >> >> >> - >> 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 >> >> >> >> > > >-- >Pierre du Parté >Final Filer Software >349 Worrigee Road >Worrigee, NSW, Australia 2540 >http://www.finalfiler.com > >Phone 61 2 44216374 >Mobile 0413 483 066 > >"If it feels good, do it!" > > >- >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 - 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:
RE: IS THIS BETTER?
Try turning the CAPs off first... Makes it easier to read... Second... You are using ADOB to connect to mySQL? Is that what you are doing? Using ASP? Try using PHP, easier to learn and is much more compatible with mySQL. ASP/mySQL can be used, but its a pain, plus ASP has its limitation that is more limiting than PHP. I use to use ASP, but it sucks and a pain in the ass to configure and just to connect the database. Yes, Access has its limitations. You can use it, but your load would need to be light. Mysql is a very lightweight DB and barely uses any ram to run it. It is very, very fast (with PHP), and I prefer it over MS SQL server and Oracle, both which I have experience in. Does that help at all? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 1:19 PM To: [EMAIL PROTECTED] Subject: IS THIS BETTER? ORIGINAL SUBJECT:HELLO (PLEASE READ THE ENTIRE EMAIL BEFORE DECIDING TO CHUCK IT, I DO GET TO MY QUESTION) GOOD AFTERNOON I THOUGHT I'D TRY MY LUCK AND ASK YOU A QUESTION, IF YOU CAN'T (OR WON'T) HELP MY I UNDERSTAND. I HAVE BEEN VISITING YOU SITE A LOT LATELY BECAUSE I HAD A PROBLEM THAT I THOUGHT I WAS ON THE VERGE OF SOLVING. (BACK STORY)---> I AM BUILDING A WEBSITE, AND I WANTED TO SPEND THE LEAST AMOUNT OF MONEY ON GETTING IT ON THE GOOD OL' WWW. SO SINCE I HAVE A FEW COMPUTERS I'D THOUGHT I COULD RUN IT MYSELF WITHOUT THE HELP OF ONE OF THOSE "WEB HOSTING" SERVICES. SO I STARTED WITH IIS WHICH HAS GOTTEN MY BASIC SITE UP, THEN I GOT TO KNOW A LITTLE ABOUT ASP (NOT REALLY I'VE BEEN USING FRONTPAGE THEY DO ALL THE WORK FOR YOU) AND I AM PRETTY GOOD WITH ACCESS SO I FIGURED IT WAS JUST A MATTER OF PUTTING THEM ALL TOGETHER. WELL.I COULDN'T GET THE FORM TO CONNECT TO ACCESS(THEY WERE BUT THEY COULDN'T HANDLE THE LOAD) SO I WAS LOOKING INTO MS SQL SERVERS(WAY TO EXPENSIVE!!!) SO THEN I FOUND MYSQL(IT'S FREE!!!). GOT THE HANG OF IT A LITTLE AND CONVERTED MY ACCESS TABLES TO MY SQL'S. I FOUND YOUR WEBSITE, AND LEARNED HOW TO LINK BETWEEN ACCESS AND MYSQL SO I COULD USE ACCESS'S INTERFACE TO MAINTAIN THE FORMS AND QUERY'S FROM MY END(INSTEAD OF WITH THAT DOS INTERFACE), AND FRONTPAGE SEEMED TO ACKNOWLEDGE MY MYSQL DATABASE WHICH GAVE ME A MORE STABLE DATA ENGINE SOLUTION(OR SO I THOUGHT) I THOUGHT I WAS THERE UNTIL I TEST SUBMITTED SOME ASP FORMS,BUT THEN I GOT A TOTALLY NEW ERROR MESSAGE: -> "Cannot add new record set to the database Error Description: Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. Error Number: 3251 Error Source: ADODB.Recordset NOW I HAVE HAD NO FORMAL TRAINING IN ANY OF THE FORE MENTIONED PROGRAMS, BUT I PICK THIS STUFF UP PRETTY GOOD (I THINK), AND I WAS WONDERING IF THERE'S JUST SOMETHING I'M LEAVING OUT OR ADDING WHEN I SHOULDN'T?? WHAT I'M I DOING WRONG!!! PLEASE HELP SINCERELY, > Your message cannot be postsed to mysql@ because it > contained an attachment. If you need to make a file publically available > you should upload it to some public URL, and then paste the URL into your > message instead of trying to send it to everyone on the list. > > Disallowing attachments protects our list from being used to > spread a virus. If you do not remember sending a message to the this list, > it is possible that your computer has been infected by a virus which tried > to spread itself using our list. It is also possible that some spammer used > your e-mail address to hide his identity. > > Some mail clients default to sending messages in HTML or multipart format. > In this case, your message will also appear as if it has an attachment. Such > message formats increase the volume of traffic, and cause readability problems > in some mail programs without providing any extra value. Such formats are > also frequently used by spammers. For these reasons we disallow such messages. > You should disable them in your mail program to be able to post. > > Your mail program was identified as 'Microsoft Outlook'. If this is correct, > you should do the following to > configure it to be able to post to our list: > > Tools->Options->Mail Format, set 'Send message in this format' to 'Plain Text' > > Please note that we may have misidentified your e-mail program, in which case > our instructions would not apply. It is also possible that we are not aware > of a version of that has a slighly different set of menus. If > our instructions are not helpful, please consult your e-mail program's manual > on how to send messages in plain text. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.my
RE: problem in telent to mysql server
I didn't realize you were trying to telnet to a client. You cannot do that. You need to telnet to the SERVER. Whatever the server is You need to make sure the user you are trying to use has access rights for the user for telnet -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 2:19 PM To: Jianping Zhu Cc: [EMAIL PROTECTED] Subject: Re: problem in telent to mysql server At 14:58 -0500 3/14/02, Jianping Zhu wrote: >I use: >telnet mysqlserverhostname 3306 > >and get following response: > > Host 'mylocalcomputer' is not allowed to connect to this MySQL server >What does this mean? and how to fix the problem? The MySQL client-server protocol is a binary protocol. It makes no sense to telnet to the server. > >Thanks - 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: problem in telent to mysql server
Can you telnet into anything else? How about a webserver? Try port 80 or 25 if you have a mail server. If you can't, you need to make sure you have telnet rights -Original Message- From: Jianping Zhu [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 1:58 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: problem in telent to mysql server I use: telnet mysqlserverhostname 3306 and get following response: Host 'mylocalcomputer' is not allowed to connect to this MySQL server What does this mean? and how to fix the problem? Thanks - 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: mySQL connection problem!!!
I think I read somewhere about this issue. I think it had to do with multiple mySQL servers running concurrently. See if there is multiple servers running using the ps command. If so, then kill one of them. Also, when adding a user, do you select a database first before adding a user? -Original Message- From: b g [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 2:35 AM To: Sherwin T. Ang Cc: [EMAIL PROTECTED] Subject: Re: mySQL connection problem!!! Hello Sherwin, Thanks for ur prompt reply. Yes, I have gone thru the mySQL manual chapter that you have mentioned.. But what I think the problem is somewhere else.. when I try to execute the command 'mysql' (when I log in as user 'babul') on command line, I get the following error: ERROR 2002: Can't conect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) It seems that the mySQL server is not running on the system... where as when I in superuser mode or login thru mysql user, I get just the "mysql>" prompt..!! This is my first time with mySQL.. I m actually trying to restore a web database into my loca machine.. then update it locally and later withh restore it to the web server.. Babul - 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: creating a password field..
Peter, I have no idea what your front end is, and this is what will do the actual encryption, all mysql does is holds the data. So whatever your front end programming language is, it will have to do the encryption. Below is the link for php encryption http://www.php.net/manual/en/function.md5.php -Original Message- From: Peter Gibbons-BU [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 11:32 AM To: '[EMAIL PROTECTED]' Subject: creating a password field.. Hi, i'd like to create a password field like in the user table in the mysql database. The data would need to be encrypted. Can mysql do the whole job. I would need it ideally to automatically decrypt it for me when I do a select.. any suggestions - code example would be really helpful.. peter This e-mail (and any attachments) is confidential and may contain personal views which are not the views of the BBC unless specifically stated. If you have received it in error, please delete it from your system, do not use, copy or disclose the information in any way nor act in reliance on it and notify the sender immediately. Please note that the BBC monitors e-mails sent or received. Further communication will signify your consent to this. - 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: login and logout
Matthew... Did you look into the session variables Session_start() Session_register() Mysql, query -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 4:49 PM To: [EMAIL PROTECTED]; mysql list; Siulun A Sze Subject: RE: login and logout The problem with that is, it doesn't allow logout. Siulun, if you /do/ find some good sample code, clue me in. I'm in the market myself. I'm using apache's basic auth right now, but I need to add logout support. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 3:05 PM To: mysql list; Siulun A Sze Subject: Re: login and logout Don't know what web server your using, but I use apache's .htmaccess feature to control user access. Works good for me, and its pretty easy to setup. Mike - Original Message - From: "Siulun A Sze" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 08, 2002 4:04 PM Subject: login and logout > Does anyone have a php sample code handling login and > logout using cookie? > > I tried to use SESSION, but when I click back on the > browswer, it lost all the data I previously entered in > a form. > > I want to have a section on the website that is only > used by registered users. The site developed using PHP > with query mysql on the backend. > > Thanks, > Siulun > > __ > Do You Yahoo!? > Try FREE Yahoo! Mail - the world's greatest free email! > http://mail.yahoo.com/ > > - > 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02 - 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.332 / Virus Database: 186 - Release Date: 3/6/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.332 / Virus Database: 186 - Release Date: 3/6/2002 - 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: Some PHP - mySQL help please ... new to both
Daniel, Usually in PHP there are some sort of syntax error before the line that says failed. -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. >> if (!($mylink = mysql_connect ("localhost","administrator",""))) { print "could not connect to database\n"; exit; } mysql_select_db("mytest"); ?> RESULT>>> while trying to run script. Fatal error: Maximum execution time of 60 seconds exceeded in dbconnect.php on line 5 Thank You <><><><><><><><><><><><><><><><> Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com <><><><><><><><><><><><><><><><> - 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: Dropdown lists
Josiah.. I think you are asking the wrong mailing list for this... I am assuming you are using PHP correct? Your explanation isn't all that clear, but I can guess what you are trying to do. You want to have a drop down list, but don't know what data type.. You can use VarChar or text for this. Varchar means you other characters besides text in the fields. Like numbers !@#$%^&*( etc. So you can do Create table State varchar(25); If you need more help, let me know, don't ask the mysql list unless its mysql related! -Original Message- From: Josiah Wallingford [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 12:30 AM To: MySql Subject: Dropdown lists I need to create a dropdown list in my script I am writing but don't know how to set it up in mysql. I have Mysql> create table tablename -> (now here is what I don¹t know what to put) state varchar(100); Do I use varchar for drop down lists? - 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: Re: [ANN] Blue World Announces Lasso vs. PHP White Paper
Here is a blurb from the report of the white paper Lasso operates identically across platforms whereas with PHP, significant functionality is lost migrating from one platform to another. This makes it very difficult to develop on one platform and deploy on another when using PHP. Lasso's platform-agnostic design makes it very easy to develop and deploy on the same or different platforms, easing the development and testing process for Web developers. HUH? I never experienced and problems migrating PHP from windows to Linux mysql -Original Message- From: Jeff Kilbride [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 7:25 PM To: MySQL Subject: Re: Re: [ANN] Blue World Announces Lasso vs. PHP White Paper Ok, now *that's* funny!! :o) Guess Blue World's dev team haven't read the White Paper... --jeff - Original Message - From: "James Cox" <[EMAIL PROTECTED]> To: "Mysql" <[EMAIL PROTECTED]> Sent: Thursday, March 07, 2002 3:45 PM Subject: FW: Re: [ANN] Blue World Announces Lasso vs. PHP White Paper > mysql,sql,query > > ~> telnet www.blueworld.com 80 > Trying 192.147.161.21... > Connected to www.blueworld.com. > Escape character is '^]'. > HEAD / HTTP/1.0 > HTTP/1.0 200 OK > Date: Thu, 07 Mar 2002 23:38:36 GMT > Content-Type: text/html > Server: Apache/1.3.20 (Unix) PHP/4.1.3-dev > X-Powered-By: PHP/4.1.3-dev > Connection closed by foreign host. > > Interesting, a server powered by the product it's competing against... > > -- > James Cox :: [EMAIL PROTECTED] :: Landonize It! http://landonize.it/ > Was I helpful? http://www.amazon.co.uk/exec/obidos/wishlist/23IVGHQ61RJGO/ > > - > 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 - 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: Re: [ANN] Blue World Announces Lasso vs. PHP White Paper
Quite hilarious... Interesting.. Trying to compete versus PHP and they use php... Wild Whats next PHP website using ASP? -Original Message- From: Jeff Kilbride [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 7:25 PM To: MySQL Subject: Re: Re: [ANN] Blue World Announces Lasso vs. PHP White Paper Ok, now *that's* funny!! :o) Guess Blue World's dev team haven't read the White Paper... --jeff - Original Message - From: "James Cox" <[EMAIL PROTECTED]> To: "Mysql" <[EMAIL PROTECTED]> Sent: Thursday, March 07, 2002 3:45 PM Subject: FW: Re: [ANN] Blue World Announces Lasso vs. PHP White Paper > mysql,sql,query > > ~> telnet www.blueworld.com 80 > Trying 192.147.161.21... > Connected to www.blueworld.com. > Escape character is '^]'. > HEAD / HTTP/1.0 > HTTP/1.0 200 OK > Date: Thu, 07 Mar 2002 23:38:36 GMT > Content-Type: text/html > Server: Apache/1.3.20 (Unix) PHP/4.1.3-dev > X-Powered-By: PHP/4.1.3-dev > Connection closed by foreign host. > > Interesting, a server powered by the product it's competing against... > > -- > James Cox :: [EMAIL PROTECTED] :: Landonize It! http://landonize.it/ > Was I helpful? http://www.amazon.co.uk/exec/obidos/wishlist/23IVGHQ61RJGO/ > > - > 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 - 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: MS-DOS Window
I don't have a problem and I am using 3.23.47 -Original Message- From: Robbie Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 3:51 PM To: Gurhan Ozen Cc: [EMAIL PROTECTED] Subject: RE: MS-DOS Window I tried using 'tee' in MySql but it's not working. mysql> tee file.txt; ERROR 1064; You have an error in your SQL syntax near 'tee file' at line 1 I'm running version 3.22.34-shareware-debug on Win98. Is this a problem? Do I need to pick up a more recent version? Thanks, Robbie On Mon, 4 Mar 2002, Gurhan Ozen wrote: > Hi Robbie, > There are a few ways you can capture the output to a file.. > First of all, you can have all your sql statement in a file , say > myquery.sql file, and call it from command line and redirect it to a > different file such as this: >C:\mysql\bin\mysql < myquery.sql > outputfile.txt > Or, you can select your query into a outfile with SELECT INTO OUTFILE > 'outfile.txt'; syntax. See > http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html #SEL > ECT for this ... > OR, you can use the tee command in mysql> prompt... Just do : > mysql>tee outfile.txt > mysql>select blah, blah; > mysql>notee > > Hope this helps... > Gurhan, > > > -Original Message- > From: Robbie Martinez [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 04, 2002 6:31 PM > To: [EMAIL PROTECTED] > Subject: MS-DOS Window > > > > This may be a simple MS-DOS question, but I'm a UNIX guy > and am pretty clueless... > > I'm trying to capture some mysql command output, but my > DOS screen runs out of space. In other words, the data > goes beyond what I can scroll up to get. Is there any > way for me to either: > >(1) Redirect output from mysql commands to a file >(2) Create a session "typescript" of mysql >(3) Increase the DOS window's scroll memory to a very >large size (so I don't lose my data on my screen). > > Thanks, > > > > > - > 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 - 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: [ANN] Blue World Announces Lasso vs PHP White Paper
Hmm Isn't price one of the the factors in doing a comparision? No matter what project size it is, cost plays a major role. If I can save a client $3000 by using PHP versus using Lasso, I would. It doesn't seem Lasso has a $3000(or more) advantage over PHP/mySQL combo. The thing is that people using PHP know PHP, and that means learning Lasso isn't cost effective now. They would need to train for it and learn the product, and buy it. Maybe if you gave use mysql list users a NFR copy of Lasso, maybe we would consider it and try it out and give our unbias opinion. Another thing is some of us rely on outsourcing our web servers and our hosting providers probably won't let us install and server products on their machines. Is there a workaround for this? I would curious to try out Lasso, but I am not going to drop $1200 into something when PHP is free and is currently more than capable of handling my tasks so far -Original Message- From: Cathy Cunningham (Blue World Lasso Evangelist) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:58 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [ANN] Blue World Announces Lasso vs PHP White Paper At 1:47 PM -0700 3/7/02, Van wrote: >> If you do a true comparison in features, you'll see that a PHP-based >> solution (with commercial add-ons) costs over three times the cost of >> Lasso. > >I try to stay out of such discussions, but your marketing-oriented spiel >inspired me to point out that most of us in here are developers interested in >technical-type things, not PHB'S cost and ease of use-type things. > >A shell and an editor probably meet most our needs. > >Announce your product(s), if you must, but move on and leave the bandwidth >available for MySQL implementation discussions if you don't mind. I agree that the principal consideration shouldn't be cost. Some of your colleagues simply stated that they won't even look at the paper because they think everything with PHP is free. All that was announced here was a report comparing Lasso to PHP. Details on what is contained in the report are contained therein. And yes, if someone is going to cast the report off due to their own personal prejudice and make inaccurate remarks here, we feel it only fair to be given the opportunity to correct said misinformation. All the technical details are in the report, and all discussion of costs aside, we'd be delighted to talk tech and get into the nitty gritty of the feature and performance comparisons. Cheers! CC -- - Cathy Cunningham [EMAIL PROTECTED] Lasso Evangelist Blue World Communications, Inc. http://www.blueworld.com/ - Lasso Studio is "the easiest way to create a database-driven Web site" - Macworld Magazine - 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: Running MySQL as Service on 2000 Server
I have no problem running mySQL as a service on Win2k Server. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:35 PM To: [EMAIL PROTECTED] Subject: Running MySQL as Service on 2000 Server Hi, Anybody running MySQL on Win 2000 server here? I just installed MySQL 3.23.49-MAX (w/ InnoDB) on a 2000 Server (Dual 1.1 GHz - 1GB RAM - 15GB HD space) and I can run it without any problem from the command line as a standalone. However I couldn't run it as a service even though I already did 'mysqld-max-nt --install' the first time I ran it. Is there anything wrong with MySQL or is it more of permission issue on NT/2000 server. I also attached the my.ini file if it would help. Thanks. Regards, Martin [mysqld] basedir=G:/MySQL datadir=G:/MySQL/data #bind-address= log-slow-queries=h:/slowquery/slowquery.log set-variable=key_buffer=20M innodb_data_home_dir = g:/ibdata innodb_data_file_path = ibdata:2000M;ibdata2:2000M set-variable = innodb_buffer_pool_size=200M set-variable = innodb_additional_mem_pool_size=30M innodb_log_group_home_dir = h:/iblogs innodb_log_arch_dir = h:/iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=24M innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=10 set-variable = innodb_lock_wait_timeout=50 [WinMySQLAdmin] Server=G:/MySQL/bin/mysqld-max-nt.exe **Disclaimer** This Memo and any attachments, may be confidential and legally privileged. If you are not the intended recipient and have received this in error, kindly destroy this message and notify the sender. Thank you for your assistance. - 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: [ANN] Blue World Announces Lasso vs PHP White Paper
You think Blue World getting the point yet? Maybe they are thinking twice about spamming mailing lists with their products? Maybe a better target is Microsoft's .NET boards since both products are about the same price -Original Message- From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:00 PM To: '[EMAIL PROTECTED]' Subject: RE: [ANN] Blue World Announces Lasso vs PHP White Paper Ah, the keywords "with commercial add-ons." Notice the plurality, as well. I wonder which add-ons and how many total add-ons were considered in making this cost estimate. I also wonder if most of us would even need more than one commercial add-on at most. - Jonathan -Original Message- From: Cathy Cunningham (Blue World Lasso Evangelist) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 12:37 PM To: Chuck "PUP" Payne; [EMAIL PROTECTED] Subject: Re: [ANN] Blue World Announces Lasso vs PHP White Paper At 1:19 PM -0500 3/7/02, Chuck \"PUP\" Payne wrote: >But who wants to pay. Get a clue that's why PHP, PERL, and other Open Source >Lang., are widely more used. If you do a true comparison in features, you'll see that a PHP-based solution (with commercial add-ons) costs over three times the cost of Lasso. Then there's also the (TCO) total cost of ownership where due to productivity gains in using Lasso, developers end up saving lots of time (e.g. money) compared with using other tools. Then there's also the fact that when you buy Lasso Professional 5, you're also supporting MySQL AB as each copy purchased puts money in their pockets. And, this is a good thing to ensure the future vitality (and growth) of the MySQL market. It also gives you peace of mind in knowing that you have a commercial license of MySQL, which can help ease liability and other concerns that may otherwise be present in certain organizations who may have concerns using just GPL products. Then there's the issue of quality. With Lasso Professional 5, no stone remains unturned with respect to ensuring Web developers have the highest quality offering both in terms of features, documentation, support materials and more. CC -- - Cathy Cunningham [EMAIL PROTECTED] Lasso Evangelist Blue World Communications, Inc. http://www.blueworld.com/ - Lasso Studio is "the easiest way to create a database-driven Web site" - Macworld Magazine - 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 - 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: [ANN] Blue World Announces Lasso vs PHP White Paper
Can you provide a NON-BIAS so-called "TRUE comparison"? I would be curious on what Blueworld has to say. Also, why do you think the TCO is lower with lasso than PHP? I don't get it, there is no cost to own it, just to develop it. And if you develop with PHP correctly, then the TCO is low. Here is my basic TCO comparison: Lasso Software Pro $1199 PHP $0.00 Learning Lasso$2500 PHP $0.00 Development (hr avg) $75 PHP $75/hr. So to me, Lasso isn't worth switching. I would already be $3700 in the hole without even touching it! -Original Message- From: Cathy Cunningham (Blue World Lasso Evangelist) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 12:37 PM To: Chuck "PUP" Payne; [EMAIL PROTECTED] Subject: Re: [ANN] Blue World Announces Lasso vs PHP White Paper At 1:19 PM -0500 3/7/02, Chuck \"PUP\" Payne wrote: >But who wants to pay. Get a clue that's why PHP, PERL, and other Open Source >Lang., are widely more used. If you do a true comparison in features, you'll see that a PHP-based solution (with commercial add-ons) costs over three times the cost of Lasso. Then there's also the (TCO) total cost of ownership where due to productivity gains in using Lasso, developers end up saving lots of time (e.g. money) compared with using other tools. Then there's also the fact that when you buy Lasso Professional 5, you're also supporting MySQL AB as each copy purchased puts money in their pockets. And, this is a good thing to ensure the future vitality (and growth) of the MySQL market. It also gives you peace of mind in knowing that you have a commercial license of MySQL, which can help ease liability and other concerns that may otherwise be present in certain organizations who may have concerns using just GPL products. Then there's the issue of quality. With Lasso Professional 5, no stone remains unturned with respect to ensuring Web developers have the highest quality offering both in terms of features, documentation, support materials and more. CC -- - Cathy Cunningham [EMAIL PROTECTED] Lasso Evangelist Blue World Communications, Inc. http://www.blueworld.com/ - Lasso Studio is "the easiest way to create a database-driven Web site" - Macworld Magazine - 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: connecting to all databases using one odbc connection..PLEASE HELP
It won't let you since Windows ODBC only lets you create ONE DSN per DATABASE -Original Message- From: Edward Peloke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 12:11 PM To: MySql Subject: connecting to all databases using one odbc connection..PLEASE HELP I asked yesterday but got no responses...anyone have any ideas how I can use one odbc connection but have access to all databases on the MSSQL server??? Thanks, Eddie - 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: Query help please!
One more thing... What are you using to pull the data? PHP? Perl? Etc? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 12:05 PM To: [EMAIL PROTECTED] Subject: Query help please! I need help writing query that would give me parent categories of catID from categories table. For example, if catID=030 then it should give me: Birthday | Special Birthday | Special Birthday If catID=028 Birthday | General Birthday | NULL >desc categories +---+--++ | catID | parentID | catName| +---+--++ | 001 | 000 | Birthday | | 002 | 000 | Get Well | | 003 | 000 | Special Occasions | | 038 | 029 | 40th | | 037 | 029 | 30th | | 036 | 029 | 21st | | 035 | 029 | 16th | | 029 | 001 | Special Birthday | | 028 | 001 | General Birthday | | 030 | 029 | Inspirational | | 045 | 001 | Children's Birthday| | 046 | 045 | 1st| +---+--++ Pinkesh - 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: Query help please!
Do you have another table with all the birthdates in it? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 12:05 PM To: [EMAIL PROTECTED] Subject: Query help please! I need help writing query that would give me parent categories of catID from categories table. For example, if catID=030 then it should give me: Birthday | Special Birthday | Special Birthday If catID=028 Birthday | General Birthday | NULL >desc categories +---+--++ | catID | parentID | catName| +---+--++ | 001 | 000 | Birthday | | 002 | 000 | Get Well | | 003 | 000 | Special Occasions | | 038 | 029 | 40th | | 037 | 029 | 30th | | 036 | 029 | 21st | | 035 | 029 | 16th | | 029 | 001 | Special Birthday | | 028 | 001 | General Birthday | | 030 | 029 | Inspirational | | 045 | 001 | Children's Birthday| | 046 | 045 | 1st| +---+--++ Pinkesh - 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: Commands...
Stephane... What is the process you are trying to do? In order to do commands in dos Go to a command prompt: C:\ Type this: Cd \mysql\bin Now type this: Mysql Now you should see this Mysql> Type this: \u name of your database; Now type in the command: Show tables; Make sure you follow the command with a " ; " -Original Message- From: Stephane Collas [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 03, 2002 12:27 PM To: Roger Baklund; 'mysql' Subject: Re: Commands... Hi Roger, It was may be a bad way to expressed. I mean, I can't type the commands in DOS window, there are no .exe Actually, would like to type my commands in text mod. Regards Steph - Original Message - From: "Roger Baklund" <[EMAIL PROTECTED]> To: "'mysql'" <[EMAIL PROTECTED]> Cc: "Stephane Collas" <[EMAIL PROTECTED]> Sent: Sunday, March 03, 2002 7:20 PM Subject: RE: Commands... > * Stephane Collas > > Have installed: > > mysql Ver 11.16 Distrib 3.23.49, for Win95/Win98 (i32) > > > > I use a Win2K Pro, and downloaded it from http://www.myqsl.com > > > > The problem is that a lot of commands are missing, like CREATE TABLE, or > > even SHOW TABLE > > What do you mean "commands are missing"...? Do you get an error message when > you try to use these commands? Can you show us what you have tried and the > error message you get? > > There is no command called SHOW TABLE... maybe you mean SHOW CREATE TABLE or > SHOW TABLE STATUS? > > -- > Roger > 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 > > - 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: After php udate, php pages no longer update MySQL database
Which PHP version did you update to? I have noticed in PHP 4.1.1 is more anal about syntax -Original Message- From: Vernon [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 1:30 PM To: php-list; MySQL-list Subject: After php udate, php pages no longer update MySQL database I just reinstalled the latest version of php on my system and after doing so the pages that existed within the site no longer allow records to be updated in MySQL, records that updated fine before. Any ideas why or how to fix? Thanks - 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: Dumping a MySQL DB Out to Access
The problem is that the DB resides on a Unix box and he access it through a cgi program -Original Message- From: Luis Gonzalez [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25, 2002 5:18 PM To: [EMAIL PROTECTED] Subject: Dumping a MySQL DB Out to Access Hi, First of all, I'm not an expert at all, I'm just a newby who started a week ago,,, But I guess that the answer is very simple: Why don't you link your MySQL database to Access thru MyODBC? This way your customers could use Access as the front-end, while MySQL is the back-end where the data is stored. For that you just have to download the Myodbc driver, create dsn connection in every PC that would be connected to the database server, create a blank database in Access and link the tables in the server to the new Access database. from this point on, it is just like working in Access. For a detailed guide, check this out: http://www.devshed.com/Server_Side/MySQL/ODBC/page1.html Good luck, LUIS [EMAIL PROTECTED] -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net - 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: database structure script
I should have been more clear... http://www.mysql.com/doc/m/y/mysqldump.html -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 24, 2002 10:03 PM To: 'Pax'; 'MySQL' Subject: RE: database structure script Yes.. Use the DUMP command -Original Message- From: Pax [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 24, 2002 9:25 PM To: 'MySQL' Subject: database structure script Is there an easy way to create SQL script from existing database and use it to create a new database? Tks Pax - 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 - 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: database structure script
Yes.. Use the DUMP command -Original Message- From: Pax [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 24, 2002 9:25 PM To: 'MySQL' Subject: database structure script Is there an easy way to create SQL script from existing database and use it to create a new database? Tks Pax - 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: migrate Microsoft Access Data into MySQL
Try myodbc? -Original Message- From: Admin [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 24, 2002 11:21 AM To: [EMAIL PROTECTED] Subject: migrate Microsoft Access Data into MySQL How to migrate Microsoft .mdb Database into MySQL under Unix environment?? Who can tell me?? Any Doc?? - 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: Comments in Documentation
I don't think the manual is very amateur like. I find it very large, somewhat imformative. I find it like hell to understand if you are a novice -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 23, 2002 10:29 AM To: savaidis; [EMAIL PROTECTED] Subject: RE: Comments in Documentation At 16:01 +0200 2/23/02, savaidis wrote: >Also there is not LIKE at all at SELECT command on MySQL manual! http://www.mysql.com/doc/S/t/String_comparison_functions.html http://www.mysql.com/doc/P/a/Pattern_matching.html >I found manual very-very amateur work. >I was trying about half hour to use I'm surprised that if you wanted to use LIKE, that you didn't just try it. >Also "binary" at field creation or WHERE should be ON by default. What would the syntax be for turning it off? > And WHERE >works erroneously with Greek chars (without the "binary" option). I think it >is comfused by other languages chars so it should be an option to declare >the language character set at runtime (not at server cnf). > >Makis - 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: MySQL PHP Development IDE
There is three options I use: 1. Macromedia Dreamweaver UltraDev4 with a PHP plugin or extension 2. PHPEdit, its free I forget the website. Its a good IDE, but kinda annoying editor. 3. Notepad -Original Message- From: Joel Wickard [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 10:34 AM To: [EMAIL PROTECTED] Subject: Re: MySQL PHP Development IDE > This off topic, but one of our programmers is interested in NuSphere's PHPEd > development interface and I would liek some feed back from other users. > > His interest lies not so much in using for database table modeling, but for > PHP and Perl development. If he's not really that interested in the mysql integration than I would say that you could probably go with a different IDE. PHPed's db integration and built-in php debugger are about the only two things that set it apart from other IDE's. I am well aware of the conflict a few months ago > between MySQL and NuSphere, but I have never heard anything one way or the > other about PHPEd. At nearly $500 per package, it is not a decision I wish > to make without some feedback from the community. > > How does PHPEd stack up compared to other PHP IDE's? What experience (good > or bad) has anyone had with it? Is there another product that is better? > > Any feed back (either to the list or me me privately) will be appreciated. Before you make a commitment, you can apply for a trial version of PHPed. You have to give them real contact information, (I think I've gotten like 5 sales-pitch emails since I downloaded my free trial 3 months ago.) So you can give it a shot before you buy... and at $500 you should probably try it first. As for feedback on experience with the editor: When you try to install the editor (at least this was what it did three months ago) It wants to install it's own copies of Apache and MySQL. kind of un-handy if you've got current installs you want to use. I think it gave you the option to keep your own, but after I got everything installed, the database integration wouldn't work. So I decided that I had free time on my hands, I hosed my installs of apache and mysql and let it install it's own stuff. after that I still couldn't get it to work properly. I probably could have tweeked something here or there and gotten everything to go, but my reaction was kind of like.. "I'm going to pay $300 to have to play with it this much to get it to work?" It just didn't seem worth it Given that I currently used allaire's homesite and the only things that PHPed had over that in features was the db integration and php debugger, and I had already worked out my own solutions to those problems. I recommend downloading the trial version before you buy. I also recommend downloading the trial version of homesite as well. Homesite gives you syntax highlighting, project management, web deployment. "scriptable" deployment wich lets you decide what gets sent, where it gets put etc... all in a script that you can re-run. Plus homesite let's you edit the ide to add in features that you may need (http://www.macromedia.com/software/homesite/) Or look into Quanta depending on what platform you plan on developing on. I found it ironic that if you buy PHPed standard, it only runs on windows platforms, and that if you decided to buy PHP advantage, "then" you get linux support. seems like it should be the other way around given that the product they are trying to sell was built on the back of Open Source technologies. > Gerald Jensen > > > - > 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 - 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: Inventory management system based on mysql
No reason, you have the right idea especially if you are dealing with multiple platforms -Original Message- From: Cip [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 8:54 AM To: [EMAIL PROTECTED] Subject: Inventory management system based on mysql Hi all, I am trying to put together an inventory management system for my company an I was thinking to do it using mysql for the database, Red Hat Linux with apache for the server. I opted for a web like environment for this project because there are so many different computers that need to access the server. I have windows pc, linux pc, Macintosh. If I were to do somenting in C++ or Java or Python I would have to make a version of the interface for every system, sometimes even for every version of the same OS. So I decided that I would want to write this application using only web technologies: mysql, php, javascript, java; and all the users would access the server through a secure connection with their browser. this way the server can be accessed from any kind of computer. And everything will be on a LAN, so the speed is no problem. Does anyone know any reason why this would not be a good idea? Thanks, --Cip-- - 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: About Regular Backup on MySQL
If you are on a Windows box, you can create a batch job for it. If you are on Linux/Unix run a cron job -Original Message- From: Che WaiSam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 8:19 AM To: [EMAIL PROTECTED] Subject: Re: About Regular Backup on MySQL Dear Sir/Madam: I'd like to know how I can have regular backup in mysql database that is carried out by the system itself, instead of typing in the backup command in the DOS mode everytime. Thanks for your attention & looking forwards to your reply. Regards, Polly __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com - 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: How to save the table content into file?
In phpmyadmin Choose the table from the list... Scroll down the main screen and you will see this: View Dump(schema) of table: You will have options like Structure only, Structure and data, CSV for MS Excel... Structure dumps the column names and all the field types... Structure AND data will dump all the data and the structure Data Only will dump just the data After you choose which one, near the bottom of that table, you will see :"Save as File" then click "go" -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 17, 2002 10:02 AM To: [EMAIL PROTECTED] Subject: How to save the table content into file? Hello, I want to store my table in text file, I've tried : select * from news into outfile 'news1.txt' but doesn't work Can you help to do this with phpmyadmin or sql, thanx - 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: How to save the table content into file
Do you mean run a query that pulls all content in a table? OR Something thats saves all content of a table? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 17, 2002 8:52 AM To: [EMAIL PROTECTED] Subject: How to save the table content into file Hello, I am looking for how to save into file content of table, Can you give an example of mysql query, thanx - 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: WIN/Linux Compatibility
Alex, What I do is a DUMP on the table, either the schema or data or both. This will create a .sql file you can run again against whatever platform you are on -Original Message- From: Alex Charlton [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 17, 2002 3:55 AM To: mySQL Subject: Fw: WIN/Linux Compatibility Hi all, I was wondering if there is any chance that table information is compatible between Windows and Linux? IE. If I copy windows data files to a linux server, can mySQL on the linux server read this data? I don't believe this is possible, but I couldn't find any posts and wanted to confirm. I realize that we may need to import through an SQL query. Thanks in advance. Alex Charlton [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 - 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: insert picture file in MySQL (+php)
The two biggest reasons why 1. Bloats the database 2. Slow at retrieving the images -Original Message- From: Reuben D Budiardja [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 9:30 AM To: Todd Williamsen; [EMAIL PROTECTED] Subject: Re: insert picture file in MySQL (+php) On Thursday 14 February 2002 10:16 am, Todd Williamsen wrote: > Reuben, > > You can store the images into a database, but no one recommends it. > What I do, is actually store the location of the file in the database > then have PHP open it. Any reason why it is not recommended? I was going to do it that way (store the location of the file only), and have php open it and then use something like . But the problem is, that way everyone who knows a bit about html can use view source and know the locations of the image file, and can open it directly. It's a problem for my particular case because we want to restrict access to the images, and only certain people can see certain image, and so on. The only I can think about right now to achieve that is to store the image directly in the table. That's why I asked. Thanks. Reuben D. Budiardja > > -Original Message- > From: Reuben D Budiardja [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 14, 2002 9:08 AM > To: [EMAIL PROTECTED] > Subject: insert picture file in MySQL (+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 - 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: insert picture file in MySQL (+php)
Reuben, You can store the images into a database, but no one recommends it. What I do, is actually store the location of the file in the database then have PHP open it. -Original Message- From: Reuben D Budiardja [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 9:08 AM To: [EMAIL PROTECTED] Subject: insert picture file in MySQL (+php) Hi, I remember reading article about how to use MySql table as a place to put picture file. I can't find that article now. Can anyone help me with this? or point me to URL or something. I am using php as the front end. Thanks. Reuben D. Budiardja - 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: forms?
Jim, I am still pretty wet behind my ears and I have always had problems with picking up the logic behind programming languages, but PHP is awesome! I had problems with the wacky structure of Visual Basic, and I hard a hard time just reading the code of C++ and Java. What helped me was a book called "PHP fast and easy Web Development" by Julie Meloni. It is so upfront with examples and she knows what her target audience is. That is the book that got me started! Then I moved onto a little more complicated things from there. She has a website www.thickbook.com She has tutorials on the site Then there is: www.scriptsearch.com www.hotscripts.com www.phpbuilder.com newsgroups: news.php.net this one will list all the newsgroups, there are A LOT of them. I use two of them, PHP.DB and PHP.windows People are nice and really helpful! Let me know if you need more! -Original Message- From: Jim Hatridge [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 5:13 AM To: [EMAIL PROTECTED] Subject: Re: forms? Hi Rick et al On Monday 11 February 2002 20:13, Rick Emery wrote: > The PHP/MYSQL combo is also a good choice, as is PERL/MYSQL The PHP/MySQL combo was what I was thinking about. But I'm having hell trying to get the damn thing to work together. The PHP manual that is installed with the software is next to useless. Oh yes, I know the manual's great (so no flames, please ), but only if you already know what you're doing, I don't. It would help, if I could find a tutorial for PHP/MySQL that I could d/l for free (Wife has all the money. ). One that is simple with good examples for beginners. Also a mailing list for PHP beginners would help. I don't think my (many) questions on PHP would be good to ask here. Thanks JIM > Using Perl/CGI and DBI::MySQL would work for forms. You could take the > input from the browser, and print the results back to the browser. Would > that work? > > j- k- > > On Monday 11 February 2002 05:20, Jim Hatridge wrote: > > Hi all... > > > > First of all, I think that MySQL is really great. The only thing I need > > now > > > is a way to do forms. > > > > What I'm looking for is something that will allow me to do data input, > > update, output either at the command line or by browser, but only if I > > can use lynx as the browser. > > > > I wrote a database system for my stamp export company back around 1990 in > > Dbase III+. That system is getting very old now. DBase III + has scripts > > and forms. Something like this is what I'm looking for. > > > > Thanks > > > > JIM -- Jim Hatridge Linux User #88484 -- BayerWulf Linux System # 129656 The Recycled Beowulf Project Looking for throw-away or obsolete computers and parts to recycle into a Linux super computer - 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: simple question on joining tables
Yaniv, Set the field of user_id to INT then make the size 10 or larger, which will produce an ID size of up to 99. Now set it to auto increment then set the user_id field to Primary key, this should solve your problem, if I understand you correctly -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 11:02 AM To: [EMAIL PROTECTED] Subject: simple question on joining tables Hi everyone, I am starting my first mySQL project . I want to create 2 tables Table User : userId , FisrtName, LastNAme, Gender with userId defined as the primary key that auto-increments I want that each time I insert a new row in this table, the field "userId" is inserted as well in another table named Results Table Results : userId, Category, ResponseText, I read carefully the mySQL tutorial and tried to define userId field when creating Table Resultsas follows : "userId smallint not null referenced user ". I tried to use then the function last_insert_id to insert new rows in Table Results but it didn't work . I always get "0" in the userId field of TableResult. Thank you very much in advance for your help ! - 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: forms?
I personally use PHP which it would use your familiar web browser. You can also use PERL, and I believe ASP as well. PHP is easy for a front end and doesn't take much to develop! There is also a web based GUI for mySQL called phpmyadmin which is awesome if you know nothing about administering mySQL. You can pratically do anything from it! Good luck! -Original Message- From: Jim Hatridge [mailto:[EMAIL PROTECTED]] Sent: Monday, February 11, 2002 8:21 AM To: [EMAIL PROTECTED] Subject: forms? Hi all... First of all, I think that MySQL is really great. The only thing I need now is a way to do forms. What I'm looking for is something that will allow me to do data input, update, output either at the command line or by browser, but only if I can use lynx as the browser. I wrote a database system for my stamp export company back around 1990 in Dbase III+. That system is getting very old now. DBase III + has scripts and forms. Something like this is what I'm looking for. Thanks JIM -- Jim Hatridge Linux User #88484 -- BayerWulf Linux System # 129656 The Recycled Beowulf Project Looking for throw-away or obsolete computers and parts to recycle into a Linux super computer - 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 - 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: How to access MySql using Perl. Help
http://www.hotscripts.com Or http://www.scriptsearch.com Both sites show examples on how to contect to a database with perl or PHP. They also show how to connect to other databases! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 3:11 AM To: Andy Cheng Cc: [EMAIL PROTECTED] Subject: Re: How to access MySql using Perl. Help > I am new to MySql. I have MySql installed in my Linux PC. How do I connect > to MySql using Perl script and assign the result of a query to an array? > Where could I find a sample code? Thank you. man DBD::mysql Cheers. -- Luis Calero Muñoz $email{luis} = '[EMAIL PROTECTED]' $who{luis} = 'sysadm at ociojoven dot com' - 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: Load_File issue
First off, you trying to insert the image into the database or just its path? -Original Message- From: yue cheng [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 2:23 PM To: [EMAIL PROTECTED] Subject: Load_File issue Hi, Now I am puzzled by the filepath,Load_file, I install MySQL in Windows98, the file which i want to insert to table is c:\P1.bmp when I run load_file in mysql command line,it succeeds mysql> insert into blobtable (load_file("/P1.bmp")) but i don't know why i should use slash instead of backslash on windows. if i use the absolute path load_file("c:\P1.bmp"), the blob field in table is NULL I also run insert into blobtable (load_file("/P1.bmp"))in mysqlgui,it also insert null to table. i run this query in my Visual basic, same problem. _ Do You Yahoo!? µ½ÊÀ½ç±Ö÷Ì⹫԰ÍæÒ»Í棬ӮȡÊÀ½ç±ÃÅƱÀÖÒ»ÀÖ¡£ http://cn.worldcup.yahoo.com/ - 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 - 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: Duplicate Records
First off, You would need to add an "id" field, then set it to a primary key, then set it to "auto_increment" This will order them correctly -Original Message- From: Rich [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 10, 2002 10:31 AM To: MySql Subject: Duplicate Records How does one go about removing one of two identical records in a MySQL database? My mistake in an earlier database was not applying a unique number to each record (1, 2, 3, ---). I know it's possible to use the DISTINCT operator to show only one of the identical records in a result, but that does not remove one of them from the database. One thought that I had would be to add a unique number to each record, and that could probably be done manually, one record at a time, but is there a way to automate the process so that unique numbers could be assigned with one command? TIA Rich -- [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 - 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: Load_File issue
First off, you trying to insert the image into the database or just its path? -Original Message- From: yue cheng [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 2:23 PM To: [EMAIL PROTECTED] Subject: Load_File issue Hi, Now I am puzzled by the filepath,Load_file, I install MySQL in Windows98, the file which i want to insert to table is c:\P1.bmp when I run load_file in mysql command line,it succeeds mysql> insert into blobtable (load_file("/P1.bmp")) but i don't know why i should use slash instead of backslash on windows. if i use the absolute path load_file("c:\P1.bmp"), the blob field in table is NULL I also run insert into blobtable (load_file("/P1.bmp"))in mysqlgui,it also insert null to table. i run this query in my Visual basic, same problem. _ Do You Yahoo!? µ½ÊÀ½ç±Ö÷Ì⹫԰ÍæÒ»Í棬ӮȡÊÀ½ç±ÃÅƱÀÖÒ»ÀÖ¡£ http://cn.worldcup.yahoo.com/ - 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: Bandwidth Throttling - a followup
Yes, the other option is to move it to a server with more bandwidth :) Most People that are running it from home either don't know how or don't know that they are running a firewall or have an ISP that won't let them touch the configuration of the modem/router. So you are one of the lucky ones. -Original Message- From: Gary Huntress [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 03, 2002 10:21 AM To: [EMAIL PROTECTED] Subject: Bandwidth Throttling - a followup A few weeks ago I posted a question regarding bandwidth management for a very busy mysql server that is swamping my cable modem upload bandwidth and impacting the rest of my network. I was seeking a way to manage connections by capping the data transferred and I wondered if this would impact MySQL. The consensus was no, and that was good :) Even though my solution had nothing really to do with MySQL I want to post it here in case anyone else has a similar situation. I thought that I needed to modify my ipchains firewall rules, when in fact what I really needed to do was built into iproute2 "traffic shaping" commands.FYI tc qdisc was exactly what I needed. Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - 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: Urgent Business Assistance.
If its so urgent and private then why are you spamming a mail list? I smell scam, or is that Spam? -Original Message- From: Engr. Martin Douglas. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 2:28 AM To: [EMAIL PROTECTED] Subject: Urgent Business Assistance. Urgent Business Asistance. Engr Martin Douglas. No. 16 Kingsway road, Ikoyi lagos Nigeria. Tel/Fax:: 234-1-7742913 30th,January 2002. Dear sir, REQUEST FOR URGENT BUSINESS RELATIONSHIP. First, I must solicit your confidence in this transaction. This is by virtue of its nature as being utterly confidential and top secret. You have been recommended by an associate who assured me in confidence of your ability and reliability to prosecute a transaction of great magnitude involving a pending business transaction requiring maximum confidence. We are top officials of the Federal Government Contract Review Panel who are interested in importation of goods into our country with funds which are presently trapped in Nigeria. In order to commence this business we solicit your assistance to enable us RECIEVE the said trapped funds ABROAD. The source of this fund is as follows : During the regime of our late head of state, Gen. Sani Abacha, the government officials set up companies and awarded themselves contracts which were grossly over- invoiced in various Ministries. The NEW CIVILIAN Government set up a Contract Review Panel (C.R.P) and we have identified a lot of inflated contract funds which are presently floating in the Central Bank of Nigeria (C.B.N). However, due to our position as civil servants and members of this panel, we cannot acquire this money in our names. I have therefore, been delegated as a matter of trust by my colleagues of the panel to look for an Overseas partner INTO whose ACCOUNT the sum of US$31,000,000.00 (Thirty one Million United States Dollars) WILL BE PAID BY TELEGRAPHIC TRANSFER. Hence we are writing you this letter. We have agreed to share the money thus: 1. 70% for us (the officials) 2. 20% for the FOREIGN PARTNER (you) 3. 10% to be used in settling taxation and all local and foreign expenses. It is from this 70% that we wish to commence the importation business. Please note that this transaction is 100% safe and we hope THAT THE FUNDS CAN ARRIVE YOUR ACCOUNT in latest ten (10) banking days from the date of reciept of the following information by TEL/FAX: 234-1-7742913: A SUITABLE NAME AND BANK ACCOUNT INTO WHICH THE FUNDS CAN BE PAID. The above information will enable us write letters of claim and job description respectively. This way we will use your company's name to apply for payments and re-award the contract in your company name. We are looking forward to doing business with you and solicit your confidentiality in this transaction. Please acknowledge receipt of this letter using either Tel/Fax number 234 1 7742913, I will bring you into the complete picture of this pending project when I have heard from you. Yours Faithfully, Engr. Martin Douglas. - 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: MySQL Checkbox table field
VarChar Usually -Original Message- From: Vernon A Webb [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 9:58 AM To: [EMAIL PROTECTED] Subject: Re: MySQL Checkbox table field Alright then! > database,sql,query,table Which field type do I use for a simply checkbox Y,N? Thanks - 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: How does one put images into a MySql database
If its a web based DB, then put the URL path in the text field of the DB. Otherwise if you put the images into the database, the database will become overwhelmed, plus a bunch of wasted disk space -Original Message- From: Brian P. Austin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 8:27 AM To: Rochester, Dean Cc: mysql Subject: RE: How does one put images into a MySql database You can put images in the DB, but the easiest way is to put the path to the images in a text field, and rely on the disk to send the images. hope that helps, Brian -Original Message- From: Rochester, Dean [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 7:50 AM To: MySQL (E-mail) (E-mail) Subject: How does one put images into a MySql database Greeting all Is there a way to put images like jpgs, tifs, gifs, bmp files into a mysql database? I have done this with OLE objects using MS Access... can this be done using the blob data type some how? Thanks in advance Dean-O - 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 - 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: Porting from MS SQL to MySQL
I would say it would take a month at least to complete the job correctly. I have seen some top OLAP developers take 3 months to complete a 30gb DB2 to an Essbase migration including all documentation and politics involved. Two hours? You should be fired for just thinking that! Just kidding. The whole project scope of a migration is HUGE! Here would be a vague outline of this type of project: 1. Politics 2. What can mySQL do that MS SQL cannot do? 3. Technical issues 4. Documentation 5. Schemas 6. admin functions 7. training 8. post installation testing 9. pre install testing, Beta 10. load testing 11. get the picture? This is NOT a two hour job! -Original Message- From: Tony Buckley [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 10:56 AM To: j.urban Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Porting from MS SQL to MySQL - Original Message - From: "j.urban" <[EMAIL PROTECTED]> To: "Tony Buckley" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, January 18, 2002 4:07 PM Subject: Re: Porting from MS SQL to MySQL > > Porting a DB takes more 'than a couple of hours'. What about the written > > procedures, the security mappings, the back up and recovery procs, the > > fallback arrangements, the testing etc. > > Yes, porting a database that was written for MSSQL with no intention of > porting can be a painful proposition. However, if you have control over > how the system is developed, you can easily design the system to be > compatible with EITHER MSSQL or MySQL (the differeces are > well-documented). If you develop your system with porting in mind (ie the > original post of "they'll develop in SQLServer and port it to MySQL > later") porting should not take more than a couple of hours. You simply > choose appropriate datatypes and don't use MSSQL-specific extensions... > > I still don't agree with this. Yes you can ease the passage by considering all the issues up front but it is still not a trivial job for a database of any consequence. There is more to a database than a physical schema - what about all the administration procedures that sit around it, what about tuning the new physical implementation, what about reviewing the access paths and optimisation, what about the redevelopment of data loading scripts. As I have said in another post, it's futile arguing about it because we don't know enough about the technical situation let the business/political one. Are you seriously saying you could sit down in front a reasonably sized DB you had never seen before and understand all the business issues and pick it up and ship to a new RDBMS and platform, rewrite the document, replan what I have stated above, and get it back up and running in two hours? Perhaps I am getting too old and slow but it would take me longer :-) I am not saying it's a huge task to do any of this but whoever said, "I could do it in a couple of hours", doesn't understand the background that led to a company quoting E18k; nor do any of us, and for anything other than a very very trivial system, two hours seems inadequate. This is an area that interests me, because I directly bid for work such as this, and when tendering you usually find the bloke down the road working out of his spare bedroom that thinks he can do it for a tenner over one day. The company requesting the work then thinks that everyone else is overinflating their prices so goes cheap and pays for it big time downstream. Cheapest and quickest is rarely best. On the flip side, nor is most expensive. Tricky world init. Tony - 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: Porting from MS SQL to MySQL
I agree. I have more experience with MS SQL than mySQL, but there are some MS SQL specifics that can cause hiccups. But these hiccups can be avoided with a bullet proof project plan and excellent documentation. You may not be able to automate all the project procedures and a lot of the database re-construction, which is OK. Make sure you run a test system to see if the migration is successful. Migrations are my specialty! Good luck, and don't be afraid to ask questions on the migration! -Original Message- From: j.urban [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 10:08 AM To: Tony Buckley Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Porting from MS SQL to MySQL > Porting a DB takes more 'than a couple of hours'. What about the written > procedures, the security mappings, the back up and recovery procs, the > fallback arrangements, the testing etc. Yes, porting a database that was written for MSSQL with no intention of porting can be a painful proposition. However, if you have control over how the system is developed, you can easily design the system to be compatible with EITHER MSSQL or MySQL (the differeces are well-documented). If you develop your system with porting in mind (ie the original post of "they'll develop in SQLServer and port it to MySQL later") porting should not take more than a couple of hours. You simply choose appropriate datatypes and don't use MSSQL-specific extensions... On Fri, 18 Jan 2002, Tony Buckley wrote: > - Original Message - > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Friday, January 18, 2002 2:14 PM > Subject: Re: Porting from MS SQL to MySQL > > What about the customer who asks a car company to make the vehicle's tryes > out of velvet? Would you go off in a huff if they refused and demand they > do it? There are obviously issues here that we are not privy to; there > *must* be logic behind the choice of SQLServer. Are they saying that mySQL > isn't upto it? > > Porting a DB takes more 'than a couple of hours'. What about the written > procedures, the security mappings, the back up and recovery procs, the > fallback arrangements, the testing etc. > > If you think E18k is a lot then ask for a detailed task plan with effort; > find out what they are asking you to pay for. > > The DB was described as 'fairly complicated' whatever that may mean. > Perhaps - and we are all guesing - there are remote data issues, views, > stored procs, java and god knows what else that all needs to be integrated. > > Bottom line when you get a quote is find out what they want to do task by > task and then cut it down from there. > > Tony > > > > - > 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 - 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: setting root psswd on Win2K ??
Gerald... He isn't on a Unix box, he is on a Win2k box -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 8:46 AM To: Bryan Capitano Cc: [EMAIL PROTECTED] Subject: Re: setting root psswd on Win2K ?? You can't login as plain old nobody. The default mysql user is your unix user, so if you are logged into unix as root , and entered "mysql" you were logged into mysql as root. You appear to have been logged in as "mysql". If the user "mysql" has full privileges, then there was nothing to prevent the deletion. Bryan Capitano wrote: >Having some problems setting root password on MySQL. Can anybody help >me? > >I've just installed MySQL 3.23.38 on a Windows 2000 server. >I'm following the directions in the documenation for setting the root >password: > >>mysql -u root mysql >> >mysql>UPDATE user >mysql>SET password=password('mynewpass') >mysql>WHERE user='root'; >mysql>FLUSH PRIVILEGES; > >okay, all seemed fine. now if I log out and log back as pain old nobody: > >>mysql >> >mysql>use mysql; >mysql>drop table user; >okay 1 table affected. > >How come just anybody can log into my MySQL server and start dropping >tables >in the mysql database?? This shouldn't be right. What have I done wrong? > >Either I have a serious mis-understanding or something is seriously not >right here. > >Thanks for any help! > > > > > > >- >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 - 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: AS SEEN ON NATIONAL TV: MAKE OVER $500,000 EVERY 20 WEEKS!!
I deleted it too! Guess what, I don't miss it either! -Original Message- From: Reports [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:12 AM To: [EMAIL PROTECTED] Subject: AS SEEN ON NATIONAL TV: MAKE OVER $500,000 EVERY 20 WEEKS!! Dear Friend: The first time I received this in my e-mail I deleted it! And later wished I had it back! I had to wait months before someone E-mailed me again with this offer! I always thought I would wait until later to try this. I wish I had done it sooner now! Don't do what I did! Make Sure you Go For It! I personally thought that this would not work! But just like many of you, I was involved in MLM marketing, which in most cases did not work! I was spending from $20 to $200 a month on FFA pages and other things to get leads to market my product. Unfortunately, as I'm sure many of you have no doubt noticed, most people who post to theses pages are like you and I. They have a product to sell! They're not there to BUY! So most of us end up spinning our wheels and getting NO WHERE! SO I thought when I came across this E-Mail... HECK, What did I have to lose? It was a lot less money than what I had been spending, and it was only $25.00. I thought even if it did not work, I have already lost a lot more money than that from other MLM and scams on the net, what was another $25.00? And I did see this on T.V. So I gave it a shot. AND BOY I AM GLAD I DID The first month only a few hundred came in, but the following month I could not believe it the response! It really worked!!! So now I am going to run it one more time! And I Am sure it will be just as good as the first time! That is what is nice about this program...you can start over and over again once you're off the 5th level. If you're A GOOD HONEST PERSON IT WILL WORK FOR YOU TOO!! GO FOR IT! MAKE YOUR DREAMS COME TRUE! AS SEEN ON NATIONAL TV: Making over half million dollars every 4 to 5 months from your home for A one-time investment of only $25 U.S.!! Before you say ''BULL'', please read the following. This is the letter you have been hearing about on the news lately. Due to the popularity of this letter on the Internet, a national weekly news program recently devoted an entire show to the investigation of this program described below, to see if it really can make people money. The show also investigated whether or not the program was legal. Their findings proved once and for all that there are ''absolutely NO Laws prohibiting the participation in the program and if people can -follow the simple instructions, they are bound to make some mega bucks with only $25 out of pocket cost''! === This is what one participant had to say: '' Thanks to this profitable opportunity. I was approached many times before but each time I passed on it. I am so glad I finally joined just to see what one could expect in return for the minimal effort and money required. To my astonishment, I received total $610,470.00 in 21 weeks, with money still coming in''. Pam Hedland, Fort Lee, New Jersey. === Here is another testimonial: ''' This program has been around for a long time but I never believed in it. But one day when I received this again in the mail I decided to gamble my $25 on it. I followed the simple instructions and whalaa . 3 weeks later the money started to come in. First month I only made $240.00 but the next 2 months after that I made a total of $290,000.00. So far, in the past 8 months by re-entering the program, I have made over $710,000.00 and I am playing it again. The key to success in this program is to follow the simple steps and NOT change anything.'' More testimonials later but first: = PRINT THIS NOW FOR YOUR FUTURE REFERENCE If you would like to make at least $500,000 every 4 to 5 months easily and comfortably, please read the following...THEN READ IT AGAIN and AGAIN!!! FOLLOW THESE SIMPLE INSTRUCTION AND YOUR FINANCIAL DREAMS WILL COME TRUE.GUARANTEED! =ORDER ALL 5 REPORTS SHOWN ON THE LIST BELOW = For each report, send $5 CASH, THE NAME & NUMBER OF THE REPORT YOU ARE ORDERING and YOUR E-MAIL ADDRESS to the person whose name appears ON THAT LIST next to the report. MAKE SURE YOUR RETURN ADDRESS IS ON YOUR ENVELOPE TOP LEFT CORNER in case of any mail problems. === When you place your order, make sure you order each of the 5 reports. You will need all 5 reports so that you can save them on your computer and resell them. YOUR TOTAL COST $5 X 5=$25.00. Within a few days you will receive, via e-mail, each of the 5 reports from these 5 different individuals. Save them on your computer
RE: Prevent WinMySQLAdmin from auto startup when windows 98 reboots
Just take the shortcut out of the startup menu -Original Message- From: Dan Jordan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 10:04 AM To: [EMAIL PROTECTED] Subject: Prevent WinMySQLAdmin from auto startup when windows 98 reboots Each time that I reboot and logon to my windows 98 server, WinMySQLAdmin starts and then starts mysqld. I do not want this behavior (acting like a service). What do I need to do to prevent this, including uninstalling WinMySQLAdmin, which I have not figured out how to do? When I remove my.ini from C:\Windows and reinstall C:\my.cnf, then the my.cnf gets renamed to my_cnf.bak and a minimal C:\Windows\my.ini is created when I reboot. Is there a flag for the [WinMySQLAdmin] section in the my.ini file that I can declare which will instruct WinMySQLAdmin not to auto start when the computer is rebooted? Thanks, Dan Jordan - 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: MySQL and COM+
I think I read something about COM+. The statement I read said it is compatible, but I don't know about MSTDC, I would think that MSTDC would be a Microsoft propriotary interface. - Original Message - From: "Patryk Choroś" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 04, 2002 8:42 AM Subject: MySQL and COM+ > Hi! > > Have anyone of you used mysql and com+? is it possible to get com+/mstdc > transactions to work with mysql? > > TIA > > Patryk > > > - > 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: Could you look at this PHP/MySQL Code?
You could just do this: $result = ($sql3); echo "$result"; - Original Message - From: "Michael Brunson" <[EMAIL PROTECTED]> To: "Matt Rudderham" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002 1:35 PM Subject: Re: Could you look at this PHP/MySQL Code? > On Wed, 2 Jan 2002 15:30:51 -0400, "Matt Rudderham" <[EMAIL PROTECTED]> wrote: > > | Hi, > | This is generating an error: > | > | Warning: Wrong parameter count for mysql_result() in > | /usr/local/www/html/matt/add.php on line 27 > | > | I can't figure out what the problem is, here is the code in question, it > | is part of an HTML form: > | > | <--Snip connect etc.. --> > | // process form > | > | $sql = "INSERT INTO members > | (first,last,position,organization,address,postal_code,county,phone,fax,e > | mail,website,member_type,on_directory,on_website,description,active,expi > | re_date) VALUES > | ('$first','$last','$position','$organization','$address','$postal_code', > | '$county','$phone','$fax','$email','$website', > | '$member_type','$on_directory','$on_website','$description','$active','$ > | expire_date')"; > | $result = mysql_query($sql); > | echo "Member Added\n"; > | $sql2 = "select max(member_id) from members"; > | $member_id = mysql_query($sql2); > | echo "$member_id"; > | $sql3 = "INSERT INTO skills (member_id, name, schooling, > | certifications, description) VALUES > | ('$member_id','$skill_name','$schooling','$certifications','$skill_descr > | iption')"; > | $result = mysql_result($sql3); > | echo "$result"; > | ?> > > > http://www.php.net/manual/en/function.mysql-result.php > > mixed mysql_result (resource result, int row, mixed [field]) > > Requires at least 2 arguments. > > > Thanks, > Michael > -- > Michael Brunson 504.473.6643 > [EMAIL PROTECTED] ICQ: 83163789 > --- Intercosmos Media Group, Inc. --- > www.intercosmos.comwww.directnic.com > > - > 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: Implement a menu structure using an relative database
non data driven menus not an option? I have buit java-script menus that are pretty cool - Original Message - From: "Jonathan Hilgeman" <[EMAIL PROTECTED]> To: "'Victor Spång Arthursson'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002 11:02 AM Subject: RE: Implement a menu structure using an relative database > This might help: > http://php.sitecreative.com/faq.php#3 > > - Jonathan > > -Original Message- > From: Victor Spång Arthursson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 02, 2002 8:59 AM > To: [EMAIL PROTECTED] > Subject: Implement a menu structure using an relative database > > > Hi! > > I'm currently working on a menu system for web pages, but I've run into > some problems... > > What I'ld like to create is a menu which can "host" an infinite number > of submenus. Further more, every menu should also be able to link to a > specific file, though not always used. > > I would like to be able to get the entire menu in one sql-line, that is, > I would like to be able to get the following in one line: > > -> menu1 > -> menu2 > -> menu1 > -> menu2 > -> menu1 > -> menu2 > * some text > * some more text > -> menu3 > -> menu3 > -> menu3 > > I'm doing my scripting in PHP, but I want as much as possible of the > menu structure to be only mySQL-specific. But having to use some loops > to be able to create the sql-line is no problem. > > I desperately need help on this one, I've put down much energy and time > to solve it but... > > Sincerely > > Victor Spång Arthursson > > > - > 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 > - 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: Select statement with decimals as a record...
I found an easier way... switch the datatype to decimal, WHAMMO!! works beautifully! - Original Message - From: "Steve Rapaport" <[EMAIL PROTECTED]> To: "Todd Williamsen" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, December 29, 2001 7:03 PM Subject: Re: Select statement with decimals as a record... > Todd, this result is perfectly correct if they are both strings: > > "52.50" is greater than "358". To make them interpreted as > numbers instead, see the manual page: > > http://www.mysql.com/doc/C/o/Comparison_Operators.html > > Steve > > Todd Williamsen wrote: > > > I have a record that keeps track of averages, now when I say > > > > SELECT * FROM tblname ORDERBY 'average' DESC; > > > > It returns the one with the largest amount of intergers... > > > > I.E. > > > > It will say that 52.50 is a larger number than 358, why is that? Is that a > > table column setting of a datatype? > > > > > > - > > 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 > > > > > > > > > -- > Steve Rapaport > World Citizen > - 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
Select statement with decimals as a record...
I have a record that keeps track of averages, now when I say SELECT * FROM tblname ORDERBY 'average' DESC; It returns the one with the largest amount of intergers... I.E. It will say that 52.50 is a larger number than 358, why is that? Is that a table column setting of a datatype? - 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
UPDATE command, adding to exisiting record
I am looking to update a record in a table, but take the exsisting value and adding the new value to it... I.e. Exsisting record = 150, new record being inputed = 250 for a total of 400 to be entered into the database. I have looked at the man pages on this but all it gives is static numbers, I need something that is being fed from a form and the new values will always be different. - 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: Location of text file for loading data in to table
LOAD DATA LOCAL INFILE "location of text file" INTO TABLE [tablename] - Original Message - From: "Inderpal Singh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, December 16, 2001 8:12 AM Subject: Location of text file for loading data in to table > Hi, > When using the command: > LOAD DATA LOCAL INFILE "xxx.txt" INTO TABLE [TABLE NAME]; > > where should the txt file be located? > > Thanks > > > > > _ > Chat with friends online, try MSN Messenger: http://messenger.msn.com > > > - > 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: Table Exists
Mysql>show tables; Would be the easy way Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 10:34 AM To: [EMAIL PROTECTED] Subject: Table Exists What is the easiest way to check if a table exists in the current database? I checked the documentation, and couldn't find anything (but maybe I missed it). Glen - 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: new user basic questions
Welcome to the Club! Connecting to a mySQL database would be the same way in VB6 as MS SQL or Access, via ODBC. You should download myODBC from mysql.com. On Microsoft Oses it is easier to develop apps via ODBC because its like saving you 5-10 lines of code to write. If it's a web application and you need to upload it to *Nix box, then you should NOT use ODBC. As Brandon previously stated. Microsoft sometimes say they have "standards in place" which really means they made up their own *cough*java*cough* The only database that is even NEAR the SQL92 standards is Microsoft's MS SQL Server 6.5 - 2000, and this isn't even SQL92 standard! Either is Oracle ( I think) I doubt that Microsoft will come out with documentation on VB front ends with mySQL backends. But I am sure there are people that do do it! I just find it easier with an HTML front end than VB or any other programming language! Good Luck! Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Rodney Broom [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 2:28 PM To: [EMAIL PROTECTED] Subject: Re: new user basic questions From: <[EMAIL PROTECTED]> > I am new to dababases in general... Learn SQL (which it sounds like you've done). It's almost always going to be the standard tool between various database vendors and APIs. > ...would like to use Visual Basic ...to edit the database. I won't make any MickySoft vs. *NIX cracks. I'm not a VB person, but I'm thrilled to see students working with real world tools. (In school, all I got was an abacus.) I searched briefly on the mysql.com site and found a few listings. http://www.mysql.com/doc/manual.php?search_query=VB&depth=0 In short, it still looks like ODBC is the way to go. I've had folks connect their MS Access and Crystal Reports via ODBC to my MySQL databases and only had limited problems. For instance, the int() in MySQL was too big for Crystal Reports. > -at least one way to connect to the Mysql database with VB6 To use ODBC, you set up a user/pass/host in MySQL to allow clients to connect. Then you set up a DSN on your MS Windows machine that points at the MySQL host, using the proper user/pass. You'll need the ODBC drivers, I can only suggest checking your VB docs, and/or the "ODBC Data Sources" option in the Control Panel to figure this out. As for writing the actual connect statement, I don't have the foggiest idea. Check the docs that came with your compiler. > -what commands I can use in VB6... I can't help you there. Definately the docs that came with your compiler. > ...a site that will point out how to use the commands ~Maybe~ microsoft.com. My experience is that their site is usually not very helpful. > -can I use an SQL book for reference on commands Yes, or the MySQL docs (section 6 on the mysql.com site). Unless you run into one of the many situations where MicroSoft is claiming that they are using a standard when they really aren't, then most of your SQL92 knowledge should just work through any API on any SQL database. At the very least, if VB6 offers a direct SQL interface to MySQL, then you should be able to do anything with SQL that MySQL says it supports. > ...only a senior in high school "Only"? In just a few years, you and your pals will be running the world. > ...so I have no one to turn to except the internet and searching > through the archives is the only help I have had so far. Heh, join the club. Don't worry about your resources not being human beings. Finding and maintaining a good set of documentation that works for you is a big part of what makes you salable in the real world. Life on the job is an open book test; you don't have to know everything, you just have to know how to find it fast enough to make your boss happy. > Any help with any of those questions is much appreciated. I'm very encouraged to see a newcomer here. I hope that you get plenty of assistance from this group. Hint, hint. --- Rodney Broom Programmer: Desert.Net - 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: Viewing table data in a webpage using ASP
Here is your problem: MM_TrackoftheWolf_STRING = "dsn=DSN Name;uid=User Id;pwd=Password;" No space between Id;pwd Unless that is what happened when you copied and paste it Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Nick Boldt [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 3:19 PM To: [EMAIL PROTECTED] Subject: RE: Viewing table data in a webpage using ASP Here is the connection code I use to view record information from a table. I'm using Dreamweaver Ultradev 4 to help with some of the basic coding. I am using MyODBC. <% MM_TrackoftheWolf_STRING = "dsn=DSN Name;uid=User Id;pwd=Password;" set ship_address = Server.CreateObject("ADODB.Recordset") ship_address.ActiveConnection = MM_TrackoftheWolf_STRING ship_address.Source = "SELECT * FROM customershipping" ship_address.CursorType = 0 ship_address.CursorLocation = 1 ship_address.LockType = 3 ship_address.Open() ship_address_numRows = 0 %> <% Dim Repeat1__numRows Repeat1__numRows = -1 Dim Repeat1__index Repeat1__index = 0 ship_address_numRows = ship_address_numRows + Repeat1__numRows %> Nick Boldt Computer Network Administrator Track of the Wolf Elk River, MN 55330 Tel: 763-633-2500 Fax: 763-633-2550 [EMAIL PROTECTED] -Original Message- From: Christopher R. Jones [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 3:07 PM To: Nick Boldt Subject: Re: Viewing table data in a webpage using ASP If you have MyODBC installed and working you should be able to view the records. I have a number of WEB pages that display MySQL data using ASP/ADO. You should send an example of you ASP script to the group to help clarify your problem. >Hi, > >I'm trying to view the records of a table in on a webpage, but nothing >is showing up. I can add records to the table from the page but cannot >view, update or delete them. > >I'm using Windows 2000 and IIS 5.0 > >I'm new to MySql and would greatly appreciate any help anyone can give >me. > >Nick Boldt >Computer Network Administrator >Track of the Wolf >Elk River, MN 55330 >Tel: 763-633-2500 Fax: 763-633-2550 > > >- >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 Christopher R. Jones, P.Eng. 14 Oneida Avenue Toronto, Ontario M5J 2E3 Tel. 416 203-7465 Fax. 416 203-8249 Email [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 - 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: Avery Labels with MySQL
I guess I would run a query to pull the data out into a CSV file, then import it into Excel, then convert it to a Word document. Or run a query where MS Access pulls the data and syncs it with a database in Access, then export the table into Excel or Word or Outlook PST file Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 02, 2001 7:32 PM To: [EMAIL PROTECTED] Subject: Avery Labels with MySQL Hi, I am creating a PHP/MySQL web based app that takes contact information in. I would like to be able to make Avery Address Labels with the data that I get. Any ideas on how to do this? I'm guessing MS Access might be able to help with this (if it handles MySQL) cause I know the Office products have Avery Wizards. Thanks in advance for any help. Kurt Giessler - 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: MySQL v.s. Oracle
MySQL is faster than any other database out there on small to medium sized web sites, but when you are going into larger sites, like yours, Oracle or MS SQL Server will be better suited for the task. Oracle does have one major draw back Price... For your size, you will spend in the neighborhood of $30,000+ for Oracle. You can try MySQL and see how it does, but I am sure it will hit its limits. In a situation like yours, you are best to be prepared, not unprepared. Oracle will do the job and then some. If the price of Oracle scares you, what about load balancing the mySQL server into several web servers/database servers and making it into a server farm? One server will get the snot knocked out of it with that kind of load. Just my $.02 Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Philip Mak [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 9:59 PM To: MySQL Mailing List Subject: MySQL v.s. Oracle Hi all, We are currently using MySQL for our database driven website. Currently, we have about 100,000 users. In January, we will be getting 2 million new registered users on our website. We're buying a $50,000 Sun box to run the database server on. We're deciding whether we should switch to Oracle. Can MySQL handle this kind of load? The president (who doesn't know much about databases) was thinking about buying Oracle, but from what I've heard, Oracle is actually slower than MySQL since it needs to check FOREIGN KEYs, TRIGGERs, ASSERTIONs, etc. Can someone provide some advice? Thanks. My main concern is whether that massive scale (2 million registered users, along with all the data and CPU load they generate) is supported by MySQL. - 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: PHP / MySQL username and password creation
What do you mean accept new users? Via adding new people to the MySQL user list or to a web application? Please specify.. Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Anthony Evans [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 10:41 AM To: MYSQL help Subject: PHP / MySQL username and password creation Hi everyone, Is there an online tutorial out there that can help me to create a PHP page that will accept a users new username and password which is then dumped with MySQL ? Your help would be most appreciated. Anthony - 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: How To Install Under MacOS X?
I am going to take a stab at this... Since MacOS X is actually an open sourced kernel, I would assume you could use the Linux or Unix version to install it. I have not worked with MacOS X, but if I remember correctly it had a command prompt. Let me know if it works Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Kurt Tappe [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 10:14 AM To: [EMAIL PROTECTED] Subject: How To Install Under MacOS X? I'm stuck trying to figure out how to install this thing. What I've tried: * The download doesn't contain a standard MacOS .pkg so I can't do a GUI install. * The command-line instructions require the "groupadd" command in step #1, but MacOS doesn't support this due to the existence of the NetInfo system. * Turning to the "manual.html" included in the MacOS X build, only Linux and Windows are mentioned. Can anyone who has successfully installed MySQL under MacOS X tell me how they did so?? Thanks, -Kurt -- I haven't failed, I've found 10,000 ways that don't work. -- Benjamin Franklin - 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: synchronising mysql and access2k data
Use myODBC to use an ODBC connection. If you are using a hosting provider on a Unix box, more than likely this will not work Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: dean browett [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 5:55 AM To: [EMAIL PROTECTED] Subject: synchronising mysql and access2k data Hi, Has anybody had experience of trying to synchronise an access 2000 db with a mysql db? If so could you enlighten me as to where I can get further information/drivers to enable me to do this. TIA Regards Dean - 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
Dumb Question: Listing tables in telnet
I looked all through the documentation for this and I cannot find the command for listing tables in mysql in telnet. I get this: Mysql> show tables -> I have no idea what the arrow does and what I am suppose to do with it. I type in commands and it just does another -> What is that? Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 - 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: How to Access MySql Database?
Sounds like you have a TCP socket problem. Is the database on a local machine or a hosting provider? What platform is it on wintel or *nix? Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Georgina Fang [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 10:14 PM To: [EMAIL PROTECTED] Subject: How to Access MySql Database? Hi: I telnet to the server. But I can not get into MySql database. What's the problem? % mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) % mysql -p linksdb Enter password: Then I type in password, and got the following: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I also tried the following: (for username I typed in real username) % mysql -u username -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) What's my problem? Thanks in advance! -- Georgina __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com - 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: Need A book for dynamic website
Brian... You can SLAM yourself into a wall of confusion if you do not pick the right books that doesn't explain things to you like a two year old. I like books that explain things that way when I learn a new technology. It keeps the frustration away Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Bryan Capitano [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 14, 2001 10:29 AM To: Webmaster; mysql Subject: Re: Need A book for dynamic website "PHP and MySQL Web Development" by Luke Welling and Laura Thomson (Sams Publishing, Copyright 2001) is the best book on the market I think. But it depends on your skill level. This book has a section on basic PHP language, another section on setting up MySQL databases, and a third section with practical examples of PHP/MySQL projects, including source code etc. This book covers 90% of everything you'd need to REALLY know. For the other 10%, I like to use the WROX series "Professional PHP Programming" by Castagnetto, Rawat, Schumann et. al. It has more fine details of the PHP language which Welling and Thomson just couldn't cover. But the WROX book only has one chapter on interfacing with MySQL. It does have a nice library of MySQL functions in the glossary, however, which Welling and Thomson would have been really wise to incorporate. The two of these books make a SLAMMING dynamic duo. You just can't fail with them. Bryan -- CAPITANO WEB CONSULTING http://www.capitanoweb.com Webmaster wrote: > Hi, > I need a book to teach me how to make a database driven website, I > think php mySql is the way to go and have seen some on amazon and fat > brain but don't know if any are any good, any ideas? > > Thanx in advance > DavidJaymz > Here are the books I'm thinking of: > PHP and MySQL Web Development > Luke Welling, Laura Thomson > > Database Driven Web Sites > By Joline Morrison,Joline Morrison > > Sams Teach Yourself Active Web Database Programming in 21 Days By Dina > Fleet,Matt Warren (Editor) > > Building Database Applications on the Web Using Php3 > By Craig Hilton,Bjorn Borud,Jeff Willis > > Create Dynamic Webpages Using PHP and MySQL > David Tansley > > PHP: Fast and Easy Web Development > J. Meloni > > Thanx again: DavidJaymz > > - > 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 - 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: Need A book for dynamic website
I bought "PHP: Fast and Easy Web Development." Its pretty through and nice walk-throughs for a beginner. You may end up buying several books... This book helps you get your feet wet with PHP and MySQL, but it is no reference on everything. Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 10:04 AM To: Webmaster Cc: [EMAIL PROTECTED] Subject: Re: Need A book for dynamic website I myself like the following PHP4 Bible Sams Teach yourself MySql in 21 days "Webmaster" <[EMAIL PROTECTED]> on 11/14/2001 10:37:53 AM To: [EMAIL PROTECTED] cc:(bcc: Lad Gaal/MarconiMedical) Subject: Need A book for dynamic website Hi, I need a book to teach me how to make a database driven website, I think php mySql is the way to go and have seen some on amazon and fat brain but don't know if any are any good, any ideas? Thanx in advance DavidJaymz Here are the books I'm thinking of: PHP and MySQL Web Development Luke Welling, Laura Thomson Database Driven Web Sites By Joline Morrison,Joline Morrison Sams Teach Yourself Active Web Database Programming in 21 Days By Dina Fleet,Matt Warren (Editor) Building Database Applications on the Web Using Php3 By Craig Hilton,Bjorn Borud,Jeff Willis Create Dynamic Webpages Using PHP and MySQL David Tansley PHP: Fast and Easy Web Development J. Meloni Thanx again: DavidJaymz - 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 - 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: lost in the Land of Oz Parking Lot (I hope this message makes it through!)
Is this your email address? I can send you all the files you need. Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 6:27 PM To: [EMAIL PROTECTED] Subject: lost in the Land of Oz Parking Lot (I hope this message makes it through!) Dear Noble X: {I tried to email you but I failed, MISERABLY!! My AOL Screen Name, Cyberbean, came with attachments, I hope this mail makes it through the border of all that is good. Please Help! Thanks!} I am lost. I am a very VERY green newbie, and I am struggling on just how to begin. Basically, I have bought a book, entitled, "PHP and MYSQL Web Development" . , I have downloaded mysql-3.23.43.tar.gz, the install for windows document (yes I have not even made it passed the Install! Oh I am PATHETIC!) says to use Setup.exe for windows. The problem is I can not find that file anywhere. The bigger problem is, I do not know which 'platform' to enter any code in, and once entered, how do you run it as a web site???. I have been using FrontPage for my website, mothermachine.com (which is in a state of utter chaos) and found that I really do not like FrontPage. My questionable quest began when I tried to authenticate my message base, and I discovered, after a few wrong turns and dead ends, this whole new world. Basically if any of you can help me out by pointing me in a direction for beginners, I will be ecstatic and will return the favor if I can, maybe by, once I learn, helping out another newbie. I tell you, this message is a New Hope, if not a last resort. I have been hunched over my computer for quite some time. I have Windows 98 on an older computer which I am using to experiment with code. Can you help?. Thanks!!! Jason Mintel mail2web - Check your email from the web at http://mail2web.com/ . - 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: MySQL to MS' Access '97
You can use phpadmin to control the database and there is an option to view dump into a CSV file either in MS Excel format or standard CSV file. Once you dumped it, you can then import it into Access Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 03, 2001 7:51 AM To: [EMAIL PROTECTED] Subject: MySQL to MS' Access '97 Does anyone know how to download a table from MySQL (at a server)to MS' Access '97 (at a client)? Thanks! Anthony F. Rodriguez ([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 - 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: MySQL to MS' Access '97
I have done Access to mySQL, but not the other way around... I guess you would need to export the table to a CSV file then import it into Access. Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 03, 2001 7:51 AM To: [EMAIL PROTECTED] Subject: MySQL to MS' Access '97 Does anyone know how to download a table from MySQL (at a server)to MS' Access '97 (at a client)? Thanks! Anthony F. Rodriguez ([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 - 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: Web Hosting
I use www.ccwebhost.com for about two years... $13/mo for 200mb of space and their tech support is beyond excellent! mySQL support, CGI-BIN, FTP, PHP4, SSI, SSL, etc... Anything and practically everything! Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Tony [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 10:45 AM To: [EMAIL PROTECTED]; Joe Fan; [EMAIL PROTECTED] Subject: Re: Web Hosting You might want to try Hurricane Electric, I've been using them for over a year, MySQL, Telent, cgi, email account, DNS support starting at $10/month. http://www.he.net They've been great. Cheers, T On Tuesday 30 October 2001 11:44 pm, Joe Fan wrote: > My current web hosting company (www.ehost.com) does not support MySql. > Is there a way that I can install within my own CGI-bin library? If > not, are there any other open-source RDBMS available that would work > independently of hosting servic? > > Thanks, > > Joe > > > Come visit http://www.joe-fan.com For the Fans, by the Fans ! > > > - > 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 - 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: Running Query
No, The column name should have been "Modified By" data type should have been "text" Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 9:20 AM To: 'Todd Williamsen'; '[EMAIL PROTECTED]' Subject: RE: Running Query "By" is not a legal data type. Did you mean "By text", without the word "Modified"? -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 9:17 AM To: [EMAIL PROTECTED] Subject: Running Query I did a dump of a table from another database table and wanted to run the .sql file in another database. I used PHPadmin to do this and used phpadmin to run the .sql file against the other database I have this is the error from mysql: SQL-query : CREATE TABLE tblmembers ( ID int(11) default NULL, FirstName text, Initial text, LastName text, Address1 text, Address2 text, City text, State text, Zip text, HomePhone text, WorkPhone text, Fax text, Email text, Userid text, Password text, Registered datetime default NULL, Modified datetime default NULL, Modified By text ) TYPE=MyISAM MySQL said: You have an error in your SQL syntax near 'By text ) TYPE=MyISAM' at line 19 Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 - 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
Running Query
I did a dump of a table from another database table and wanted to run the .sql file in another database. I used PHPadmin to do this and used phpadmin to run the .sql file against the other database I have this is the error from mysql: SQL-query : CREATE TABLE tblmembers ( ID int(11) default NULL, FirstName text, Initial text, LastName text, Address1 text, Address2 text, City text, State text, Zip text, HomePhone text, WorkPhone text, Fax text, Email text, Userid text, Password text, Registered datetime default NULL, Modified datetime default NULL, Modified By text ) TYPE=MyISAM MySQL said: You have an error in your SQL syntax near 'By text ) TYPE=MyISAM' at line 19 Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 - 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: web-based interface for manipulating MySQL tables?
No PHPadmin has two versions PHP3 and PHP Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Gonzalo Valenzuela [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 2:39 PM To: Ing. Gustavo Edelstein; [EMAIL PROTECTED]; Bennett Haselton Subject: Re: web-based interface for manipulating MySQL tables? But PhpMyAdmin only use php3 At 12:39 p.m. 30-10-01 -0300, Ing. Gustavo Edelstein wrote: >If you have PHP installed, try phpMyAdmin. It's a very good tool, easy >use and installing. Regards. > >Ing. Gustavo A. Edelstein >Tech. Mgr. >Equiplus Argentina S.A. >__ >Visit us On Line at www.equiplus.com >Email addresses: >Operations: [EMAIL PROTECTED] >Consulting: [EMAIL PROTECTED] >Technical: [EMAIL PROTECTED] >Web related: [EMAIL PROTECTED] >General: [EMAIL PROTECTED] > >- Original Message - >From: Bennett Haselton <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Tuesday, October 30, 2001 11:16 AM >Subject: web-based interface for manipulating MySQL tables? > > > > Is there any pre-written code that allows users, authenticated over > > the Web, to view MySQL tables in their database as HTML tables? > > Desirable features for something like that would include: > > > > - tables are displayed in row-and-column format, with a few blank > > rows at the bottom where you can fill in new values and click to add > > them to the database (assuming that the user viewing the table has > > the appropriate > > rights) > > - values that represent foreign keys are hyperlinked, so that when you > > click on them, you're taken to the appropriate row in the other table > > > > etc. > > > > -Bennett > > > > [EMAIL PROTECTED] http://www.peacefire.org > > (425) 649 9024 > > > > > > > > - > > 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 Saludos. Gonzalo Valenzuela S. Teléfono: 562 2451248 Móvil: 09 4892052 http://www.vianet.cl - 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: SELECT Query in PHP
Yes, I think HTML, mySQL and PHP is a marriage made in heaven but... Online docs is like reading stereo instructions in a foreign language most of the time. I tried the webmonkey.com tutorial and it was ok.. Funny thing is that the script they used, I couldn't get to work... Go figure... Just my luck! Granted I am so new to PHP I think I just eclipsed the 48 hour mark... So am I still a rookie? Lol!! Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Mike [mailto:[EMAIL PROTECTED]] Sent: Friday, October 26, 2001 9:33 PM To: Woolsey, Fred Cc: '[EMAIL PROTECTED] ' Subject: Re: SELECT Query in PHP I think the worst part about the books is that with things like PHP, Apache and MySQL, by the time you find (i.e. from browsing at the local library) and sit down to learn, it's talking about MySQL 3.22, Apache 1.2, and PHP3. Nothing beats the online documentation.. amen to that. :) You might try some sites like webmonkey.com for php tutorials. I think that's where I went when I decided to learn php about.. oh about a year ago. Mike Woolsey, Fred wrote: >Funny... I find the PHP, HTML and MySQL combo to be a marriage made in >heaven. Also, I have not yet seen a book (and I've bought a few of >them) that beats the PHP and MySQL documentation available <> >on the web. Follow the URLs in the other e-mails and you will find the >truth... OK, maybe I exaggerate, but at least you'll find the info you >need. > >Cheers (and remember, "wer immer streibend sich bemueht, den koennen >wir >erloesen."- apologies to Goethe) >Fred Woolsey > >-Original Message- >From: Todd Williamsen >To: [EMAIL PROTECTED] >Sent: 10/26/2001 8:25 PM >Subject: SELECT Query in PHP > >I am a newbie at this and I cannot find the damn answer to it! I want >to display the table in an html format with PHP but I cannot get it to >work! With MS SQL Server it was sooo easy! With PHP and mySQL it's a >pain in the butt! I cannot find any documentation on this and I order >3 books on this stuff, but they won't be here till at least Monday. > >HELP! > >Thank you, > >Todd Williamsen, MCSE >home: 847.265.4692 >Cell: 847.867.9427 > > >- >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 > - 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