snowbob

SELECT co.*, 
    COALESCE(mod.moduleCount,0) AS moduleCount,
    COALESCE(vid.vidCount,0) AS vidCount
FROM courses AS co
    LEFT JOIN (
            SELECT COUNT(*) AS moduleCount, course_id AS courseId 
            FROM modules
            GROUP BY course_id
        ) AS mod
        ON mod.courseId = co.id

snowbob

endAndStartTimer();

		var timer;
		function endAndStartTimer() {
		 window.clearTimeout(timer);
		//var millisecBeforeRedirect = 10000; 
		timer = window.setTimeout(function(){
			resize_iframe();
		},500); 
		}

snowbob

$foo = trim(preg_replace( '/\s+/', ' ', $foo ));

snowbob

<script src="//code.jquery.com/jquery-1.11.0.min.js"></script>
   <script src="//code.jquery.com/jquery-migrate-1.2.1.min.js"></script>

snowbob

$included_files = get_included_files();
   
   foreach ($included_files as $filename) {
       echo "$filename\n";
   } 

snowbob

<?php

include('../../../connect.php');

$id = (isset($_POST['id']) && $_POST['id'] != '') ? mysql_real_escape_string($_POST['id']) : '';
$value = (isset($_POST['value']) && $_POST['value'] != '') ? mysql_real_escape_string($_POST['value']) : '';

$ERROR=0;

snowbob

mysql_query("DELETE FROM example WHERE age='15'")or die(mysql_error());

snowbob

$table="|";
$sql="update from $table set = , =  where id=$id";
$result=mysql_query($sql) or die ("<h3>Error</h3><p><b>".mysql_error()."</b></p>");

snowbob

$sql="insert into table () values ( , , , ) where id='$id'";
$result=mysql_query($sql) or die ("<h3>Error</h3><p><b>".mysql_error()."</b></p>");

snowbob

$.ajax({
        url: 'ajaxCalls/remove_printer.php',
        type: 'POST',
        data: {
            'id': id

        },
        dataType:"json", 
        success: function(response) {
            if(response.status === "success") {