Problems with viewing images

HeinekenBeer

Hey all...

Im having some large problems with some codes which should be easy. Im trying to put in an images which are pulled out of the database. The code im using is the following:

I have created the map images in the main folder on the webserver.

The whole code is as following:

$result = mysql_query("SELECT pl_id, pl_name, pl_pos, pl_pic, pl_shirt FROM squad ORDER BY pl_shirt");

while ($row = mysql_fetch_array($result))
{
$pl_shirt = $row['pl_shirt'];
$pl_pic = $row['pl_pic'];
$pl_id = $row['pl_id'];
$pl_name = $row['pl_name'];
$pl_pos = $row['pl_pos'];

$pl_details .=<<<SIF
<tr align='left'>
<td><IMG SRC='../images/".$pl_pic."' WIDTH='30' HEIGHT='30' ALT=''></td>
<td>$pl_shirt</td>
<td><a href='squad_details.php?pl_id=$pl_id'title='Klik her, for at få mere info om $pl_name'>$pl_name</a></td>
<td>$pl_pos</td>
</tr>
<tr>
<td colspan='4'>
<hr width="400" size="1" noshade>
</td>
</tr>

Again im trying to put in a picture from the pl_pic table in the database.

I really hope you can help me out.

HeinekenBeer

barand

Setting $pl_pic = 'aaa.gif', then viewing the generated source shows

<td><IMG SRC='../images/".aaa.gif."' WIDTH='30' HEIGHT='30' ALT=''></td>

HeinekenBeer

I can't just direct the code directly to the images, then the same image shows allover.

I need the code to the picture from what ever id nr it has.

barand

It's part of process called "debugging".

I wanted to run your code so I could see the HTML source that it generated. I could have created a duplicated of your database table but is was a little easier just to hard-code in a value and see what came out.

If you bother to look at the generated html you will see the img tag's src value is garbage.

HeinekenBeer

Yep i know its is garbage. Thats why im looking for a code which can perform the action i want, because i know that the code that i have now doesn't work in any way.

So im looking for a code that can show an image from its id number. The code doesn't have to have anything to do with my former code.

barand

Because you are inside a heredoc block, the concatenation operator (.) and double quotes are taken as part of the text, so take them out.

$pl_details .=<<<SIF
<tr align='left'>
<td><IMG SRC='../images/$pl_pic' WIDTH='30' HEIGHT='30' ALT=''></td>
<td>$pl_shirt</td>
<td><a href='squad_details.php?pl_id=$pl_id'title='Klik her, for at få mere info om $pl_name'>$pl_name</a></td>
<td>$pl_pos</td>
</tr>
<tr>
<td colspan='4'>
<hr width="400" size="1" noshade>
</td>
</tr>
SIF;

HeinekenBeer

Im really greatful that you are trying to help me, but it still doesn't work. Its propperly just me, who are doing something wrong.

Here a link to the homepage: http://88.212.66.150/squad.php

Here you can see that the images isn't shown. Maybe im doing something wrong in the database?

HeinekenBeer

The whole code is here, if it can help in any way:

<html>
<body>
<?php
require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";

include LOCALE.LOCALESET."squad.php";
include('mysql_connect.php');

$pl_header .=<<<SIF
<table width='100%' class='main-body'>
<tr>
<td>
<table width='100%'>
<tr align='left' class='table-cellpic'>
<th colspan='3'>Spillertrup 2006/2007</th>
</tr>
</table>

<table width='40%' align='left' cellpadding='2' cellspacing='2'>

    <tr align='left'>
        <td></td>
        <th>Nr.</th>
        <th>Navn</th>
        <th>Position</th>
    </tr>

SIF;

$result = mysql_query("SELECT pl_id, pl_name, pl_pos, pl_pic, pl_shirt FROM squad ORDER BY pl_shirt");

while ($row = mysql_fetch_array($result))
{
    $pl_shirt = $row['pl_shirt'];
    $pl_pic = $row['pl_pic'];
    $pl_id = $row['pl_id'];
    $pl_name = $row['pl_name'];
	$pl_pos = $row['pl_pos'];

$pl_details .=<<<SIF
<tr align='left'>
<td><IMG SRC='../images/'.$pl_pic.'' WIDTH='30' HEIGHT='30' ALT=''></td>
<td>$pl_shirt</td>
<td><a href='squad_details.php?pl_id=$pl_id'title='Klik her, for at få mere info om $pl_name'>$pl_name</a></td>
<td>$pl_pos</td>
</tr>
<tr>
<td colspan='4'>
<hr width="400" size="1" noshade>
</td>
</tr>

SIF;
}

$pl_footer = "</table></td></tr></table>";

$player=<<<PLAYER
$pl_header
$pl_details
$pl_footer

PLAYER;

echo $player;

require_once "side_right.php";
require_once "footer.php";
?>

</body>
</html>

barand

You are still showing the wrong img src value.

HeinekenBeer

It works! thanks alot mate.... it really helped alot......