If ListingID is in property session table, then display one

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
REwing
Forum Newbie
Posts: 2
Joined: Sat Jan 30, 2010 1:06 pm

If ListingID is in property session table, then display one

Post by REwing »

Hello, i hope you can help.

I have two tables, listings and property_session

I'm trying to write some code which basically says:

If ListingID is in property session table, then display one image if not then display another.

Can anyone help?
User avatar
AbraCadaver
DevNet Master
Posts: 2572
Joined: Mon Feb 24, 2003 10:12 am
Location: The Republic of Texas
Contact:

Re: If ListingID is in property session table, then display one

Post by AbraCadaver »

Assuming MySQL and that you have the ID in $ListingID:

Code: Select all

$result = mysql_query("SELECT * from property_session WHERE ListingID = '$ListingID'");
 
if (mysql_num_rows($result) > 0) {
    //found 
    //echo an image
} else {
    //not found
    //echo another image
}
mysql_function(): WARNING: This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQLextension should be used. See also MySQL: choosing an API guide and related FAQ for more information.
Post Reply