How do I add a default image ??

dicko_md

I am creating a database that shows a picture of whoevers birthday is in the current month for my local football team.

I have this working fine. When there is a birthday and the picture is there.

What I cant seem to get though is a default picture if there is no birthdays in the current month. It just shows as if there is a picture missing with the X.

The code I used for the image is

<img src="images/<?php echo $row_RS_Birthdays['Image']; ?>" alt="Thumbnail">

and then for the name its the code below

<?php echo $row_RS_Birthdays['Name']; ?>

The name is not a problem when there are no birthdays.

So my question is, can I have an image saying no birthdays or is there some code that says if no birthdays in database then show nothing ?

Also is there any code that will make the data go vertical and not horizontal ?

Thanks in advance

Dicko

SirEvenhand

$today = date("Y-m-d");

$SQL = "SELECT imageID FROM dbtable WHERE birthday = '$today'";

#execute SQL statement
$rsGetImageInfo = mysql_query("$SQL",$cid) or die ("Couldn't connect to the MySQL database! find birthday for this user");

$GetImageInfo = mysql_fetch_row($rsGetImageInfo);

if ($GetImageInfo)
{
// display image
}
else
{
// assign default image
}

dicko_md

Does this code below go into my php web page or on the sql server ?

If I just want the month, can I change the $today = date("Y-m-d") to

$today = date("M") ?

Thanks

Dicko

$today = date("Y-m-d");

$SQL = "SELECT imageID FROM dbtable WHERE birthday = '$today'";

#execute SQL statement
$rsGetImageInfo = mysql_query("$SQL",$cid) or die ("Couldn't connect to the MySQL database! find birthday for this user");

$GetImageInfo = mysql_fetch_row($rsGetImageInfo);

if ($GetImageInfo)
{
// display image
}
else
{
// assign default image
}

shawty

It's PHP code dicko, so will need to go in a PHP page on your web server.

You'll probably need to modify the SQL query though so it matches the appropriate columns/fields etc in your database.

Cheers

Shawty