Mysql group by in mysql and php

Mysql group by in mysql and php

<?php
$sql="select sum (payment) from 'your table name ' GROUP BY name ";
?>
or
<?php
$sql="select sum (payment) from 'your table name ' GROUP BY name , name LIKE 's%' ";
?>

Comments

how send mail using Swift mailer | switmailer send mail tutorial

how send mail using Swift mailer | switmailer send mail tutorial <?php /* step 1 include Swift mailer file ; */ include("vendor/swiftmailer/swiftmailer/lib/swift_required.php"); /* step 2 create your user details */ $senderEmail="saddam1234321@gmail.com"; $senderPassword="****Your password****"; $senderName="Saddam huassin"; /* step 3 set SMTP host for sending mail */ $user = Swift_SmtpTransport::newInstance('smtp.gmail.com','587','tls'); /* step 4 set your user details */ $user->setUsername($senderEmail); $user->setPassword($senderPassword); /* step 5 create swift mailer instance with a variable */ $mailer = Swift_Mailer::newInstance($user); /* step 6 Create a message */ $message = Swift_Message::newInstance('Wonderful Subject') ->setFrom(array($senderEmail => $senderName)) ->setTo(array($senderEmail)) ->setBody('Here is the message itsel...

Find more ----»

how install Swift mailer in localhost | swift mailer installation | composer install swift mailer

how install Swift mailer in localhost | swift mailer installation | composer install swift mailer Step 1:- open cmd Step 2;- copy this command " composer required swiftmailer/swiftmailer @stable " . Step 3;- paste in cmd and press enter. Step 4;- after few second swift mailer ready to use .................................

Find more ----»

Mysql distinct in mysql and php

Mysql distinct in mysql and php <?php $sql="select distinct * from 'your table name ' "; ?> or <?php $sql=" select distinct * from 'your table name ' name LIKE 's%' "; ?>

Find more ----»

Code with saddam

Search This Blog