How To Create Mysql Select Statement With Limit

Question

Hello. I need help with doing a mysql select, where the values in wins is higher than lets say 100 ? So it selects only the users who have had more than 100 win's

Then i need to inserts each one into a table.

Here is what i have so far

<?php
// i have toke my connect out


// Get all the data from the "example" table
$result = mysql_query("SELECT * FROM users") 
or die(mysql_error());  

echo "<table border='1'>";
echo "<tr> <th>username</th> <th>wins</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
    // Print out the contents of each row into a table
    echo "<tr><td>"; 
    echo $row['username'];
    echo "</td><td>"; 
    echo $row['wins'];
    echo "</td></tr>"; 
} 

echo "</table>";
?>

I am guessing id need a were statement ? Saying select were wins > 100 ? I have done loads of select were's be for but never select were is over. I also will need to insert each one of the results into another table called rewards

SELECT * FROM users where wins >= 100

Fahim Parkar
– Fahim Parkar

2012-05-19 12:29:18 +00:00
Commented May 19, 2012 at 12:29 — Fahim Parkar
– Fahim Parkar, Commented May 19, 2012 at 12:29

Fahim Parkar · Accepted Answer · 2012-05-19 12:37:30Z

0

Your current query SELECT * FROM users will give you ALL data that is present in your table.

To get the data where wins > = 100 just add this condition so that new statement will be

SELECT * FROM users where wins >= 100

To insert into rewards table (considering you have fields as username, wins) use below

insert into rewards 
(username, wins) 
select username, wins 
from users 
WHERE wins >= 100

edited May 19, 2012 at 12:37

answered May 19, 2012 at 12:31

Fahim Parkar

31.8k46 gold badges169 silver badges285 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Fahim Parkar Over a year ago

nope.. that is just one query. using while you will be just displaying all records...

user1405062 Over a year ago

The insert does not work for me. Could you post it has coding ?? and not just words ?

Fahim Parkar Over a year ago

what are the field name that you have in rewards table?

user1405062 Over a year ago

Don't worry i got it now just did a simple insert in the while. And did the select out of the while

Fahim Parkar Over a year ago

can you tell me what did you write inside while loop??

Collectives™ on Stack Overflow

How To Create Mysql Select Statement With Limit

1 Answer 1

To insert into rewards table (considering you have fields as username, wins) use below

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

To insert into rewards table (considering you have fields as username, wins) use below

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related