brownrl


Member since 06/19/2009

Name: Robert Brown

brownrl

Location: Belgium

Website: http://www.itsgotto.be

3 snippets

1526 profile views

9 Comment(s) Posted

View their favorites

Profile

Achievement

first submission:submitting first snipplet

brownrl's Recent SnippetsTagged sql



« Prev 1 Next »
Moving a wordpress site for local dev, to staging, to production? This SQL snippet has done the job more often than not. It may not be 100% full proof but it has saved my butt hundreds of times. Please, if you know other tables or enhancements share...
0 382 posted 6 years ago by brownrl
This piece of sql is used to find the similarity of one item to other items based on a 3 table tag system, cities, cities_tags, tags. It works in sQlite and MySQL. Use this code to get the idea of how you would make a "item" has "related items" based...
0 379 posted 6 years ago by brownrl
When using PDO with sQlite ->rowCount() doesn't work. the recommendation is to do a pre query to get the number. Thus, I created this snippet to help things along.
0 334 posted 8 years ago by brownrl
« Prev 1 Next »