I have a simple query that pulls content for a page from a database. Shown below. After I display a piece of information I want it move to the next row in the query. I'm not using a loop of any sort...I just want to advance the query by one row. Here is my code:
//Database Info
$Conn = mysql_connect('localhost', 'user', 'pass');
mysql_select_db(database', $Conn) or die(mysql_error());
$ct=0;
//Query to get content for main text
$query_content="SELECT c_id, c_content FROM bc_content WHERE c_location='" . $theView . "' ORDER BY c_order";
$content=mysql_query($query_content, $Conn);
$row_content=mysql_fetch_assoc($content);
$total_content=mysql_num_rows($content);
Then when I call the rows to display the content:
echo $row_content['c_content']; mysql_data_seek($content, $ct++); //move to next row
Any Help or point me in the right direction. THANKS.
