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>
Beginner question regarding Array's
Hi everyone, the page im working on has an array of variable at the top...Code: $define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL, 'PRODUCT_LIST_NAME'
Include ("Absolute Path") of a file?
I'm not sure what I'm doing wrong. I am writing my php code in the same directory of the file that I wish to include is in. So, here's what I have written:Code: include ('file.php');This works
form class help (oop php5)
Hidy Ho Neighbors,I'm forcing myself to learn oop/classes for php5. It seems like a good idea for repetitious coding such as with forms. I've been through the oop tutorials here and elswhere in
Call to undefined function mysql_fetch_accoc()
New to php/mysql coding. What's wrong with this sequence, or am I just not seeing to obvious?Getting, "Call to undefined function mysql_fetch_accoc()" at line n, whereline n is referring to
defining website tags
Hi,What would be the best way to define tags for my site, such as website title, url etc.Should I just use somethng like:$website_name = "name";or should I use arrays?Thanks
Extract text from string
Hi folks,I have a string that looks like this:aaaaaaaaaa: bbbbbbbbbb (ccccccccc) dddddddddddddddddddddeeeeeeeeeeeeeeeeeeeee(format can't be changed - lengths of strings will vary) and I need to
Unidentified index error in a simple form
I have been trying to make an HTML form that is handled by a PHP script. So far my attempts to get it to work have proven fruitless.I'm referencing the Visual Quickstart Guide for PHP to learn PHP,
Calling variables
I want to call this to my website but it doesn't display what I want it to,Code: <h5>Edit Subject: <?php echo $sel_subject['menu_name']; ?></h5>If I change
Code clarification
Hi In the following code what could be the "search_print()" and where it could be placed.Couldn't find within the page or included pagesCode: [Select]<td align="right"
Suggestions for Functional module
Hello experts,
