How Would I....

PunkGo

select a certain column, say its a number, then make sure a user has enough 'points' for them to do something....then if they do and they want to go there, when they click on it, it makes sure they have enough, then subtracts how many points it was...

drawmack

assumptions:
users is the name of the table with the user's information
userspoints is the name of the field holding the number of points the user has
events is the name of the table with the event's information
neededpionts is the name of the field with the points an even costs

<?php
$sql = "select (a.userspoints - b.neededpoints) as difference from users as a, events as b WHERE userid = $userID";
$query = mysql_query($sql);
$pointsLeft = mysql_result($query,0,0);
if($pointsLeft < 0) {
  //user does not have enough points
} else {
  $sql = update users set userspoints = $pointsLeft;
  mysql_query($sql);
//user has enough points
}
?>

jonno946

you expecting us to program it for you?!

The idea of this forum, is to ask for help, not ask for someone else to do your dirty work for you!!!

Post some code, and we will see what is wrong...

PunkGo

i dont expect that. ive tried numerous times but never seems to go right, heres my most recent try

<?php

$points = $_REQUEST['points'];

mysql_connect("localhost", "punkgo_punkgo", "*********")
or die(mysql_error());

mysql_select_db("punkgo_users")
or die(mysql_error());

$mysql_query = mysql_query("SELECT * FROM users WHERE points='$points'")
or die(mysql_error());

while ($result = mysql_fetch_array($mysql_query)) {
if($points_check['points'] > 3){ 
echo $points_check['points'].'<br />';
}
else {
echo 'BOOOOO';
}
}
?>

but that did nothing.