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

calculate distance between two points in jquery

<!doctype html> < html class = " no-js " lang = " " > < head > < meta charset = " utf-8 " > < meta http-equiv = " X-UA-Compatible " content = " IE=edge,chrome=1 " > < meta name = " author " content = " Green Ido | @greenido | plus.google.com/+greenido " > < meta name = " viewport " content = " width=device-width, initial-scale=1.0 " /> < title >Geo - Calculate the distance</ title > < meta name = " description " content = " Geo - Calculate the distance " > < meta name = " viewport " content = " width=device-width, initial-scale=1 " > < style type = " text/css " > body { font-size : 120 % ; } #demo { padding : 1 em ; background : yellow ; width : 20 em ; border-radius : 1 em ; } Button { p...
Read more

How To Read JSON Data Response Using PHP?

Example JSON Response $json_data = '{       "stat": "ok",       "profile": {         "providerName": "testing",         "identifier": "http://testing.com/58263223",         "displayName": "testing 1",         "preferredUsername": "testing 2",         "name": {           "formatted": "testing"         },         "url": "http://testing.com/testing/",         "photo": "https://securecdn.testing.com/uploads/users/5826/3223/avatar32.jpg?1373393837",         "providerSpecifier": "testing"       }     }'; Alternative 1 (returns object format) $data = json_decode($json_data); echo $data->profile->displayName; // outputs testing 1 echo $data->profile->preferredUsername;// outputs testing 2 Alternative 2...
Read more

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