Skip to main content

Mysql top function in mysql and php

Mysql top function in mysql and php


<?php
$sql="select top 3 from 'your table name ' ";
?>
or
<?php
$sql="select top 5  from 'your table name ' ' where name LIKE 's%' ";
?>
Labels:

Comments

Post a Comment

Popular posts from this blog

Minimum and maximum number with - and + 500 in Mysql and Sql query and Find out table scheema of our database in Mysql and sql query and Find out all table name of our database in Mysql and sql query and Find out current date and time in mysql and sql help of sql query

Minimum and maximum number with - and + 500 in Mysql and Sql query:- syntax:-  SELECT MIN(Used)-500 , max(Used)+500 FROM audit Find out current date and time in mysql and sql help of sql query:- syntax:- SELECT now() Find out database name in Mysql and sql query:- syntax:-  SELECT DATABASE(); Find out all table name of our database in Mysql and sql query:- syntax:- SHOW TABLES; Find out   table scheema   of our database in Mysql and sql query:- syntax:- DESCRIBE <table name>;
Post a Comment
Find more ----»

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...
Post a Comment
Find more ----»

create mysql database connection with code OR MYSQL DATABASE CONNECTION IN PHP

MYSQL DATABASE CONNECTION IN PHP <html> <head> <title>php and mysql by sam saifi</title> </head> <body> create mysql database connection with code step by step step1:- create connection to data  like $con. step2:-mysql_connect() having three para meter step3:- first your server name like "localhost" if you use in local machine step4:-secound is username by default it root but you can change easly. step5:- thirld is password in local machine having null but you can change easly. step6:- now data base connected; <?     $con = mysql_connect("localhost","sam","sam");     if($con)     {         echo "horey........... my database Connected.";     }     else     {         echo "Cannot Connect database ".mysql_error();     }     mysql_close($co...
Post a Comment
Find more ----»