MySQL Newbie

Hi,

I have done indexing on a column which contains almost half of the records as null value. The remaining half of the records contain unique value for that column.

Is it optimized one or if it is wrong kindly guide me.


With Regards,
Suv

I'm having problems with creating a select statement which I'm hoping someone can provide the answer, below are the details.

Table <Account>

|id| address | blah |

1 ... ....
2 ... ....
3 ... ....
4 ... ....
5 ... ....

Table <Members>

|id| account_id | email | first |

1 1 NULL Joe
2 1 test1@test Fred
3 1 NULL Greg
4 2 test2@test Steve
5 3 test3@test Heather
6 3 NULL Rick
7 4 NULL Cris
8 5 NULL Lisa
9 5 NULL Tom

What I'm basically trying to do is only select an account_id from second table if no emails are present for that account group

for instance, account_id has 3 members inwhich one has email so skip, account 2 has email so skip, account 3 has two members one with email so skip, account 4 has one member without email and account 5 has two members without email....meaning that account 4 and account 5 would be returned as no one living in those premises has email on file and a letter should be mailed.

I tried the following sql which did seem to work only in the case that for each account group the first record had an email

here's my query:

select * from members group by account_id having email = "" which is returning no records I would expect results to be returned for id 7/8/9 where account_id 4 and 5 in each dwelling have no email addresses on file.

I'm really trying to do a select and NO stored procedure.

Thanks,
Marc

How to create an admin panel using PHP where I can link my My SQL DB so that I can generate reports to excel from the panel itself?

Thanks,

Hi,
How do I delete multiple records in a table? I'm new to RDBMS, I use the fowllowing query to execute the command which will delete only one record at a time...but what if I want to delete more than one record at a time?

DELETE FROM table_name WHERE id=1

If i want to delete all the records in between id 1 and id 10, how do I do that?


Any help is highly appreciated!

Thanks,

Hey folks,

I'm in the process of setting up a database for archiving some articles, and tracking word frequency for these articles. Articles may have something like 50-1000 words each. The number of articles I'm storing at the moment will be something like 250,000, but I'll need to expand later.

My goal is to make it easy/fast to execute a selection statement that returns two vectors
1. unique words in a subset of articles, and
2. the frequency of each of those words in that subset of articles.

Essentialy, this is what I need to generate a sparse word-document-frequency matrix from sets of articles.

Are there any suggestions for the optimal way to design the tables?
Thanks,
Brian

hi
i am totally new to mysql can any1 please help me to insert data which is either in excel,wordpad,notepad i made a small table i m using import option...please

Hi,

Is it possible to run a sql-Script with attributes. For example:
source Demoscript.sql -Databasename -Tablename

I would like to write a script, the user can set the name of the database by own.

Is this possible?

best regards,
Franz

Hi,

I am currently facing a problem where if the value of a record(rateBat) is NULL, I need to replace it with the previous value of record(rateBat). Here "previous" means the row where the PK(masterstamp) is lesser than current Row's PK and playerid is same.

TABLE bat1:
For eg my table is:
masterstamp----rateBat--------playerId
1---------------0.30--------------300
2---------------0.50--------------200
4---------------0.60--------------300
8---------------0.90--------------200
9---------------0.70--------------100
11--------------0.60--------------200
14--------------0.10--------------200
17--------------NULL--------------100
19--------------0.00--------------300
21--------------0.90--------------100
I want a way to replace NULL with value 0.70 since that is the record where the masterstamp is lesser than NULL values' masterstamp and the playerid is same.

However there is a twist to my question. The fact is that there are two similar tables bat1 and bat2. I need to UNION these two table and then get the desired result on that UNION. However I need this all to be done in a single query rather than break into process.


The table bat1 and bat2 are:
CREATE TABLE bat1 (masterstamp int(11),rateBat float(9,4),playerid int(11)); CREATE TABLE bat2 LIKE bat1; In these table eventhough the masterstamp is not auto increement, however it is the primary key. Also when I mean previous value, I mean the

The dataset may contain following:
INSERT INTO bat1(masterstamp,rateBat,playerid) VALUES(1,2.3,100);


My Query (WITH NULL VALUES INTACT):

