mysql_data_seek -- AHHHHHH

kingsol

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.

archangel_617b

Please be sure to copy&paste your code exactly as it is in your source file (eg this copy is missing a tick around 'database' in the mysql_select_db() call).

Okay, mysql_data_seek() moves the internal pointer of the resrult set to the specified row, right? That does not affect the last row you read out. You must call mysql_fetch_assoc() to retrieve the row you specified.

This is why mysql_fetch_assoc() is usually displayed from with in a loop since it advances the pointer by one anyhow.

If you simply want to fecth two rows and print them, mysql_data_seek() to the first one, call mysql_fetch_assoc() to read the first row, print that, then call mysql_fetch_assoc() a second time to read the next row and then display it.

I sorta fired a bunch of random shots out there for you, lemme know if this helps you at all or maybe you can clarify your problem for me if I'm dead-off.