Sql-request to sort blogs by order in wordpress mu? -

-


Sql-request to sort blogs by order in wordpress mu? -

i'm using next code generate list of wordpress blogs in wordpress mu network:

$blogs = $wpdb->get_results("select * " . $wpdb->blogs . " last_updated!='0000-00-00 00:00:00' , public='1' , spam = '0' , deleted ='0' order registered " . $order . " limit " . $limit);

how do order them alphabetically instead of when registered? if not familliar database layout of wordpress, i'd happy coneptual explanation! name not registered in same database, how blogname collected output:

foreach ($blogs $blog) { $blog_options = "wp_" . $blog->blog_id . "_options"; $blog_name = $wpdb->get_col("select option_value " . $blog_options . " option_name='blogname'"); }

without knowing wordpress database schema:

if there unique blog id in both $wpdb->blogs table , $blog_options table, can bring together between them, (pseudocode):

select [...] $wpdb->blogs left bring together (select id, option_value blogname $blog_options option_name='blogname') b on a.id = b.id last_updated!='0000-00-00 00:00:00' , public='1' , spam = '0' , deleted ='0' order blogname [... etc ...]

in query, you've joined each blog associated blog_option record optionname='blogname'. inner query in bring together returns option_value alias 'blogname', can reference in order clause.

you'll have work query bit based on actual database schema, it's start!

sql wordpress

Comments

Post a Comment

Popular posts from this blog

Using Android Volley to post an array to PHP -

-
Using Android Volley to post an array to PHP - this how post values volley: @override protected map<string, string> getparams() { jsonobject jsonobjectmembers=new jsonobject(); (int i=0; i<arr_added_userids.size(); i++) { seek { jsonobjectmembers.put("params_"+i,arr_added_userids.get(i)); } grab (jsonexception e) { e.printstacktrace(); } } map<string, string> params = new hashmap<string, string>(); params.put("host", session_userid); params.put("params",jsonobjectmembers.tostring()); homecoming params; } this tried: foreach($_post['params'] $key => $value) { seek { $stmt = $conn->prepare("insert crewmembers (crewid, member) values (:crewid, :member)"); $query_params = array( ':crewid' => $crewid, ':member' => $value ); ...
Read more

python - How to add an model instance to a django queryset? -

-
python - How to add an model instance to a django queryset? - it seems django queryset behaves somehow python list. but doesn't back upwards list's .append() method know. what want like: from my_django_app.models import mymodel queryset = mymodel.objects.none() queryset.append(mymodel.objects.first()) ## no list's .append() method! is there way add together model instance existing queryset? no. queryset representation of query - hence name - not arbitrary collection of instances. if need actual queryset rather list, seek accumulating ids of objects need , getting objects via __in query: list_of_ids = [] list_of_ids.append(my_id) ... queryset = mymodel.objects.filter(id__in=list_of_ids) this isn't efficient, though. python django
Read more

angularjs - No 'Access-Control-Allow-Origin' error from local domain to public API -

-
angularjs - No 'Access-Control-Allow-Origin' error from local domain to public API - i'm trying create app retrieve stock name, asking , purchase cost yahoo finance api, using restangular. i'm having problem accessing public api in local application i'm creating when request. url parameters i'm sending: http://finance.yahoo.com/d/quotes.csv?s=msft+ge&f=nab using postman, request returns array contains stock name, asking cost , purchase cost of stock. doing request in postman returns desired info without errors. when request in local, next error: xmlhttprequest cannot load http://finance.yahoo.com/d/quotes.csv?s=msft+ge&f=nab. no 'access-control-allow-origin' header nowadays on requested resource. origin 'http://localhost' hence not allowed access. the html code follows: <html ng-app="app"> <head> <title>restangular</title> <script src="https://ajax.googleapis.com/ajax/li...
Read more