PHP - Doesn't Display Acp Link

Hi guys, i'm new to PHP and i just couldn't get something right..

http://carnex.com.sg/preownedcars.php
this is the web that i'm currently having problem with, after pressing the button "learn more".

It will link to a page example, http://carnex.com.sg/view_car.php?id=97

And it should show more details of the cars, but i aren't getting any my details out..

The scripts are here..

I'm not sure if this is correct..
 <?php

include "includes/common.php";

$det1 = mysql_query("select * from tab_product where Status='1' and feat='1' limit $offset,$recperpage");

while($det2 = mysql_fetch_array($det1))

{

$det[] = $det2;

}


        $objSmarty->assign("det",$det);
$objSmarty->assign("IncludeTemplate","view_car.tpl");
$objSmarty->display("pagetemplateautomobile.tpl");

?>


 <tr>
    <td style="padding-top:30px; padding-bottom:20px;"><table width="780" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="540" valign="top"><table width="540" border="0" align="left" cellpadding="0" cellspacing="0">
          <tr>
            <td valign="top" class="body"><form id="form1" name="form1" method="post" action="">
              <table width="93%" border="0" align="center" cellpadding="2" cellspacing="4" class="border">
{literal}

<script src="http://www.google.com/jsapi" type="text/javascript"></script>

<script type="text/javascript" charset="utf-8">

google.load("jquery", "1.3");

</script>






<link rel="stylesheet" href="css/prettyPhoto.css" type="text/css" media="screen" title="prettyPhoto main stylesheet" charset="utf-8" />

<script src="js/jquery.prettyPhoto.js" type="text/javascript" charset="utf-8"></script>

<script type="text/javascript">

<script type="text/javascript" src="js/login.js"></script>


<style type="text/css">


.error {

font: normal 12px arial;

text-align:center;

font-weight:bold;

background-color: #ffc;

border: 1px solid #c00;

}



.ok {

font: normal 12px arial;

text-align:center;

font-weight:bold;

background-color:#EFFFDF;

border: 1px solid #339966;

color:#009900;

}



</style>

{/literal}

{section name=a loop=$det}

<tr>

        <td width="580" align="center" valign="top"><table width="580" border="0" cellspacing="0" cellpadding="0">

          <tr>

            <td height="672" align="center" valign="top" background="images/boby_bg_top.jpg" style="background-position:top; background-repeat:repeat-x; background-color:#FFFFFF;"><table width="100%" border="0" cellspacing="0" cellpadding="0">

              <tr>

                <td height="19">&nbsp;</td>

                <td>&nbsp;</td>

              </tr>

              <tr>

                <td width="580" valign="top"><table width="580" border="0" align="left" cellpadding="0" cellspacing="0">

                  <tr>

                    <td height="620" align="center" valign="top"><table width="98%" border="0" align="center" cellpadding="5" cellspacing="0">

                      

                      <tr>

                                

                                <td width="32%" align="left" valign="middle"><!--<a href="carforsale.php"><img src="images/back.jpg" name="back" width="80" border="0" /></a>--></td>

                                <td width="43%" align="left" valign="middle">&nbsp;</td>

                       </tr>

                      <tr align="left">

                        <td width="12%" class="tit_1">{$det[a].prod_name}</td>

                        <td width="88%" class="tit_1">&nbsp;</td>

                      </tr>

                      

                      <tr align="left">

                        <td colspan="2" valign="top" class="tit_1"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="registration_border">

                          <tr>

                            <td height="228" valign="top" bgcolor="#FFFFFF"><table width="95%" border="0" align="center" cellpadding="5" cellspacing="0">

                              

                              <tr>

                                <td height="15" colspan="3"></td>

                              </tr>



                              

                                

                              <tr>

                               
                                <td align="center" class="content_text" valign="top" colspan="2">
                                {if $det[a].prod_imgsize1 eq '0' and $det[a].prod_imgsize2 eq '0' and $det[a].prod_imgsize3 eq '0' and $det[a].prod_imgsize4 eq '0' and $det[a].prod_imgsize5 eq '0' and $det[a].prod_imgsize6 eq '0' and $det[a].prod_imgsize7 eq '0'}<img src="product_img/no_image.gif" width="100" align="absmiddle"  border="1" style="border-color:#CCCCCC; padding:5px;"/>

                                {else}
