Show table status query

2004-05-17 Thread Andrew Barnes
Hi When I run the "SHOW TABLE STATUS" query against a database with 4 tables, 3 of the tables come have the correct row count, but 1 table changes the No of rows every time I run the query. The correct row count for this table is 313, but the query returns anywhere from 97 to 574. I am running 4.0

Query help

2004-01-27 Thread Andrew Barnes
Hi I have a table called "sections" with the following structure: +---++--+-+-++ | Field | Type | Null | Key | Default | Extra | +---++--+-+-++ | secid | int(11)|

SELECT problem

2003-10-13 Thread Andrew Barnes
Hi, I have three tables, a title's table, a genre's table and a genre_titles map table (to model the many to many relationship between genre's and title's). I need to write a query that will return title's that match two or more genre's. An example would be one title could be a comedy/drama and I