UBB.Developers Forums UBB.threads 7 Development How Do I? Database entry call... ?

I'm stuck. I'm doing something wrong here and was hoping it would be obvious to folks more familiar with php than myself.

// # --------------------------
// # Let's grab the news items
$Newsboard_q = addslashes($newsboard);

$query = "
SELECT B_Number,B_Posted,B_Last_Post,B_Username,B_Subject,B_Body,B_Main
FROM w3t_Posts
WHERE B_Number = B_Main
AND B_Board = '$Newsboard_q'
ORDER BY B_Last_Post DESC
LIMIT $totalnews
";

$sth = $dbh -> do_query($query);
(the above line of code is where the error says it's happening, which I guess is referencing my database syntax... ?)

while ($rows = $dbh -> fetch_array($sth) ) {
list($Number,$Posted,$Last,$Username,$Subject,$Body,$Main) = $rows;
$dbh -> finish_sth($sth);


[]/testimages/icons/smile.gif[/] 6 []/testimages/icons/frown.gif[/]
Screamers

while ( list($Number,$Posted,$Last,$Username,$Subject,$Body,$Main) = $dbh -> fetch_array($sth)) {

[:red]--------------
http://extremeforums.org

Tried your line without success. I don't think it's even getting to the while, which is after that database call...

This is the fatal error message:


Fatal error: Call to a member function on a non-object in main.inc.php on line 758

Line 758 is:

$sth = $dbh -> do_query($query);

of the block:

$Newsboard_q = addslashes($newsboard);

$query = "
SELECT B_Number,B_Posted,B_Last_Post,B_Username,B_Subject,B_Body,B_Main
FROM w3t_Posts
WHERE B_Number = B_Main
AND B_Board = '$newsboard'
ORDER BY B_Last_Post DESC
LIMIT $totalnews
$sth = $dbh -> do_query($query);

Not sure what I'm pulling out that it doesn't like.. scuse the expression... []/w3timages/icons/wink.gif[/]

[]/w3timages/icons/smile.gif[/] 6 []/w3timages/icons/frown.gif[/]
Screamers

duh..... went home thought about it, you forgot closing bracket } lets see if it works now.

[:red]--------------
http://extremeforums.org

Forgot to define $dbh as a global near the top of the database call. []/testimages/icons/crazy.gif[/]

I'm learning... slowly... []/testimages/icons/laugh.gif[/]



[]/testimages/icons/smile.gif[/] 6 []/testimages/icons/frown.gif[/]
Screamers