Please Help

[christalix]

I have this select form which collects every thing from my database.
This is for user to change a templATE:
I am having problem with the updating.

Could someone help me to work on the updat so that when a client chooses another template, it will be updated?

i am new in PHP. Where should the update set start and is it right to do it
UPDATE * SET templates WHERE type ='single' ORDER BY description";
Thanks

echo "<table border ='0' width='650' id='table' align='center' cellpadding='1' cellspacing='1' >\n"
				."<tr>\n"
				."<td width='80%'align='center' colspan='3'>"._T_EDIT."</td>\n"
				."</tr>\n";

	$query2 = "SELECT tid FROM navi WHERE nid = $nid";
	$result2 = my_sql_query($query2, "");
	$actualSelected = $result2[1][0]['tid'];

	$query5 = "SELECT * FROM templates WHERE type ='single' ORDER BY description";
	$result5 = my_sql_query($query5, "tid");
	echo "<tr>\n";
	echo "<td width='80%'align='center' colspan='3'><br />";
	echo "<select>";
	if( is_array($result5[1]) ) {
		foreach($result5[1] as $key => $value ) {
			echo "<option value='".$value['tid']."'";
			if( $actualSelected == $value['tid'] ) {
				echo ' selected="selected"';
			}
			echo ">".$value['description']."</option>";
		}
	}
	echo "</select></td></tr>";
	echo "<tr>\n"
		."<td width='100%' colspan='3'></td>\n"
		."</tr>\n"
		."<tr>\n";
	echo "<td width='80%' align='center' colspan='3'><br /><input type='submit' name='new' value='"._CHANGE."' id='button'>&nbsp;&nbsp;";
	echo "<input type='submit' name='reset2' value='"._RESET."' id='button' ></td>\n";
	echo "<br /></tr>\n";
	echo "</table><br />\n"

where should the u

[djjjozsi]

the

echo "<select>";

should have name teg.
Once the user selects a template, check the selected value on the page (where the action goes).
Lets add form teg and POST method for it first.

And an UPDATE structure looks like:

$sql="update MYTABLE set field='$value1', field2='$value2' WHERE PrimarykeyName=234";

Where $value1 and $value2 are the new values.

[christalix]

So will be like this

echo "<table border ='0' width='650' id='table' align='center' cellpadding='1' cellspacing='1' >\n"
				."<tr>\n"
				."<td width='80%'align='center' colspan='3'>"._T_EDIT."</td>\n"
				."</tr>\n";

	$query2 = "SELECT tid FROM navi WHERE nid = $nid";
	$result2 = my_sql_query($query2, "");
	$actualSelected = $result2[1][0]['tid'];

	$query5 = "SELECT * FROM templates WHERE type ='single' ORDER BY description";
	$result5 = my_sql_query($query5, "tid");
	echo "<tr>\n";
	echo "<td width='80%'align='center' colspan='3'><br />";
	echo "<select>";
	if( is_array($result5[1]) ) {
		foreach($result5[1] as $key => $value ) {
			echo "<option value='".$value['tid']."'";
			if( $actualSelected == $value['tid'] ) {
				echo ' selected="selected"';
			}
			echo ">".$value['description']."</option>";
		}
	}
	echo "</select>";


[COLOR="Red"][QUOTE]   $sql="update navi SET nid='$nid' AND tid='$tid' WHERE parent !=something";                       

[/QUOTE][/COLOR]


 echo</td></tr>";
		echo "<tr>\n"
			."<td width='100%' colspan='3'></td>\n"
			."</tr>\n"
			."<tr>\n";
		echo "<td width='80%' align='center' colspan='3'><br /><input type='submit' name='new' value='"._CHANGE."' id='button'>&nbsp;&nbsp;";
		echo "<input type='submit' name='reset2' value='"._RESET."' id='button' ></td>\n";
		echo "<br /></tr>\n";
		echo "</table><br />\n"

where should the u[/QUOTE]

[djjjozsi]

Make MYSQL & PHP backup before you use it, who knows.

Read the comments:

<form method="post" action="">

<?php

/* Check the field names,
if new button has pressed and template has selected AND navi ID has value too
*/
if ( isset( $_POST["new"] ) AND isset( $_POST["nid_update"] ) AND isset( $_POST["template"] ) ) {
    $sql_update = sprintf( "UPDATE navi SET TEMPLATEFIELD = %d WHERE nid = %d" , $_POST["template"] , $_POST["nid_update"] ) ;
    mysql_query( $sql_update ) OR DIE( mysql_error() . " in query: " . $sql_update );
} 

?><table border ='0' width='650' id='table' align='center' cellpadding='1' cellspacing='1'>
				<tr>
				<td width='80%'align='center' colspan='3'><?php echo _T_EDIT ;
?></td>
				</tr>
<?php

$query2 = "SELECT tid FROM navi WHERE nid = $nid";
$result2 = my_sql_query( $query2, "" );
$actualSelected = $result2[1][0]['tid'];

$query5 = "SELECT * FROM templates WHERE type ='single' ORDER BY description";
$result5 = my_sql_query( $query5, "tid" );

?>
		<tr>
		<td width='80%'align='center' colspan='3'><br />
		<select name="template">
<?php if ( is_array( $result5[1] ) ) {
    foreach( $result5[1] as $key => $value ) {
        echo "<option value='" . $value['tid'] . "'";
        if ( $actualSelected == $value['tid'] ) {
            echo ' selected="selected"';
        } 
        echo ">" . $value['description'] . "</option>";
    } 
} 

?>	</select></td></tr>
		<tr>
		<td width='100%' colspan='3'></td>
			</tr>
			<tr>
		<td width='80%' align='center' colspan='3'><br />
		<input type='submit' name='new' value='<?php echo _CHANGE ; ?>' id='button'>&nbsp;&nbsp;
		<input type='submit' name='reset2' value='<?php echo _RESET ; ?>' id='button' ></td>
		<input name="nid_update" type="hidden" value="<?php echo $nid ?>">

	<br /></tr>
	</table><br />
	</form>

[christalix]

Thanks a lot, l will give it a try tomorrow.

Best Regards