retrieving a mysql query

Crisp1991

New Member
I have written a mysql query and fetched the result as an assoc array using mysql_fetch_assoc().The query returns a list for two fields.I am looping through this field using through the result array and am extracting the value.how do i display the two fields since doing a plain echo is not working for me?The code which i have written isThanks in advance.\[code\] $query = "SELECT x,y FROM table"; $result = mysql_query( $query , $resourcelink); while( $s= mysql_fetch_assoc( $result ) ) {extract( $s ); echo $x . " - " . $y . "<br />"; }\[/code\]
 
Top