The Joomla! Forum™

Thanks for that explanation ircmaxwell. That's very clear and helpful. Thanks again for all of your help.

I found the problem. Prior to ircmaxwell's comment with the code sample that included the if(!$database->query()), I did not have that line in my code. I was under the impression that the $database->setQuery($query) command performed the query since it did for "SELECT" statements (this is supposed t...

@pe7er: No, I'm just trying to do one table. @ircmaxwell: Yep, that's how I'm executing the query and it's not throwing any errors. Here's some of my code, in case it helps. global $database; $counter = 0; for( $i = 0; $i<count($positions); $i++ ){ if( $positions[$i] != '' ){ $query = "UPDATE #__con...

Yes, all of the normal Joomla components work just fine. I can add, edit, and delete articles. I also took a look at the code for the users core component, since I'm inserting / updating / deleting things in the users, core_acl, and contact_details tables, and double-checked that my code was the sam...

I'm working on a bunch of new components for my website and many require using MySQL INSERT, UPDATE, and DELETE commands. (I'm on Joomla 1.0.13 BTW). Right now, any queries that are SELECT work just fine. However, whenever I go to any of the above types, the query doesn't seem to execute, but there ...