Problems with mysql.sock

the MySQL site and from Google. But I noticed at the end of the user comments on the page http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html say these solutions do not work FC 4. Could anyone help me out with this? I'd greatly appreciate it. Thanks! Chip Lambert IST

adding an incremented count from page hits

--- ? --- The count doesn't increment in the database. The table has a column called 'count'. Can someone please please point me in the right direction? Thanks, Chip -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

stop and restart mysql on freebsd?

I made a change to my.cnf and want it to restart mysqld_safe so it will re-read my.cnf. How do I do this? Thanks, Chip -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

copy data only from one table to another table

How do I copy all data only from one table into another table? Both tables are in the same database. I have phpMyAdmin and it suppossedly does this, but it is not working, and there are no error messages. Thanks, -- Chip -- MySQL General Mailing List For list archives: http://lists.mysql.com

query of two tables returns far too many rows, more than the two tables contain

the rows that are in the dealers table but not in the blackgate_users table. Thanks for any help, Chip Wiegand Computer Services Simrad, Inc 425-778-8821 425-771-7211 (FAX) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: query of two tables returns far too many rows, more than the two tables contain

sleuthing around in there I will probably figure out what the extra 10 rows are. Thanks you very much. Regards, Chip So by looking for only those rows where the right hand table contains NULL values, you find the non-matching rows. Get it? Shawn Green Database Administrator Unimin

RE: I can delete, add, but not update

checked my update script to make sure there were no spelling errors in the field names, and all looks good. It's just really strange. -- Chip -Original Message- From: Chip Wiegand To: [EMAIL PROTECTED] Sent: 8/17/04 11:29 AM Subject: I can delete, add, but not update I don't know

RE: I can delete, add, but not update

I found the problem - it was in an include file, not with the script. It had a variable that should have been changed from $address1 to $address, but wasn't in that one particular file. Anyway, thanks for the replies. -- Chip Victor Pendleton [EMAIL PROTECTED] wrote on 08/18/2004 01:09:25 PM

I can delete, add, but not update

correctly in MySQL? Thanks, Chip Wiegand Computer Services Simrad, Inc 425-778-8821 425-771-7211 (FAX)

Re: problem importing .csv (excel format) into mysql

Joshua J. Kugler [EMAIL PROTECTED] wrote on 07/08/2004 04:24:41 PM: On Thursday 08 July 2004 02:35 pm, Chip Wiegand said something like: I was sent an excel file from a remote office, and need to put the data into a mysql database to be displayed on our web site. I removed a few lines

problem importing .csv (excel format) into mysql

files into mysql? Thanks -- Chip Wiegand Computer Services Simrad, Inc www.simradusa.com www.simrad.com [EMAIL PROTECTED] When I'm working on a problem, I never think about beauty. I think only how to solve the problem. But when I have finished, if the solution is not beautiful, I know

RE: slow response time

Are you running spam assassin? I'm finding that my slow query log is showing the spam queries to really be dragging. -Original Message- From: Charles Sprickman [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 06, 2004 2:29 PM To: [EMAIL PROTECTED] Cc: Egor Egorov Subject: Re: slow response

RE: authentication error

seem to know A LOT more than I do so I thought someone may have seen this...or have an idea. -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:45 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do

RE: authentication error

The email users authenticate against a MySQL table... -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 6:12 AM To: [EMAIL PROTECTED] Subject: Re: authentication error Chip Bell [EMAIL PROTECTED] wrote: Hello, I run a toaster email server

RE: authentication error

Ok, I have no read_buffer anywhere... 256M (key) + 20 (sort) * 100 (connections) Correct? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:09 AM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication

RE: authentication error

My bad, just realized that read_buffer_size USED to be record_buffer My total @ 100 connections is 2356M. I'm going to guess that I should shave that down a bit?? -Original Message- From: Chip Bell Sent: Thursday, July 01, 2004 10:17 AM To: Victor Pendleton; [EMAIL PROTECTED] Subject

RE: authentication error

I had my admin turn it down from 256M to 50M and it started just dogging at 40 connections. We're now at 128M and checking. How do I set the key_buffer appropriately? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:51 AM To: Chip

RE: authentication error

Key_Reads 57 Key_read_request 16218 -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 1:17 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error What is the value of key_reads/key_read_request

RE: authentication error

I don't know how to look at the explain plan for that query..or how to find out what query is being run. -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 1:29 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE

RE: Server tuning

Victor, Thanks for all your help with the authentication issue. I still have it, but at least I know what to look for. My server is running RH9 with 3 gigs ram, PIII. I have about 150 users at any given time and they're all coming via IMAP or HTTPD. They all authenticate against MySQL but

