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
Strange Oracle Query problem
Ok So I have this PHP class that talks to a Javascript class that basically creates a table of information from a database query and puts it in a sortable, filterable table. This all works fine and
bind error during socket programming
i am kinda new to socket programming. wrote the below code for a server. but getting the bind error everytime. i even tried changing the port number(currently is 13 daytime) but doesnt work. please
Blocking video streaming
Hello everyone,I post a message here because i didn't find any solution yet.I just finished video streaming service on my website. I use xmoov script (http://xmoov.com/xmoov-php/) to do that. It works
. and .. appearing instead of pictures
First of all, thanks very much for providing this forum. It is very much appreciated!My son-in-law created a php script for my website about 10 years ago to show pictures like a manual slideshow, and
Problems with strings containing
Hey all,I have encountered something strange in a script. I am trying to write an XML header and then fill in the file:Code: $xmlFile = "fetchableData.xml";$fh = fopen($xmlFile,
How to refresh a parent page from a modal popup
Hi,I have a modal popup in which I need to upload a file and store in the database should give a message to the user that file is uploaded and update the parent page when I close the
trouble printing an array....
I'm having some trouble printing out an array forwards. I'm figuring out the high and low of an array and did soo, but can't print out. My result is zero. if anyone could help that would be great, and
Can anyone give me some link on .htaccess tutorial
i wish to have friendly url using .htaccess, but no idea yet about this Hope that anyone could give me a simple .htaccess tutorialthanks
download directory onto C drive
I am attempting (if this is possible) to write a routine to automatically dump the contents of a directory on the server into a directory on the local C drive.I started out like this :Code:
Final year project, please point me in the right direction
hi there for my final year project I'm aiming to build a php script shell to use as an expert system ( I got a feeling this is gonna be difficult, VERY )The idea is that i create txt / csv file with
