Re: error

2004-05-31 Thread Dan Bowkley
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

Re: [PHP-DB] lamer noob with repeat question

2004-05-04 Thread Dan Bowkley
"; $result_insert = @mysql_query ($query_insert) or die("you suck! $mysql_error"); } mysql_close(); ?> 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 m

Re: [PHP-DB] lamer noob with repeat question

2004-05-04 Thread Dan Bowkley
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 PROTECTE

Re: SQL and Yahoo IM

2004-05-03 Thread Dan Bowkley
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. ht

Re: INTO OUTFILE

2004-04-30 Thread Dan Bowkley
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 o

Re: unstable mysql connection

2004-04-22 Thread Dan Bowkley
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 p

Re: Uninstall mysql

2004-04-22 Thread Dan Bowkley
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 - Orig

Re: Trying to understand the license

2004-04-09 Thread Dan Bowkley
lt;[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: >

Re: Trying to understand the license

2004-04-09 Thread Dan Bowkley
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 - F

Re: Import from excel to MYSQL

2003-11-12 Thread Dan Bowkley
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 INFIL

RE: RE: Platform vs. Performance

2003-09-19 Thread Dan Bowkley
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

INSERT weirdness

2003-06-28 Thread Dan Bowkley
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 proba

why me??!

2003-06-21 Thread Dan Bowkley
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