outputting multiple rows/cells

bryson

I am outputting a row for each message for a message board... the browser can't seem to handle more than about 30 rows ... i get page can't be displayed. I thought maybe there was funky characters or corruption in one of the records in the DB but i ruled that out. (browser can display 28 rows ok... 29 rows i get page can't be displayed... but it can display 29 alone.) Here's the code... it's alot ... but i need to show it all. It's only one table, but multipe rows. I have a feeling this is an access issue. Maybe there is a more efficient way to do this??

$sql = "SELECT id,sub,createdBy,createDate FROM msg_board ORDER BY id DESC";
$pointer = odbc_exec($db,$sql);
while (odbc_fetch_into($pointer,&$rowdata)) {
list($id,$sub,$createdBy,$createDate) = $rowdata;
echo "<TR>
<TD><A HREF='view_msg.php?id=$id'>$sub</A></TD>
<TD ALIGN=center NOWRAP>$createdBy</TD>
<TD ALIGN=center NOWRAP>$createDate</TD>
</TR>";
$sql = "SELECT reply_id,r_sub,r_createdBy,r_createDate FROM reply WHERE id = $id";
$pointer2 = odbc_exec($db,$sql);
while (odbc_fetch_into($pointer2,&$rowdata2)) {
list($reply_id,$r_sub,$r_createdBy,$r_createDate) = $rowdata2;
echo "<TR>
<TD>  <A HREF='msg.php?reply_id=$reply_id'>$r_sub</A></TD>
<TD ALIGN=center NOWRAP>$r_createdBy</TD>
<TD ALIGN=center NOWRAP>$r_createDate</TD>
</TR>";
}
}

bryson

OK, it's not the table's or rows or cells or anything.... something to do with my code... unless it's access

$sql = "SELECT reply_id,r_sub,r_createdBy,r_createDate FROM reply WHERE id = $id";
$pointer2 = odbc_exec($db,$sql);
while (odbc_fetch_into($pointer2,&$rowdata2)) {
list($reply_id,$r_sub,$r_createdBy,$r_createDate) = $rowdata2;
echo "  <A HREF='msg.php?reply_id=$reply_id'>$r_sub</A> 
$r_createdBy 
$r_createDate ";
}
}

bryson

sigh... ok.. this is a little cleaner... same problem tho. So I don't think it's the code. I think it's some sort of access problem in display multiple records.

$dbc = new COM("ADODB.Connection");
$dbc->Provider = "MSDASQL";
$dbc->Open("msg_board");

$rs = $dbc->Execute("select * from msg_board");
while (!$rs->EOF) {
$id = $rs->Fields["id"]->value;
$sub = $rs->Fields["sub"]->value;
$createdBy = $rs->Fields["createdBy"]->value;
$createDate = $rs->Fields["createDate"]->value;
echo "<A HREF='view_msg.php?id=$id'>$sub</A> 
$createdBy 
$createDate ";
$rs->MoveNext();
}

bryson

ok, i've done some trouble shooting. I created a record with like every character and it displays it fine. I replicate the record 100 times, it's reads and outputs ok. If I replicate it 300 times,... so 300 identical records in the DB it can't do it... page can't be displayed.

Has anyone written a msg board on here? How did you display multiple records? Do i have to read the DB info into an array first?
I'm using Apache web server 2.0.4.7, PHP 4.3.3 and Access XP/2002 SP2 :mad: :mad: :mad: