adding an incremented count from page hits

I have an existing database/tables and would like to add a counter to a table that would increment when a document is downloaded from the database. I am sure it is an easy addition to the php page but struck-out looking for info not related to auto-increment in the mysql manual. I tried adding

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

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

ULL values, you find the non-matching rows. Get it? > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > Chip Wiegand <[EMAIL PROTECTED]> wrote on 11/11/2004 04:29:08 PM: > > > I have two tables I want to get out the rows that are different be

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

01:09:25 PM: > Can you log on as the web account and try to insert, update, select directly > from the MySQL monitor? > > -Original Message----- > From: Chip Wiegand > To: Victor Pendleton Cc: '[EMAIL PROTECTED] ' > Sent: 8/18/04 2:41 PM > Subject: RE:

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: Plz help quick - mysql/php/web server undefined function all of a sudden

I hope not. -- Chip > On Monday 03 May 2004 09:20 am, Chip Wiegand said something like: > > 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

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

is a table header. > > Second, if you are expecting a single result row, then you do not > need the while() loop. Do a > single fetch and display the result. > > rick > "People will forget what you said. People will forget what you did. > But people will never forget how y

select statement not working in a php page

I am trying to get a single result from a database, which works fine at the sql command line. I have tried several versions of code, this being the most recent - \n"; echo "Warranty ID:\n"; echo "$WarrantyID\n"; echo "\n"; } ?> No matter what I do I do not get the desired max id number from the c

Re: update question

or two on MySQL. So, I'll have to buy a SQL book specifically. Regards, Chip > - Original Message - > From: "chip wiegand" <[EMAIL PROTECTED]> > To: "Tore Bostrup" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Sunday, March 02,

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

I need to make a change to a field in a table and don't know how to write the correct sql statement. I made an error and now have a date field with the year repeated twice - 01-01-03-03 - there are aproximately 100 rows like this, and maybe 20 or so that are formatted properly. How can I remove the

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

db dump question

I need to copy a database and all its tables and contents to a backup server. The server they live on is on an ISP, the server I want to back the up on is in my office in another town. I can access the ISP's server via phpMyAdmin and dump the data to a .sql file, but then what do I do to recre

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

led previous versions of mysql a dozen times and have never had this trouble. -- Chip > ---- > > At 04:19 PM 9/17/2002 -0700, Chip Wiegand wrote: > >I am trying to get mysql-server installed from the FreeBSD port but keep > >getting this dog-gone error - > > > >mysql

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

I am trying to get mysql-server installed from the FreeBSD port but keep getting this dog-gone error - mysqld started Can't start server: Bind on unix socket: Permission denied Do you already have another mysqld server running on socket: /tmp/mysql.sock? Aborting Okay, so, I do a ps -aux | grep

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

I first posted this on the php-db list, but am not getting the proper results yet, so I am copying here, hopefully someone can help me figure this one out... I have a form with a select list and a hidden field to save the selected item. On submit another page is loaded with a few fields to be fil

Re: export table?

On Mon, 2002-07-08 at 04:42, Victoria Reznichenko wrote: > > What about mysqldump? > http://www.mysql.com/doc/m/y/mysqldump.html > > You can make dump file of your table, copy from one server to > another and restore table or > mysqldump database_name table_name | mysql -hhost_name

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

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

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 attem

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

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 q

select statement group by unusual results

I have a database with 12 tables. I am running a query to select certain fields from 3 of the tables, like this - select Title, Details, StartDate, City, State from phpCalendar_Details, phpCalendar_Daily, phpCalendar_EventLocations where phpCalendar_Details.EventLocationID = phpCalendar_EventLoca

Rename a Database?

I searched the archives and the manual online but could not find the answer, I believe this has been covered in the list though. Is it possible to rename a database? If not, is it possible to move/copy a table from a database to a new database? Could someone point me to the details on this? -- Ch

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

getting multiple columns per row from databse query

I have a database that is names and addresses. I want to make a web page that will display those names and addresses in a table with 4 columns per row, as many rows as necessary. The little if statement below works to make 2 columns, but when I change the number to 3 or higher it no longer works

linking to a database id

I have a database of dealers. A web page loads a list of states, a user clicks on the state and the database is queried and lists in a table the dealers for that state. Simple enough. When the dealers page is first loaded, it shows all dealers in the database, name, address, phone, etc. I want to

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

Werner Stuerenburg <[EMAIL PROTECTED]> on 08/14/2001 11:55:37 PM Internet mail from: Please respond to Werner Stuerenburg <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: Re: I blew it big time... locked myself out of mysql I think it is grant all on *.* to 'root'@'localhost' id

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

[EMAIL PROTECTED]@bellsouth.net on 08/14/2001 10:03:13 PM Internet mail from: Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: I blew it big time... locked myself out of mysql On Tue, 14 Aug 2001 12:16:59 -0700, [EMAIL PR

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

-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

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!

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 whe

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

your SQL syntax near 'fields terminated by ','' at l ine 3 mysql> Regards, 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, pr

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

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,

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

I am having a problem with inserting data into a table via a web form, which was working just fine prior to changing the port the web server is listening on from 80 to 8080. I can insert data via the mysql command line just fine, just not from the web form. Below are the forms and table def for re

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: web search form for a mysql database

is empty. Go back and type a string to search"; > } > include ('links.x'); > ?> > > > -Original Message- > FROM: [EMAIL PROTECTED] > TO: [EMAIL PROTECTED] > DATE: Thu 7/5/01 10:13 > SUBJECT: web search form for a mysql database > > I ha

Re: web search form for a mysql database

essage- > FROM: [EMAIL PROTECTED] > TO: [EMAIL PROTECTED] > DATE: Thu 7/5/01 10:13 > SUBJECT: web search form for a mysql database > > I have mysql 3.23.38, php4.03, apache1.3.14. I have a small database of > dealer bulletins. > I have created a web page to allow easy inpu

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