<!--{if $det[a].prod_imgsize1 neq '0'}-->

<a href="product_img/{$det[a].prod_imgname1}"rel="prettyPhoto[mixed]"><img src="product_img/{$det[a].prod_imgname1}" width="140" height="100" border="1" style="border-color:#CCCCCC; padding:5px;"/></a>{/if}
{if $det[a].prod_imgsize2 neq '0'}<a href="product_img/{$det[a].prod_imgname2}"  rel="prettyPhoto[mixed]"><img src="product_img/{$det[a].prod_imgname2}" width="140" height="100" border="1" style="border-color:#CCCCCC; padding:5px;"/></a>{/if}
{if $det[a].prod_imgsize3 neq '0'}<a href="product_img/{$det[a].prod_imgname3}"  rel="prettyPhoto[mixed]"><img src="product_img/{$det[a].prod_imgname3}" width="140" height="100" border="1" style="border-color:#CCCCCC; padding:5px;"/></a>{/if}
{if $det[a].prod_imgsize4 neq '0'}<a href="product_img/{$det[a].prod_imgname4}"  rel="prettyPhoto[mixed]"><img src="product_img/{$det[a].prod_imgname4}" width="140" height="100" border="1" style="border-color:#CCCCCC; padding:5px;"/></a>{/if}
{if $det[a].prod_imgsize5 neq '0'}<a href="product_img/{$det[a].prod_imgname5}" rel="prettyPhoto[mixed]"><img src="product_img/{$det[a].prod_imgname5}" width="140" height="100" border="1" style="border-color:#CCCCCC; padding:5px;"/></a>{/if}
{if $det[a].prod_imgsize6 neq '0'}<a href="product_img/{$det[a].prod_imgname6}" rel="prettyPhoto[mixed]"><img src="product_img/{$det[a].prod_imgname6}" width="140" height="100" border="1" style="border-color:#CCCCCC; padding:5px;"/></a>{/if}
{if $det[a].prod_imgsize7 neq '0'}<a href="product_img/{$det[a].prod_imgname7}"  rel="prettyPhoto[mixed]"><img src="product_img/{$det[a].prod_imgname7}" width="140" height="100" border="1" style="border-color:#CCCCCC; padding:5px;"/></a>{/if}
{/if}{if $det[a].feat eq '1'}




                                  <div style="margin-top:-5px;" align="center"><img src="administrator/images/favorites.png" width="36" border="0" /></div>


                                {/if}</td>
 
                              </tr>

                              <tr>

                                <td class="car_1_blc"><strong class="car_1_blc">Car Name : </strong></td>

                                <td class="content_text">{$det[a].prod_name}</td>
                              </tr>

                              <tr>

                                <td class="car_1_blc"><strong class="car_1_blc">Category : </strong></td>

                                <td class="content_text">{$det[a].category}</td>

                                </tr>
                                
                               <tr>

                                <td class="car_1_blc"><strong class="car_1_blc">Agent Name : </strong></td>

                                <td class="text1">{$fname} {$lname}</td>

                                </tr>

                              

                              <tr>

                                <td class="car_1_blc"><strong class="car_1_blc">Agent Email : </strong></td>

                                <td class="text1">{$det[a].email}</td>

                                </tr>

                              

                              <tr>

                                <td class="car_1_blc"><strong class="car_1_blc">Agent Code : </strong></td>

                                <td class="text1">{$det[a].agent}</td>

                                </tr>

                                 <tr>

                                <td class="car_1_blc" valign="top"><strong class="car_1_blc">Contact No. : </strong></td>

                                <td class="text1">{$phone}<br /><br />{$phone2}</td>

                                </tr>
                                
                              <tr>


                                <td class="car_1_blc"><strong class="car_1_blc">Sale Price : </strong></td>

                                <td class="content_text">${$det[a].saleprice}</td> 

                                </tr>  

                             {if $smarty.session.user_log neq ''}
                              <tr>


                                <td class="car_1_blc"><strong class="car_1_blc">Dealer Price : </strong></td>

                                <td class="content_text">{$det[a].prod_price}</td>

                                </tr>

