Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problems quering 3 tables in one statment (GROUP BY)
Awesome thanks piti. That works like a charm. I was under the false impression that my mySQL version didn't support joins - I couldn't have been more wrong! Because I didn't think I supported them, i've never taken the time to learn about them before. That'll change now! Many thanks, James -
Problems quering 3 tables in one statment (GROUP BY)
Hello, below is my rather complecated sql query. It does two things: a) Gets all the articles in catagory '4' b) Gets all the articles in catagories with parent catagory '4' (a) and (b) run fine on their own, but when i combine them with an OR statement, i get multiple (seemingly) redundant... -
Copy of auto_increment column
Fantastic, very pleased i don't have to worry about the insert id changing. Thanks to both of you for your help! James -
Copy of auto_increment column
Hello, i've got an `id` column which auto_increments, but I also would like another column initially set to the same number as `id`. Is this a sensible way of doing this on mySQL 4.0.26: "INSERT INTO `bla` ( `id` , `id2`, `text`) VALUES ('', '', 'Bob'); UPDATE `bla` SET `id2`=LAST_INSERT_ID( )...
