php databse entry

i am currently working on a series of scripts and my current one i have it so that through entering information onto a form it will then enter that info into a mwsql databse. my problem is that instead of entering what a variable equals into the databse it is entering the variable itself. for example, instead of $url putting [whatever.com...] into the databse it is putting just "$url" without trading it out for what the variable equals. that is probably a little confusing but here is the script which will hopefully make more sense.


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head><?php
include('db.php'); //file containing user and pass
?>
<?
if (isset($_POST['submit']))
{
mysql_select_db("tehhaxtest",$db); 
$sql = 'UPDATE `links` SET `url` = \'$urlc\',`target` = \'$target\',`description` = \'$desc\',`cssclass` = \'$cssc\' WHERE `id` = \'$idc\' LIMIT 1 ;'; 
// the problem is in the previous statement, it is entering the unparsed variable $urlc into the database rather than what the user enters in the form for $urlc, all the other variables do the same $result = mysql_query($sql);
 echo "Thank you! Information updated. <a href=\"change.php\">other</a>";
}
else
{
?>

[edited by: jatar_k at 12:54 am (utc) on Sep. 10, 2003]
[edit reason] snipped extra code [/edit]

php databse entry

tunnelduck

jatar_k

tunnelduck

vincevincevince

jatar_k

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week