Connect fails but only from this one file WHY

i am developing a php app. in the beginning of every file there is a require_once("./setup.php"); that does the housekeeping, fetches the connection credentials and connects to the database. All that worked fine until this morning I made a new file. Now I get a connection failure when I try

How to get a count from this query

SELECT avg(abs(pmd.value) - (mypmd.value))) as diff, pm.mname, pmd.uid FROM pmdata pmd, mnames pm, pmdata mypmd WHERE mypmd.uid= ? AND pmd.pmid=pm.pmid AND mypmd.pmid=pm.pmid AND pmd.uid != mypmd.uid GROUP BY pmd.pmid, pmd.uid ORDER BY pmd.uid What I would like also to return in this query is a

Re: Suppress table header when using ODBC

e the first row has a non numeric field header. and that is why I need it to go away. Gerald Taylor wrote: Hello, I am using a desktop program that imports data from a mysql database using the ODBC mysql driver and everything works fine except for one little glitch: it adds one extra row a

Suppress table header when using ODBC

Hello, I am using a desktop program that imports data from a mysql database using the ODBC mysql driver and everything works fine except for one little glitch: it adds one extra row at the beginning of the dataset with the names of the columns in it. I need for that column name row to NOT b

Re: best practices for finding duplicate chunks

2 at doc1 and words 587-643 at doc2 with a marker. Yeah it looks ugly, and will take a lot of space for temporary data. But in the end you'll have all 20+ words duplicate chunks properly identified. On 8/14/05, Gerald Taylor <[EMAIL PROTECTED]> wrote: I just revived a database that was

best practices for finding duplicate chunks

I just revived a database that was in a version 3.23 server and moved it to a 4.1 There are big fields of TEXT based data. They have a way of compressing the amount of TEXT data by identifying common subchunks and putting them in a "subchunk" table and replacing them with a marker inside the

Re: MySQL constraint question

Thanks for these answers. I can now write this in the application and be OK with it without that nagging feeling that somebody will say upa if you just put xxx in the database then you could filter all that in your query. If it ever happens I can say, ah yes but when I wrote that we were only on

MySQL constraint question

I have a database thats full of ingredients that are placed in various categories. and then there are mixtures that are allowed to be labelled with a certain grade based on the quality and composition of the ingredients it is comprised from. But the formulas are not always the same, as long as the

Re: Tricky self join query help?

] wrote: If you post the table structure (SHOW CREATE TABLE tablename\G) we could help you write this statement. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Gerald Taylor <[EMAIL PROTECTED]> wrote on 11/10/2004 11:52:35 AM: > I have this table of events. Each event

Tricky self join query help?

I have this table of events. Each event has an owner id and the time that it happened. What I want to do is delete all events more than three months old but only if the owner does not own any newer events. The coolest would just be a single DELETE query. Can this be done? Mysql 4.0.18 -- MySQL G

Re: Script question

Philippe Poelvoorde wrote: mysql> system echo hi there; mysql> system ls -ls; mysql> system uname-a; all work on the 2.4.22-10mdk kernel and the semi-colon is optional. mysql> system echo "hi there" should be also working, the first parameters 'echo' is recognized as the command to execute, and

Query optimization question

Query optimization question I am selecting from a single table but it has a lot of rows and it has a very involved calculation. What I really want to do is is FIRST restrict the number of rows so that the big calculation is only performed on the ones that are within 3 degrees. Using 4.0.20 A s

Re: SELECT queries on replicate DB server

Thanks, that is a really good answer. Raises a bunch more questions but they're good ones. Jim Grill wrote: My question is: Why would they deem it necessary to use yet a third server? Could it be because the main server and the main slave are constantly being updated and they wouldn't want to ov

SELECT queries on replicate DB server

We have a main db server that has a pretty big db and it sometimes gets overloaded. We also have a replicated slave server... every update to the main server writes through to it and it is the one that is backed up to avoid interruption service for the website. There are certain sections of th

Re: MySQL book

I totally recommend Paul Dubois's book. Excellent book I own the first edition. I bet the second edition is just as good and more up to date. Paul DuBois wrote: At 1:55 +0200 7/26/04, Schalk Neethling wrote: Can anyone suggest o great book to learn MySQL inside out? I am thinking of getting: *MyS

Re: query gets count wrong

I am an anal single query-oholic. I know I could do this in 2 queries I have a query involving several related tables and I have attempted to reduce it down to what causes "not what I want" results. I am attempting to fill a summary table. For each main item in this table I want to count the numbe

selecting by average

I have a table called ratings. It has 3 rows of interest id foreign key to another table quala quality rating u the user who gave that rating (also a foreign key into the users table) Now I would like to select all the unique ids for which the average quality is below 1.5 so

Re: Converting to Percentages

Hi all I have a legacy table to convert where the schema has changed. originally the primary key was a multi field key, keyed by a customer id and then within each customer, numbers 1,2,3... etc. cust no 1 1 1 2 2 1 2 2 . . 4323433 1 4323433 2 4323433

Re: Order by price?

I want to count the passing and failing scores of a group of tests so I have a table with a row that describes each test Each test has a minimum passing score. Each test can be run an arbitrary number of times so I have a table of scores, which uses test id as a "foreign key". what I would like

Re: bookings

How would I benifit from a stored procedure? Stored procedures live with your data and can be called directly from inside queries. They can be customized to do what you want to the data before mysql gives it to you (SELECT) or after you feed it in, which is what you want for an insert. so your

Re: bookings

Kevin Waterson wrote: I am (trying) to make a booking systems. Currently I have a table with 3 timestamps that record bookingDate, bookingFromDate and bookingToDate I have another table that records 'seasons'. This table contains two timestamps that record seasonStartDate and seasonEndDate also I h

Re: default encrypt for PASSWORD

Paul DuBois wrote: At 15:02 -0700 2/25/04, Colleen Dick wrote: I'm sure this is in the manual somewhere or in the archives, but I'm not finding it and I bet someone easily knows the short answer: Using 3.23 setting a varchar field to PASSWORD("secret") Having altered nothing regarding encryption i