когато няма картинка

DangerM

Registered
Може ли да ми кажете как когато няма картинка на мястото да надписа No Picture да изкара картинка с текст няма аватар ето моя код
Код:
<? 
if (eregi("modules/songs/play.php", $_SERVER['SCRIPT_NAME'])) { die ("Access Denied"); }
?>
<b>
<style type="text/css">
.borderc2 {
border: 1px #CCCCCC solid;
}

.borderc2 h1 {
font-size: 12px;
font-weight: bold;
margin: 0;
}

.borderc2 a {
color: #0099FF;
font-weight: bold;
}

.borderc2 a:hover {
color: #FF0030;
font-weight: bold;
}
</style>
<?php 
include("settings.php");
$user = $_GET['username']; 
$sql = mysql_query("SELECT * FROM `users` WHERE `username`='$user'"); 
$row = mysql_fetch_array($sql); 
$view = $row['views'];
$pic = $row['picture'];
?> 
</a>
<?
include("settings.php");
$newdown = $view + 1;
$sql3 = "UPDATE users SET views='$newdown' where username='$user'";
$ress = mysql_query($sql3);
?>
<table width="100%" border="0" cellpadding="2" cellspacing="2">
  <tbody><tr>
    <td colspan="3" class="borderc2">
	<h1>Потребител: <? echo $row[username]; ?></h1></td>
  </tr>
  <tr>
    <td class="borderc2" width="15%">
	Име:
	</td>
    <td class="borderc2" width="60%" align="left"><? echo $row['username']; ?></td>  
    <td rowspan="9" class="borderc2" width="70%" align="center">
<a href='send.php?id=<? echo $row[username]; ?>'>Изпрати съобщение!</a><br>
<?php 
if($_SESSION['username'])
{
$id=$_GET['id'];
echo '<a href="addfr.php?id='.$row[id].'">Добави в Приятели</a>';                                            }
?>

<img src="<? echo $row['picture']; ?>"  width = "200" height = "200" alt="No Picture" border="0"/><br/>


	  </td>

  <tr>


  <tr>
    <td class="borderc2" width="15%">
	Години:
	</td>
    <td class="borderc2" width="60%" align="left"><? echo $row['age']; ?></td>
	</td>
  </tr>
  <tr>
    <td class="borderc2" width="15%">
	Пол:
	</td>
    <td class="borderc2" width="60%" align="left"><? echo $row['sex']; ?></td>
	</td>
  </tr>
  <tr>
    <td class="borderc2" width="15%">
	Населено Място:
	</td>
    <td class="borderc2" width="60%" align="left"><? echo $row['location']; ?></td>

	</td>
  </tr>
  <tr>
    <td class="borderc2" width="30%">
	Девис:
	</td>
    <td class="borderc2" width="100%" align="left"><? echo $row['signature']; ?></td>
	</td>
  </tr>
  <tr>
    <td class="borderc2" width="30%">
	Интереси:
	</td>
    <td class="borderc2" width="100%" align="left"><? echo $row['interests']; ?></td>
	</td>
  </tr>
  <tr>
    <td class="borderc2" width="15%">
	Профилът е прегледан:
	</td>
    <td class="borderc2" width="60%" align="left"><? echo $newdown; ?></td>
	</td>
  </tr>
  <tr>
    <td class="borderc2">
	Качени песни:
	</td>
    <td class="borderc2" align="left">
	<b><? echo $row['uploads']; ?></b>	</td>
  </tr>
  <tr>
    <td class="borderc2">
	Емайл:
	</td>
    <td class="borderc2" align="left">
	<b><a href="mailto:<? echo $row[email]; ?>"><? echo $row[email]; ?></a></b>	</td>
  </tr>
  <tr>
    <td class="borderc2">
	Skype:
	</td>
    <td class="borderc2" align="left">
	<div class="playads">
	<a href="skype:<? echo $row[skype]; ?>?call"><? echo $row[skype]; ?></a></td>
  </tr>


	

	</div>
	</td>
  </tr>
</tbody></table>
</b>

Благодаря предварително +1
 
Така?

