php mysql query and display results problem

Question

I am trying to query the mysql DB and if there is a picture for the record I would like to have that image displayed. If there is no picture associated with the record then there should be no image displayed and no broken image link showing on the page.

    if ($data['picture'] > 0)
    {
    echo "<td><img style='float: left; padding: 2px 7px 2px 0px;' src='../images/pictures/' .'"$data['picture']"'. .'"$data['message']"'. .'</td>
                          </tr>'";
    }
  else
    {
    echo ".'<td>'. .'"$data['message']"'. .'</td>
                          </tr>'";
                          }

I'm sure it's something pretty small that I'm missing but I cannot seem to find the problem.

Currently this page returns a 500 error when I try to view the page.

'500' errors get logged in the server's error_log - the basic 500 error page is intentionally sparse on details. Check the log and you'll get much more info as to what really went wrong. — Marc B
– Marc B, Commented Jan 24, 2011 at 21:23

jb1785 · Accepted Answer · 2011-01-24 20:39:54Z

1

I think you need to add some more code in order to determine what the 500 error is from. But I can tell you that you are including your array vars incorrectly in the html strings. The correct way to echo an array var in a string is:

echo "<td>html html".$phpCode['array']." html html</td>";

answered Jan 24, 2011 at 20:39

jb1785

7421 gold badge7 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nanne · Accepted Answer · 2011-01-24 20:38:14Z

0

I'd assume it would be something else, like a htaccess problem. Trouble in php usually doesn't turn into a http 500 server error.

Is all your .htacces code ok? What does your log say?

answered Jan 24, 2011 at 20:38

Nanne

64.4k16 gold badges122 silver badges166 bronze badges

Comments

gen_Eric · Accepted Answer · 2011-01-24 20:40:53Z

0

Your quotes and concatenation are all wrong.

echo ".'<td>'. .'"$data['message']"'. .'</td>
                          </tr>'";

Should be

echo '<td>'.$data['message'].'</td></tr>';

And

echo "<td>
      <img style='float: left; padding: 2px 7px 2px 0px;' src='../images/pictures/' 
      .'"$data['picture']"'. .'"$data['message']"'. .'</td>
                          </tr>'";

Should be:

echo "<td>
      <img style='float: left; padding: 2px 7px 2px 0px;' src='../images/pictures/'" 
      .$data['picture'].$data['message']."</td></tr>";

You also need to make sure you close your <img> tag.

answered Jan 24, 2011 at 20:40

gen_Eric

228k42 gold badges304 silver badges343 bronze badges

Collectives™ on Stack Overflow

php mysql query and display results problem

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related