2 replies to this topic

[mutago]

Good day everyone, please i can display database records as follow in coldfusion
and now i want display it using an array in coldfusion as showed below in php code any help please.
below is the working code

<cfquery name="result" datasource="mydsn">


SELECT name,age,sex FROM data_record

</cfquery>

<h1><font color=green>data successfully selected</font></h1>

<cfoutput>

<b>Your Name is</b> #name#<br>

<b>Yoour age is</b> #age#<br>

</cfoutput>

Finally, in php i can do it this way

while($rows=mysql_fetch_array($result)){


?>

<b>name</b><? print $rows['name']; ?><br>

<b>Age:</b><? print $rows['age']; ?><br>

<b>sex:</b><? print $rows['sex']; ?><br>

[WingedPanther]

PHP is using an associative array to represent the records. ColdFusion uses a loop over the query object. You access members using either #name# or #query.name#.

[mutago]

thanks