RE: authentication error

Hi Victor, I have stumbled on to something. The server is bouncing back and forth b/t fast and slow. When I do show processlist and its above 100, it's slow. When it's below, it's fine. What variable is wrong? I have Max_connections = 250? Thanks Chip -Original Message- From

RE: authentication error

No sir... -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:43 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error I would check to see if your server is swapping at this point. -Original

RE: authentication error

After looking through, show variables; the only one I found with a value of 100 is the delayed_insert_limit Could this be the issue? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:45 PM To: Chip Bell; Victor Pendleton; '[EMAIL

authentication error

Hello, I run a toaster email server which is having trouble authenticating at times. Both methods of authentication, imap AND web for some reason just hang. I'm pretty new to MySql but I figure if both methods are trying to authenticate against the same table, the problem is there. I activated

RE: authentication error

: Tuesday, June 29, 2004 12:04 PM To: Chip Bell; '[EMAIL PROTECTED] ' Subject: RE: authentication error What does the error log say? -Original Message- From: Chip Bell To: [EMAIL PROTECTED] Sent: 6/29/04 9:03 AM Subject: authentication error Hello, I run a toaster email server which

RE: authentication error

:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 12:53 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Can you view or log the errors that imap and the web authentication are getting? Try issuing a flush-hosts to see if the max_connect_errors was reached

RE: authentication error

- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:02 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error From the mysql monitor it is `FLUSH HOSTS;` . Does the email server not log failed connection attempts? -Original

RE: authentication error

1:11 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error What is the connection like between the two servers? Once you are logged in can you do a show processlist and see if anything is bottelnecking the database? -Original Message- From: Chip Bell

RE: authentication error

PROTECTED] Sent: Tuesday, June 29, 2004 1:31 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do you have an `execessive` numer of processes running? Do you have any processes that have been running for an `abnormal` length of time? -Original Message

RE: authentication error

Is there anything I should set in my startup options to accommodate this? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:54 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error The values

Please help..

Hello, I have a Red Hat 9 server which runs a qmail/toaster software package. It allows webmail to authenticate against a mysql db and stores mail there too. K, the issue.. Every once in a while, the web client just SITS at authentication. The client just sits there forever. The

Plz help quick - mysql/php/web server undefined function all of a sudden

