Re: error
sure that isn't c:\winnt\system32? see if you can find the libmysql.dll file on your computer and copy it into c:\winnt\system. It's not the most elegant solution...but it'll work. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 31, 2004 7:38 PM Subject: error I've installed mysql on my windows 2000 system, with the windows installer. When it's done and I double click on winmysql admin I get this error - The dynamic link library LIBMYSQL.dll could not be found in the specified path C:\mysql\bin;.;C:\WINNET\system32;C:\WINNT\system etc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [PHP-DB] lamer noob with repeat question
I've got it currently as method=get; I thought it had to be get in order to manipulate variables in the URL, as I've got them...have I thought wrong? - Original Message - From: Ross Honniball [EMAIL PROTECTED] To: Dan Bowkley [EMAIL PROTECTED] Sent: Monday, May 03, 2004 11:53 PM Subject: Re: [PHP-DB] lamer noob with repeat question Have you tried putting in a form method=post action=script-name.php in your html? I'm haven't read all of your email but this is what I use and your html doesn't seem to have this. I think php needs the 'action=' to know what to do when the user submits the form. At 04:37 PM 4/05/2004, you wrote: Anyone? - Original Message - From: Dan Bowkley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, May 02, 2004 1:21 AM Subject: [PHP-DB] lamer noob with repeat question Hello everyone, I've been working on (read:tearing my hair out over) my mom's website for some time now. Specifically, I'm trying to get her work order database up and running. The basic idea is this: you start out adding a new record by going to add.php. It sees that you've not done anything yet and thus presents you with a form to fill out. That form gets submitted to add.php, which sees that you're adding something. It checks for a duplicate work order number (and eventually other errors) and then either adds the stuff you submitted into the DB, or pops an error and presents the form again. Alas, it does nothing. When you initially load the page, it works okay, sensing that you've not yet done anything and displaying the form. But when you submit data, it spits out naught more than a blank page, and doesn't add anything to the database. Damned lazy script. What I've got so far is this: html headtitleThe Board Lady - Work Order Database 0.1a/title/head body ?php define ('DB_USER', 'user'); define ('DB_PASSWORD', ''); define ('DB_HOST', 'localhost'); define ('DB_NAME', 'boardlady'); $dbc = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not connect to database: ' . mysql_error()); @mysql_select_db (DB_NAME) OR die ('Could not connect to database: ' . mysql_error()); $page_req=$HTTP_GET_VARS['action']; if ($page_req == ) {$page_req=0;} if ($page_req == 0) { echo SWORD data entrybr\n; echo form action=\add.php\ method=\get\; echo Work Order #: input type=\text\ name=\wo_num\br\n; echo Customer Name: input type=\text\ name=\name\ Phone: input type=\text\ name=\phone\br\n; echo Email Addy: input type=\text\ name=\email\ Date In: input type=\text\ name=\date\br\n; echo Board Type and SN: input type=\text\ name=\board_type\ Last 3 of SN: input type=\text\ name=\last_three\br\n; echo Weight In: input type=\text\ name=\weight_in\ Weight Out: input type=\text\ name=\weight_out\br\n; echo input type=\hidden\ name=\action\ value=\1\\n; echo INPUT type=\submit\ value=\Add Work Order\ INPUT type=\reset\br\n; } if ($page_req == 1) { $wo_num=$HTTP_GET_VARS['wo_num']; $name=$HTTP_GET_VARS['name']; $phone=$HTTP_GET_VARS['phone']; $email=$HTTP_GET_VARS['email']; $date=$HTTP_GET_VARS['date']; $board_type=$HTTP_GET_VARS['board_type']; $last_three=$HTTP_GET_VARS['last_three']; $weight_in=$HTTP_GET_VARS['weight_in']; $weight_out=$HTTP_GET_VARS['weight_out']; $query_testingforadupe = SELECT job_no FROM boards WHERE job_no == $job_no ORDER BY job_no ASC; $result_testingforadupe = @mysql_query ($query_testingforadupe); if ($result_testingforadupe) { echo That's a duplicate work order number, you ditz. Try again, this time without screwing it all up.brbr\n; echo form action=\add.php\ method=\get\; echo Work Order #: input type=\text\ name=\wo_num\br\n; echo Customer Name: input type=\text\ name=\name\ Phone: input type=\text\ name=\phone\br\n; echo Email Addy: input type=\text\ name=\email\ Date In: input type=\text\ name=\date\br\n; echo Board Type and SN: input type=\text\ name=\board_type\ Last 3 of SN: input type=\text\ name=\last_three\br\n; echo Weight In: input type=\text\ name=\weight_in\ Weight Out: input type=\text\ name=\weight_out\br\n; echo input type=\hidden\ name=\action\ value=\1\\n; echo INPUT type=\submit\ value=\Add Work Order\ INPUT type=\reset\br\n; } else { $query_insert = INSERT INTO boards (wo_num, name, phone, email, date, board_type, last_three, weight_in, weight_out) VALUES (\'$wo_num\', \'$name\', \'$phone\', \'$email\', \'$date\', \'$board_type\', \'$last_three\', \'$weight_in\', \'$weight_out\'); $result_insert = @mysql_query ($query_insert); if ($result_insert == ) { echo input type=\hidden\ name=\action\ value=\0\\n; echo INPUT type=\submit\ value=\Continue\\n; } else {echo OOPS! Your programmer is an idiot!\n;} }} mysql_close(); ? /body
Re: [PHP-DB] lamer noob with repeat question
I pruned it all down ti this: html headtitleThe Board Lady - Work Order Database 0.1a/title/head body ?php define ('DB_USER', ''); define ('DB_PASSWORD', ''); define ('DB_HOST', ''); define ('DB_NAME', ''); $dbc = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not connect to database: ' . mysql_error()); @mysql_select_db (DB_NAME) OR die ('Could not connect to database: ' . mysql_error()); $page_req=$HTTP_GET_VARS['action']; if ($page_req == ) { echo SWORD data entrybr\n; echo form action=\add.php\ method=\get\; echo Work Order #: input type=\text\ name=\wo_num\br\n; echo Customer Name: input type=\text\ name=\name\ Phone: input type=\text\ name=\phone\br\n; echo Email Addy: input type=\text\ name=\email\ Date In: input type=\text\ name=\date\br\n; echo Board Type and SN: input type=\text\ name=\board_type\ Last 3 of SN: input type=\text\ name=\last_three\br\n; echo Weight In: input type=\text\ name=\weight_in\ Weight Out: input type=\text\ name=\weight_out\br\n; echo input type=\hidden\ name=\action\ value=\1\\n; echo INPUT type=\submit\ value=\Add Work Order\ INPUT type=\reset\br\n; } if ($page_req == 1) { $wo_num=$HTTP_GET_VARS['wo_num']; $name=$HTTP_GET_VARS['name']; $phone=$HTTP_GET_VARS['phone']; $email=$HTTP_GET_VARS['email']; $date=$HTTP_GET_VARS['date']; $board_type=$HTTP_GET_VARS['board_type']; $last_three=$HTTP_GET_VARS['last_three']; $weight_in=$HTTP_GET_VARS['weight_in']; $weight_out=$HTTP_GET_VARS['weight_out']; $query_insert = INSERT INTO boards (wo_num, name, phone, email, date, board_type, last_three, weight_in, weight_out) VALUES ('$wo_num', '$name', '$phone', '$email', '$date', '$board_type', '$last_three', '$weight_in', '$weight_out');; echo $query_insertbr\n$result_insertbr\n; $result_insert = @mysql_query ($query_insert) or die(you suck! $mysql_error); } mysql_close(); ? /body /html Which I figured would reduce the number of things that can pop an error to a minimum. When I post something, it echoes a rather beautiful mysql insert statement...then tells me that I suck. But it doesn't tell me why I suck...$mysql_error is empty. And it's not sticking anything into my database. Arrrg. - Original Message - From: Dan Bowkley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 12:18 AM Subject: Re: [PHP-DB] lamer noob with repeat question I've got it currently as method=get; I thought it had to be get in order to manipulate variables in the URL, as I've got them...have I thought wrong? - Original Message - From: Ross Honniball [EMAIL PROTECTED] To: Dan Bowkley [EMAIL PROTECTED] Sent: Monday, May 03, 2004 11:53 PM Subject: Re: [PHP-DB] lamer noob with repeat question Have you tried putting in a form method=post action=script-name.php in your html? I'm haven't read all of your email but this is what I use and your html doesn't seem to have this. I think php needs the 'action=' to know what to do when the user submits the form. At 04:37 PM 4/05/2004, you wrote: Anyone? - Original Message - From: Dan Bowkley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, May 02, 2004 1:21 AM Subject: [PHP-DB] lamer noob with repeat question Hello everyone, I've been working on (read:tearing my hair out over) my mom's website for some time now. Specifically, I'm trying to get her work order database up and running. The basic idea is this: you start out adding a new record by going to add.php. It sees that you've not done anything yet and thus presents you with a form to fill out. That form gets submitted to add.php, which sees that you're adding something. It checks for a duplicate work order number (and eventually other errors) and then either adds the stuff you submitted into the DB, or pops an error and presents the form again. Alas, it does nothing. When you initially load the page, it works okay, sensing that you've not yet done anything and displaying the form. But when you submit data, it spits out naught more than a blank page, and doesn't add anything to the database. Damned lazy script. What I've got so far is this: html headtitleThe Board Lady - Work Order Database 0.1a/title/head body ?php define ('DB_USER', 'user'); define ('DB_PASSWORD', ''); define ('DB_HOST', 'localhost'); define ('DB_NAME', 'boardlady'); $dbc = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not connect to database: ' . mysql_error()); @mysql_select_db (DB_NAME) OR die ('Could not connect to database: ' . mysql_error()); $page_req=$HTTP_GET_VARS['action']; if ($page_req == ) {$page_req=0;} if ($page_req == 0) { echo SWORD data entrybr\n; echo form action=\add.php\ method=\get\; echo Work Order #: input type=\text\ name=\wo_num\br\n; echo Customer Name: input
Re: SQL and Yahoo IM
yeah, isn't it cute! Cute enough to gag a maggot, maybe. You can turn that off, you know..click 'login', 'preferences', and open the 'Messages' menu. You will see a checkbox under 'misc' for 'Enable Emoticons'. Uncheck it, and it'll quit turning things like :) and * into silly graphics. hth Dan - Original Message - From: Sime [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 03, 2004 3:09 AM Subject: Re: SQL and Yahoo IM Shantanu Oak wrote: Hi, I am using phpMyAdmin for last several years. I don't like it's framed design. Recently I read that I can query the database using my Yahoo IM. http://www.duncanlamb.com/sdba/?Projects/SQL+Admin I wonder if this software really works. Has anyone tried it before? What type of server will I need to host such software. (I apologize if it's out of topic) Love the way Yahoo's IM has converted select count(*) to select count and a pretty yellow graphical star.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: INTO OUTFILE
If you're using notepad to view it, it'll display it all as one line because notepad only recognises the complete CR/LF as a new line. A CR or an LF by themselves will just show up as a square, non-displayable character and won't break the line. Wordpad, on the other hand, understands that a CR or an LF by itself is often used interchangeably with a CRLF...and renders its output accordingly. hth Dan - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, April 30, 2004 4:41 PM Subject: Re: INTO OUTFILE At 19:18 -0400 4/30/04, [EMAIL PROTECTED] wrote: hi, I am trying to put the output of certain queries into a file using SELECT * INTO OUTFILE FILENAME FROM TABLE NAME WHERE CONDITION; I am able to see the file and the records are there. But is there a way I can see one record per line??? If i do the above i see all the records continously when i save it as txt file.dont see it as one record in one line. ? The default _is_ to write one record per line. The line terminator is (as the manual indicates) newline (linefeed). Perhaps you are viewing the output with a program that doesn't understand how to display such files? If you believe that that output is being written otherwise, check it with a hexdump program to see what's really in the output file. Thanks, liz -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Uninstall mysql
Check the process list (do a ctrl+alt+delete and click the processes tab) to see if mysql is still running; you might have to stop the service before removing it. Even with permissions set to read/write for everyone, it still won't let you delete it if it's running at the time. hth Dan - Original Message - From: vasanthsena x [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 3:49 PM Subject: Uninstall mysql Hi, I tried to uninstall mysql from win Xp.however it did not remove everything completely.I tried to remove the files manually but specifically it does not let me delete mysqld.exe.it says access denied. Can anyone help me?I would to reinstall mysql. S. __ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25ยข http://photos.yahoo.com/ph/print_splash -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: unstable mysql connection
you might also try using some sort of VPN solution; depending on distance, setting up pptp might not be a bad idea anyways. The overhead can hit 5% or even 10%, but the added security and error correction makes it well worth it, especially over a potentially buggy connection such as yours. I've personal experience with using a pair of Netopia R910 routers; they're bloody cheap and approaching wire speeds on their ports, which is no small feat when you consider they're less than $150 a pop. If they're in the same room, however...just get a decent pair of 10/100 cards and make a nice crossover cable. Please. It's the right thing to do. hth Dan - Original Message - From: Alexander Newald [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 6:36 PM Subject: unstable mysql connection Hello, I've an application client that stores it's data in a mysql server. Client and server (Both linux) are on diffrent hosts, I can't change the application but I have root access on both server and client. The problem: Sometimes the lan connection has paket drops (about 1%) and the connection to the mysql server is lost. Unfortunately the client starts his work from the beginning. How can I add some sort of proxy between the client and the server on the client host that accept the mysql query from the client like a mysql server, forwards this query to the real mysql server as often as needed to get the answer over the bad lan connection and than returns the result of the clients query to the client like a normal mysql server would do? Anyway, if someone knows a complete diffrent solution that works without changing the client application (and of course the buggy lan) I will be happy! Thanks, Alexander Newald -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Trying to understand the license
Exactly. The license only becomes an issue when you distribute mysql itself. Essentially, the gist is you can't charge people for mysql; only mysql can do that. You could, OTOH, let folks get your php app, and provide a link so they can download mysql themselves. - Original Message - From: charles kline [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 09, 2004 4:54 PM Subject: Trying to understand the license Hi all, I am still a bit confused as to the license for using MySQL. If I create an application in PHP, that uses a MySQL database (for example a shopping cart application) and I want to sell this application (not open source), am I required to pay a license fee? I found this quote: 2. Free use for those who never copy, modify or distribute As long as you never distribute (internally or externally) the MySQL Software in any way, you are free to use it for powering your application, irrespective of whether your application is under GPL or other OSI approved license or not. Which I understand to mean, that as long as I am not distributing MySQL with my application, that I don't need to worry about it. Thanks for any help. - Charles -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Trying to understand the license
Only if you incorporate mysql into your app--for example, if your app is a database system based on the mysql engine. An app that merely talks to mysql doesn't require you to license it. - Original Message - From: John Mistler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 09, 2004 8:58 PM Subject: Re: Trying to understand the license I thought I read that if your app is not GPL and interacts with MySQL in any way, you must license MySQL. on 4/9/04 5:16 PM, Dan Bowkley at [EMAIL PROTECTED] wrote: Exactly. The license only becomes an issue when you distribute mysql itself. Essentially, the gist is you can't charge people for mysql; only mysql can do that. You could, OTOH, let folks get your php app, and provide a link so they can download mysql themselves. - Original Message - From: charles kline [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 09, 2004 4:54 PM Subject: Trying to understand the license Hi all, I am still a bit confused as to the license for using MySQL. If I create an application in PHP, that uses a MySQL database (for example a shopping cart application) and I want to sell this application (not open source), am I required to pay a license fee? I found this quote: 2. Free use for those who never copy, modify or distribute As long as you never distribute (internally or externally) the MySQL Software in any way, you are free to use it for powering your application, irrespective of whether your application is under GPL or other OSI approved license or not. Which I understand to mean, that as long as I am not distributing MySQL with my application, that I don't need to worry about it. Thanks for any help. - Charles -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Import from excel to MYSQL
I save it as a CSV and stick it through phpmyadmin...it can be a bit clumsy (getting the delimiters to agree, mostly, which isn't exactly a monumental hurdle) but it works great unless your sheet is bloody massive and it runs past the timeout. I guess it'd be equally simple to do a LOAD DATA INFILE on the aforementioned CSV...again, make sure the delimiters are what's expected and it should work perfectly. On Tue, 2003-11-11 at 21:20, Lists - Dustin Krysak wrote: Is there an easy way to get an excel spread sheet imported into a MYSQL database? Any links to a tutorial? Thanks in advance! Dustin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: RE: Platform vs. Performance
I'm running 1Gb on my normal desktop with XP pro...it's sufficient, but just, if you've got swap disabled. Still gets bogged down sometimes, almost like it's trying to swap and getting frustrated because it's not allowed to. I'd be happier with 1.5 or even 2Gb of nice hot DDR333...these days, ram is cheap enough you can really load up a machine and not hurt too much. D -Original Message- From: Jeremy Proffitt [mailto:[EMAIL PROTECTED] Sent: Friday, September 19, 2003 8:46 PM To: Mysql List Subject: Re: RE: Platform vs. Performance First, Thanks for all replies, I'll be going with XP Pro on a P4 machine. The next question is RAM, I know more is better, but the access database file I'm using now is 120Megs and will stay about the same size. Do I need more than 1G, can I get by with 512M Ram? I will of course turn virtual memory off and will also be using this computer for file sharing and burning cd's as backup's - or using a tape drive. Thanks Again! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
INSERT weirdness
Hey there everyone, I'm trying to get a table of computer parts manufacturers populated with a list culled from my distributor and I'm having a devil of a time getting anything to work. I'm totally new to MySQL and don't really know my SELECT from a hole in the ground just yet...which is probably the entire problem. ;) Anyways. I'm trying to do this INSERT INTO `manufacturers` (`manufacturers_name`, `manufacturers_image`) VALUES (`CREATIVE_LABS`, `manufacturer_CREATIVE_LABS.gif`); to this table CREATE TABLE `manufacturers` ( `manufacturers_id` int(11) NOT NULL auto_increment, `manufacturers_name` varchar(32) NOT NULL default '', `manufacturers_image` varchar(64) default NULL, `date_added` datetime default NULL, `last_modified` datetime default NULL, PRIMARY KEY (`manufacturers_id`), KEY `IDX_MANUFACTURERS_NAME` (`manufacturers_name`) ) TYPE=MyISAM AUTO_INCREMENT=11 ; and keep getting this: Error SQL-query : INSERT INTO `manufacturers` ( `manufacturers_name` , `manufacturers_image` ) VALUES ( `CREATIVE_LABS` , `manufacturer_CREATIVE_LABS.gif` ) MySQL said: Unknown column 'CREATIVE_LABS' in 'field list'I know 'CREATIVE_LABS' isn't a colunm, and I didn't tell anyone that it was either. Why is this thing convinced that it is? help???
why me??!
I'm trying to load a couple tons of data into a shopping cart system and for some reason it keeps kicking back with an error. I'm too dumb to figure out why. Can anyone tell me what's wrong with this code and why it doesn't work? INSERT INTO 'products' VALUES (153328, 2, '181150', 'noimage.gif', '154.1000', '2003-06-20 23:03:00', NULL, '-00-00 00:00:00', '0.00', 1, 1, 1, 0); The table itself looks like this CREATE TABLE `products` ( `products_id` int(11) NOT NULL auto_increment, `products_quantity` int(4) NOT NULL default '0', `products_model` varchar(12) default NULL, `products_image` varchar(64) default NULL, `products_price` decimal(15,4) NOT NULL default '0.', `products_date_added` datetime NOT NULL default '-00-00 00:00:00', `products_last_modified` datetime default NULL, `products_date_available` datetime default NULL, `products_weight` decimal(5,2) NOT NULL default '0.00', `products_status` tinyint(1) NOT NULL default '0', `products_tax_class_id` int(11) NOT NULL default '0', `manufacturers_id` int(11) default NULL, `products_ordered` int(11) NOT NULL default '0', PRIMARY KEY (`products_id`), KEY `idx_products_date_added` (`products_date_added`) ) TYPE=MyISAM AUTO_INCREMENT=30 ; and I myself look like http://www.dibcomputers.com/images/headbang.gif at the moment. ;) TIA!