Interested to Buy Any Domain ? << Click Here >> for more details...
Want to know the 10th max salary in salary table
- 3 Answers
- 5966 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / amar banerjee
SELECT sal FROM salary SORT BY sal desc limit 9,1
| Is This Answer Correct ? | 16 Yes | 5 No |
Answer / jose_100
SELECT SAL FROM SALARY_TABLE ORDER BY SAL DESC LIMIT 9, 10;
| Is This Answer Correct ? | 5 Yes | 3 No |
What is better .net or php?
How to pass variables and data from php to javascript?
how to run PHP in command line?
8 Answers InfoShore, Ramp Green, Xtreeme,
What is session_start () in php?
Write a program to find a string is palindrome or not?
how retrive the video file in php using video tag
Does php have multiple inheritance?
Do you know what is php?
Why is PHP-MySQL frequently used for web (Portal) Development?
5 Answers T3 Softwares, Wipro,
What is indexing how many types?
3 Answers DLF, Infosys, Net Solution, Vcare,
What is the difference between single quoted string and double quoted string?
i start a new session with : session_start(); then i set some session variable like this : $_SESSION['name']=$_POST['name'];\ and some another variables. at bottom of page i set header to diffrent page : header('location: index.php'); exit(); now in new page (index.php i can't access to my session variables, like $_SESSION['name']) what's wrong ? thanks. here is my files : a.php ======================================== session_start(); require ('config.inc.php'); if(isset($_POST)) foreach($_POST as $v=>$k) { $items[$v]=$k; } $sql="SELECT * FROM members WHERE username='{$items['user']}' AND pass=MD5('{$items['Password']}') "; $res=mysql_query($sql); $row=mysql_fetch_assoc($res); if($row['username']) { $_SESSION['type']=$row['type']; $_SESSION['name']=$row['name']; $_SESSION['family']=$row['family']; $_SESSION['username']=$row['username']; $_SESSION['date']=$row['date']; } header('location: admin.php'); exit(); ====================================== admin.php ===================================== <?php session_start(); if(!isset($_SESSION['admin'])) { header('location: index.php'); exit(); } require ('config.inc.php'); ?> . . . =================================
PHP 
