Smudly 0 Light Poster

Hello, I've got a page that I've created that allows me to change multiple values in a row in my database. These values are all stored in a single row. I have input boxes for every one of the columns in my row. If a box is filled in, that value will be updated for that column in the row. This sounds like all I have to do is an Update query for the row, but it's becoming more complicated. Take a look:

<?php

include_once('../inc/admin.php');
include_once('../inc/connect.php');

$varsquery = mysql_query("SELECT * FROM vars WHERE id='2'");
$row = mysql_fetch_array($varsquery);

$varsquery1 = mysql_query("SELECT * FROM vars WHERE id='1'");
$row1 = mysql_fetch_array($varsquery1);

$edit = $_GET['edit'];
$newvalue = "";

echo "
<html>
<head>
<title>Variables</title>
<style>
a:link{
text-decoration: none;
color: #519904;
}
a:visited{
text-decoration: none;
color: #519904;
}
a:hover{
text-decoration: none;
color: #4296ce;
}
#border{
	border-right-style: solid;
	border-bottom-style: solid;
	border-width: 1px;
}
</style>
</head>
<body>
";

echo "<div style='font-size: 28px; text-align: center;'>Variables</div><br />
<table align='center'>
<tr>
<th bgcolor='#cccccc'><a href='changevars.php?sort=number'>#</a></th>
<th bgcolor='#cccccc'><a href='changevars.php?sort=variable'>Variable</a></th>
<th bgcolor='#cccccc'><a href='changevars.php?sort=value'>Value</a></th>
<th bgcolor='#cccccc'><a href='changevars.php?sort=rate'>Rate</a></th>
<th bgcolor='#cccccc'><a href='changevars.php'>Change</a></th>
<th bgcolor='#cccccc'><a href='changevars.php?sort=default'>Default</a></th>
</tr><form action='changevars.php' method='POST'>";

$i = 1;
$color = 0;
while ($i < mysql_num_fields($varsquery)) {
    $meta = mysql_fetch_field($varsquery, $i);
    if (!$meta) {
        echo "No information available<br />\n";
    }
	
	if ($color % 2){
	$bgcolor = "#cccccc";
	}
	else{
		$bgcolor = "#ffffff";
	}
	
		echo "<tr bgcolor='$bgcolor'><td align='center' width='20' bgcolor='#eeeeee' id='border'>$i</td>";
		echo "<td align='center' width='200' id='border'>$meta->name</td>";
		echo "<td align='center' width='200' id='border'>" .$row[$i]. "</td>";
		echo "<td align='center' width='100' id='border'>0</td>";
		echo "<td align='center' width='200' id='border'><input type='text' name='$meta->name'></td>";
		echo "<td align='center' width='200' id='border' bgcolor='#77ff77'>" .$row1[$i]. "</td>";
		echo "</tr>";
		$newvalue .= $_GET[$meta->name];
    $i++;
	$color++;
}
echo "<tr><td colspan='6' align='center'><input type='submit' name='edit' value='Edit'>&nbsp;<input type='reset' name='reset' value='Reset'></td></tr></form>"; 
echo "</table>";

if ($edit){

// Update new value
$sql = mysql_query("UPDATE vars SET `credits500`='$newvalue[0]' WHERE id='2'");

}

// Footer
echo "
</body>
</html>
";

?>
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.