<?
if (eregi("modules/songs/play.php", $_SERVER['SCRIPT_NAME'])) { die ("Access Denied"); }
?>
<b>
<style type="text/css">
.borderc2 {
border: 1px #CCCCCC solid;
}

.borderc2 h1 {
font-size: 12px;
font-weight: bold;
margin: 0;
}

.borderc2 a {
color: #0099FF;
font-weight: bold;
}

.borderc2 a:hover {
color: #FF0030;
font-weight: bold;
}
</style>
<?php
include("settings.php");
$user = $_GET['username'];
$sql = mysql_query("SELECT * FROM `users` WHERE `username`='$user'");
$row = mysql_fetch_array($sql);
$view = $row['views'];
$pic = $row['picture'];
?>
</a>
<?
include("settings.php");
$newdown = $view + 1;
$sql3 = "UPDATE users SET views='$newdown' where username='$user'";
$ress = mysql_query($sql3);
?>
<table width="100%" border="0" cellpadding="2" cellspacing="2">
<tbody><tr>
<td colspan="3" class="borderc2">
<h1>Потребител: <? echo $row[username]; ?></h1></td>
</tr>
<tr>
<td class="borderc2" width="15%">
Име:
</td>
<td class="borderc2" width="60%" align="left"><? echo $row['username']; ?></td>
<td rowspan="9" class="borderc2" width="70%" align="center">
<a href='send.php?id=<? echo $row[username]; ?>'>Изпрати съобщение!</a><br>
<?php
if($_SESSION['username'])
{
$id=$_GET['id'];
echo '<a href="addfr.php?id='.$row[id].'">Добави в Приятели</a>'; }
?>

<?php
if($row['picture']===NULL)
{
echo '<img src="http://bgbirds.com/forum/images/no_avatar.png" idth = "200" height = "200" border="0"><br />';
}
else
{
echo $row['picture'];
}
?>

</td>

<tr>


<tr>
<td class="borderc2" width="15%">
Години:
</td>
<td class="borderc2" width="60%" align="left"><? echo $row['age']; ?></td>
</td>
</tr>
<tr>
<td class="borderc2" width="15%">
Пол:
</td>
<td class="borderc2" width="60%" align="left"><? echo $row['sex']; ?></td>
</td>
</tr>
<tr>
<td class="borderc2" width="15%">
Населено Място:
</td>
<td class="borderc2" width="60%" align="left"><? echo $row['location']; ?></td>

</td>
</tr>
<tr>
<td class="borderc2" width="30%">
Девис:
</td>
<td class="borderc2" width="100%" align="left"><? echo $row['signature']; ?></td>
</td>
</tr>
<tr>
<td class="borderc2" width="30%">
Интереси:
</td>
<td class="borderc2" width="100%" align="left"><? echo $row['interests']; ?></td>
</td>
</tr>
<tr>
<td class="borderc2" width="15%">
Профилът е прегледан:
</td>
<td class="borderc2" width="60%" align="left"><? echo $newdown; ?></td>
</td>
</tr>
<tr>
<td class="borderc2">
Качени песни:
</td>
<td class="borderc2" align="left">
<b><? echo $row['uploads']; ?></b> </td>
</tr>
<tr>
<td class="borderc2">
Емайл:
</td>
<td class="borderc2" align="left">
<b><a href="mailto:<? echo $row; ?>"><? echo $row[email]; ?></a></b> </td>
</tr>
<tr>
<td class="borderc2">
Skype:
</td>
<td class="borderc2" align="left">
<div class="playads">
<a href="skype:<? echo $row[skype]; ?>?call"><? echo $row[skype]; ?></a></td>
</tr>




</div>
</td>
</tr>
</tbody></table>
</b>[/quote]
 
ами не http://85.255.164.46/images/avatars/1379602Q.jpg само това пише и не се показва и на тези който имат
 
Вместо $row['picture'] можеш да използваш променливата, която си дефинирал $pic. Предполагам полето за аватар е празно, ако потребителя няма аватар. Ако съм прав, променливата можеш да я промениш така