{/if}
                              

                           <!--   <tr>

                                <td class="car_1_blc"><strong class="car_1_blc">Car Quantity : </strong></td>

                                <td class="content_text">{$det[a].quant}</td>

                                </tr>-->

                              

                              <tr>

                                <td class="car_1_blc"><strong class="car_1_blc">Road Tax : </strong></td>

                                <td class="content_text">{$det[a].roadtax}</td>

                                </tr>

                              

                              <tr>

                                <td class="car_1_blc"><strong class="car_1_blc">Transmission  : </strong></td>

                                <td class="content_text">{$det[a].trans}</td>

                                </tr>

                              

                              <tr>

                                <td class="car_1_blc"><strong class="car_1_blc">Engine Capacity : </strong></td>

                                <td class="content_text">{$det[a].capacity}</td>

                                </tr>

                              

                              <tr>

                                <td class="car_1_blc"><strong class="car_1_blc">Mileage : </strong></td>

                                <td class="content_text">{$det[a].mile}</td>

                                </tr>

                                                            

                              <tr>

                                <td class="car_1_blc"><strong class="car_1_blc">Register date  : </strong></td>

                                <td class="content_text">{$det[a].regdate}</td>

                                </tr>
                                

                                
                              <tr>

                                <td class="car_1_blc"><strong class="car_1_blc">Features  : </strong></td>

                                <td class="content_text">{$det[a].features}</td>

                                </tr>
                                
                              <tr>

                                <td class="car_1_blc"><strong class="car_1_blc">Accessories  : </strong></td>

                                <td class="content_text">{$det[a].acc}</td>

                                </tr>
                                
                              <tr>

                                <td class="car_1_blc"><strong class="car_1_blc">COE  : </strong></td>

                                <td class="content_text">{$det[a].coe}</td>

                                </tr>
                                
                               <tr>

                                <td class="car_1_blc"><strong class="car_1_blc">OMV  : </strong></td>

                                <td class="content_text">{$det[a].omv}</td>

                                </tr>
                                
                               <tr>

                                <td class="car_1_blc"><strong class="car_1_blc">Depreciation  : </strong></td>

                                <td class="content_text">{$det[a].dep}</td>

                                </tr>
                                
                               <tr>

                                <td class="car_1_blc"><strong class="car_1_blc">No. of owners  : </strong></td>

                                <td class="content_text">{$det[a].owner}</td>

                                </tr>
                                
                                <tr>

                                <td class="car_1_blc"><strong class="car_1_blc">Type of Vehicle   : </strong></td>

                                <td class="content_text">{$det[a].type}</td>

                                </tr>

                              

                              <tr>

                                <td class="car_1_blc" valign="top"><strong class="car_1_blc">Description  : </strong></td>

                                <td colspan="2" class="content_text">{$det[a].desc}</td>

                              </tr>



                              

                              <tr>

                                <td height="10" colspan="3"></td>

                                </tr>



                              <tr>

                                <td width="25%">&nbsp;</td>

                                <td colspan="2"><a href="sendmail.php?id={$det[a].prod_id}"><img src="images/sendthemail.jpg" border="0" style="padding:10px;" /></a></td>

                              </tr>

                              

                            </table></td>

                          </tr>

                        </table></td>

                      </tr>

                      

                    </table></td>

                  </tr>

                </table></td>



                <!-- Side panel -->

               <td width="32%" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">

                {include file="side.tpl"}

                 </table></td>

               <!-- Side ends -->



              </tr>

              <tr>

                <td width="68%">&nbsp;</td>

                <td>&nbsp;</td>

              </tr>

              

            </table></td>

          </tr>

        </table></td>

      </tr>

