Member since 06/19/2009

Name: Robert Brown


Location: Belgium


3 snippets

4206 profile views

9 Comment(s) Posted

View their favorites



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 807 posted 9 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 695 posted 9 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 643 posted 10 years ago by brownrl
« Prev 1 Next »