Grrrrrr image display code broken?!?!?

MichaelCS

So I've learned a lot in the last 2 days from you guys on here and I appreciate it greatly! Ya'll are making this project go by much easier and faster...

I looked up on the web how to display an image using a url stored in the database (the field is a text type and I just stored the url as "/images/website/placeholder.jpg")

The problem I am running in to is a bad parse error or synatx. What am I missing? I copied and pasted the added codes from here...

http://php.about.com/od/phpwithmysql/ss/Upload_file_sql_4.htm

Here is my final code for this section of the page (although I repeat this same process in 3 more tables after it).

<?php

//MySQL Database Connect
 include 'connect.php'; 

// First create an html table
echo '<table border="0" cellpadding="1">

   <tr>
      <th> </th>
      <th> </th>
      <th> </th>
      <th> </th>
      <th> </th>
    </tr>';
// Create a loop to get one row of the returned data at once:

$result = mysql_query("SELECT * FROM ArticleData ORDER BY date DESC LIMIT 0, 1");
$data = mysql_query("SELECT * FROM ArticleData") or die(mysql_error()); 

while($info = mysql_fetch_array( $data ))  { 

while( $row = mysql_fetch_assoc($result) ) {

// while continues util the evaluation in () is false
// $row will contain a single row of data say: ID=1,name=Dero,type=BA,code=1234
// each peice of information will be available thru array keys IE $row['id'] will give me the value of 1
// now start printing this information to the browser with a link to the user's profile where their name is
echo '<tr>
   <td><a href="Article.php?id='. $row['id'] .'"> Echo <img src=/images/website/".$info['image'] ."></a></td>
   <td width="15"> </td>
   <td>'. $row['description'] .'</td>
   <td width="15"> </td>
   <td>'. $row['date'] .'</td>
</td>';

//close the loop
}

// end the html table
echo '</table>';
?>

NogDog

You have some single/double quote issues in this echo statement (corrected version shown here):

echo '<tr>
   <td><a href="Article.php?id='. $row['id'] .'"> Echo <img src="/images/website/'.$info['image'] . '"></a></td>
   <td width="15"> </td>
   <td>'. $row['description'] .'</td>
   <td width="15"> </td>
   <td>'. $row['date'] .'</td>
</td>';

MichaelCS

Using that code you gave me (cut and pasted it)

I get the following error...

Parse error: syntax error, unexpected $end in /home/hadean/www/www/Index3.php on line 413

Line 413 is the end of the file with this...

</html>

NogDog

Make sure you have a closing "}" for each opening "{".

MichaelCS

NogDog;10980586 wrote:
Make sure you have a closing "}" for each opening "{".

Ah, I think I found it... In the code under the WHILE string I had two of these "{" so one of them was never closed...

Here is the new code but now the problem is it displays the word ECHO in that cell LOL

<?php

//MySQL Database Connect
include 'connect.php';

// First create an html table
echo '<table border="0" cellpadding="1">

   <tr>
      <th> </th>
      <th> </th>
      <th> </th>
      <th> </th>
      <th> </th>
    </tr>';
// Create a loop to get one row of the returned data at once:

$result = mysql_query("SELECT * FROM ArticleData ORDER BY date DESC LIMIT 0, 1");
$data = mysql_query("SELECT * FROM ArticleData") or die(mysql_error());

while($info = mysql_fetch_array($data)) 

while($row = mysql_fetch_assoc($result)) {

// while continues util the evaluation in () is false
// $row will contain a single row of data say: ID=1,name=Dero,type=BA,code=1234
// each peice of information will be available thru array keys IE $row['id'] will give me the value of 1
// now start printing this information to the browser with a link to the user's profile where their name is
echo '<tr>
   <td><a href="Article.php?id='. $row['id'] .'"> Echo <img src="/images/website/'.$info['image'] . '"></a></td>
   <td width="15"> </td>
   <td>'. $row['description'] .'</td>
   <td width="15"> </td>
   <td>'. $row['date'] .'</td>
</td>'; 

//close the loop
}

// end the html table
echo '</table>';
?>

Check out http://www.hadean.org/Index3.php

You see the top "Featured Story"? It says ECHO where there should be an image.

laserlight

If you look carefully at the string, you will see that it displays "Echo" because you wrote "Echo" before the image element.

MichaelCS

Thanks LaserLight,

You are correct. For some reason that was written in there!!!

I have removed it and now everything is working correctly for displaying the images guys thanks!!!! I've even got the images mated to the articles in descending order based on time date.

Wow, you can learn a lot from these sites LOL who knew 😛