php-general | 2001092

Re: [PHP] displaying certain columns From: Christian Dechery (cdechery <email protected>)
Date: 09/30/01

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 <email protected>
>For additional commands, e-mail: php-general-help <email protected>
>To contact the list administrators, e-mail: php-list-admin <email protected>

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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>