Topic: "Mysql error and Checkboxes in php" (page 1 of 1)

1
Author Post
sniperkid
groupmastergroupmastergroupmastergroupmastergroupmastergroupmastergroupmastergroupmastergroupmaster
firstly Mysql error:
here is the query i have;
$query = "SELECT * FROM users ORDER BY money DESC LIMIT 0 , 10";

this should select from the db the user who has the most money but it only selects users with the first '9'.
Example

user1 - $9
user2 - $990357
user3 - $901

anyway to get it to show who has the most money ?

Checkboxes

how can u tell which checkboxes were checked ?
example;

form action="check.php method="post"

1 [] 2 [] 3 [] 4 [] 5 []

/form

and it should say which checkboxes were checked.....i cant seem to find any tutorials on this :(


Edit: Sorted Mysql error :read: if anyones interested or encounters the same problem this is the solution i have found;
SQL query:
ALTER TABLE `users` CHANGE `money` `money` INT( 30 ) NOT NULL DEFAULT '10000'
:laola:
Edited by sniperkid on 22.08.2005 00:56:01
private message Website
quangntenemy
groupmastergroupmastergroupmastergroupmastergroupmastergroupmastergroupmastergroupmastergroupmastergroupmastergroupmastergroupmastergroupmaster
Edited by quangntenemy on 26.08.2005 09:41:49
private message EMail Website
sniperkid
groupmastergroupmastergroupmastergroupmastergroupmastergroupmastergroupmastergroupmastergroupmaster
yea thats sort of right i need it in php though ;)
private message Website

Topic: "Mysql error and Checkboxes in php" (page 1 of 1)

1