[Resolved] Images and URL links

[dcjones]

Hi all,

I am going out of my mind with this problem.

In a table with a number of records, each record has its own image assoicated with it. In the table I have a feild which holds the path to the image for that record.

The image displays on the screen with on problem. How can I create a link to another site useing the image as the command button.

This is a part of the script that displays the image.

<img src="<?php echo $row_DetailRS1['book_image']; ?>">

I am useing "book_image" feild to hold the image and "book_url" feild to hold the URl to the other site.

Can anyone help please.

Kind regards, keep safe and well.

Dereck

[dcjones]

Hi all.

I have been playing round with the following code:

<a href="<?php echo $row_record_detail['amazon_url']; ?>" target="_blank"><img src="<?php echo $row_DetailRS1['book_image']; ?>" border="0"></a></div></td>

This does not work.

where am i going wronge.

Thanks

Dereck

[lazzerous]

the code you've posted looks fine - we'll need to see the chunk of code you have calling the data used

[dcjones]

Hi and thanks for your reply.

Below is the code that calls the data:

<?php require_once('../Connections/Chandos.php'); ?>
<?php

mysql_select_db($database_Chandos, $Chandos);
$query_record_detail = "SELECT * FROM chandos_books";
$record_detail = mysql_query($query_record_detail, $Chandos) or die(mysql_error());
$row_record_detail = mysql_fetch_assoc($record_detail);
$totalRows_record_detail = mysql_num_rows($record_detail);

$maxRows_DetailRS1 = 4;
$pageNum_DetailRS1 = 0;
if (isset($_GET['pageNum_DetailRS1'])) {
  $pageNum_DetailRS1 = $_GET['pageNum_DetailRS1'];
}
$startRow_DetailRS1 = $pageNum_DetailRS1 * $maxRows_DetailRS1;

mysql_select_db($database_Chandos, $Chandos);
$recordID = $_GET['recordID'];
$query_DetailRS1 = "SELECT * FROM chandos_books WHERE book_title = '$recordID'";
$query_limit_DetailRS1 = sprintf("%s LIMIT %d, %d", $query_DetailRS1, $startRow_DetailRS1, $maxRows_DetailRS1);
$DetailRS1 = mysql_query($query_limit_DetailRS1, $Chandos) or die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);
$request = mysql_fetch_assoc($DetailRS1);

Many thanks for looking at this post

Dereck

[dcjones]

Hi All,

Anyone out there that can give me some help with this post

Kind regards

Dereck

[dcjones]

Hi all,

I am still trying to sort this problem out. I am useing the following code which I think is correct.

<a href="<?php echo $row_record_detail['amazon_url']; ?>" target="_blank"><img src="<?php echo $row_DetailRS1['book_image']; ?>" border="0"></a>

When i load the page and click on the image the "href" shows the URL to my site "http://www.mydomain.com/catalogue" and not the URL stored in "amazon_url".

Does anyone know what is going on and what I am doing wronge.

Kind regards

Dereck

[tsinka]

Hi,

if you load the page in your browser and view the source of the page ... how does the a href look like ?

Thomas

[dcjones]

Hi Thomas,

I have had a look at the source code and the href is blank. This tells me that the script is not pulling the content of the feild from the database. But why.

I changed the code to look like "

<td rowspan="3" valign="top" class="bodytext"><div align="right"><a href="?<?php echo $row_record_detail['amazon_url']; ?>=<?php echo $row_record_detail['amazon_url']; ?>" target="_blank"><img src="<?php echo $row_DetailRS1['book_image']; ?>" alt="Order" width="51" height="71" border="0"></a></div></td>

and the result is the source code now looks like:

<td rowspan="3" valign="top" class="bodytext"><div align="right"><a href="?=" target="_blank"><img src="bookcovers/a_librarians_guide_to_the_internet.gif" alt="Order" width="51" height="71" border="0"></a></div></td>

and the href is ?=

any ideas as to where I go now.

Kind regards, keep safe and well.

Dereck

[Weedpacket]

Well, you say it's not pulling the record from the database - have you checked to make sure that there's something in the database for it to get out? The amazon_url field in the database might be empty for some reason.

[tsinka]

Hi,

i looked at your code an the last two lines look suspicious ...

$row_DetailRS1 = mysql_fetch_assoc($DetailRS1); 
$request = mysql_fetch_assoc($DetailRS1); 

I can't see where $request is used ... besides that mysql_fetch_assoc fetches just one row so it would be better to do something like e.g.

