[Resolved] Syntax correct?

[k994519]

HI guys

just wondering if this syntax is correct I am working at my cuz house where he has not got php or mysql installed....... otherwise i would not ask........:

<?
if(isset($_POST["submit"])
select * from table_users where [$_post"user_id"] = user_id; 



<form action="<?=$_SERVER["PHP_SELF"]?>" method="POST">
	<table>
		<td><input type="text" name="user_id" 
		value="<?php print isset($_POST["user_id"]) ? $_POST["user_id"] : "" ;?>" 
		maxlength="15"></td></tr>
		<td><input name="submit" type="submit" value="Submit">&nbsp;<input type="reset" name="Reset" value="Reset"></tr></td>
	</table>
  </form>

if this is correct then how would I then put each of the field data(from db query) into text boxes....

thanks in advance for ur help

[drew010]

yes, most of it is correct except the top:
select * from table_users where [$_post"user_id"] = user_id;
wont work, plus you wont have any record of the query.

something like:

$query = "select * from table_users where user_id = '" . $_POST['user_id'] . "'";
$result = mysql_query($query);
will work. then to put all the results in textboxes

$data = mysql_fetch_array($result);

echo "<input type=\"text\" name=\"x\" value=\"{$data[0]}\"><br />\n";

just do that echo as many times as there are fields, and replace x with whatever the row contains, like username, or password...