[PHP] displaying certain columns

2001-09-30 Thread Melih Onvural
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 =

Re: [PHP] displaying certain columns

2001-09-30 Thread Christian Dechery
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