SELECT masterstamp,IFNULL(A.rateBat,NULL) as rateBat FROM (SELECT rateBat,masterstamp FROM bat1 WHERE playerid=52047 UNION SELECT rateBat,masterstamp FROM bat2 WHERE playerid=52047) A ORDER BY A.masterstamp
MY QUERY (ATTEMPT NOT WORKING):
I tried to do it the following way but it is still showing error:

SELECT B.masterstamp, IFNULL(B.rateBat,SELECT A.rateBat FROM A WHERE A.masterstamp<B.masterstamp ORDER BY A.masterstamp DESC LIMIT 1) FROM (SELECT masterstamp,rateBat FROM (SELECT rateBat,masterstamp FROM bat1 WHERE playerid=52047 UNION SELECT rateBat,masterstamp FROM bat2 WHERE playerid=52047) as A ORDER BY A.masterstamp) B
Any help will be appreciated.


Thanks,
Sandeep

Hello, i'd like to ask for help on my problem here.
I'm setting up a server to run mysql and at my company we secure an environment using ESM Enterprise Security Manager from Symantec and it is complaining that mysql.lock has a security threat because it is world writable. Is there any way i could change the mysql.lock file permission? i've tried making it 775, 755 but then mysql stops working.

Any help is very appreciated.

Thanks
Adi

Hi Experts,

MYSQL VERSION - 5.0.51a-3ubuntu5.1
SET NAMES 'utf8'; SHOW VARIABLES LIKE 'character_set%';
character_set_client utf8 character_set_connection utf8 character_set_database latin1 character_set_filesystem binary character_set_results utf8 character_set_server latin1 character_set_system utf8 character_sets_dir /usr/share/mysql/charsets/
JUST COPIED AND WORKED OUT CODE FROM NET AS BELOW,

