adamd

  • Random
  • Archive
  • RSS
  • Ask me anything
  • Submit
Dear #bubble #bath,
I am too tall for you.
Pop-upView Separately

Dear #bubble #bath,
I am too tall for you.

    • #bubble
    • #bath
  • 1 day ago
  • Permalink
  • Share

_mysql() - Select data from rows, grouped by column

This allows for chained queries/linking with other tables, for example, to select `applications` that match the first query.

Code
<?php
	$applications_assigned=_mysql(
		'select',
		'computers_applications_assigned',
		array(
			'fields'=>array( //fields you want to return
				'application',
				'license'
				),
			'where'=>array( //query for selection
				'active'=>1,
				)
			),
		array(
			'return-only'=>array('application','license') //fields you want uniques for
			)
		);
?>
Output
Array (
    [query] => SELECT `application`, `license` FROM `computers_applications_assigned` WHERE `active`='1'
    [result] => Array (
            [application] => Array ( //all values in the 'application' column matching the query
                    [0] => 61
                    [1] => 77
                )
            [license] => Array ( //all values in the 'license' column matching the query
                    [0] => 61
                    [1] => 77
                )
        )
    [results_count] => 2
    [startfrom] => 0
    [remaining] => 0
    [affected_rows] => 2
    [error] => 
)
    • #mysql
    • #php
    • #code
    • #snippet
    • #documentation
    • #function
  • 2 days ago
  • Permalink
  • Share
Making #radio (at Radio Fremantle)
Pop-upView Separately

Making #radio (at Radio Fremantle)

    • #radio
  • 5 days ago
  • Permalink
  • Share
Who knew supporting kids football teams could be so delicious? #krispykreme
Pop-upView Separately

Who knew supporting kids football teams could be so delicious? #krispykreme

    • #krispykreme
  • 2 weeks ago
  • Permalink
  • Share
K: Tri colour taxi? Seems ironic cos all I see is a gunmetal grey taxi…
(via nerdsontheroad)
  • 2 weeks ago > nerdsontheroad
  • 1
  • Permalink
  • Share
#taxi #boredwhilewalking #perth
Pop-upView Separately

#taxi #boredwhilewalking #perth

    • #taxi
    • #boredwhilewalking
    • #perth
  • 2 weeks ago
  • Permalink
  • Share
View Separately

(via prguitarman)

  • 3 weeks ago > thepetcollective
  • 66605
  • Permalink
  • Share
View Separately

(via ryanhasabutt)

  • 3 weeks ago > onlylolgifs
  • 112752
  • Permalink
  • Share
lovequotesrus:

EVERYTHING LOVE
View Separately

lovequotesrus:

EVERYTHING LOVE

  • 3 weeks ago > aestheticaspirations
  • 13251
  • Permalink
  • Share
'\x3cdiv id=\x22photoset_48530331186\x22 class=\x22html_photoset\x22\x3e \x3ciframe id=\x22photoset_iframe_48530331186\x22 class=\x22photoset\x22 scrolling=\x22no\x22 frameborder=\x220\x22 height=\x222540\x22 width=\x22500\x22\x0a style=\x22border:0px; background-color:transparent; overflow:hidden;\x22 src=\x22http://adamd.tumblr.com/post/48530331186/photoset_iframe/adamd/tumblr_meoxyp0geC1r87i11/500/false\x22\x3e\x3c/iframe\x3e\x3c/div\x3e'

kylerc:

atavus:

Mark Daniel - Kolmanskop, 2008

(via nosubstitute-for--time)

  • 1 month ago > atavus
  • 11805
  • Permalink
  • Share
#marshmallow #cafe
Pop-upView Separately

#marshmallow #cafe

    • #cafe
    • #marshmallow
  • 1 month ago
  • Permalink
  • Share
Will you sit with me and watch the world go by?
Pop-upView Separately

Will you sit with me and watch the world go by?

  • 1 month ago
  • Permalink
  • Share
#lunch #allbymyself #sammichshop
Pop-upView Separately

#lunch #allbymyself #sammichshop

    • #lunch
    • #allbymyself
    • #sammichshop
  • 1 month ago
  • Permalink
  • Share
#easter #bunny #rabbits
Pop-upView Separately

#easter #bunny #rabbits

    • #rabbits
    • #easter
    • #bunny
  • 1 month ago
  • 4
  • Permalink
  • Share
#bike #ride #cousin
Pop-upView Separately

#bike #ride #cousin

    • #cousin
    • #ride
    • #bike
  • 1 month ago
  • 2
  • Permalink
  • Share
← Newer • Older →
Page 1 of 194

About

Hi,
I'm Adam.
I'm a Perth based computer "geek". I design and code websites, provide technical support and also tear computers apart..
I'm on Radio Fremantle (107.9fm) from 4pm to 5pm on Fridays.
In addition to this, I listen to a massive range of music. Most people don't understand how diverse my range is.

Me, Elsewhere

  • @adam_d on Twitter
  • adamdiswikkid on Youtube
  • RSS
  • Random
  • Archive
  • Ask me anything
  • Submit
  • Mobile

adam_d. Effector Theme by Carlo Franco.

Powered by Tumblr