Database | Forum profile

Whatever happened to the edit button? Can't even correct my spelling any more I realise that I did not answer your question fully sneakyimp. The COUNT has to be run of course, but it is the GROUP BY that create the overhead in a query like this and that is quite normal no matter what method one uses.

Quote: Originally Posted by Roger Ramjet But not MySQL. sonny100 did not state what database system was used, so MySQL is just an assumption, although it is probably the best assumption to make when you have no other information Checking the MySQL documentation, can anyone confirm that AUTO_INCREMENT for MySQL does not allow reuse of ids even for deleted rows? The part about "this happens even for MyISAM tables, for which...

It is not clear on my part when I get partial code back from you to put it in the correct place. It might be helpful if the entire code with updates was returned. I am having trouble putting it all together when it is returned. The code below has error: Undefined index: submit on line 21. Thank you in advance for your help. PHP Code: <?php $db = odbc_connect ( '' , '' , '' );   //put your...

Your foreach line has the potential to break something: $tag and $tag is being used to mean two different things at the same time. PHP Code: foreach( $tag as $key => $value ) {      $tag [ $key ] = "'" . mysql_real_escape_string ( $value ). "'" ; } $query = "Select tag_name from tags where tag_name in (" . join ( ',' , $tags )....

Obviously not, or it would work. It should work with rincewind's suggested changes. What does your code look like now?

And i figured it out...i had to change to call the $shout in two other places.

Answering my own question. Great post! codinghorror.com/blog/archives/000976.html Hot diggity that Google is slicker than whale snot in an ice flow!

sql 1 PHP Code: $SQL == "select table1.* , table2.* from table1     left join table2 on (table2.id = table1.foreignkey)     where table1.idsofmulitiple = whateveralue   and table2.fieldsofidentity = whateveralue " ; vs sql2 PHP Code: $SQL == "select table1.* , table2.* from table1     left join table2 on...

I'm not sure if I can do this with relations and CASADE functions etc. So for now I'm calling an extra query to DELETE orphan tags; Code: DELETE t.* FROM tags AS t LEFT JOIN tags2img AS t2i ON t.tID = t2i.tID WHERE t2i.tID IS NULL "; Is there a better way to do this?

tomhath, I tried the NOT EXISTS. I can see why this is a faster way of doing it, but it's simply not giving me the results that I'm looking for. I'm looking to pinpoint which 'rid' values are in the clearance table. When I do a NOT EXISTS, it's basically kicking out a TRUE value if any value exists in the query and giving me an 'all or nothing'. Perhaps it's the way I have the rest of the query...