PHPProBid Random Auction Block

This is a block that I use on my vbindex to show random auctions from my PHPProbid site. PHPProBid

I don't offer support but will help you out as much as I can. The script is pretty basic. I just make it a PHP file and use a PHP inlude into my vbindex.

You can check out what it looks like at http://www.everything2stroke.com

<?
$host = "localhost";        //Server Name
$user= "username";                  //Username
$password= "password";              //Password
$database="databasename";               //Reviews database name or forum database name
$path = "http://www.pathtoauctionsite.com/";
$price = " ";
$pic = " "; ?>
<table width="100%" border="0" cellpadding="3" cellspacing="1">
  <tr height="15">
    <td nowrap="nowrap"><center><b>Picture</b></center></td>
    <td width="100%"><b>Item Title</b></td>
    <td nowrap="nowrap"><b>Price</b></td>
    <td nowrap="nowrap"><b>bids</b></td>
    <td nowrap="nowrap"><center><b>End Date</b></center></td>
  </tr>
  <? // Connecting, selecting database
$link = mysql_connect ("$host", "$user", "$password") or die ('I cannot connect to the database.');
mysql_select_db ("$database")or die("Could not select database");
        $getRandomAuctions=mysql_query("SELECT id, startdate, bidstart, currency, itemname, maxbid, enddate, picpath, nrbids FROM probid_auctio
ns WHERE
        closed=0 AND active=1 AND deleted!=1 ORDER BY rand() DESC LIMIT 0,2");
        while ($randAuctions = mysql_fetch_array($getRandomAuctions)) {
        if ( $randAuctions['picpath'] == ""){
            $pic = "clear.gif ";
        }
        else {

            $pic = $randAuctions['picpath'];
        }
 if ( $randAuctions['maxbid'] == "0.00"){
            $price = $randAuctions['bidstart'];
        }
        else {

            $price = $randAuctions['maxbid'];
        }
?>
  <tr>
        <td nowrap="nowrap"><img width="100" src="<?=$path;?><?=$pic;?>"></td>
        <td width="100%"><a href="<?=$path;?>auctiondetails.php?id=<?=$randAuctions['id'];?>" TARGET="_blank"> <? echo $randAuctions['itemname'
];?> </a></td>
        <td nowrap><?=$price;?> <? echo $randAuctions['currency'];?></td>
        <td nowrap><center><?echo $randAuctions['nrbids']?></center></td>
        <td nowrap><b><? echo $randAuctions['enddate'],$setts['date_format'];?></b></td>
  </tr>
  <? } ?>
</table>

[schlottkej]

binarywebs is a hassle to work with... the code he gave is pretty simple, but it doesn't work well/at all with 3.6.5

[betablue]

What do we do with this code? Some instructions would be nice....

will this work with the new version of PHP ProBid v6.03 ?