hours without a hiccup. thanks for the help, -- Chip Wiegand Computer Services Simrad, Inc www.simradusa.com [EMAIL PROTECTED] There is no reason anyone would want a computer in their home. --Ken Olson, president, chairman and founder of Digital Equipment Corporation, 1977 (Then why do I have

Re: [PHP] Plz help quick - mysql/php/web server undefined function all of a sudden

John W. Holmes [EMAIL PROTECTED] wrote on 05/03/2004 10:59:15 AM: From: Chip Wiegand [EMAIL PROTECTED] I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on freebsd-5.1. It has been working fine for the past few years, now all of a sudden today I get an undefined

Re: Plz help quick - mysql/php/web server undefined function all of a sudden

for mysql. Only two of have the password to the server, myself and my boss (who knows absolutely nothing about it). Now the question is - how do I configure php to support mysql when it is already installed from the ports? Do I do a whole new install again? I hope not. -- Chip On Monday 03

out of memory error and update problem

Mounted on /dev/ad0s1a 508M 346M 121M74%/ devfs 1.0K 1.0K 0B 100%/dev /dev/ad0s1d14G 2.9G 9.9G22%/usr File system is not full, what's it talking about? What would be the recommended remedies? -- Chip Wiegand Computer Services Simrad, Inc

select statement not working in a php page

line. What am I doing wrong? thanks -- Chip -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: select statement not working in a php page

Thanks for the tip. Got it working. -- Chip Rick Emery [EMAIL PROTECTED] wrote on 03/22/2004 09:50:59 AM: What result are you getting? First off, I see that your HTML is possibly incorrect; should it be: echo tdWarranty ID:/td\n; th is a table header. Second, if you are expecting

Re: update question

character. I should look for a better MySQL book, the ones I have don't cover that info. Any suggestions for one that does? -- Chip HTH, Tore. - Original Message - From: chip wiegand [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Sunday, March 02, 2003 1:46 AM Subject: update

Re: update question

specific functions are available, etc. HTH, Tore. Thanks, after reviewing my 'library' I find the books I have with mysql info are PHP books that have a chapter or two on MySQL. So, I'll have to buy a SQL book specifically. Regards, Chip - Original Message - From: chip wiegand [EMAIL

update question

the last 3 characters while leaving other rows that do not have this problem alone? (other than manaully editing each row of course) Thanks, Chip W. www.wiegand.org - Before posting, please check: http://www.mysql.com/manual.php

load data infile command not allowed problem - revised

, -- Chip Wiegand Computer Services Simrad, Inc www.simradusa.com [EMAIL PROTECTED] There is no reason anyone would want a computer in their home. --Ken Olson, president, chairman and founder of Digital Equipment Corporation, 1977 (Then why do I have 8? Somebody help me

load data infile command not allowed problem

it defaults to not enabled. The server is running MySQL-3.23.52. How do I run phpMyAdmin to give me the ability to upload a local data file to a mysql server that doesn't allow this? thanks, -- Chip Wiegand Computer Services Simrad, Inc www.simradusa.com [EMAIL PROTECTED] There is no reason anyone

Help with mysql_fetch_array

commented out. I think I need a while loop in here somewhere from what I've read, but I haven't been able to make sense of the manual or any other help pages I've found. Any help would be greatly appreciated. Thanks, Chip html head titleOur DVD's/title link rel=stylesheet href=dvd.css

RE: Help with mysql_fetch_array

); $query = select * from list order by title; $result = mysql_query($query); $num_results = mysql_num_rows($result); $dvd_time_query = select sum(runtime) from list; $dvd_time_result = mysql_query($dvd_time_query); echo td class=mfont size = -1b.$dvd_time_result./b/td; ? Thanks, Chip

Help Please ... PHP Problem - /libraries/grab_globals.lib.php

getting it working. I tried searching Google for those error msgs, but couldn't find any resources or possibilities, other than some pages written in Russian. Thanks in advance, Chip [EMAIL PROTECTED] - Before posting, please check

Need help installing PHP (Linux) with MySQL and Apache

wouldn't know one if I saw it. Can someone help with a pointer/link? I'd very greatly appreciate it.. Chip [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

MySql module won't load in Apache (DebianLinux)

, with the following, and when I loaded it into my browser it doesn't show any MySql support/modules/extensions, and my php interface to Mysql doesn't work. Mysql normally works fine.. html body ?php phpinfo(); ? /body/html Does anyone have a clue about what I'm *TRYING* to convey?? Thanks/Chip Rose

Are there ANY terminal-based frontends for Linux?

history transaction tracker. Help/Thanks! Chip Rose - 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

db dump question

to recreate the database and all the tables on my local mysql server? What do I look for in the manual? -- Chip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: db dump question

On Thu, 2002-09-26 at 18:28, Mihail Manolov wrote: mysql datadump.sql Thanks, I finally found it. the mysql manual doesn't have anything about exporting/importing, I was using the wrong words for searching. -- Chip - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED

I know it's not supposed to be this difficult to install

? -- Chip - 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

Re: I know it's not supposed to be this difficult to install

On Tue, 2002-09-17 at 16:30, Robert Citek wrote: Hello Chip, Try 'rm /tmp/mysql.sock' MySQL creates a new one at startup. - Robert Tried that, it didn't create a new one. It still gives the same error also, as if it is there. I've installed previous versions of mysql a dozen times

select box result on page1 to insert statement table name on page2- not working

, a connection is made and the query is completed. -- Chip W www.wiegand.org [EMAIL PROTECTED] Below is the code for the first page -- html head title/title /head body div align=center ? $exercises=array(absflexor,absmachine,leglifts); echo form action='workout-absflexor.php' method='get'; echo table width

Re: export table?

search for export.) :-) Thanks for the help, -- Chip -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko

export table?

Where is info on exporting a table? I checked the mysql docs and the only reference to export has nothing to do with exporting a table. I want to copy a table from one server to another, should be simple enough, right? -- Chip [EMAIL PROTECTED] www.wiegand.org

Help for MYSQL installation

: don't know how to make my_init.c. Stop *** Error code 1 Please help. Chip Thanks! __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com

Finding out whos using the database

