while ( problems );

[zook]

Alright, I've got a database with multi-part articles. The parts of the article are stored in a table called pages with fields: 'aid'(article id) 'pid'(part id) 'pname'(partname) and 'text'. each part has its own row.

I'm trying to create a script to display all the parts of a given article.

i can't seem to get this right, heres the chunk of code:

$sql = mysql_query("SELECT pname, text FROM pages WHERE aid=$aid AND pid=$pid");
while ( $row = mysql_fetch_array($sql) ) {
$pid2 = $row["pid"];
$pname2 = $row["pname"];
$text2 = $row["text"];
echo("<p class=\"subtitle\">Part $pid2: $pname2<p>$text2");
$pid++;
} 

any suggestions?

[Paul S]

The problem is you are not selecting all the fields you need, try this

$sql = mysql_query("SELECT * FROM pages WHERE aid=$aid AND pid=$pid");
while ( $row = mysql_fetch_array($sql) ) {
$pid2 = $row["pid"];
$pname2 = $row["pname"];
$text2 = $row["text"];
echo("<p class=\"subtitle\">Part $pid2: $pname2<p>$text2");
}

BTW which is the primary key, AID or PID?

[zook]

BTW which is the primary key, AID or PID?

neither. aid is the id of the article, pid the the part id. is it neccasarry to set a primary key?

thanks for pointing out the missing field. i still need to somehow add 1 the pid and then display everything again...thats where im lost.

[zook]

yes! after testing idea after idea i finally found the problem. see, i was using the WHERE clause with "where aid=$aid and pid=$pid - limiting myself to access to that one particular row, while trying to get multiple rows. i took out the "and pid=$pid" as well as "$pid++;" and it worked fine.

thanks for your support though!

[Paul S]

glad I could help