Greenbox

but isnt it a easier way to do it than do everyone like that?

Something like this? if ($_POST['save_settings']){ $sex=mysql_real_escape_string(strip_tags($_POST['sex'])); mysql_query("UPDATE users SET sex='$sex' WHERE username='$username'"); }

im trying to do an update because settings is already in the db

hi, i get this error when i click the save settings code i got two diffrent buttons on the page one for the save settings and one for save profile im a noob at php so please help me out and see if you can see whats the problem is in this code Thanks You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(`sex` , `country` , `day`, `year`, `month`, `msn` , `skype`) VALUES ('2', '', '' at line 1 <? session_start(); include_once "includes/db_connect.php"; include_once"includes/functions.php"; logincheck(); $username=$_SESSION['username']; $query=mysql_query("SELECT * FROM users WHERE username='$username'"); $fetch=mysql_fetch_object($query); if ($_POST['save_profile']){ $image=strip_tags($_POST['viewprofile']); $quote = $_POST['quote']; $bgcolor = $_POST['bgcolor']; $textco = $_POST['textco']; $pic = $_POST['pic']; $musictitle = $_POST['musictitle']; $profilmu = $_POST['profilmu']; $updatemusicchange = $_POST['updatemusicchange']; $avatar = $_POST['avatar']; } if ($_POST['save_settings']){ $skype = $_POST['skype']; $sex = $_POST['sex']; $country = $_POST['country']; $month = $_POST['month']; $day = $_POST['day']; $year = $_POST['year']; } if ($_POST['save_profile']){ mysql_query("UPDATE users (`avatar` , `updatemusicchange` , `profilmu`, `musictitle`, `pic`, `textco` , `bgcolor` , `quote`) VALUES ('$avatar, '$updatemusicchange', '$profilmu', '$musictitle', '$pic', '$textco', '$bgcolor', '$quote')") or die (mysql_error()); echo "<font color=orange><center><b>Your Profile have been updated!<meta http-equiv=Refresh content=0;url=editprofile.php></font></b>"; } if ($_POST['save_settings']){ mysql_query("UPDATE users (`sex` , `country` , `day`, `year`, `month`, `msn` , `skype`) VALUES ('$sex', '$country', '$day', '$year', '$month', '$msn', '$skype')") or die (mysql_error()); echo "<font color=orange><center><b>Your Profile have been updated!<meta http-equiv=Refresh content=0;url=editprofile.php></font></b>"; } ?>

Hey, im trying to get this drop down list working.. My problem is when i select a country the image of the country shows at the right side as it should.. But when i save the information it shows up the country code instead of the country name and the flag dissapear.. is there any way i can make the value stay like it is when i update or reload the site? any help would be appreciated <td>Country:</td> <td height="21"> <select onchange="if(document.images) document.images['flag'].src='images/flags/'+this.options[this.selectedIndex].value+'.png';" name="country" id="country" class="TextBox"> <option selected="selected" value=""><?php if ($fetch->country == ""){echo "-Select Country-";}else{ echo"$fetch->country";} ?></option> <option value="af">Afghanistan</option> <option value="al">Albania</option> <option value="dz">Algeria</option> <option value="as">American Samoa</option> <option value="ad">Andorra</option> <option value="ao">Angola</option> <option value="ai">Anguilla</option> <option value="aq">Antarctica</option> <option value="ag">Antigua and Barbuda</option> <option value="ar">Argentina</option> <option value="am">Armenia</option> <option value="arpa">Arpanet</option> <option value="aw">Aruba</option> <option value="au">Australia</option> <option value="at">Austria</option> <option value="az">Azerbaijan</option> <option value="bs">Bahamas</option> <option value="bh">Bahrain</option> <option value="bd">Bangladesh</option> <option value="bb">Barbados</option> <option value="by">Belarus</option> <option value="be">Belgium</option> <option value="bz">Belize</option> <option value="bj">Benin</option> <option value="bm">Bermuda</option> <option value="bt">Bhutan</option> <option value="bo">Bolivia</option> <option value="ba">Bosnia and Herzegovina</option> <option value="bw">Botswana</option> <option value="bv">Bouvet Island</option> <option value="br">Brazil</option> <option value="io">British Indian Ocean Territory</option> <option value="bn">Brunei Darussalam</option> <option value="bg">Bulgaria</option> <option value="bf">Burkina Faso</option> <option value="bi">Burundi</option> <option value="kh">Cambodia</option> <option value="cm">Cameroon</option> <option value="ca">Canada</option> <option value="cv">Cape Verde</option> <option value="ky">Cayman Islands</option> <option value="cf">Central African Republic</option> <option value="td">Chad</option> <option value="cl">Chile</option> <option value="cn">China</option> <option value="cx">Christmas Island</option> <option value="cc">Cocos (Keeling) Islands</option> <option value="co">Colombia</option> <option value="km">Comoros</option> <option value="cg">Congo</option> <option value="ck">Cook Islands</option> <option value="cr">Costa Rica</option> <option value="hr">Croatia (Hrvatska)</option> <option value="cu">Cuba</option> <option value="cy">Cyprus</option> <option value="cz">Czech Republic</option> <option value="cs">Czechoslovakia (former)</option> <option value="dk">Denmark</option> <option value="dj">Djibouti</option> <option value="dm">Dominica</option> <option value="do">Dominican Republic</option> <option value="tp">East Timor</option> <option value="ec">Ecuador</option> <option value="eg">Egypt</option> <option value="sv">El Salvador</option> <option value="gq">Equatorial Guinea</option> <option value="er">Eritrea</option> <option value="ee">Estonia</option> <option value="et">Ethiopia</option> <option value="eu">Europe</option> <option value="fk">Falkland Islands (Malvinas)</option> <option value="fo">Faroe Island</option> <option value="fj">Fiji</option> <option value="fi">Finland</option> <option value="fr">France</option> <option value="gf">French Guiana</option> <option value="pf">French Polynesia</option> <option value="tf">French Southern Territories</option> <option value="ga">Gabon</option> <option value="gm">Gambia</option> <option value="ge">Georgia</option> <option value="de">Germany</option> <option value="gh">Ghana</option> <option value="gi">Gibraltar</option> <option value="gb">Great Britain (UK)</option> <option value="gr">Greece</option> <option value="gl">Greenland</option> <option value="gd">Grenada</option> <option value="gp">Guadeloupa</option> <option value="gu">Guam</option> <option value="gt">Guatemala</option> <option value="gn">Guinea</option> <option value="gw">Guinea-Bissau</option> <option value="gy">Guyana</option> <option value="ht">Haiti</option> <option value="hm">Heard and McDonald Islands</option> <option value="hn">Honduras</option> <option value="hk">Hong Kong</option> <option value="hu">Hungary</option> <option value="is">Iceland</option> <option value="in">India</option> <option value="id">Indonesia</option> <option value="int">International</option> <option value="ir">Iraq</option> <option value="iq">Iran</option> <option value="ie">Ireland</option> <option value="il">Israel</option> <option value="it">Italy</option> <option value="jm">Jamaica</option> <option value="jp">Japan</option> <option value="jo">Jordan</option> <option value="kz">Kazakhstan</option> <option value="ke">Kenya</option> <option value="ki">Kiribati</option> <option value="kp">Korea (North)</option> <option value="kr">Korea (South)</option> <option value="kw">Kuwait</option> <option value="kg">Kyrgyzstan</option> <option value="la">Laos</option> <option value="lv">Latvia</option> <option value="lb">Lebanon</option> <option value="ls">Lesotho</option> <option value="lr">Liberia</option> <option value="ly">Libya</option> <option value="li">Liechtenstein</option> <option value="lt">Lithuania</option> <option value="lu">Luxembourg</option> <option value="mo">Macau</option> <option value="mk">Macedonia</option> <option value="mg">Madagascar</option> <option value="mw">Malawi</option> <option value="my">Malaysia</option> <option value="mv">Maldives</option> <option value="ml">Mali</option> <option value="mt">Malta</option> <option value="mh">Marshall Islands</option> <option value="mq">Martinique</option> <option value="mr">Mauritania</option> <option value="mu">Mauritius</option> <option value="yt">Mayotte</option> <option value="mx">Mexico</option> <option value="fm">Micronesia</option> <option value="md">Moldova</option> <option value="mc">Monaco</option> <option value="mn">Mongolia</option> <option value="ms">Montserrat</option> <option value="ma">Morocco</option> <option value="mz">Mozambique</option> <option value="mm">Myanmar</option> <option value="na">Namibia</option> <option value="nr">Nauru</option> <option value="np">Nepal</option> <option value="nl">Netherlands</option> <option value="an">Netherlands Antilles</option> <option value="nc">New Caledonia</option> <option value="nz">New Zealand (Aotearoa)</option> <option value="ni">Nicaragua</option> <option value="ne">Nigee</option> <option value="ng">Nigeria</option> <option value="nu">Niue</option> <option value="nf">Norfolk Island</option> <option value="mp">Northern Mariana Islands</option> <option value="no">Norway</option> <option value="om">Oma</option> <option value="pk">Pakistan</option> <option value="pw">Palau</option> <option value="pa">Panama</option> <option value="pg">Papua New Guinea</option> <option value="py">Paraguay</option> <option value="pe">Peru</option> <option value="ph">Philippines</option> <option value="pn">Pitcairn</option> <option value="pl">Poland</option> <option value="pt">Portugal</option> <option value="pr">Puerto Ric</option> <option value="qa">Qatar</option> <option value="re">Reunion</option> <option value="ro">Romania</option> <option value="ru">Russia</option> <option value="rw">Rwanda</option> <option value="gs">S. Georgia and S. Sandwich Isls</option> <option value="kn">Saint Kitts and Nevis</option> <option value="lc">Saint Lucia</option> <option value="vc">Saint Vincent and the Grenadines</option> <option value="ws">Samoa</option> <option value="sm">San Marino</option> <option value="st">Sao Tome and Principe</option> <option value="sa">Saudi Arabia</option> <option value="sn">Senegal</option> <option value="rs">Serbia</option> <option value="sc">Seychelles</option> <option value="sl">Sierra Leone</option> <option value="sg">Singapore</option> <option value="sk">Slovak Republic</option> <option value="si">Slovenia</option> <option value="sb">Solomon Islands</option> <option value="so">Somalia</option> <option value="za">South Africa</option> <option value="es">Spain</option> <option value="lk">Sri Lanka</option> <option value="sh">St. Helena</option> <option value="pm">St. Pierre and Miquelon</option> <option value="sd">Sudan</option> <option value="sr">Suriname</option> <option value="sj">Svalbard and Jan Mayen Islands</option> <option value="sz">Swaziland</option> <option value="se">Sweden</option> <option value="ch">Switzerland</option> <option value="sy">Syria</option> <option value="tw">Taiwan</option> <option value="tj">Tajikistan</option> <option value="tz">Tanzania</option> <option value="th">Thailand</option> <option value="tg">Togo</option> <option value="tk">Tokelau</option> <option value="to">Tonga</option> <option value="tt">Trinidad and Tobago</option> <option value="tn">Tunisia</option> <option value="tr">Turkey</option> <option value="tm">Turkmenistan</option> <option value="tc">Turks and Caicos Islands</option> <option value="tv">Tuvalu</option> <option value="ug">Uganda</option> <option value="ua">Ukraine</option> <option value="ae">United Arab Emirates</option> <option value="gb">United Kingdom</option> <option value="us">United States</option> <option value="uy">Uruguay</option> <option value="um">US Minor Outlying Islands</option> <option value="su">USSR (former)</option> <option value="uz">Uzbekistan</option> <option value="vu">Vanuat</option> <option value="va">Vatican City State (Holy See)</option> <option value="ve">Venezuela</option> <option value="vn">Viet Nam</option> <option value="vg">Virgin Islands (British)</option> <option value="vi">Virgin Islands (U.S.)</option> <option value="wf">Wallis and Futuna Islands</option> <option value="eh">Western Sahara</option> <option value="ye">Yemem</option> <option value="zr">Zaier</option> <option value="zm">Zambia</option> <option value="zw">Zimbabwe</option> </select> <img id="flag" src="images/flags/none.png"/>

Ok, the addfriend page is finished i think.. but how i can make it so when the user that have been invited goes into his inbox and click the accept button it updates the db field and add id, username, person? anyone who could tech me how i can do it? thanks <?php session_start(); include "includes/db_connect.php"; include "includes/functions.php"; $username=$_SESSION['username']; $query=mysql_query("SELECT * FROM users WHERE username='$username'"); $fetch=mysql_fetch_object($query); $inviter = mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$username'")); // if (strip_tags($_POST['invite_button']) && strip_tags($_POST['invite_person'])){ if (isset($_POST['invite_button']) && isset($_POST['invite_person'])) { $invite_person=strip_tags($_POST['invite_person']); if (strtolower($invite_person) == strtolower($username)){ echo "You cannot invite yourself"; }elseif (strtolower($invite_person) != strtolower($username)){ $invite_title="You have a friend invitation"; $invite_text="<form name=invite_friend method=post action=?accept=friends&friends_id=$inviter->id> <div align=center>You have been invited to be $username s friend!<br> <input name='Decline' type='submit' id='Decline' value='Decline'> | <input name='Accept_friend' type='submit' id='Accept' value='Accept'> </div> </form>"; mysql_query("INSERT INTO `inbox` ( `id` , `to` , `title` , `from` , `message` , `date` , `read` ) VALUES ('', '$invite_person', '$invite_title', '$invite_person', '$invite_text', '$date', '0')") or trigger_error("Mysql Update Inbox Failed: " . mysql_error()); mysql_query("UPDATE friends SET person ='$invite_person' WHERE id='$inviter->id'") or trigger_error("Mysql Update Failed Friend: " . mysql_error()); echo "Invite has been sent to <a href='profile.php?viewuser=$invite_person'><b>$invite_person</b></a>"; } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>add friend</title> </head> <body> <div align="center"> <form name="form1" method="post" action=""> <input name="invite_person" type="text" id="invite_person" /> <input name="invite_button" type="submit" id="invite_button" value="Invite" /> </form> </div> </body> </html>

Parse error: syntax error, unexpected T_STRING, expecting ']' in /home7/greenbox/public_html/MafiaLegacy/addfriend.php on line 14 Thanks for your reply it was very helpfull but i got this error when i tried it out

when i push the invite button, nothing happends

Why dosent the keno show up at the page? i dont have any errors either :S Anyone who could have a check on the code and see whats missing og wrong? thanks <?PHP session_start(); include_once "includes/functions.php"; logincheck(); $username=$_SESSION['username']; include_once "includes/db_connect.php"; include_once"casinoCP.php"; $fetch= mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$username'")); $keno = mysql_fetch_object(mysql_query("SELECT * FROM properties WHERE location='$fetch->location' AND casino='Keno'")); $fetch_owner=mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$keno->owner'")); if (strtolower($keno->owner) == strtolower($fetch->username)){ casinoCP($input); exit(); } $query1=mysql_query("SELECT * FROM properties WHERE casino='Keno' AND location='$fetch->location' LIMIT 1"); $fetch1=mysql_fetch_object($query1);; $getname = $_GET['pickupkeno']; if ($getname == "yes" && $fetch1->owner == "0"){ mysql_query("UPDATE properties SET owner='$username' WHERE casino='Keno' AND location='$fetch->location'"); echo "<font color=orange><center><b>You are now the owner of $fetch->location Keno!</b></font>"; } if (strip_tags(!$_POST['play']) && $_POST['bet'] == ""){ $ticked="0"; }elseif (strip_tags($_POST['play']) && $_POST['bet'] != ""){ $bet=intval(strip_tags($_POST['bet'])); if ($bet > "99"){ if ($bet == 99 || !$bet || ereg('[^0-99]',$bet)){ print "<font color=orange><center><br><br><b>You cant bet that amount.</font></b>"; $ticked="99"; }elseif ($bet != 99 || $bet || !ereg('[^0-99]',$bet)){ if ($bet > $keno->max){ echo "<font color=orange><center><br><br><b>Your bet exceeds the max bet.</font></b>"; $ticked="0"; }elseif ($bet <= $leno->max){ if ($bet > $fetch->money){ echo "<font color=orange><center><br><br><b>You dont have that much money.</font></b>"; $ticked="0"; }elseif ($bet <= $fetch->money){ $keno_numbers = array ( "0" => "", "1" => "", "2" => "", "3" => "", "4" => "", "5" => "", "6" => "", "7" => "", "8" => "", "9" => "", "10" => "", "11" => "", "12" => "", "13" => "", "14" => "", "15" => "", "16" => "", "17" => "", "18" => "", "19" => "", "20" => ""); if ($_REQUEST[resetall] != "") { $player_numbers = array (); $action = ""; } else { $player_numbers = array ( "0" => "$n1", "1" => "$n2", "2" => "$n3", "3" => "$n4", "4" => "$n5", "5" => "$n6", "6" => "$n7", "7" => "$n8", "8" => "$n9", "9" => "$n10", "10" => "$n11", "11" => "$n12", "12" => "$n13", "13" => "$n14", "14" => "$n15", "15" => "$n16", "16" => "$n17", "17" => "$n18", "18" => "$n19", "19" => "$n20"); } if ($action == "play") { $i = 0; while ($i < 20) { $temp = rand(1,80); if (!in_array($temp,$keno_numbers)) { $keno_numbers[$i] = $temp; $i++; } } sort($keno_numbers); sort($player_numbers); } $i = 0; $points = 0; while ($i < 21) { if (in_array($keno_numbers[$i],$player_numbers)) $points++; $i++; } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Keno - Coolio</title> <style type="text/css"> .keno_blueline { background-color: #E3E4F7; } .keno_pickednumber { background-color: #F5F5C2; } .keno_winningandpickednumber { background-color: #C1F5C2; } .keno_winningnumber { background-color: #ECBCBC; } .keno_notpickednumber { } .keno_winningnumber, .keno_pickednumber, .keno_blueline, .keno_notpickednumber, .keno_winningandpickednumber { font-size: 12px; font-family: Verdana, Arial, Helvetica, sans-serif; color: #000000; } </style> <script type="text/javascript"> <!-- function selectkeno(v) { if (document.getElementById('picked' + v).value == 0) { if (document.kenoform.n20.value > 0) { document.getElementById('keno' + document.kenoform.n20.value).className = document.getElementById('oldclass' + document.kenoform.n20.value).value; document.getElementById('picked' + document.kenoform.n20.value).value = 0; } document.kenoform.n20.value = document.kenoform.n19.value document.kenoform.n19.value = document.kenoform.n18.value document.kenoform.n18.value = document.kenoform.n17.value document.kenoform.n17.value = document.kenoform.n16.value document.kenoform.n16.value = document.kenoform.n15.value document.kenoform.n15.value = document.kenoform.n14.value document.kenoform.n14.value = document.kenoform.n13.value document.kenoform.n13.value = document.kenoform.n12.value document.kenoform.n12.value = document.kenoform.n11.value document.kenoform.n11.value = document.kenoform.n10.value document.kenoform.n10.value = document.kenoform.n9.value document.kenoform.n9.value = document.kenoform.n8.value document.kenoform.n8.value = document.kenoform.n7.value document.kenoform.n7.value = document.kenoform.n6.value document.kenoform.n6.value = document.kenoform.n5.value document.kenoform.n5.value = document.kenoform.n4.value document.kenoform.n4.value = document.kenoform.n3.value document.kenoform.n3.value = document.kenoform.n2.value document.kenoform.n2.value = document.kenoform.n1.value document.kenoform.n1.value = v document.getElementById('keno' + v).className = 'keno_pickednumber'; document.getElementById('picked' + v).value = 1; } } //--> </script> </head> <body> <center> <? echo "<A NAME=keno></A><FORM METHOD=post ACTION=\"$PHP_SELF?page=keno&". time(). "#keno\" NAME=kenoform>\n"; echo "<P>Click on the numbers you would like to pick. You may only select 20 numbers.</P>\n"; echo "<TABLE BORDER=0 CELLPADDING=5 CELLSPACING=0>"; $n = 1; for ($i = 0; $i < 8; $i++) { if ($i % 2 == 1) echo "\n <TR CLASS=keno_blueline>"; else echo "\n <TR>"; for ($j = 0; $j < 10; $j++) { $picked = 0; if (in_array ($n, $player_numbers) && in_array($n, $keno_numbers)) { $picked = 1; $class = 'keno_winningandpickednumber'; $oldclass = 'keno_winningnumber'; } else if (in_array ($n, $player_numbers)) { $picked = 1; $class = 'keno_pickednumber'; $oldclass = 'keno_notpickednumber'; } else if (in_array($n, $keno_numbers)) { $class = 'keno_winningnumber'; $oldclass = 'keno_winningnumber'; } else { $class = 'keno_notpickednumber'; $oldclass = 'keno_notpickednumber'; } echo " <TD ALIGN=center CLASS=". $class ." ID=\"keno$n\" onClick=\"javascript:selectkeno($n);\"><INPUT TYPE=hidden NAME=pickednumber[$n] VALUE=\"$picked\" ID=picked$n><INPUT TYPE=hidden NAME=oldclass[$n] VALUE=\"$oldclass\" ID=oldclass$n> <B>$n</B> </TD>\n"; $n++; } echo " </TR>\n"; } echo " <TR><TD CLASS=keno_pickednumber> </TD><TD COLSPAN=9 CLASS=keno_notpickednumber>Number you picked</TD></TR>\n"; echo " <TR><TD CLASS=keno_winningnumber> </TD><TD COLSPAN=9 CLASS=keno_notpickednumber>Winning number you didn't have</TD></TR>\n"; echo " <TR><TD CLASS=keno_winningandpickednumber> </TD><TD COLSPAN=9 CLASS=keno_notpickednumber>Winning number you <B>did</B> pick!</TD></TR>\n"; echo "</TABLE>"; if ($action == "play") { $again = " again!"; echo "<B>The winning numbers are:</B><BR>"; $w = 0; while ($w < 21) { echo " $keno_numbers[$w]"; $w++; if ($w == 10) echo "<BR>"; } echo "<BR><B>and you selected:</B><BR>"; $w = 0; while ($w < 21) { echo " $player_numbers[$w]"; $w++; if ($w == 10) echo "<BR>"; } echo "<P><B>You have $points winning numbers!</B></P>"; } if ($points == 18) { $win = 6; }elseif ($points == 19) { $win = 8; }elseif ($points == 20){ $win = 10; } $new_money = $bet * $win; $n_money = $fetch->money + $new_money; $owner_money=$fetch_owner->money - $new_money; if ($owner_money <= "0"){ echo "<font color=orange><center><br><br><b>Congratulations! You bankrupted the Keno owner. Refresh the page and click the link to pick it up</font></b>"; mysql_query("UPDATE properties SET owner='0' WHERE casino='Keno' AND location='$fetch->location'"); }elseif($owner_money > "0"){ mysql_query("INSERT INTO `logs` ( `id` , `username` , `prop` , `location` , `winloss` , `amount`, `date`) VALUES ( '', '$username', 'Keno', '$fetch->location', 'win', '$new_money', '$date');") or die (mysql_error()); echo "<center><font color=orange><center>Congratulations! You've won $".makecomma($new_money)." from the bet</font></b>"; mysql_query("UPDATE users SET money='$n_money' WHERE username='$username'"); $ear = $keno->profit - $new_money; mysql_query("UPDATE properties SET profit='$ear' WHERE location='$fetch->location' AND casino='Keno' AND owner !='0'"); mysql_query("UPDATE users SET money='$owner_money' WHERE username='$Keno->owner'"); } }else{ $new_money2 = $fetch_owner->money + $bet; $ear2 = $keno->profit + $bet; $loose_money=$fetch->money-$bet; mysql_query("INSERT INTO `logs` ( `id` , `username` , `prop` , `location` , `winloss` , `amount`, `date`) VALUES ( '', '$username', 'Keno', '$fetch->location', 'loss' , '$bet', '$date');") or die (mysql_error()); mysql_query("UPDATE properties SET profit='$ear2' WHERE location='$fetch->location' AND casino='Keno' AND owner !='0'"); mysql_query("UPDATE users SET money='$new_money2' WHERE username='$keno-s>owner'"); mysql_query("UPDATE users SET money='$loose_money' WHERE username='$username'"); echo "<center><font color=orange><center><b>You have lost $".makecomma($bet)."</b></font></center>"; }} echo "<INPUT TYPE=hidden NAME=action VALUE=\"play\"> "; echo "<INPUT TYPE=hidden SIZE=2 MAXLENGTH=2 NAME=n1 VALUE=\"". ($player_numbers[0] * 1) ."\"> "; echo "<INPUT TYPE=hidden SIZE=2 MAXLENGTH=2 NAME=n2 VALUE=\"". ($player_numbers[1] * 1) ."\"> "; echo "<INPUT TYPE=hidden SIZE=2 MAXLENGTH=2 NAME=n3 VALUE=\"". ($player_numbers[2] * 1) ."\"> "; echo "<INPUT TYPE=hidden SIZE=2 MAXLENGTH=2 NAME=n4 VALUE=\"". ($player_numbers[3] * 1) ."\"> "; echo "<INPUT TYPE=hidden SIZE=2 MAXLENGTH=2 NAME=n5 VALUE=\"". ($player_numbers[4] * 1) ."\"> "; echo "<INPUT TYPE=hidden SIZE=2 MAXLENGTH=2 NAME=n6 VALUE=\"". ($player_numbers[5] * 1) ."\"> "; echo "<INPUT TYPE=hidden SIZE=2 MAXLENGTH=2 NAME=n7 VALUE=\"". ($player_numbers[6] * 1) ."\"> "; echo "<INPUT TYPE=hidden SIZE=2 MAXLENGTH=2 NAME=n8 VALUE=\"". ($player_numbers[7] * 1) ."\"> "; echo "<INPUT TYPE=hidden SIZE=2 MAXLENGTH=2 NAME=n9 VALUE=\"". ($player_numbers[8] * 1) ."\"> "; echo "<INPUT TYPE=hidden SIZE=2 MAXLENGTH=2 NAME=n10 VALUE=\"". ($player_numbers[9] * 1) ."\"><BR>"; echo "<INPUT TYPE=hidden SIZE=2 MAXLENGTH=2 NAME=n11 VALUE=\"". ($player_numbers[10] * 1) ."\"> "; echo "<INPUT TYPE=hidden SIZE=2 MAXLENGTH=2 NAME=n12 VALUE=\"". ($player_numbers[11] * 1) ."\"> "; echo "<INPUT TYPE=hidden SIZE=2 MAXLENGTH=2 NAME=n13 VALUE=\"". ($player_numbers[12] * 1) ."\"> "; echo "<INPUT TYPE=hidden SIZE=2 MAXLENGTH=2 NAME=n14 VALUE=\"". ($player_numbers[13] * 1) ."\"> "; echo "<INPUT TYPE=hidden SIZE=2 MAXLENGTH=2 NAME=n15 VALUE=\"". ($player_numbers[14] * 1) ."\"> "; echo "<INPUT TYPE=hidden SIZE=2 MAXLENGTH=2 NAME=n16 VALUE=\"". ($player_numbers[15] * 1) ."\"> "; echo "<INPUT TYPE=hidden SIZE=2 MAXLENGTH=2 NAME=n17 VALUE=\"". ($player_numbers[16] * 1) ."\"> "; echo "<INPUT TYPE=hidden text SIZE=2 MAXLENGTH=2 NAME=n18 VALUE=\"". ($player_numbers[17] * 1) ."\"> "; echo "<INPUT TYPE=hidden SIZE=2 MAXLENGTH=2 NAME=n19 VALUE=\"". ($player_numbers[18] * 1) ."\"> "; echo "<INPUT TYPE=hidden SIZE=2 MAXLENGTH=2 NAME=n20 VALUE=\"". ($player_numbers[19] * 1) ."\"><BR>"; echo "<input name='bet' type='text' value=\"$_POST[bet]\"><br>"; echo "<INPUT TYPE=submit NAME=play VALUE=\"Play KENO$again\"> <INPUT TYPE=submit NAME=resetall VALUE=\"Re-start\"></FORM>"; echo "<br>"; if($fetch1->owner == "0"){ die("<center><u><a href='keno.php?pickupkeno=yes'><font color=red><b>Click here to pick up $fetch->location keno!</u></font></b></b></p></a>"); } if($fetch1->owner == "0"){ die(""); }}}} ?> </center> </body> </html>

