Re: <cfquery> correct cfm-mysql/phpMyAdmin ? I use goDaddy.com hostingphp/cfml/mysql

["Semaphorians"]

Hi, I hope the below solves your concern:

 First select the record from table using <cfquery> like

 <cfquery name='selectqry' datasource='your_data_source_name'>
 SELECT *
 FROm table_name
 WHERE your_condition   

 </cfquery>

 then populate form items with this record like

 <cfoutput query="selectqry">
 <form >
 <input type="text" name="textbox" value="#selectqry.column_name#" />
 .
 .
 .
 .
 .
 <input type="submit" name="submit" value="submit" />
 </form>
 </cfoutput>

 Hope this helps!