Код:
$pic = (!empty($row['picture'])) ? '<img src="' . $row['picture'] . '" width = "200" height = "200" alt="No Picture" border="0" />' : 'Няма аватар.';

Целия код

Код:
 <?
if (eregi("modules/songs/play.php", $_SERVER['SCRIPT_NAME'])) { die ("Access Denied"); }
?>
<b>
<style type="text/css">
.borderc2 {
border: 1px #CCCCCC solid;
}

.borderc2 h1 {
font-size: 12px;
font-weight: bold;
margin: 0;
}

.borderc2 a {
color: #0099FF;
font-weight: bold;
}

.borderc2 a:hover {
color: #FF0030;
font-weight: bold;
}
</style>
<?php
include("settings.php");
$user = $_GET['username'];
$sql = mysql_query("SELECT * FROM `users` WHERE `username`='$user'");
$row = mysql_fetch_array($sql);
$view = $row['views'];
//$pic = $row['picture'];
$pic = (!empty($row['picture'])) ? '<img src="' . $row['picture'] . '" width = "200" height = "200" alt="No Picture" border="0" />' : 'Няма аватар.';
?>
</a>
<?
include("settings.php");
$newdown = $view + 1;
$sql3 = "UPDATE users SET views='$newdown' where username='$user'";
$ress = mysql_query($sql3);
?>
<table width="100%" border="0" cellpadding="2" cellspacing="2">
  <tbody><tr>
    <td colspan="3" class="borderc2">
   <h1>Потребител: <? echo $row[username]; ?></h1></td>
  </tr>
  <tr>
    <td class="borderc2" width="15%">
   Име:
   </td>
    <td class="borderc2" width="60%" align="left"><? echo $row['username']; ?></td> 
    <td rowspan="9" class="borderc2" width="70%" align="center">
<a href='send.php?id=<? echo $row[username]; ?>'>Изпрати съобщение!</a><br>
<?php
if($_SESSION['username'])
{
$id=$_GET['id'];
echo '<a href="addfr.php?id='.$row[id].'">Добави в Приятели</a>';                                            }
?>

<img src="<? echo $pic; ?>"  width = "200" height = "200" alt="No Picture" border="0"/><br/>


     </td>

  <tr>


  <tr>
    <td class="borderc2" width="15%">
   Години:
   </td>
    <td class="borderc2" width="60%" align="left"><? echo $row['age']; ?></td>
   </td>
  </tr>
  <tr>
    <td class="borderc2" width="15%">
   Пол:
   </td>
    <td class="borderc2" width="60%" align="left"><? echo $row['sex']; ?></td>
   </td>
  </tr>
  <tr>
    <td class="borderc2" width="15%">
   Населено Място:
   </td>
    <td class="borderc2" width="60%" align="left"><? echo $row['location']; ?></td>

   </td>
  </tr>
  <tr>
    <td class="borderc2" width="30%">
   Девис:
   </td>
    <td class="borderc2" width="100%" align="left"><? echo $row['signature']; ?></td>
   </td>
  </tr>
  <tr>
    <td class="borderc2" width="30%">
   Интереси:
   </td>
    <td class="borderc2" width="100%" align="left"><? echo $row['interests']; ?></td>
   </td>
  </tr>
  <tr>
    <td class="borderc2" width="15%">
   Профилът е прегледан:
   </td>
    <td class="borderc2" width="60%" align="left"><? echo $newdown; ?></td>
   </td>
  </tr>
  <tr>
    <td class="borderc2">
   Качени песни:
   </td>
    <td class="borderc2" align="left">
   <b><? echo $row['uploads']; ?></b>   </td>
  </tr>
  <tr>
    <td class="borderc2">
   Емайл:
   </td>
    <td class="borderc2" align="left">
   <b><a href="mailto:<? echo $row[email]; ?>"><? echo $row[email]; ?></a></b>   </td>
  </tr>
  <tr>
    <td class="borderc2">
   Skype:
   </td>
    <td class="borderc2" align="left">
   <div class="playads">
   <a href="skype:<? echo $row[skype]; ?>?call"><? echo $row[skype]; ?></a></td>
  </tr>


   

   </div>
   </td>
  </tr>