Hi, im trying to make a code where you can send a friend invite to other members and be stored in a page called friends.php, i'm not the best coder but i think im getting alittle hang on it of anyone could help me out alittle then it would been great just ask if you need any information about the db, Thanks in advance <?php session_start(); include "includes/db_connect.php"; include "includes/functions.php"; $username=$_SESSION['username']; $query=mysql_query("SELECT * FROM users WHERE username='$username'"); $fetch=mysql_fetch_object($query); $inviter = mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$username'")); if (strip_tags($_POST['invite_button']) && strip_tags($_POST['invite_person'])){ $invite_person=strip_tags($_POST['invite_person']); if (strtolower($invite_person) == strtolower($username)){ echo "You cannot invite yourself"; }elseif (strtolower($invite_person) != strtolower($username)){ $invite_text="<form name=invite_friend method=post action=?accept=friends&id=$inviter->id> <div align=center>You have been invited to be $username s friend!<br> <input name=Decline type=submit id=Decline value=Decline> | <input name=Accept type=submit id=Accept value=Accept> </div> </form>"; mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` ) VALUES ( '', '$invite_person', '$invite_person', '$invite_text', '$date', '0' )"); mysql_query("UPDATE friend SET person ='$invite_person' WHERE id='$inviter->id'"); echo "Invite has been sent to <a href='profile.php?viewuser=$invite_person'><b>$invite_person</b></a>"; }} ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> <div align="center"> <input name="invite_person" type="text" id="invite_person" /> <input name="invite_button" type="submit" id="invite_button" value="Invite" /> </div> </body> </html>