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>
PHP and XML image gallery variable issue
I'm trying to display the large image on the same page as the thumbnails, to do that I'm passing a variable called $current. I know that the code to display large image works, because it works when no
Searching keywords from array
Hello everyone, Im just wondering if someone could help me with another issue im having. Im still learning PHP and I have been for a few months now, but every now and then I get stuck on small things.
Price in PR
Dear Experts,
Unable to retreve the values from Mysql Query
Hi, Here is the php code that I have, Query is running properly in phpmyadmin and is resulting 5 which is correct but when i try to get tht in php its not printing the value $sql_query=
Need help with a mail notify function
I was tasked with setting up a site that's been prewritten. The site is basically a form that captures user's info on the frontpage. All the code is there except the ability to notify the admin upon
Certain files upload, while others do not
I want to read the data from an uploaded file. Not sure why, but it only uploads for certain files. Not sure if it has to do with the size or what. Even when I comment all of the if and else
WS-Security PL/SQL Forms
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
Thought I has this figured out especially after all the help i received?
Cags, Salathe, Daniel helped me with this yesterday, but not sure i took it all in.I am attempting to open the URL and grab all the links within using preg_match_allThe problem is Parse error: syntax
Comparing two dates
Hi GuysI have two dates I want to compare. Below is my current implementation. The problem with it is it always returns false:if(date("d/m/y", $course->finish_date) >
How can you detect variable string in a massive string?
Ok guys, i need some help with this one.I am going to be getting a large string, like 10-20 paragraphs. I will also have an array or words that i would like to search it for.