selecting and updating mysql

[scbmx]

can you make a select query and make the variables of the selected row show only but putting(like stating the values such as in a insert query)

<?php
echo $var;
?>

ive only used select queries that dislpay the rows where you define the infromation like this

<?php
echo $blah['id'];
?>

i want to be able to update mysql with a form and the update query is like so...

UPDATE table SET name='$name' location='$location' WHERE id='$id';

so i would want a select query where i can display the info in the form feild like so...

<input type="text" name="name" value="<?php echo ("$name"); ?>">

can someone shoe me an example select query where i can display info with varibles like that?

[skirby]

pretty close. First, your id in the select will probably be an integer, so the $id won't be in quotes.

I prefer to make the inputs like this:

<?php
echo "<INPUT TYPE=\"radio\" NAME=\"cust\" value='" . $row["signupID"] . "'> ";
?>

or

<?php
echo '<INPUT TYPE="radio" NAME="cust" value="' . $row["signupID"] . '">';
?>

or even

<?php
$v = $row["signupID"];
echo "<INPUT TYPE=\"radio\" NAME=\"cust\" value=\"$v\">";
?>

all work, just depends on what you prefer for documentation. Personally, I hate the inline php switches you were showing, they're hard to maintain.