</tbody></table>
</b>
 
когато сложа този код
Код:
	  <?
if (eregi("modules/songs/play.php", $_SERVER['SCRIPT_NAME'])) { die ("Access Denied"); }
?>
<b>
<style type="text/css">
.borderc2 {
border: 1px #CCCCCC solid;
}

.borderc2 h1 {
font-size: 12px;
font-weight: bold;
margin: 0;
}

.borderc2 a {
color: #0099FF;
font-weight: bold;
}

.borderc2 a:hover {
color: #FF0030;
font-weight: bold;
}
</style>
<?php
include("settings.php");
$user = $_GET['username'];
$sql = mysql_query("SELECT * FROM `users` WHERE `username`='$user'");
$row = mysql_fetch_array($sql);
$view = $row['views'];
//$pic = $row['picture'];
$pic = (!empty($row['picture'])) ? '<img src="' . $row['picture'] . '" width = "200" height = "200" alt="No Picture" border="0" />' : 'Няма аватар.';
?>
</a>
<?
include("settings.php");
$newdown = $view + 1;
$sql3 = "UPDATE users SET views='$newdown' where username='$user'";
$ress = mysql_query($sql3);
?>
<table width="100%" border="0" cellpadding="2" cellspacing="2">
  <tbody><tr>
    <td colspan="3" class="borderc2">
   <h1>Потребител: <? echo $row[username]; ?></h1></td>
  </tr>
  <tr>
    <td class="borderc2" width="15%">
   Име:
   </td>
    <td class="borderc2" width="60%" align="left"><? echo $row['username']; ?></td>
    <td rowspan="9" class="borderc2" width="70%" align="center">
<a href='send.php?id=<? echo $row[username]; ?>'>Изпрати съобщение!</a><br>
<?php
if($_SESSION['username'])
{
$id=$_GET['id'];
echo '<a href="addfr.php?id='.$row[id].'">Добави в Приятели</a>';                                            }
?>

<img src="<? echo $pic; ?>"  width = "200" height = "200" alt="No Picture" border="0"/><br/>


     </td>

  <tr>


  <tr>
    <td class="borderc2" width="15%">
   Години:
   </td>
    <td class="borderc2" width="60%" align="left"><? echo $row['age']; ?></td>
   </td>
  </tr>
  <tr>
    <td class="borderc2" width="15%">
   Пол:
   </td>
    <td class="borderc2" width="60%" align="left"><? echo $row['sex']; ?></td>
   </td>
  </tr>
  <tr>
    <td class="borderc2" width="15%">
   Населено Място:
   </td>
    <td class="borderc2" width="60%" align="left"><? echo $row['location']; ?></td>

   </td>
  </tr>
  <tr>
    <td class="borderc2" width="30%">
   Девис:
   </td>
    <td class="borderc2" width="100%" align="left"><? echo $row['signature']; ?></td>
   </td>
  </tr>
  <tr>
    <td class="borderc2" width="30%">
   Интереси:
   </td>
    <td class="borderc2" width="100%" align="left"><? echo $row['interests']; ?></td>
   </td>
  </tr>
  <tr>
    <td class="borderc2" width="15%">
   Профилът е прегледан:
   </td>
    <td class="borderc2" width="60%" align="left"><? echo $newdown; ?></td>
   </td>
  </tr>
  <tr>
    <td class="borderc2">
   Качени песни:
   </td>
    <td class="borderc2" align="left">
   <b><? echo $row['uploads']; ?></b>   </td>
  </tr>
  <tr>
    <td class="borderc2">
   Емайл:
   </td>
    <td class="borderc2" align="left">
   <b><a href="mailto:<? echo $row[email]; ?>"><? echo $row[email]; ?></a></b>   </td>
  </tr>
  <tr>
    <td class="borderc2">
   Skype:
   </td>
    <td class="borderc2" align="left">
   <div class="playads">
   <a href="skype:<? echo $row[skype]; ?>?call"><? echo $row[skype]; ?></a></td>
  </tr>


   

   </div>
   </td>
  </tr>
