vb.org Archive - Problem displaying a table output in a vBulletin powered page

Hello everyone,

I'm a novice PHP and MySQL but have some understanding of how programming languages are supposed to work so based on about 3 days worth of effort, I have built a table in MySQL called 'sales'. This table contains sales data on cars. Now, I'm trying to display this tabular data and picture on a vBulletin powered page as a table but to no avail... I'm getting memory errors... It goes without saying that I copied most of this code from others on this website so have a very limited understanding of many of the concepts. Following is the memory error:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 129237044 bytes) in /home/xxxxxxx/public_html/ref.php(64) : eval()'d code on line 18

So, here's my PHP code:

<?php

error_reporting(E_ALL & ~E_NOTICE);

define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'ref'); // change this depending on your filename

// get special phrase groups
$phrasegroups = array();

// get special data templates from the datastore
$specialtemplates = array();

// pre-cache templates used by all actions
$globaltemplates = array(
'REF',
'REFBODY'
);

$actiontemplates = array();

require_once('./global.php');

if ($vbulletin->userinfo['userid'] == 0)
{
$show['permission_error'] = 1;
eval('print_output("' . fetch_template('STANDARD_ERROR') . '");');
}
elseif (isset($_REQUEST['do']))
// Being passed from a web page
$ref_req = $_GET['mdl'] ;

include("dbinfo.php");

mysql_connect(localhost,$user,$pass);
@mysql_select_db($db) or die( "Unable to select database");

$showlistbits = '';
$altclass = 'alt1';

$query="SELECT * FROM sales WHERE model LIKE '%$ref_req%' ";
$result=mysql_query($query);
$omega = mysql_fetch_array($result);
$num=mysql_numrows($result);
mysql_close();

$i=0;
while ($i < $num)
{
$altclass = ($altclass=='alt1') ? 'alt2' : alt1;
eval('$showlistbits .= "' .fetch_template('REFBODY') . '";');
}

$navbits = array();
$navbits[$parent] = "Sales Table";
$navbits = construct_navbits($navbits);
eval('$navbar = "' . fetch_template('navbar') . '");');
eval('print_output("' . fetch_template('REF') . '");');

?>

Here's the REF template:
$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
$headinclude
<title>$vboptions[bbtitle] - $pagetitle</title>
</head>
<body>
$header
$navbar

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="1" border="0" width="100%" align="center">
<tr>
<td class="tcat" align="center" colspan="6">Sales Table</td>
</tr>
<tr align="center" bgcolor="#336699">
<th style="width: 81px">Venue</th>
<th style="width: 77px">Cylinders</th>
<th style="width: 77px">Color</th>
<th style="width: 90px">Wheels</th>
<th style="width: 90px">Year</th>
<th style="width: 50px">Pic 1</th>
</tr>
$showlistbits
</table>

$footer
</body>
</html>

Here's the REFBODY template:
<tr>
<td class=$altclass">
$omega[venue]
</td>
<td class=$altclass">
$omega[cyl]
</td>
<td class=$altclass">
$omega[color]
</td>
<td class=$altclass">
$omega[wheel]
</td>
<td class=$altclass">
$omega[year]
</td>
<td class=$altclass">
$omega[pic_1]
</td>
</tr>

Two more things. I have a thumbnail pic and a full-size pic. When the table displays, I want the thumbnail to show but when you click on the thumbnail, I want the full-size pic to display in a new window. BTW, both the thumbnail and the full-size pics are stored on the server directory and not in MySQL. Also, I've noticed some people using conventions like $DB->... These conventions don't work on my server, however, I have verified that PEAR is installed on the server. Any advice in this area will also be greatly appreciated.

Thanks in advance for your help.

Shoolace

--------------- Added [DATE]1230316112[/DATE] at [TIME]1230316112[/TIME] ---------------

Fixed

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00952 seconds Memory Usage 1,724KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (1)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: