I don't know what to put after "SET" to indicate all columns.
What you see after "SET <<<<<HERE>>> = " is the replacement info coming from a form.
Code: Select all
mysql_connect("localhost","$username","$password");
@mysql_select_db($database) or die( "Unable to select database");
("update name_list set name='$name' where id='$row[id]'");
$query = "UPDATE wanted SET <<<<<HERE>>> = ('$name','$last','$middle','$dob','$alialses','$race','$age','$sex','$height'
,'$weight','$marks','$street','$city','$state','$zip','$make','$model','$summary','$hair','$eyes','$piclink') WHERE id=1";
mysql_query($query);