Re: displaying certain columns

You have to fetch the row data with some function... try mysql_fetch_row() or mysql_fetch array(), examples: $arr=mysql_fetch_row($result); echo $arr[0]; or $arr=mysql_fetch_array($result); echo $arr[$dbrow]; that should do... At 21:19 30/9/2001 -0400, you wrote:

i have a database and it randomly selects one piece of data from a table of quotes, but it will only print the quote when I include the row that it's picked with. I have my SELECT statement at $sql = "SELECT $dbrow FROM $dbtable ORDER BY RAND() LIMIT 1"; and then to display the result $result = mysql_db_query($dbname, $sql) then in the code, print "<td> $result </td>"; what do i need to add? (the result is Resource id #3) thank you, Melih -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net

_____________________________ . Christian Dechery . . Gaita-L Owner / Web Developer . . http://www.webstyle.com.br . . http://www.tanamesa.com.br