Reply to thread

Message

<blockquote data-quote="nateforever96" data-source="post: 469479" data-attributes="member: 100733">$currencyData = mysql_fetch_array(mysql_query(&quot;SELECT * FROM [ICODE]users_currency[/ICODE] WHERE [ICODE]user_id[/ICODE] = '&quot;.$_SESSION['user']['id'].&quot;'&quot;));&nbsp; this is far as my logic goes with the pulling i am use to simple and when i have to pull a tables value only at the session user i get confused one person can get me a far way right now the tables areUsers_CurrencysvaluesUsers_Id , Type , Amountcredits are type 0 diamonds 5&nbsp; &nbsp; &nbsp; &nbsp; P.S. im trying to reconvert this and bring it back&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; if(isset($_POST['BuyRoll'])){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $userData = mysql_fetch_array(mysql_query(&quot;SELECT * FROM [ICODE]users[/ICODE] WHERE [ICODE]id[/ICODE] = '&quot;.$_SESSION['user']['id'].&quot;'&quot;));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $currencyData = mysql_fetch_array(mysql_query(&quot;SELECT * FROM [ICODE]users_currency[/ICODE] WHERE [ICODE]user_id[/ICODE] = '&quot;.$_SESSION['user']['id'].&quot;'&quot;));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $Purchase = '5000';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($userData['credits'] &lt; $Purchase){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;Not Enough Credits&lt;/br&gt;&lt;/br&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }else{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mysql_query(&quot;UPDATE [ICODE]users[/ICODE] SET credits = credits - $Purchase WHERE id = '&quot;.$_SESSION['user']['id'].&quot;'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $LotControl = mysql_fetch_array(mysql_query(&quot;SELECT * FROM [ICODE]LotteryControls[/ICODE]&quot;));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($userData['online'] == 0){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $testUsers = mysql_query(&quot;SELECT * from user_lottery WHERE user_id = '&quot;. $_SESSION['user']['id'] .&quot;' LIMIT 1&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(mysql_num_rows($testUsers) &gt; 0){</blockquote>

[QUOTE="nateforever96, post: 469479, member: 100733"] $currencyData = mysql_fetch_array(mysql_query("SELECT * FROM [ICODE]users_currency[/ICODE] WHERE [ICODE]user_id[/ICODE] = '".$_SESSION['user']['id']."'")); this is far as my logic goes with the pulling i am use to simple and when i have to pull a tables value only at the session user i get confused one person can get me a far way right now the tables are Users_Currencys values Users_Id , Type , Amount credits are type 0 diamonds 5 P.S. im trying to reconvert this and bring it back if(isset($_POST['BuyRoll'])){ $userData = mysql_fetch_array(mysql_query("SELECT * FROM [ICODE]users[/ICODE] WHERE [ICODE]id[/ICODE] = '".$_SESSION['user']['id']."'")); $currencyData = mysql_fetch_array(mysql_query("SELECT * FROM [ICODE]users_currency[/ICODE] WHERE [ICODE]user_id[/ICODE] = '".$_SESSION['user']['id']."'")); $Purchase = '5000'; if($userData['credits'] < $Purchase){ echo "Not Enough Credits"; }else{ mysql_query("UPDATE [ICODE]users[/ICODE] SET credits = credits - $Purchase WHERE id = '".$_SESSION['user']['id']."'"); $LotControl = mysql_fetch_array(mysql_query("SELECT * FROM [ICODE]LotteryControls[/ICODE]")); if ($userData['online'] == 0){ $testUsers = mysql_query("SELECT * from user_lottery WHERE user_id = '". $_SESSION['user']['id'] ."' LIMIT 1"); if(mysql_num_rows($testUsers) > 0){ [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members