CREATE TABLE IF NOT EXISTS `poll_categories` ( `category_id` tinyint(2) NOT NULL auto_increment, `category_name` varchar(50) character set utf8 collate utf8_bin NOT NULL default '', PRIMARY KEY (`category_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; INSERT INTO `poll_categories` (`category_id`, `category_name`) VALUES (1, '????? ?? ??? ???? ?????? ????');
WHEN I SELECT IN MYSQL QUERY BROWSER,IT DISPLAYS AS BELOW

1, '????? ?? ??? ???? ?????? ????'
CAN SOME ONE HELP ME WHAT AM DOING WRONG HERE.

Create Trigger Zamowienie
after INSERT ON KLIENT
FOR EACH ROW
IF Klient(WycieczkaID) <> NULL Then
UPDATE wycieczka set IloscMiejsc = IloscMiejsc - 1 where wycieczka(WycieczkaID)=NEW.Klient(WycieczkaID)

I totally don't get syntax of it, how I should do trigger which will change IloscMiejsc in table wycieczka when I Inster on table klient with Wycieczka(ID) <> 0 ?

Gokarna is a real key journeying property with the famous Mahabaleshwara tabernacle and is also a

tourer force for its beaches. Gokarna way 'cow's ear'. It is believed that Peerage Hebdomad

appeared here in the represent of a Shiva Linga out of the ear of a cow. This cow is believed to be a

dissent of Prithvi, or Parent Connexion.

Gokarna Beaches

There are some Gokarna Beaches to - and Kudle Beach, Om Beach, Half-Moon Beach and Region Beach

are nonpareil symptom to in Gokarna. Om Beach is a unparalleled beach, in the regulate of the place symbolization of Om.

Gokarna Hotels - The Diametric Ranges

Among separate Gokarna Hotels, you can outride left the beach in one of 12 Country complex communication suites

in Om Beach Resorts. The apartment message magnificent views of the beach and the profuse immature hills. The

resort provides you with all the recent conveniences in a tranquil, old earth positioning. Position a boat

travel on the comely Part beach.




Bask yourself in the sporadic Paradise beach, which can be reached only by boat or by trekking

finished a earth course. Unbend and rejuvenate your body with Ayurvedic treatments - a relaxing oil

bath or a yoga and reflexion term. the famous temples around the townspeople, including the pretty

Mahabaleshwara Temple.



SwaSwara Resorts takes you on a travel of self-discovery in the exquisite settings of Gokarna, with

its beaches, verdant hills and ancient temples. Set amidst an undulating landscape, surrounded by

waving mick comedian and food groves, SwaSwara is a pleasing recur built on 26 acres of line

that overlooks the Om Beach. The assist offers 27 self-contained villas improved in the Konkan music.

Lose yourself in the beat and sounds of nature, the splashing waves, the wrap rustling finished

the trees and the songs of birds. At the parcel of the utilise is a blue-domed contemplation place that

reflects the organization of the Gokarna Temple. Yoga and musing classes and Ayurvedic therapies can

ameliorate you ameliorate your design and embody. The cooking offered is a compounding of caller farm expose from

nearby villages and rested seafood. SwaSwara is paragon for those who essential to expend at smallest a period in

an obscure heaven, inaccurate from the hassles of city period.

Bangalore to Gokarna

Gokarna is not straight adjunctive on the ride and air routes. The nearest airport is Dabolim in

Goa, 140 km gone and the near railway rank is Ankola, 20 km forth. Gokarna is 475 km from

Metropolis. You can get some KSRTC and personal buses to Gokarna from Bangalore.



Gokarna is a great judge to , with temples and beaches and hills. Pass a sybaritic leisure in one

the resorts in Gokarna, nigh the beaches, and grow position recharged to tackle the mundane bit of

municipality spiritedness.




Malvan a undersize port in Sindhudurg dominion of Maharashtra left Goa, is having lovely beaches with

few of the somebody accommodations in konkan. Malvan is famous for two things its more comprehended

Malvani content and Sindhudurga fort. The field characteristic, Sindhudurga gather is an superior model of

foregather building architecture and the providence of the majuscule Maratha competitor Chatrapati Shivaji Maharaj.

You can cross a dish mate for ing the inclose. With Sindhudurga meet in the backcloth the sunset at the

Malvan beach is striking. It is absorbing to rite the bargains at the auctions of good search,

attractive situate faction on the beach. The another options around Malvan are Tarkarli, Kunkeshwar with a

Mahadev temple shapely in the 10th century by the Yadavas. If you are fond of luscious Alphanso

mangoes (commonly called Hapus) then you staleness nearby Devgad, the rootage of Alphanso with great

mango plantations.

The enclose Sindhudurga in Malvan reminds us of the enthusiastic Amerind feature Chatrapati Shivaji Maharaj, who

was a great beguiler and a wise intellect. Obscure from the median forts, he constructed forts in liquid

(Jal Durg) to forbid the contender from entry our part by substance of sea route. We (Panoramic

Radical) existence in the welcome industry soul reliable to mention the eager cheat by selecting the

tract for our Hotel Sagar kinara, malvan at a beautiful positioning at Somwar peth in Malwan rightful coating

Sindhudurg meet so that our guests can get a magnificent analyze of the foregather in the sea. Its peaceful

emplacement makes it the unsurpassable among hotels in malvan and resorts in Malvan.

Be it a freshman instance or to the Region, a businessperson on a concern flub, a anesthetic honeymoon span or

a association on their way support from Goa, we advocate our hotel in Malvan, Sindhudurg as the somebody place

to affect and part any leisure moments with us on your Malvan botch. During your fill you can

explore the beach, the inclose or upright remain indoors hearing to the music of the waves. It is totally

your action. Symmetric you can get Maharashtra's most famous unsalty, tasteful Malvani content with lots of

varieties.

For your can and pleasance the hotel is having cardinal large apartment, all outfitted with

full-fledged living making Sagar Kinara one of the uncomparable beach utilize in Konkan. The multi-cuisine

edifice offers Amerindian, Sinitic cuisines and characteristic Malvani dishes. Opposite facilities state A/C &

non A/C Mortal / Bingle bed apartment with clean tub. Flat for Elder Citizens and physically

challenged, Multi-cuisine restaurant, Bar, Opportunity tableware and Lot plateau. We tolerate Assign / Entry

game and Advance for Wood testament be provided.


konkan resorts
Devgad hotels

Hey i'm new to mysql, i started using it today for the first time and i would appreciate your help introducing me to the first steps. Right now i'm trying to make a website that uses mysql to store database.

UPDATE home1 SET birthday1 = '1950-03-21' WHERE id1 = '2';

It is somewhere in the WHERE.
id1 is the PRIMARY KEY and AUTO_INCREMENT.
I tried using other FIELDS in WHERE but I got the same error.

OK here is my setup. This is probably not the norm.

I have setup a drupal website and to do this I used what is called Appserv wich has apache, mysql, phpmyadmin, and php all built in. I have this at the moment runing on a simple windows vista machine. I can go into phpmyadmin and do a manual backup of the database just fine. But when this site goes live wich is going to be an internal site for my engineering group wich will be around 30 users. Is there a way that I can setup something to do an automatated backup of the database at a certain time? I have seen people using mysql dump and crontab but these seem to only be linux based. I suppose I should just build the webserver on a linux server but that would require more time involved in setup and learning how to run. Learning how to get drupal configured is enoguh at this point. If anyone has any suggestions on what can be done with getting this accomplished I would greatly appreciate it!

Thanks in advance.

I have a db that has a single table 'quotes' and several tables that hold data related to the quotes table. I get the following error when trying to get a single record from the joined tables:

Error Number: 2008

MySQL client ran out of memory

SELECT * FROM (`quotes`) JOIN `caulk` ON `caulk`.`quote` = `quotes`.`id` JOIN `cracks` ON `cracks`.`quote` = `quotes`.`id` JOIN `door_types` ON `door_types`.`quote` = `quotes`.`id` JOIN `mask` ON `mask`.`quote` = `quotes`.`id` JOIN `notes` ON `notes`.`quote` = `quotes`.`id` JOIN `inspection` ON `inspection`.`quote` = `quotes`.`id` JOIN `pressurewash` ON `pressurewash`.`quote` = `quotes`.`id` JOIN `prime` ON `prime`.`quote` = `quotes`.`id` JOIN `sbm` ON `sbm`.`quote` = `quotes`.`id` JOIN `sealers` ON `sealers`.`quote` = `quotes`.`id` JOIN `sfgd` ON `sfgd`.`quote` = `quotes`.`id` JOIN `tarp` ON `tarp`.`quote` = `quotes`.`id` JOIN `tools` ON `tools`.`quote` = `quotes`.`id` JOIN `whd` ON `whd`.`quote` = `quotes`.`id` WHERE `quotes`.`id` = '39'

The MySQL client is a PHP connection. Any help is appreciated.

Hi All,

I am seeing the above error when I use the following command to dump a small number of tables via a cron shell script. Which has worked fine for ages until I have just released a major performance patch that incorporated a substitute of the history table for a weekly table (with considerably less recs).

/usr/bin/mysqldump -u my_user --password="abc" ${DB1} mdl_scorm_scoes_track_weekly mdl_user mdl_scorm mdl_scorm_scoes mdl_scorm_scoes_track | /bin/gzip > ${TODAYS_DUMP_DIR}/SR7.${DATE}.moodletabs.dump.gz

The dump.gz file just has the header but no DDL and DML for the tables being dumped.

I have a similar command in the same cron script that reference tables in another schema with identical structure and it works fine.

I have manually applied the above table to my production environment and a stored procedure then inserts the recs in the weekly table into a persistent master_archive table.

The stored procedure that then processes against the master archive is then running incredibly slow and doesn't appear to be showing anything like the behaviour and performance I was seeing on my test environment.

I am using mysql 5.1

On the production side all the tables are myisam

There seems to be an issue with the recs in the weekly table that is then carried through to the archive table.

Please could anyone offer any guidance on these issues.

Many thanks for your help

I've created a simple HTML form that gathers service provider information about a building (electrician, landscaping company, etc). The PHP file sends that information to the database -> table that I created in phpmyAdmin (columns already created and named). There are 30 columns, and the code does it's job, except when I try to add one particular column's data.

This is the error I get: "Could not query:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key, janitor, plumbing, police, roofing, sewer, snow, utilelec, utilgas, wastere' at line 1"

This happens only with the 'key' column's data.

Here is the HTML:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;
<html xmlns="http://www.w3.org/1999/xhtml&quot; xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Service Provider List</title>
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<h2>Property Vendor List</h2>


<form method="post" action="localserviceprovider.php">
<label for="projectname">Project Name:</label>
<input type="text" id="projectname" name="projectname" /><br />
<label for="proplanpartner">Partner name:</label>
<input type="text" id="proplanpartner" name="proplanpartner" /><br />
<label for="vendor">Partner name:</label>
<input type="text" id="vendor" name="vendor" /><br />
<label for="attorney">Attorney:</label>
<input type="text" id="attorney" name="attorney" /><br />
<label for="buildeng">Building Engineer:</label>
<input type="text" id="buildeng" name="buildeng" /><br />
<label for="buildown">Building Owner:</label>
<input type="text" id="buildown" name="buildown" /><br />
<label for="buildsec">Building Security:</label>
<input type="text" id="buildsec" name="buildsec" /><br />
<label for="electrician">Electrician:</label>
<input type="text" id="electrician" name="electrician" /><br />
<label for="elevator">Elevator Company:</label>
<input type="text" id="elevator" name="elevator" /><br />
<label for="exterminator">Exterminator:</label>
<input type="text" id="exterminator" name="exterminator" /><br />
<label for="fire">Fire Department:</label>
<input type="text" id="fire" name="fire" /><br />
<label for="firepro">Fire Protection:</label>
<input type="text" id="firepro" name="firepro" /><br />
<label for="firesprink">Fire Sprinklers:</label>
<input type="text" id="firesprink" name="firesprink" /><br />
<label for="gas">Gas Supplier:</label>
<input type="text" id="gas" name="gas" /><br />
<label for="hvac">HVAC Company:</label>
<input type="text" id="hvac" name="hvac" /><br />
<label for="inscarrier">Insurance Carrier:</label>
<input type="text" id="inscarrier" name="inscarrier" /><br />
<label for="insagent">Insurance Agent:</label>
<input type="text" id="insagent" name="insagent" /><br />
<label for="landscape">Landscape:</label>
<input type="text" id="landscape" name="landscape" /><br />
<label for="lighting">Lighting:</label>
<input type="text" id="lighting" name="lighting" /><br />
<label for="key">Lock and Keys:</label>
<input type="text" id="key" name="key" /><br />
<label for="janitor">Janitor:</label>
<input type="text" id="janitor" name="janitor" /><br />
<label for="plumbing">Plumbing:</label>
<input type="text" id="plumbing" name="plumbing" /><br />
<label for="police">Police Department:</label>
<input type="text" id="police" name="police" /><br />
<label for="roofing">Roofing/Structure:</label>
<input type="text" id="roofing" name="roofing" /><br />
<label for="sewer">Sewer:</label>
<input type="text" id="sewer" name="sewer" /><br />
<label for="snow">Snow Removal:</label>
<input type="text" id="snow" name="snow" /><br />
<label for="utilelec">Utility Co (Elec):</label>
<input type="text" id="utilelec" name="utilelec" /><br />
<label for="utilgas">Utility Co (Gas):</label>
<input type="text" id="utilgas" name="utilgas" /><br />
<label for="waste">Waste Removal:</label>
<input type="text" id="waste" name="waste" /><br />
<label for="water">Water:</label>
<input type="text" id="water" name="water" /><br />
<input type="submit" value="Submit" name="submit" />
</form>
</body>
</html>


And the PHP:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;
<html xmlns="http://www.w3.org/1999/xhtml&quot; xml:lang="en" lang="en">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

<title>Service Provider Confirmed</title>

</head>


<body>

<h2>Service Provider List</h2>


<?php
$projectname = $_POST['projectname'];
$proplanpartner = $_POST['proplanpartner'];
$vendor = $_POST['vendor'];
$attorney = $_POST['attorney'];
$buildeng = $_POST['buildeng'];
$buildown = $_POST['buildown'];
$buildsec = $_POST['buildsec'];
$electrician = $_POST['electrician'];
$elevator = $_POST['elevator'];
$exterminator = $_POST['exterminator'];
$fire = $_POST['fire'];
$firepro = $_POST['firepro'];
$firesprink = $_POST['firesprink'];
$gas = $_POST['gas'];
$hvac = $_POST['hvac'];
$inscarrier = $_POST['inscarrier'];
$insagent = $_POST['insagent'];
$landscape = $_POST['landscape'];
$lighting = $_POST['lighting'];
$key = $_POST['key'];
$janitor = $_POST['janitor'];
$plumbing = $_POST['plumbing'];
$water = $_POST['water'];
$police = $_POST['police'];
$roofing = $_POST['roofing'];
$sewer = $_POST['sewer'];
$snow = $_POST['snow'];
$utilelec = $_POST['utilelec'];
$utilgas = $_POST['utilgas'];
$waste = $_POST['waste'];



echo 'Thank you for submitting ' . $projectname .'<br />';
echo 'ProPlan will contact you with any questions. <br />';

$link=mysql_connect('localhost', 'admin', '1234');
if(!$link){
die('Could not connect to Database' . mysql_error());
}
echo 'Connected successfully';
if (!mysql_select_db('pptest'))
die('Could not select database.'. msql_error());



$query="INSERT INTO serviceproviderlist (projectname, proplanpartner, vendor, attorney, buildeng, buildown, buildsec, electrician, elevator, exterminator, fire, firepro, firesprink, gas, hvac, inscarrier, insagent, landscape, lighting, key, janitor, plumbing, police, roofing, sewer, snow, utilelec, utilgas, wasteremoval, water) " .
"VALUES ('$_POST[projectname]', '$_POST[proplanpartner]', '$_POST[vendor]', '$_POST[attorney]', '$_POST[buildeng]', '$_POST[buildown]', '$_POST[buildsec]', '$_POST[electrician]', '$_POST[elevator]', '$_POST[exterminator]', '$_POST[fire]', '$_POST[firepro]', '$_POST[firesprink]', '$_POST[gas]', '$_POST[hvac]', '$_POST[inscarrier]', '$_POST[insagent]', '$_POST[landscape]', '$_POST[lighting]', '$_POST[key]', '$_POST[janitor]', '$_POST[plumbing]', '$_POST[police]', '$_POST[roofing]', '$_POST[sewer]', '$_POST[snow]', '$_POST[utilelec]', '$_POST[utilgas]', '$_POST[waste]', '$_POST[water]')";

$result = mysql_query($query);
if (!$result) {
die('Could not query:' . mysql_error());
}

mysql_close($link);



?>

</body>
</html>

I just upgraded from MySQL 5.1 to 5.5 so I could make use of the exit handlers.

But I just copied and pasted a sample procedure and it gives me a syntax error and I have no clue why because it comes right out of the MySQL manual. I added the delimiter statement but the rest is a simple copy/paste.

Can someone give me a sample that works so I can get started using the error handler? Could the issue have anything to do with me using the MySQL Workbench?

DELIMITER $$
CREATE PROCEDURE p()
BEGIN
DECLARE EXIT HANDLER FOR SQLEXCEPTION
BEGIN
SIGNAL SQLSTATE VALUE '99999'
SET MESSAGE_TEXT = 'An error occurred';
END;
DROP TABLE no_such_table;
END$$

Hi All,

I am seeing the above error when I use the following command to dump a small number of tables via a cron shell script. Which has worked fine for ages until I have just released a major performance patch that incorporated a substitute of the history table for a weekly table (with considerably less recs).

The following is in a SQL block within the cron shell script

/usr/bin/mysqldump -u my_user --password="abc" ${DB1} mdl_scorm_scoes_track_weekly mdl_user mdl_scorm mdl_scorm_scoes mdl_scorm_scoes_track | /bin/gzip > ${TODAYS_DUMP_DIR}/SR7.${DATE}.moodletabs.dump.gz

The dump.gz file just has the header but no DDL and DML for the tables being dumped.

I have a similar command in the same cron script that reference tables in another schema with identical structure and it works fine.

I have manually applied the above table to my production environment and a stored procedure then inserts the recs in the weekly table into a persistent master_archive table.

The stored procedure that then processes against the master archive is then running incredibly slow and doesn't appear to be showing anything like the behaviour and performance I was seeing on my test environment.

I am using mysql 5.1

On the production side all the tables are myisam

There seems to be an issue with the recs in the weekly table that is then carried through to the archive table.

Please could anyone offer any guidance on these issues.

Many thanks for your help