<?PHP
while ($row_DetailRS1 = mysql_fetch_array($DetailRS1) {
?>
  <td rowspan="3" valign="top" class="bodytext">
    <div align="right">
      <a href="?<?php echo $row_DetailRS1['amazon_url']; ?>=<?php echo $row_DetailRS1['amazon_url']; ?>" target="_blank"><img src="<?php echo $$row_DetailRS1['book_image']; ?>" alt="Order" width="51" height="71" border="0"></a>
    </div>
  </td>
<?PHP
}
?>

To check the row data you might want use print_r($row_DetailRS1); inside the while loop.

It might help if you post the complete code if it isn't too much ...

Thomas

[dcjones]

Hi and a big thanks for looking at the code.

I will study the code and let you know if I get the thing to work.

Thanks for your time.

Keep safe and well

Dereck

[dcjones]

Hi, thanks again for looking at the code. I have rewritten the complete page. and now it works.

Thank you all.

Keep safe and well

Dereck

<?php require_once('../Connections/Chandos.php'); ?><?php
$maxRows_DetailRS1 = 1;
$pageNum_DetailRS1 = 0;
if (isset($_GET['pageNum_DetailRS1'])) {
  $pageNum_DetailRS1 = $_GET['pageNum_DetailRS1'];
}
$startRow_DetailRS1 = $pageNum_DetailRS1 * $maxRows_DetailRS1;

$colname_DetailRS1 = "1";
if (isset($_GET['category'])) {
  $colname_DetailRS1 = (get_magic_quotes_gpc()) ? $_GET['category'] : addslashes($_GET['category']);
}
mysql_select_db($database_Chandos, $Chandos);
$recordID = $_GET['recordID'];
$query_DetailRS1 = sprintf("SELECT * FROM chandos_books  WHERE ID = $recordID", $colname_record_filter);
$query_limit_DetailRS1 = sprintf("%s LIMIT %d, %d", $query_DetailRS1, $startRow_DetailRS1, $maxRows_DetailRS1);
$DetailRS1 = mysql_query($query_limit_DetailRS1, $Chandos) or die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);

if (isset($_GET['totalRows_DetailRS1'])) {
  $totalRows_DetailRS1 = $_GET['totalRows_DetailRS1'];
} else {
  $all_DetailRS1 = mysql_query($query_DetailRS1);
  $totalRows_DetailRS1 = mysql_num_rows($all_DetailRS1);
}
$totalPages_DetailRS1 = ceil($totalRows_DetailRS1/$maxRows_DetailRS1)-1;

