RE: Computer reboots during long table join

2005-04-15 Thread Andrew Maynes
My win98 is rebooting after a while which is very odd, I reckon someone from the list has hacked people from on this list Andrew >-Original Message- >From: Ian Gibbons [mailto:[EMAIL PROTECTED] >Sent: 15 April 2005 16:22 >To: mos; mysql@lists.mysql.com >Subject: Re: Computer reboots duri

MSSQL Import from MySQL

2005-03-29 Thread Andrew Maynes
I need to imort a MySQL DB inot MSQL is this possible? Thank you Andrew -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.4 - Release Date: 27/03/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Table Update

2003-02-26 Thread Andrew Maynes
problably a silly question but if I am updating a table in a MySQL DB with a table structure like this: TABLE xxx ItemSKU ItemName ItemDescription PostCode Category CityID CTelephone ItemID Cfax Cemail Caddress CTown Cwww PRIMARY KEY (ItemID) and the update query is t

RE: Query from a PHP Form

2003-02-25 Thread Andrew Maynes
Thanks to al that repsonded and helped out. i dicovered that the form itself was not quite right and not posting the variables doh anmy way that is now fixed all but some cosmetics :) so the problem now returns to the query in companies.php if someone can have a little look and I am sure this wi

Query from a PHP Form

2003-02-25 Thread Andrew Maynes
I have a query that is extracting records from a MySQL DB at the moment the query is just pulling 'all' records and not the selected records from a drop down :( I am using php too. the query I have is this: $result=mysql_query('select distinct items.* from items,city,category where items.CityID=

Another Query Table Structure

2003-02-22 Thread Andrew Maynes
This may be simple for most of you MySQL experts out there so a little help would be nice :) I have an index page that is using a Navigation system based on the ID from a table City: The link then goes a DIR for that City. http://www.theaddress.co.uk/City/ The navigation within this DIR is base

query inserts from a table join

2003-02-09 Thread Andrew Maynes
I don't know whetehr this is going to make any sense! I have a query pulling records from MySQL tables that are joined. The join is for a color_id to an item... /// function showColor($item_id) { $query="select ref_colours.* from item_color ,ref_colou

query produces a navigation

2003-02-06 Thread Andrew Maynes
I have a set of records in a mysql table that are called categories. A query pulls all the records for category and in turn this are then to items of that said category. Simple. Ok here is the bit I want some feeback on. I want to create another table (if this is the solution) and split the cat

performance measuring

2003-02-04 Thread Andrew Maynes
Hi All I have been told that my php connection to my MySQL could be slow. The guys that are telling me this have 3 years php development. Is thee anything out there that I can measure the performance with. This is a web site and I coud really do with the performance being fast. Andrew --