Is there a command that I can use to find out how many people, or more specifically, who, is using the database? I tried the mysql web site but the search result are more irrelevant than relevant. Thanks, Chip W www.wiegand.org [EMAIL PROTECTED

Row Statistics?

Is there a way I can track how often which rows are being returned in select queries? I'm trying to determine, on an hourly, daily, weekly interval, which rows get hit the most, the least, and how many times. For the application I'm running, I'd like to use this metric to purge old records.

Re: select statement group by unusual results

DL Neil [EMAIL PROTECTED] on 12/06/2001 12:26:45 AM Internet mail from: Please respond to DL Neil [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject: Re: select statement group by unusual results Chip, I have a database with 12 tables. I am running a query

Re: select statement group by unusual results

DL Neil [EMAIL PROTECTED] on 12/06/2001 05:27:55 PM Internet mail from: Please respond to DL Neil [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject: Re: select statement group by unusual results Hi Chip, Thanks for the tips. So here's my latest attemp: select

select statement group by unusual results

the same problem, whatever the first returned field, it is carried down through all the rows. How do I get around this, or what am I doing wrong? Thanks, Chip - Before posting, please check: http://www.mysql.com/manual.php

Re: select statement group by unusual results

DL Neil [EMAIL PROTECTED] on 12/05/2001 11:35:46 PM Internet mail from: Please respond to DL Neil [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject: Re: select statement group by unusual results Chip, I have a database with 12 tables. I am running a query

Re: GUIfront-end in Linux?

. I don't use Linux, rather FreeBSD and use MySQLNavigator on FBSD. I like it. There are many others you could look at. Check the mysql.com site, I believe they reference some. -- Chip - Before posting, please check: http

Rename a Database?

on this? -- Chip - 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

getting multiple columns per row from databse query

%sbr%sbr%sbr%s, %s %s/td\n, $row[Account], $row[name], $row[email], $row[Address], $row[Address2], $row [City], $row[State], $row[Zip]); if ($i % 2) { echo /tr\ntr\n; } $i++; } ? -- Chip W - Before posting, please check: http

Re: getting multiple columns per row from databse query

Thanks Bill, That works great. Much appreciative, Chip Bill Adams [EMAIL PROTECTED]@tqs.com on 11/15/2001 10:31:45 PM Internet mail from: Sent by: [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject: Re: getting multiple columns per row from databse query Try

linking to a database id

for the help... -- Chip --- lots of elseif statements trimmed -- elseif ($orderby == '46'): $query = select * from dealers where ID = '46' order by 'DealerName' asc; else: $query = select * from dealers; endif; $result = mysql_query($query); $i = 0; while ( $row = mysql_fetch_array($result

Need Help with PHP / Apache

so I really don't know anyway. All I want to do at the moment is get a good Forms interface using Apache/PHP) for inputting data into MySQL database - the MySQL frontends aren't what I wanted.. Thanks. Chip. [EMAIL PROTECTED

Re: GUI for MySql

will find info on the mysql site regarding gui clients, and lots of posts in the archives. Your question is also too general - what OS are you working on? (not the mysql server necessarily). -- Chip W. - Before posting, please

PHP Tutorial for total beginner??

don't mind studying up, if someone can help me get a clue. Thanks a lot. Chip. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Fresh install fails to start - 'host could not be looked up'

On Sunday 21 October 2001 22:59, Chip wrote: I just installed mysql-3.23.43, apache-1.3.22, and php-4.0.6 all from source this evening (on freebsd-4.4-r). When I try to run safe_mysqld I get this; mysqld started Fatal error: Can't change to run as user 'mysql' ; Please check that the user

Fresh install fails to start - 'host could not be looked up'

still. What should I do next? -- Chip W. - 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

I blew it big time... locked myself out of mysql

, with -uroot -ppassword and get the same results. Please help ASAP. I have always been able to connect as root with just 'mysql' at the prompt. -- Chip Wiegand Computer Services www.simradusa.com [EMAIL PROTECTED] Simrad, Inc Lynnwood, WA 425-712-1138 There is no reason anyone would want a computer

Re: I blew it big time... locked myself out of mysql

I have tried a number of variations on the grant statement above but they all fail with the same message. More suggestions? -- Chip Hans Zaunere [EMAIL PROTECTED] on 08/14/2001 07:37:55 PM Internet mail from: To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED

Re: I blew it big time... locked myself out of mysql

command that should be: grant all on *.* to root@localhost identified by 'xx' with grant option; Turns out I get the same error message when I try the command that way too. -- Chip Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing

Re: I blew it big time... locked myself out of mysql

'@'localhost' - identified by 'xx' - with grant option; ERROR 1047: Unknown command Still not working. -- chip -- [EMAIL PROTECTED] schrieb am Dienstag, 14. August 2001, 22:54:48: [EMAIL PROTECTED]@bellsouth.net on 08/14/2001 10:03:13 PM Internet

Re: My databases got hosed when the server went down hard!

Stefan Hinz wrote: Dear Chip, myisamchk is not an SQL command, so it's not executed from the MySQL Monitor (the SQL command line tool) but rather from a shell. Type myisamchk at the shell prompt and you will see the options. Thanks, I'm discovering there are a few of these commands to run

My databases got hosed when the server went down hard!

properly. In Webmin I see the icons for the database, but when I select it the screen changes and shows This database has no tables. Hopefully these files can be restored, I can view them with cat and they do contain the data that was entered previously. Chip Wiegand Computer Services www.simradusa.com

Re: My databases got hosed when the server went down hard!

Thankyou, that fixed it. Man, I was concerned I'd have to rebuild those databases and re-enter all the data. thanks for the help, -- Chip [EMAIL PROTECTED] on 08/07/2001 11:35:31 PM Internet mail from: To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject: Re: My databases got hosed

Search results are differant on console and in webmin

all their characters. Any idea what the problem could be? (Or is it actually a problem?) Chip Wiegand Computer Services www.simradusa.com [EMAIL PROTECTED] Simrad, Inc Lynnwood, WA 425-712-1138 There is no reason anyone would want a computer in their home. --Ken Olson, president, chairman

Import data question

is of this format - password,name,account password,name,account etc File name is users and table name is users. mysql load data infile '/usr/home/chip/users' into table users - (name,password,account) - fields terminated by ','; ERROR 1064: You have an error in your SQL syntax near 'fields

data checking during input?

I have a database I enter data into from a web based php form. I wonder if there is a way to have mysql check the database for a duplicate entry before it gets written into the database? And inform me of such so I will not have duplicate entries? -- Regards, Chip

Please help - does changing the port the web server listens on affect mysql?

for reference. (freebsd4.2, apache 1.3.14, php4.0.3pl1, mysql Ver 11.15 Distrib 3.23.38, for -freebsd4.2 (i386) ) -- Chip This first one is the data input form... -- html head titleDealer Bulletins - Simrad, Inc/title /head body bgcolor=aqua ? if(isset($submit)): $db

Re: Please help - does changing the port the web server listens on affect mysql?

That's what I expected, but haven't figured out the problem with the one database. I created another very simple database and form and can insert data from the web form with no problem. -- Chip Jeremy Zawodny wrote: MySQL knows nothing of the ports that your Web server may listen

Re: Please help - does changing the port the web server listens on affect mysql?

with the code. And I have tried several differant formats of writing the code. I have tried another web form and database and it worked fine from the browser. -- Chip Allen Grace wrote: - Original Message - From: Chip [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 20, 2001 10:04

Multiple values for a column

granted, this isn't elegant, but I think it should work, am I missing anything? Thanks, Chip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: Multiple values for a column

that once I saw the obvious answer, I wanted to stem the flow of those. Thanks, Chip At 09:01 AM 7/17/01 -0400, you wrote: Hi all, I'm fairly new to MySQL and to SQL in general, but not a complete newbie. I have the o'reilly book, as well as dubois and the SAMS PHP MySQL books . . . I think I know

can't connect from web page, but works fine from command line

on mysql though, right? Chip Wiegand Computer Services www.simradusa.com [EMAIL PROTECTED] Simrad, Inc Lynnwood, WA 425-712-1138 There is no reason anyone would want a computer in their home. --Ken Olson, president, chairman and founder of Digital Equipment Corp., 1977 (-- Then why do I have

web search form for a mysql database

variations on the above query statement, none of which would work. I can do this without any problem from the mysql command line by entering the word I am interested in searching on. The problem seems to be with the part after against, just how do I get the user input data into that field? Chip

Re: web search form for a mysql database

people want to work. -- Chip Patrick J. Larkin [EMAIL PROTECTED] on 07/05/2001 07:45:40 PM Internet mail from: To: MySQL List [EMAIL PROTECTED] cc: Subject: Re: web search form for a mysql database What if you want to search for a number of terms? Say you have a database of common

Re: web search form for a mysql database

Thanks, I guess I just meant I'm just stupid on this subject, not stupid overall, heh heh. Anyway, thanks for the reference, I'll check it out shortly. -- Chip [EMAIL PROTECTED] on 07/05/2001 09:03:56 PM Internet mail from: To: [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject: Re: web

using a variable to search a database

) against ('request'); I want 'request' to be the variable from the form input=text field. Does mysql have something similar to perl's $variable=STDIN? Just how do I do this type of search? Thankyou, Chip Wiegand Computer Services www.simradusa.com [EMAIL PROTECTED] Simrad, Inc Lynnwood, WA 425-712

Re: $sth-{mysql_insertid} not working in 3.23.38?

I use: $Gdata{'custid'} = $dbh-{'mysql_insertid'}; on 3.23.38 with perl 5.6.1 and DBI-1.15 Works like a champ! On Sat, Jun 23, 2001 at 01:07:07PM -0500, xris wrote: Two things you might want to try... first download and install the newest Msql-Mysql DBD drivers.. check what the