The vbulletin db functions are pretty much just a wrapper for the mysql functions which you can see here:
http://us2.php.net/manual/en/book.mysql.php
Quote:
Oh wait.. that bumps my queries on that page up from 35 to 83,...
|
Well, now this query
PHP Code:
$getChecked = $db->query_first("SELECT id, country FROM " . TABLE_PREFIX . "services WHERE country = " . $viewCountry['id'] . " AND id = " . $editService['id']);
must be getting done more times, right? Are you sure you actually need that one (I'm still not completely clear on the db structure so I'm not sure).