I have sql statement:
Code:
SELECT count(id) FROM artists_tags GROUP BY tag ORDER BY count(id) DESC, tag ASC
I could also use simple sort option with...
FrEaKmAn
Last Activity: Jul 27 '08, 01:38 PM
Joined: Aug 26 '07
Location:
-
order by count and tag
Hello
I have sql statement:
I want to create simple tag cloud, so I want to order by the amount, count some tag appears and then sorted that tags by name ASC. As I know, my code doesn't do this as it sorted tags by name only where count results repeat...
I could also use simple sort option with... -
hm, I came to this solution, but I don't know if it's the best one..
[HTML]<div>
<div style="float:le ft;width:100%;m argin: 0 auto 0 -150px;backgroun d:#ff0000;">
<div style="margin-left:150px;">a</div>
</div>
<div style="float:le ft;width:150px; background:#ccc ;">g</div>
</div>[/HTML] -
fixed and auto width
Hi
I have a problem which is probably very simple to solve. For example
[HTML]
<div style="width:10 0%;">
<div style="float:le ft;width:100%"> percents</div>
<div style="float:le ft;width:100px; ">fixed</div>
</div>
[/HTML]
what I want to do is to make 2 columns, 1 is set to width of 100px and other one... -
nice thanks :D But on the end I decided for JS and drag feature :DLeave a comment:
-
Select from 2 tables and reselect if not exists
Hello
I have 2 tables,
...Code:CREATE TABLE `events` ( `id` int(11) NOT NULL auto_increment, `type` int(1) NOT NULL, `typeid` int(5) NOT NULL, `dt` datetime NOT NULL, `locationid` int(11) NOT NULL, `status` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-
adding # to the url
Hello
I might have a weird problem, but I'm seeking for a solution. I have a form with some inputs. I'm using ajax to call a search data and everything works, but problem is when users use back button because it loads the main search page (without results).
My idea was to store search data or parameters and then recall them when user access the page. As I have
site.com/browse
url, I need... -
CSS center page alignment
Hello
I'm wondering if I can align some div to the center of the page (horizontal and vertical). We are talking about the option to scroll up/down and that div still stays at the center. I know that this is possible with JS, but what about CSS?
Thanks in advance -
hm, looks interesting, only problem is that it doesn't work with safari... maybe does now after almost 3 years...
my idea was to use ajax to store data, basically what is users searching, where etc and then this data is reloaded when he/she returns to search page. Only problem is that I don't know how to separate returning to search page and accessing it (it will load last searched data).. any ideas?Leave a comment:
-
Remember data
Hello
I'm building a simple search option so my site and I have a problem with remembering the data. For example if user hits the search button, the data is loaded with ajax and he/she goes to the next link showed in loaded data. Now when he/she hits the return button, it goes back to main state, but I want that it returns to state where the search data is showed....
should I use some tricks, maybe remembering data with... -
as I said, "old". It not old and it's used almost everywhere, but it's older comparing to the new methods.....Leave a comment:
-
what does a session has to do with post? I'm just wondering if there is a better way then "old" <form method="POST"> way.....Leave a comment:
-
PHP Post
Hello
I'm working on paypal payment system and I'm wondering how can I post data with PHP. I don't want any forms that have some hidden inputs, but everything should be hidden in PHP. I checked some modules (like on oscommerce) but I don't understand them. So does anybody know any code, class, tutorial for this? -
image and charset
Hello
I'm creating a website where users will upload all sort of images, so I decided to make my system work something like
domain.com/randomtext/original-image-name.jpg
Now I'll try to rename file to randomtext_orig inal-image-name.jpg and I have mod_rewrite and everything works. But my language has also some non english symbols, like č, š, ž and lately I noticed that they are not replaced anymore... -
http://www.fpdf.org/
http://sourceforge.net/projects/tcpdf/
untested but they look interesting...Leave a comment:
-
php classes
Hello,
I have this simple but weird thing, at least for me
[PHP]
<?php
class a{
function __construct(){
$this->data='6';
b::b();
//$a=b::b();
}
function get(){
exit($this->data);
//exit($a);
}
}
class b{
function b(){
$this->data='9';
return $this->data;... -
hello again
what I did is I created new class someclassname, which extends database class. Then we I construct it, I also construct database class suing parent::__contr uct(); and everything works :D
only problem is how do I access parent class or the parent class? For example if I have new class somenewclassnam e extends someclassname, how do I access database class?Leave a comment:
-
hm, my next solution is that I use
[PHP]
$GLOBALS['db']->query(....
[/PHP]
as $db is already created. Would this be optimal solution?...Leave a comment:
-
class scope::
[php]
class database{
function __construct(){
$this->connect_id = mysql_connect(' localhost','roo t','');
if($this->connect_id){
if (mysql_select_d b('dbname')) return $this->connect_id;
else return $this->error();
}else return $this->error();
}
function query($query){
if ($query... -
this is possible, but when we replace it once we can't replace it with something else, so is it possible to make a pattern?Leave a comment:
-
it's not important if I'm gonna have folder or not. What I want is to change the value of href, for example
from
toCode:#statistics/day/type:songs
there could be also more options after type:songs so this need to stay untouched......Code:#statistics/year/type:songs
Leave a comment:
No activity results to display
Leave a comment: