[RESOLVED] Pre-populating A Form With Query Results

[scriderpsd]

This is probably a bonehead question but I've been spinning my wheels on this for a while now...I'm hoping someone can help me out.

I have this query...

$sql_pay_id="SELECT pay_id FROM personnel where personnel_id=$cat3";
	$conn = db_trans_connect();
	$result_pay_id = mysql_query($sql_pay_id,$conn);

This returns one row / one field. Something like: 65655

I have an html form and I want that result to be the default value of a form field.

I'm not sure what PHP function to use to pull to grab that value so I can populate the form.

I've tried using something like this....

while($row = mysql_fetch_array($result_pay_id)) {

but I keep get warnings.

Any help is appreciated.

Thanks,

Scott

[Weedpacket]

If it's one row then you don't need an entire loop to do it.

 $sql_pay_id="SELECT pay_id FROM personnel where personnel_id=$cat3";
$conn = db_trans_connect();
$result_pay_id = mysql_query($sql_pay_id,$conn);
list($pay_id) = mysql_fetch_array($result_pay_id);

echo "<input type=\"text\" value=\"$pay_id\" />";

What "warnings" are you getting?

[scriderpsd]

Thanks Weedpacket. That fixed it.

For the last line I had to use...

echo '<input type="text" value="'.$pay_id.'" />';