VB database pulls on nonvb pages

[TheCaver]

In 3.0.x, I used this code to pull calendar events...it no longer works in 3.5....Any ideas? I have several pages on my site broken for this same reason I suspect. Just not sure what changed :


<?
$events = $DB_site->query("select * from event order by dateline DESC limit 3");

if ($DB_site->num_rows($events))
{
while ($ev = $DB_site->fetch_array($events))
{
$news="";
$new_date = vbdate('m-d-Y', $ev['dateline'], false, false);
$news .= "<B>".$new_date."</B><BR>";
$news .= $ev['title']."<BR>";

echo "<A class='text-9white' HREF=\"calendar.php?do=getinfo&e=$ev[eventid]&day=$new_date&c=1\">$news</A>";

}
}

?>


THANKS !!!

JC

[jugo]

$DB_ is now $db_

[noppid]

I think changing $DB_site->query to $db->query_read will do it.

[TheCaver]

Hmm, that didn't seem to do it....Thanks for the suggestions though!

JC

[Blaine0002]

<?
$events = $db->query("select * from event order by dateline DESC limit 3");

if ($db->num_rows($events))
{
while ($ev = $db->fetch_array($events))
{
$news="";
$new_date = vbdate('m-d-Y', $ev['dateline'], false, false);
$news .= "<B>".$new_date."</B><BR>";
$news .= $ev['title']."<BR>";

echo "<A class='text-9white' HREF=\"calendar.php?do=getinfo&e=$ev[eventid]&day=$new_date&c=1\">$news</A>";

}
}

?>

try this.