The information schema is present as Basic Auto template was used. I also have backups that were created from the admin section and all site files are still present. Only the database itself was deleted. How would I go about restoring this mess? 

Thanks

list($listingRecords, $listingDetails) = getRecords(array(
'tableName' => 'listings',
'perPage' => '10',
'orderBy' => 'createdDate DESC'

<?php
/* STEP 1: LOAD RECORDS - Copy this PHP code block to the TOP of your page BEFORE anything else. */
require_once "init.php";

list($listingRecords, $listingDetails) = getRecords(array(
'tableName' => 'listings',
'joinTable' => 'homepages',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$listing = @$listingRecords[0];

if (!$listing) { print "listingsRecord not found!"; exit; }

?>
<?php include "include_header.php"; ?>

<div class="subheader">View : <?php echo $listing['vehicle'] ?></div><br/>

<table border="0" cellspacing="0" cellpadding="2" width="590">
<tr>
<td rowspan="20" valign="top" align="center" width="165">

PHOTOS<br/>
<b>Click photo to enlarge</b><br/><br/>

<?php foreach ($listing['uploads'] as $upload): ?>
<?php if ($upload['hasThumbnail']): ?>
<a href="<?php echo $upload['urlPath'] ?>"><img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" border="0" title="<?php echo $upload['info1'] ?>" alt="<?php echo $upload['info2'] ?>" /></a><br/>
<?php echo $upload['info3'] ?><br/>
<?php endif ?>
<?php endforeach ?>

<?php if (!$listing['uploads']): /* if no uploads show this: */ ?>
<table cellspacing="0" cellpadding="0" width="150" class="noPhoto" style="height: 100px">
<tr><td bgcolor="#EEEEEE" align="center"><b>Photo<br/>Not<br/>Available</b></td></tr>
</table>
<?php endif; ?>

</td>
<td valign="top">
<div class="separatorBar" style="padding: 3px 3px 3px 3px;">
<div style="float: right;"><b>Price</b> $<?php echo number_format($listing['price']); ?></div>
<div><strong>Details</strong></div>
</div> 

<?php foreach ($listing['uploads'] as $upload): ?>
<?php if ($upload['hasThumbnail']): ?>
<a href="<?php echo $upload['urlPath'] ?>" rel="lightbox['gallery']" title="<?php echo $upload['info2'] ?>"><img src="<?php echo $upload['thumbUrlPath'] ?> " width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" border="1" title="<?php echo $upload['info1'] ?>" alt="<?php echo $upload['info2'] ?>" /></a><br/>
<?php echo $upload['info3'] ?><br/>
<?php endif ?>
<?php endforeach ?>

<?php if (!$listing['uploads']): /* if no uploads show this: */ ?>

<table cellspacing="0" cellpadding="0" width="125" class="noPhoto" style="height: 100px">
<tr><td bgcolor="#EEEEEE" align="center"><b>Photo<br/>Not<br/>Available</b></td></tr>
</table>
<?php endif; ?>

<b><u>Photos Courtesy of</u></b><br/> <?php echo $listing['photos_courtesy_of'] ?>
</td>
<td valign="top">
<div class="separatorBar"><b><u>Profile Details:</b> - <b><?php echo $listing['year'] ?></b> <b><?php echo $listing['vehicle'] ?> <?php echo $listing['model'] ?></b></u></div></div></div>

And so on

In the developer log I get the following error. 

E_NOTICE: Undefined variable: record
/home/siteaddress(without.com)/public_html/listingDetail.php (line 316)
http://siteaddress.com/listingDetail.php?Ford-54

This is the code for link. http://www.siteaddress.com/dataAdmin/admin.php?menu=listings&action=edit&num=<?php echo $recrod['num']; ?>

Security Warning: A link from an external source has been detected and automatically disabled.
For security links are only accepted from: http://www.siteaddress.com/dataAdmin/admin.php
Your browser indicated that it linked from: http://www.siteaddress.com/listingDetail2.php?Chevrolet-43

I am replacing a database of products with over 10,000 listings and from time to time some products need to be updated. This is a function that was present in the old program that we used and really was a time saver. 

Thanks once again. 

Model produced by <?php echo $listing['manufacture'] ?> for </i> <b><?php echo $listing['produced_for'] ?>

http://www.diecastdata.com/listingDetail2.php?Dodge-2

If you know of something that would work better that's OK. Just want a very simple image slide. 

Head tags

<script type="text/javascript" src="js/prototype.js"></script>
<script type="text/javascript" src="js/scriptaculous.js?load=effects"></script>
<script type="text/javascript" src="js/lightbox.js"></script>

Code as in page

<?php foreach ($listing['uploads'] as $upload): ?>
<?php if ($upload['hasThumbnail']): ?>
<a href="<?php echo $upload['urlPath'] ?>" rel="lightbox"><img src="<?php echo $upload['thumbUrlPath'] ?> " width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" border="1" title="<?php echo $upload['info1'] ?>" alt="<?php echo $upload['info2'] ?>" /></a><br/>
<?php echo $upload['info3'] ?><br/>
<?php endif ?>
<?php endforeach ?>

<?php if (!$listing['uploads']): /* if no uploads show this: */ ?>
<table cellspacing="0" cellpadding="0" width="125" class="noPhoto" style="height: 100px">
<tr><td bgcolor="#EEEEEE" align="center"><b>Photo<br/>Not<br/>Available</b></td></tr>
</table>
<?php endif; ?>

This is the instructions from Dynamic Drive. 

<a href="images/image-1.jpg" rel="lightbox" title="my caption">image #1</a>

The rel attribute is mandatory in order to activate the effect for this particular image. The "title" attribute is optional, and when defined, adds a caption beneath the enlarged image. The "href" attribute obviously should contain the path to the enlarged image. If you wish a particular caption ("title") to be hyperlinked to a specific URL, throw in a "rev" attribute pointing to the desired URL. For example:

<a href="images/image-1.jpg" rel="lightbox" title="my caption" rev="http://www.dynamicdrive.com">image #1</a>

LightBox version 2 also adds the ability to group multiple image links together, so an image gallery is created out of the enlarged images:

<a href="images/image-1.jpg" rel="lightbox[roadtrip]">image #1</a> <a href="images/image-2.jpg" rel="lightbox[roadtrip]">image #2</a> <a href="images/image-3.jpg" rel="lightbox[roadtrip]">image #3</a>