SOME HTML *****

              <tr>
                <td width="124" class="formcolheadersmall"><div align="left">Title</div></td>
                <td class="bodytext"><div align="left"><?php echo $row_DetailRS1['book_title']; ?></div></td>
                <td class="bodytext"><div align="right"></div></td>
              </tr>
              <tr>
                <td class="formcolheadersmall"><div align="left"></div></td>
                <td colspan="2" class="bodytext"></td>
              </tr>
              <tr>
                <td class="formcolheadersmall">&nbsp;</td>
                <td colspan="2" class="bodytext"><?php echo $row_DetailRS1['sub_title']; ?></td>
              </tr>
              <tr>
                <td class="formcolheadersmall">&nbsp;</td>
                <td class="bodytext"></td>
                <td rowspan="5" class="bodytext"><div align="right"> <a href="<?php echo $row_DetailRS1['amazon_url'];?>" target="_blank"><img src="<?php echo $row_DetailRS1['book_image'];?>" border="0"></a></div></td>
              </tr>
              <tr>
                <td class="formcolheadersmall"><div align="left">Author</div></td>
                <td class="bodytext"><div align="left"> </div>
                    <div align="left"><?php echo $row_DetailRS1['author_name']; ?></div></td>
              </tr>
              <tr>
                <td class="formcolheadersmall">&nbsp;</td>
                <td class="bodytext">&nbsp;</td>
              </tr>
              <tr>
                <td class="formcolheadersmall"><div align="left"></div></td>
                <td valign="top" class="bodytext"><div align="left"><?php echo $row_DetailRS1['author_summary']; ?> </div></td>
              </tr>
              <tr>
                <td class="formcolheadersmall">&nbsp;</td>
                <td valign="top" class="bodytext">&nbsp;</td>
              </tr>
              <tr>
                <td valign="top" class="formcolheadersmall">Summary</td>
                <td colspan="2" class="bodytext"><?php echo $row_DetailRS1['book_summary_short']; ?></td>
              </tr>
              <tr>
                <td valign="top" class="formcolheadersmall">&nbsp;</td>
                <td colspan="2" class="bodytext">&nbsp;</td>
              </tr>
          <td valign="top" class="formcolheadersmall"><div align="left">Readership</div></td>
              <td colspan="2" class="bodytext"><div align="left"><?php echo $row_DetailRS1['readership']; ?> </div></td>
          </tr><tr>
            <td valign="top" class="formcolheadersmall">&nbsp;</td>
            <td colspan="2" class="bodytext">&nbsp;</td>
          </tr>
          <tr>
            <td valign="top" class="formcolheadersmall"><div align="left">Key
                features </div></td>
            <td colspan="2" class="bodytext"><div align="left">
			<? 
			mysql_select_db($database_Chandos, $Chandos); 
			$recordID = $_GET['recordID'];     
			$query_DetailRS1 = mysql_query("SELECT * FROM chandos_books WHERE book_title = '$recordID'");  
			$row = mysql_fetch_array($query_DetailRS1);  
			$broken = explode("*", $row['key_features']);  
			$countbroken = count($broken);  
			echo "<uL>";  
			FOR($i = 0; $i < $countbroken; $i++){  
			  echo "<LI>".$broken[$i]."</LI>";  
			}  
			echo "</uL>"; 
			?>
			</div></td>
          </tr>
          <tr>
            <td valign="top" class="formcolheadersmall">&nbsp;</td>
            <td colspan="2" class="bodytext">&nbsp;</td>
          </tr>
          <tr>
            <td valign="top" class="formcolheadersmall"><div align="left">Content</div></td>
            <td colspan="2" class="bodytext"><div align="left"><?php echo $row_DetailRS1['content']; ?> </div></td>
          </tr>
          <tr>
            <td valign="top" class="formcolheadersmall">&nbsp;</td>
            <td colspan="2" class="bodytext">&nbsp;</td>
          </tr>
          <tr>
            <td class="formcolheadersmall"><div align="left">Publication</div></td>
            <td colspan="2" class="bodytext"><div align="left"><?php echo $row_DetailRS1['published_date']; ?> </div></td>
          </tr>
          <tr>
            <td class="formcolheadersmall">&nbsp;</td>
            <td colspan="2" class="bodytext">&nbsp;</td>
          </tr>
          <tr>
            <td class="formcolheadersmall"><div align="left">Pages</div></td>
            <td colspan="2" class="bodytext"><div align="left"><?php echo $row_DetailRS1['pages']; ?> </div></td>
          </tr>
          <tr>
            <td class="formcolheadersmall">&nbsp;</td>
            <td colspan="2" class="bodytext">&nbsp;</td>
          </tr>
          <tr>
            <td class="formcolheadersmall"><div align="left">Size</div></td>
            <td colspan="2" class="bodytext"><div align="left"><?php echo $row_DetailRS1['size']; ?> </div></td>
          </tr>
          <tr>
            <td class="formcolheadersmall">&nbsp;</td>
            <td colspan="2" class="bodytext">&nbsp;</td>
          </tr>
          <tr>
            <td class="formcolheadersmall"><div align="left">ISBN (paperback) </div></td>
            <td width="268" class="bodytext"><div align="left"><?php echo $row_DetailRS1['isbn_paperback']; ?></div></td>
            <td width="173" class="bodytext"><div align="left"><span class="formcolheadersmall">Price </span>&pound; <?php echo $row_DetailRS1['price_paperback']; ?></div></td>
          </tr>
          <tr>
            <td class="formcolheadersmall"><div align="left">ISBN (hardback) </div></td>
            <td class="bodytext"><div align="left"><?php echo $row_DetailRS1['isbn_hardback']; ?></div></td>
            <td class="bodytext"><div align="left"><span class="formcolheadersmall">Price </span>&pound; <?php echo $row_DetailRS1['price_hardback']; ?></div></td>
          </tr>
          <tr>
            <td class="formcolheadersmall">&nbsp;</td>
            <td class="bodytext">&nbsp;</td>
            <td class="bodytext">&nbsp;</td>
          </tr>
          <tr>
            <td class="formcolheadersmall"><a href="#TOP">Order</a></td>
            <td class="bodytext"><?php echo $row_DetailRS1['category']; ?></td>
            <td class="bodytext">&nbsp;</td>
          </tr>
          <tr>
            <td class="formcolheadersmall"><a href="<?php echo $row_DetailRS1['amazon_url'];?>" target="_blank">TEST ORDER</a>