$_POST variable un-useable


Posted on 16th Feb 2014 07:03 pm by admin

I'm trying to use a $_POST variable in a mysql update statement but i can't use it for some unknown reason i can echo the variable and it outputs the correct value but i cannot use that variable in anyway in the mysql update statement here is the whole page.Thankyou for your time.

Code: <?php session_start(); ?>
<!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" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Model login</title>
<META name="keywords" content="webcam, webcams, cam, cams, live, girls, free, video, women,
lesbians, porn, porno, teen, teens, men, guys, nude, private, pussy, sexy, webcam, camgirls,
home cams, video chat, free video, teen, sex, xxx, adult, age ,naked">
<META name="robots" content="index,follow">
<META name="revisit-after" content="10">
<META name="robots" content="all">
<meta name="author" content="root">
<META name="page-topic" content="live sexy web cams and chat">
<META name="copyright" content="privatechatnow.com,2009">
<META name="distribution" content="global">
<META name="ABSTRACT" CONTENT="Privatechatnow.com - Live video cam and chat">
<META name="rating" content="Mature">

<?php
include("../secure_php/admin_database.php");


//exchange 3 with 1
//$oldnum =3;
//$newnum =1;

if(isset($_POST['exchange'])){
$oldnum =$_POST['oldnum'];
$newnum =$_POST['newnum'];


$current1 = Array();
$currsel1 = mysql_query("select id from page0.page0 where refnum ='$oldnum' AND username!='admin'")
or die(mysql_error());
while($currrow1 = mysql_fetch_array($currsel1)){
array_push($current1,$currrow1['id']);
}
print_r($current1);



$test = $current1[0];

$upref11= mysql_query("update page0.page0 SET refnum='$oldnum' where id='$test'")
or die(mysql_error());
}



?>
</head>
<body >


<form action="" method="POST">
<table align="left" border="0" cellspacing="0" cellpadding="3">
<?php
$_SESSION['refnum0'] = $_POST['oldnum'];


$_SESSION['refnum1'] = $_POST['newnum'];

?>
<tr><td>Old RefNum:</td><td><input type="text" name="oldnum" maxlength="4" width= "30"value ="<?php if(isset ($_SESSION['refnum0'])){echo $_SESSION['refnum0'];}?>"> </td></tr>
<tr><td>New RefNum:</td><td><input type="text" name="newnum" maxlength="4"value ="<?php if(isset ($_SESSION['refnum1'])){ echo $_SESSION['refnum1'];}?>"></td></tr>
<tr><td colspan="2" align="right"><input type="submit" name="exchange" value="Change"></td></tr>
</table>
</form>
</body>
</html>





























No comments posted yet

Your Answer:

Login to answer
122 Like 36 Dislike
Previous forums Next forums
Other forums

an interesting question
Greetings folks, got to ask an interesting question...

let say
i have created a function s

foreach loop, assistance request
I would like some guidance on the usage of foreach as I try to parse through a large database and wh

How would I protect......
I have a from, actually, a good amount of forms. How can I make it so you can't type the characters:

do while conditions
i want to display 6 images in a 2x3 table
now what would be the correct logic to
count that th

php libs/ browsercap.in
ok i have a host that refuses to stay current. they control my php settings and libs. is there a way

how to get IP address?
hey guys,

i have this code which is supposed to get me the IP address of my site visitors:

Undefined index on my form
ok im getting Undefined index on this line.. print_r($_REQUEST['form']);

below is the full sc

Big O & time complexity ???
can you help me how to calculate the Big O & time complexity for any algorithm and c++ program pleas

PHP Cannot redeclare class
I have 6 files, and two of them do not seem to want to play well. I keep getting a "Cannot rede

Putting double spaces instead of single spaces
Im looking at trying to replace all single spacing between fields with double spacing

At pres

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash