Problems with mysql.sock

s from 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! Ch

adding an incremented count from page hits

<--- This is the added bit ---> ?> --- 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://lists.mysql.com/[EMAIL PROTECTED]

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

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

the query. The above select statement gets me 141 rows returned. With a little 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 N

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

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: 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

RE: I can delete, add, but not update

pt. I double 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,

I can delete, add, but not update

t up 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 o

problem importing .csv (excel format) into mysql

could cause it to fail on a non-existant key? Is there a trick to loading Excel .csv 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 s

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

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] &#x

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_re

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:

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] Su

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

RE: authentication error

ing that and watching, but you guys 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]

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 B

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. ---

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 -O

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

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 val

RE: authentication error

[mailto:[EMAIL 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

RE: authentication error

ECTED] Sent: Tuesday, June 29, 2004 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? --

RE: authentication error

-Original Message- 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 fail

RE: authentication error

ndleton [mailto:[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_c

RE: authentication error

mailto:[EMAIL PROTECTED] Sent: 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

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

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 login

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

fied that it no longer shows support 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?

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

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

either today or over the weekend, I know it worked friday when I left the office. This particular machine has been up for 151 days 22 hours without a hiccup. thanks for the help, -- Chip Wiegand Computer Services Simrad, Inc www.simradusa.com [EMAIL PROTECTED] "There is no reason anyone

out of memory error and update problem

su-2.05b# df -H FilesystemSize Used Avail Capacity 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 rec

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 "Warranty ID:\n"; > >

select statement not working in a php page

get the desired max id number from the column WarrantyID. The same query works fine at the sql command 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: update question

mentation to find out what > is/isn't supported, what differes froim the standard, and what > 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

Re: update question

ks for the help, worked great. I didn't know about the underscore being a wildcard 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: &qu

update question

emove 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/manua

load data infile command not allowed problem - revised

r that doesn't allow this? thanks, -- 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

load data infile command not allowed problem

or without? Evidently 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 P

RE: Help with mysql_fetch_array

ok, here is my code without all of the html (sorry people). I'm trying to get a sum of the field runtime. With this code, I get "Resource id #3" as an error. Any help getting me to the proper result would be greatly appreciated. ".$dvd_time_result.&

Help with mysql_fetch_array

few things, that I currently have 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 Our DVD&

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

l like I'm probably just a step away from finally 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]

Need help installing PHP (Linux) with MySQL and Apache

't know how to find these MySQL headers since I 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 chec

MySql module won't load in Apache (DebianLinux)

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.. Does anyone have a clue about what I'm *TRYING* to convey?? T

Are there ANY terminal-based frontends for Linux?

-faceted client 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,

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 PROTE

db dump question

do 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: 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 instal

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

m the port? -- 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

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

iable, and it displays the expected result (see code below). I am at a loss as to why the one in the sql insert statement is not working. If I replace the $listbox variable with the table name shown in the echo statement, a connection is made and the query is completed. -- Chip W www.wiegand.org [

Re: export table?

gain, maybe I'm the only person to ever 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/ >__ ___ ___ __ &g

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

UNDEF_THREADS_HACK -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -c errmsg.c -o errmsg.o >/dev/null 2>&1 mv -f .libs/errmsg.lo errmsg.lo make: don't know how to make my_init.c. Stop *** Error code 1 Please he

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. It

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,

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, > &

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

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: GUIfront-end in Linux?

nt write-up in Linux Journel. 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 posti

Rename a Database?

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

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

getting multiple columns per row from databse query

ot;], $row ["City"], $row["State"], $row["Zip"]); if ($i % 2) { echo "\n\n"; } $i++; } ?> -- Chip W - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Need A book for dynamic website

The books I got started with are: Essential PHP for web professionals by Cosentino (Prentice Hall) MySQL/PHP Database Applications by Greenspan & Bulgar (M&T) -- Chip On Wednesday 14 November 2001 07:37, Webmaster wrote: > Hi, > I need a book to teach me how to make a database dri

linking to a database id

Thanks 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_quer

Need Help with PHP / Apache

remember which module I compiled in, or whatever - I'm still learning 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 data

Re: GUI for MySql

ts.mysql.com You 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. - Be

PHP Tutorial for total beginner??

the way for me to go. I 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

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 'my

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

it doesn't work 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-ma

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

-> with grant option; ERROR 1047: Unknown command mysql> grant all on * to 'root'@'localhost' -> identified by 'xx' -> with grant option; ERROR 1047: Unknown command Still not working. -- chip -- [EMAIL

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

27;\c' to clear the buffer >>mysql> grant all privileges on *.* to root@localhost identified by 'xx'; >>ERROR 1047: Unknown command that should be: grant all on *.* to root@localhost identified by 'xx' with grant option; Turns out I get the same error mes

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

'xx'; ERROR 1047: Unknown command 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 Int

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

line, 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

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'

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

My databases got hosed when the server went down hard!

x27; at line 1 Obviously I don't know how to use myisamchk 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 d

Import data question

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

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, ch

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

Solved! The a href link to a table data problem

elieve I found the answer. I just wonder why something so obvious (now that I see it working) is not in the books, or why none of the suggested answers included this. Is this not a 'proper' way to do such a link? Chip Wiegand Computer Services www.simradusa.com [EMAIL PROTECTED] Simrad,

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

hing wrong 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: <

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

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

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... -- Dealer Bulletins - Simrad, Inc The Data has been entered!\n"); print("You can add another Deale

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

just continue to the next web page as if all is well and good. I can add data from the mysql command line, and also from within webmin, just not from the web page. Is it a permissions problem, or access rights problem, or something like that? The only change made recently was to the web server, ap

Re: Multiple values for a column

just 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 &a

Multiple values for a column

column are the primary key from the OS table 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 manu

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: S

Re: web search form for a mysql database

marketing 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? S

web search form for a mysql database

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 Wiegand Computer Services www.simradusa.com [EMAIL PROTECTED] Simrad, Inc Lynnwood, W

using a variable to search a database

match (body,bulletin_subject) against ('request')"; I want 'request' to be the variable from the form input=text field. Does mysql have something similar to perl's $variable=? Just how do I do this type of search? Thankyou, Chip Wiegand Computer Services www.simradusa

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 docume