</tbody></table>
</b>
изкарва това в секи профил и в този които има снимка
No Picture" width = "200" height = "200" alt="No Picture" border="0"/>
 
Код:
  <?
if (eregi("modules/songs/play.php", $_SERVER['SCRIPT_NAME'])) { die ("Access Denied"); }
?>
<b>
<style type="text/css">
.borderc2 {
border: 1px #CCCCCC solid;
}

.borderc2 h1 {
font-size: 12px;
font-weight: bold;
margin: 0;
}

.borderc2 a {
color: #0099FF;
font-weight: bold;
}

.borderc2 a:hover {
color: #FF0030;
font-weight: bold;
}
</style>
<?php
include("settings.php");
$user = $_GET['username'];
$sql = mysql_query("SELECT * FROM `users` WHERE `username`='$user'");
$row = mysql_fetch_array($sql);
$view = $row['views'];
//$pic = $row['picture'];
$pic = (!empty($row['picture'])) ? '<img src="' . $row['picture'] . '" width = "200" height = "200" alt="No Picture" border="0" />' : 'Няма аватар.';
?>
</a>
<?
include("settings.php");
$newdown = $view + 1;
$sql3 = "UPDATE users SET views='$newdown' where username='$user'";
$ress = mysql_query($sql3);
?>
<table width="100%" border="0" cellpadding="2" cellspacing="2">
  <tbody><tr>
    <td colspan="3" class="borderc2">
   <h1>Потребител: <? echo $row[username]; ?></h1></td>
  </tr>
  <tr>
    <td class="borderc2" width="15%">
   Име:
   </td>
    <td class="borderc2" width="60%" align="left"><? echo $row['username']; ?></td>
    <td rowspan="9" class="borderc2" width="70%" align="center">
<a href='send.php?id=<? echo $row[username]; ?>'>Изпрати съобщение!</a><br>
<?php
if($_SESSION['username'])
{
$id=$_GET['id'];
echo '<a href="addfr.php?id='.$row[id].'">Добави в Приятели</a>';                                            }
echo $pic;
?>
<br />
     </td>

  <tr>


  <tr>
    <td class="borderc2" width="15%">
   Години:
   </td>
    <td class="borderc2" width="60%" align="left"><? echo $row['age']; ?></td>
   </td>
  </tr>
  <tr>
    <td class="borderc2" width="15%">
   Пол:
   </td>
    <td class="borderc2" width="60%" align="left"><? echo $row['sex']; ?></td>
   </td>
  </tr>
  <tr>
    <td class="borderc2" width="15%">
   Населено Място:
   </td>
    <td class="borderc2" width="60%" align="left"><? echo $row['location']; ?></td>

   </td>
  </tr>
  <tr>
    <td class="borderc2" width="30%">
   Девис:
   </td>
    <td class="borderc2" width="100%" align="left"><? echo $row['signature']; ?></td>
   </td>
  </tr>
  <tr>
    <td class="borderc2" width="30%">
   Интереси:
   </td>
    <td class="borderc2" width="100%" align="left"><? echo $row['interests']; ?></td>
   </td>
  </tr>
  <tr>
    <td class="borderc2" width="15%">
   Профилът е прегледан:
   </td>
    <td class="borderc2" width="60%" align="left"><? echo $newdown; ?></td>
   </td>
  </tr>
  <tr>
    <td class="borderc2">
   Качени песни:
   </td>
    <td class="borderc2" align="left">
   <b><? echo $row['uploads']; ?></b>   </td>
  </tr>
  <tr>
    <td class="borderc2">
   Емайл:
   </td>
    <td class="borderc2" align="left">
   <b><a href="mailto:<? echo $row[email]; ?>"><? echo $row[email]; ?></a></b>   </td>
  </tr>
  <tr>
    <td class="borderc2">
   Skype:
   </td>
    <td class="borderc2" align="left">
   <div class="playads">
   <a href="skype:<? echo $row[skype]; ?>?call"><? echo $row[skype]; ?></a></td>
  </tr>


   

   </div>
   </td>
  </tr>
</tbody></table>
</b>
 

Back
Горе