query for those customer which have multiple order in mysql

SELECT customer.name, orders.order_name
FROM customer
LEFT JOIN orders ON customer.cid = orders.c_id
GROUP BY customer.cid
HAVING COUNT( orders.c_id ) >1

Comments

Post a Comment

Popular posts from this blog

dynamic create multiple ckeditor onclick event using jquery

<!DOCTYPE html> <html> <head> <title>New Ckeditor Instance Dynamically</title> <script type="text/javascript" src="ckeditor_3.5/ckeditor/ckeditor.js"></script> <script type="text/javascript" src="scripts/jquery-1.4.4.js"></script> <script type="text/javascript" src="ckeditor_3.5/ckeditor/adapters/jquery.js"></script> <script type="text/javascript"> $(document).ready(function() { $('.jquery_ckeditor').ckeditor(); }); </script> <script> function newCkeditor(){ $('<div><textarea><\/textarea><\/div>') .appendTo('#body').find('textarea').ckeditor(); } function clicked(){ for ( instance in CKEDITOR.instances ){ alert("ckeditor values : " + CKEDITOR.instances[instance].getData()); } } </script> </head> <body...
Read more

Fatal error: Can't use method return value in write context in ci

Replace the first if statement with if( ! $this->session->userdata('user_id') ) . The empty function check if a variable is empty but userdata is a function. Additionally, for your information, according to the CodeIgniter documentation , the userdata function returns FALSE if the item doesn't exist, which means that if user_id doesn't exist in your session, the code in the else will be executed. ref: https://stackoverflow.com/questions/6730216/cant-use-method-return-value-in-write-context
Read more

online visitor counter

   <?php session_start();      function getUsersOnline() {    $count = 0;         $handle = opendir(session_save_path());    if    ($handle == false) return -1;         while (($file = readdir($handle)) != false) {          if (ereg("^sess", $file)) $count++;    }    closedir($handle);         return $count; } ?> then just call it using this <?php echo $usercount = getUsersOnline(); ?>
Read more