ok so i have this very simple code:
Code: $query = "SELECT search_keywords, COUNT(search_keywords) AS counter FROM phpbb_popsearch GROUP BY search_keywords ORDER BY counter DESC limit 5";
$res = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($res)) {
$term = $row["search_keywords"];
echo $term;
}
phpbb_popsearch is a table where i put the last search terms used in my forum search engine
this code will group together the same terms and list the 5 most popular terms
my problem is that the results will be ordered by "counter" which is the number of time a term has been found.
I want to get the 5 most popular results AND THEN, AFTER, list the results alphabetically
if i sort the results alphabetically right in the sql query (replacing "ORDER BY counter" by "ORDER BY search_keywords") it will not work correctly because it will not get the 5 most popular terms but just the 5 first terms, alphabetically sorting them and ignoring the number of times the term has been found
thanks for help
PHP If Else statement for breadcrumb
HiI am trying to use a PHP if else statement to display a breadcrumb link on wordpressThe codeLine number On/Off | Expand/Contract <div class="triple silhouette_break">
how to read and write into a word document using php...?
hi,I need,reading and writting into a word document using php.Thank u inadvance,Madhu
User information
Hi All,
PHP Thumbnail Creation
Ok so i use this function to create thumbnails:Code: function createthumb($name,$filename,$new_w,$new_h){ $system=explode('.',$name); $src_img=imagecreatefrompng($name);
INSERT data problem!
After having an string with apostrophes ', double quotes " or any other special characters, successfully escaped through one of themany php functions availables to escape, what other
Mysterious Timeouts
I've deployed a few simple AJAX-enabled web page to a local server that is accessed through the Internet by just two people: Me & one client.When running in VS2008 it works perfectly fine but when
date("now") prints out wrong date ?
Hi GuysAnyone know why and how I can fix it ?
PEAR Email Attachment w/ $gpg
I have no issues with this code if I take out the attachement section and include the info in the email body instead. However, I want the info to be in an email attachment. I do receive the email,
Remove directories not empty
hi,i have an array that contains some names (1,4,6,56...). Every integer is a name of a folder.I must to delete only the folders in array, i use this code:Code: $all_folders = array();while ($row =
PHP SUBMIT
Code: <input name="doLogin" type="image" src="images/loginsubmit.jpg" id="doLogin3" value="Login">ON FIREFOX it works finebut on