{/section}


      {literal}



<script type="text/javascript" charset="utf-8">

$(document).ready(function(){

$("a[rel^='prettyPhoto']").prettyPhoto();

});

</script>

   {/literal}
</table>

</form>
 </td>
  </table>
  </tr>
  

</td>
 </tr>
</td>
</tr>

I have a problem with the three special characters in the Danish language: æ, ø and å. I have created a database with a simple table manually within phpMyAdmin, and I have added contents, which is text with the letters mentioned. Everythings looks correct in here. But when I get the content of the database written out via a php document, these three letters are replaced with a box sign. In phpMyAdmin I chose "utf8_danish_ci" as collation. And here is the code of the php document writing out the content of the database table, named "lille_tabel", with the password written with stars.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>

<?php
$server = "localhost";
$brugernavn = "root";
$kodeord = "************";
$db = "lille";

mysql_connect($server,$brugernavn,$kodeord) or die(mysql_error());

echo "Forbundet til MySQL server<br/>";

mysql_select_db($db) or die(mysql_error());

echo "Forbundet til Databasen<br/>";

$data = mysql_query("SELECT * FROM lilletabel") or die(mysql_error());

while ($info = mysql_fetch_array($data))
  {
echo "ID: ".$info['id']."<br/>";
echo "Navn: ".$info['navn']."<br/>";
echo "Tekst: ".$info['tekst']."<br/>"."<br/>";
  }

?>


</body>
</html>

By the way: I use Dreamweaver. I hope someone have suggestions to pinpoint the problem ...   Regards,   Erik

Goal: To have a gallery that downloads images from the folder I previously uploaded to in a previous script.

Bug: When I load the page the thumbnail comes up as broken and when I click on the thumbnail to get the bigger picture it comes up with the following error message:

"Firefox doesn't know how to open this address, because the protocol (c) isn't associated with any program."


<?php
include 'db.inc.php';
//connect to MySQL
$db = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD) or 
    die ('Unable to connect. Check your connection parameters.');
mysql_select_db(MYSQL_DB, $db) or die(mysql_error($db));

//change this path to match your images directory
$dir ='C:/x/xampp/htdocs/images';

//change this path to match your thumbnail directory
$thumbdir = $dir . '/thumbs';
?>
<html>
 <head>
  <title>Welcome to our Photo Gallery</title>
  <style type="text/css">
   th { background-color: #999;}
   .odd_row { background-color: #EEE; }
   .even_row { background-color: #FFF; }
  </style>
 </head>
 <body>
  <p>Click on any image to see it full sized.</p>
  <table style="width:100%;">
   <tr>
    <th>Image</th>
    <th>Caption</th>
    <th>Uploaded By</th>
    <th>Date Uploaded</th>
   </tr>
<?php
//get the thumbs
$result = mysql_query('SELECT * FROM images') or die(mysql_error());

$odd = true;
while ($rows = mysql_fetch_array($result)) {
    echo ($odd == true) ? '<tr class="odd_row">' : '<tr class="even_row">';
    $odd = !$odd; 
    extract($rows);
    echo '<td><a href="' . $dir . '/' . $image_id . '.jpg">';
    echo '<img src="' . $thumbdir . '/' . $image_id . '.jpg">';
    echo '</a></td>';
    echo '<td>' . $image_caption . '</td>';
    echo '<td>' . $image_username . '</td>';
    echo '<td>' . $image_date . '</td>';
    echo '</tr>';
}
?>
  </table>
 </body>
</html>


Any help appreciated.

I wanted to store a link in the db and display the same link on the front end which will take me to the site.

i tried with href but i get some string error.

Also i wanted to add a youtube embed tag to display it again on query to the db.

in short is  possible to store the url in the db  and display the same url.

thanks