motlive

- friends
3,010 link karma
4,029 comment karma
send messageredditor for
what's this?

TROPHY CASE

Help with JOIN query. by motlivein mysql

[–]motlive[S] 0 points1 point ago

I had never used the alias thing. This morning I gave it a bash and it worked. Cheers.

Help with JOIN query. by motlivein mysql

[–]motlive[S] 0 points1 point ago

Thanks, thats close, with a * it brings back all the fields from both tables, what I'm after is:

products.ref products.game_id products.notes products.postage products.price products.picture products.sold game.title

Help with JOIN query. by motlivein mysql

[–]motlive[S] 0 points1 point ago

Would help, heres the schema code:

http://snipt.org/ujTf5

And an image for a quick overview:

http://i.imgur.com/2Qs6M.png

My Harley Quinn costume for MCM London Comic Con 2012 (minus the few accessories I have to buy) by soozeh92in gaming

[–]motlive 0 points1 point ago

"cybercandy stalls" what are those?

My Harley Quinn costume for MCM London Comic Con 2012 (minus the few accessories I have to buy) by soozeh92in gaming

[–]motlive 0 points1 point ago

Is it any good?

Im more for the autographs and talks so will be heading to LFCC again this year. I was meant to be going dressed as an Royal Imperial Guard but funds and time and the fact Ive been finding it incredibly hard to find size 11 shoes in the right style (womens) has slowed the whole thing down.

Need some help! by motlivein PHP

[–]motlive[S] 0 points1 point ago

I think thats a sign for me to go to sleep.... what an idiot!

Seems to have had some success now.

Need some help! by motlivein PHP

[–]motlive[S] 0 points1 point ago

I just get:

Invalid query: Whole query: SELECT games.* , game_desc.description, images.header, images.thumbnails, images.main, images.screenshots FROM games, game_desc, images WHERE games.id = '1' AND game_desc.id = games.id AND images.id = games.id

Need some help! by motlivein PHP

[–]motlive[S] 0 points1 point ago

Top of my php page I have:

game_details();

And then I have:

function game_details(){

database_connection();

$query = "SELECT games.* , game_desc.description, images.header, images.thumbnails, images.main, images.screenshots FROM games, game_desc, images WHERE games.id = '1' AND game_desc.id = games.id AND images.id = games.id"; $query_result = mysql_query($query);

if (!$result) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $query; echo $message; }

}

The database connection function works fine as its functions in other functions correctly.

J.J. Abram's "Revolution" looks to be our kind of show. by TyGossin geek

[–]motlive 5 points6 points ago

premise looks like it may be good, but JJ Abrhams likes to fuck with things too much, drag it out to death and then slowly rape the corpse of the show whilst simultaneously calling your mother a filthy whore.

Question for the UK from the US South: what do you think about your knives/firearms laws? by north0in unitedkingdom

[–]motlive 2 points3 points ago

I think it boils down to changes in society. Unless you are doing an activity that requires you to carry a knife (Diving, camping, threatening people) then you really don't need to have one, that is what I believe the general consensus is on the subject.

Hey Diageo: This how not to do PR... by tdobsonin unitedkingdom

[–]motlive 0 points1 point ago

if you're an ale drinker its worth checking out, as its a bit out of town the clientele is a little "better" too.

Hey Diageo: This how not to do PR... by tdobsonin unitedkingdom

[–]motlive 0 points1 point ago

I think the actual bar was alright, and well laid out, but as its meant to be a craft beer pub and the beers seem overpriced and not great imo it kind of fails!

If you're from Nottingham have you checked out the Organ Grinder at the top of canning circus?

Vulnerabilities found in Photoshop CS 5.5 and earlier by ross_the_bossin photography

[–]motlive 0 points1 point ago

The "Solution" is great:

Adobe has released Adobe Photoshop CS6 (paid upgrade), which addresses these vulnerabilities. For users who cannot upgrade to Adobe Photoshop CS6, Adobe recommends users follow security best practices and exercise caution when opening files from unknown or untrusted sources.

American views of British game shows: Pointless by gray-pilgrimin BritishTV

[–]motlive 13 points14 points ago

to me...

Hey Diageo: This how not to do PR... by tdobsonin unitedkingdom

[–]motlive 1 point2 points ago

No, next to the price is will say 1/3 2/3 etc, so you know its not a full pint. They do this on the really strong ales 10+% but I got a 2/3 for a 5% ale!

Hey Diageo: This how not to do PR... by tdobsonin unitedkingdom

[–]motlive 9 points10 points ago

I dont mind Punk IPA, but the rest of their beers are not very nice in comparison to other "craft" beers.

Their new pub in Nottingham is a farce too, its layout is "alright", plenty of high tables to stand at which is cool when its busy. But the price of their "craft" beers is just insane, 2/3 pint glasses and still charge £3.50 for a "pint" of Punk IPA.. no ta.

I would rather drink my local ales, Castle Rock do a nice IPA called Harvest Pale which is good when nothing else is available, they also do my other favourite which is Elsie Mo and a fine selection of others.

Hey Diageo: This how not to do PR... by tdobsonin unitedkingdom

[–]motlive 2 points3 points ago*

They charge an incredible amount for a pint.. and sometimes you don't even get a pint, they serve in 2/3 pint glasses and still charge over £3!

**Spelling mistake

Starhawk's Reverse Cover Art by Crunchumsin PS3

[–]motlive -1 points0 points ago

Exactly what I was going to point out.

People on eBay sell these for $300+. I found hi-res images of it and printed it myself for $20 by Albuyehin geek

[–]motlive 2 points3 points ago

are the limited edition runs the ones being sold on ebay or are they copies?

also why a limited run?

view more: next