multiple db table entry overwrite

seanisean

just looking for some help with some syntax, i've been trying to make a webpage interface for my database and i have been using forms to process upload and display etc....

i'm currently stuck trying to overwrite an entry with this code:

<?php
$res= mysql_query("UPDATE test SET (file_name, file_id, name, common, family, alphabetical, description, height, width, base, habit, flow,  submitter) VALUES ('$file_name', '$file_id', '$name', '$common', '$family', '$alphabetical', '$description', '$height', '$width', '$base', '$habit', '$flow',  '$submitter') WHERE file_id = '$file_id'")or die (mysql_error());
?>

ok heres an update which clicks through ok and returns no errors but does not update any of the fields when submitted:

<?php
$res= mysql_query("UPDATE test SET file_name='$file_name', file_id='$file_id', name='$name', common='$common', family='$family', alphabetical='$alphabetical', description='$description', height='$height', width='$width', base='$base', habit='$habit', flow='$flow', submitter='$submitter' WHERE file_id='$file_id'")or die (mysql_error());
?>

is this enough info?

regards sean

NogDog

With MySQL you'll need to use the syntax in the second example. As to why it doesn't update anything, I don't think we have enough info. First thing to do is verify that the variables involved have the values you think they should, especially the one used in the where clause. You might want to try something like this to get some more debug data:

$sql = "UPDATE test SET file_name='$file_name', file_id='$file_id', 
name='$name', common='$common', family='$family', alphabetical='$alphabetical',
description='$description', height='$height', width='$width', base='$base', 
habit='$habit', flow='$flow', submitter='$submitter' WHERE file_id='$file_id'";
$res= mysql_query($sql) or die (mysql_error());
if(!mysql_affected_rows())
{
  die("No rows updated<br>$sql");
}

Later you might want to change the die() to user_error() or error_log() once you get things straightened out.

seanisean

hi thanks for your response

here is more of the code:

include('passwords.inc');
	if (! @mysql_select_db('mydb'))
	{
		die( '<p>Unable to locate the ' . 'database at this time.</p>' );
	}

// Get data from form elements 
$file_name= $_POST['file_name'];
$file_id= $_POST['file_id'];
$name= $_POST['name'];
$common= $_POST['common'];
$family= $_POST['family'];
$alphabetical= $_POST['alphabetical'];
$description= $_POST['description'];
$height= $_POST['height'];
$width= $_POST['width'];
$base= $_POST['base'];
$habit= $_POST['habit'];
$flow= $_POST['flow'];
$submitter= $_POST['submitter'];

// Insert plant info into the db 
$sql= "UPDATE test SET file_name='$file_name', file_id='$file_id', name='$name', common='$common', family='$family', alphabetical='$alphabetical', description='$description', height='$height', width='$width', base='$base', habit='$habit', flow='$flow', submitter='$submitter' WHERE file_id='$file_id'";
$res= mysql_query($sql) or die (mysql_error()); 
if(!mysql_affected_rows()) 
{ 
                            echo("$file_id");
	die("No rows updated<br>$sql"); 
} 

include("submitted.php");

EDIT: I have noticed that on echo $file_id seems to contain nothing, file_id is also the query string used to produce this page with the desired db entry so i seem to be losing its value somewhere here? Using error output it tells me that No Rows Were Updated and shows all the values passed except for file_id which is shown as ''

EDIT: I think i should also point out that file_id represents an integer value and is also a primary key, all the rest are string or text values, so am i storing or passing the $file_id=$_POST['file_id']; in the wrong manner?

sean