bob2006

the 1 come form a checkbox when i uncheck it the databases has noting in it

now i am trying to get this to work it should change the variable if the statement is ture and it not in that and any one help include'db.php'; $sql2=mysql_query("SELECT * FROM site_config WHERE id=1")or die(mysql_error()); while($row2=mysql_fetch_array($sql2)) { $paypal_email=$row2['paypal_email']; $price=$row2['price']; $sandbox=$row2['sandbox']; $account_number=$row2['account_number']; $quantity_1=$row2['quantity_1']; $product=$row2['product']; $return_url=$row2['return_url']; $demo=$row2['demo']; if($sandbox==1) { $link='http://www.sambob.info'; if(empty($sandbox)) { $link='http://www.bob.tdsnet.org'; } echo"$link<br>$sandbox"; } }

thanks for the help and you are right i had a typo thanks for all the help

Can some one look at this code for me i dont see the problem but there is some thing wrong thank you 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 '','34448','US','3525887894')' at line 1 <?php include'db.php'; if (isset($_POST[submit])) { $frist=$_POST['firstname']; $lastname=$_POST['lastname']; $mail=$_POST['email']; $add1=$_POST['address1']; $add2=$_POST['address2']; $city=$_POST['city']; $state=$_POST['state']; $post=$_POST['postcode']; $country=$_POST['country']; $number=$_POST['phonenumber']; echo"$frist<br>$last<br>$mail<br>$add1<br>$add2<br>$city<br>$state<br>$post<br>$country<br>$number"; mysql_query("INSERT INTO user (id,username,email,last,address1,address2,City,State,Postcode,Country,Phone) VALUES (NULL,'$frist','$mail','$lastname','$add1','$add2','$city',$state','$post','$country','$number')")or die(mysql_error()); } else { echo"<form action='' method='post'> <table width='100%' border='0' cellpadding='0' cellspacing='0'> <tbody> <tr> <td width='50%' height='312' valign='top'><table width='100%' border='0' cellpadding='10' cellspacing='0'> <tbody> <tr> <td width='100'>First Name</td> <td><input type='text' name='firstname' value='' /></td> </tr> <tr> <td>Last Name</td> <td><input type='text' name='lastname' value='' /></td> </tr> <tr> <td>Email Address</td> <td><input type='text' name='email' value='' /></td> </tr> <tr> <td></td> <td></td> </tr> <tr> <td></td> <td></td> </tr> <tr> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> </tr> </tbody> </table></td> <td width='50%' valign='top'><table width='100%' border='0' cellpadding='10' cellspacing='0'> <tbody> <tr> <td width='100'>Address 1</td> <td><input type='text' name='address1' value='' /></td> </tr> <tr> <td>Address 2</td> <td><input type='text' name='address2' value='' /></td> </tr> <tr> <td>City</td> <td><input type='text' name='city' value='' /></td> </tr> <tr> <td>State/Region</td> <td><input type='text' name='state' value='' /></td> </tr> <tr> <td>Zip Code</td> <td><input type='text' name='postcode' size='15' value='' /></td> </tr> <tr> <td>Country</td> <td><select name='country'> <option value='AF'>Afghanistan</option> <option value='AX'>Aland Islands</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='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='CD'>Congo, Democratic Republic</option> <option value='CK'>Cook Islands</option> <option value='CR'>Costa Rica</option> <option value='CI'>Cote D'Ivoire</option> <option value='HR'>Croatia</option> <option value='CU'>Cuba</option> <option value='CY'>Cyprus</option> <option value='CZ'>Czech Republic</option> <option value='DK'>Denmark</option> <option value='DJ'>Djibouti</option> <option value='DM'>Dominica</option> <option value='DO'>Dominican Republic</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='FK'>Falkland Islands (Malvinas)</option> <option value='FO'>Faroe Islands</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='GR'>Greece</option> <option value='GL'>Greenland</option> <option value='GD'>Grenada</option> <option value='GP'>Guadeloupe</option> <option value='GU'>Guam</option> <option value='GT'>Guatemala</option> <option value='GG'>Guernsey</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 Island & Mcdonald Islands</option> <option value='VA'>Holy See (Vatican City State)</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='IR'>Iran, Islamic Republic Of</option> <option value='IQ'>Iraq</option> <option value='IE'>Ireland</option> <option value='IM'>Isle Of Man</option> <option value='IL'>Israel</option> <option value='IT'>Italy</option> <option value='JM'>Jamaica</option> <option value='JP'>Japan</option> <option value='JE'>Jersey</option> <option value='JO'>Jordan</option> <option value='KZ'>Kazakhstan</option> <option value='KE'>Kenya</option> <option value='KI'>Kiribati</option> <option value='KR'>Korea</option> <option value='KW'>Kuwait</option> <option value='KG'>Kyrgyzstan</option> <option value='LA'>Lao People's Democratic Republic</option> <option value='LV'>Latvia</option> <option value='LB'>Lebanon</option> <option value='LS'>Lesotho</option> <option value='LR'>Liberia</option> <option value='LY'>Libyan Arab Jamahiriya</option> <option value='LI'>Liechtenstein</option> <option value='LT'>Lithuania</option> <option value='LU'>Luxembourg</option> <option value='MO'>Macao</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, Federated States Of</option> <option value='MD'>Moldova</option> <option value='MC'>Monaco</option> <option value='MN'>Mongolia</option> <option value='ME'>Montenegro</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</option> <option value='NI'>Nicaragua</option> <option value='NE'>Niger</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'>Oman</option> <option value='PK'>Pakistan</option> <option value='PW'>Palau</option> <option value='PS'>Palestinian Territory, Occupied</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 Rico</option> <option value='QA'>Qatar</option> <option value='RE'>Reunion</option> <option value='RO'>Romania</option> <option value='RU'>Russian Federation</option> <option value='RW'>Rwanda</option> <option value='BL'>Saint Barthelemy</option> <option value='SH'>Saint Helena</option> <option value='KN'>Saint Kitts And Nevis</option> <option value='LC'>Saint Lucia</option> <option value='MF'>Saint Martin</option> <option value='PM'>Saint Pierre And Miquelon</option> <option value='VC'>Saint Vincent And 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'>Slovakia</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='GS'>South Georgia And Sandwich Isl.</option> <option value='ES'>Spain</option> <option value='LK'>Sri Lanka</option> <option value='SD'>Sudan</option> <option value='SR'>Suriname</option> <option value='SJ'>Svalbard And Jan Mayen</option> <option value='SZ'>Swaziland</option> <option value='SE'>Sweden</option> <option value='CH'>Switzerland</option> <option value='SY'>Syrian Arab Republic</option> <option value='TW'>Taiwan</option> <option value='TJ'>Tajikistan</option> <option value='TZ'>Tanzania</option> <option value='TH'>Thailand</option> <option value='TL'>Timor-Leste</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' selected='selected'>United States</option> <option value='UM'>United States Outlying Islands</option> <option value='UY'>Uruguay</option> <option value='UZ'>Uzbekistan</option> <option value='VU'>Vanuatu</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</option> <option value='EH'>Western Sahara</option> <option value='YE'>Yemen</option> <option value='ZM'>Zambia</option> <option value='ZW'>Zimbabwe</option> </select></td> </tr> <tr> <td>Phone Number</td> <td><input type='text' name='phonenumber' size='20' value='' /></td> </tr> </tbody> </table></td> </tr> </tbody> </table> <center><input type='submit' name='submit' id='submit' value='Submit' /></center> </form>"; } ?>

Thanks

i am pulling the login date from the databases and i want it to check if the variable is empty and if it is echo Never Loged In and if it not empty echo the date <?php include'db.php'; $id=$_GET['id']; $sql=mysql_query("SELECT * FROM admin WHERE id='$id'")or die(mysql_error()); while($row=mysql_fetch_array($sql)) { $date=$row['login_date']; if($date > 0) { echo"Never Loged In"; } else { echo"$date"; } } ?>

my bad please forgive

// and finally forward user to members page (populating the session id in the URL): header("Location: main.php"); there is the url i was talking about and for $massage if( !($row = checkPass($_POST["rsUser"], $_POST["rsPass"])) ) { // login/passwd string not correct, create an error message: $messages[]="Incorrect login/password, try again"; } i am not postive that is the $massages though just my guess

does this work for you <?php echo("<h3> Symmetric Encryption </h3>"); $key_value = "KEYVALUE"; $plain_text = "PLAINTEXT"; $encrypted_text = mcrypt_ecb(MCRYPT_DES, $key_value, $plain_text, MCRYPT_ENCRYPT); echo ("<p><b> Text after encryption : </b>"); echo ( $encrypted_text ); $decrypted_text = mcrypt_ecb(MCRYPT_DES, $key_value, $encrypted_text, MCRYPT_DECRYPT); echo ("<p><b> Text after decryption : </b>"); echo ( $decrypted_text ); ?>

i fixed my post i know it was all messed up i have not slept yet today :/

header("Location: main.php?".session_name()."=".session_id()); i really need to get some sleep your session is not passing though the url this code should pass the session through the url

i figure it out i had an if statement messed up above this code all better now thanks

that what i allways use works fine for me

i was messing around the code does not work it was set to if($pass1 != $pass2) i forgot to change it back before i posted my code sorry

One Problem i see is that you query has no WHERE in it mysql_query("UPDATE users SET statusB='25A' WHERE user_id='some number'")or die(mysql_error()); i with out seeing the whole code there not much else i can tell you