If Statement Help

mricklefs

I'm completely new to php, and need to create an if statement that says if year =< 1998 echo a image(button) can someone please help me out..

sheephat

if( year =< 1998 ){echo "<img src='source.jpeg' />

im not sure what the 'year' is, is it from the database or is it a $year variable?

mricklefs

year is coming from database.. Sorry I didnt explain that very well. What do i do with that?

sheephat

how is the year string called??

have you used something like mysql_fetch_array or you havent got that far yet?

mricklefs

I have yet to call the string? Im unsure on how to do that?

Weedpacket

Well, how far have you got? If you showed us that we wouldn't have to ask or guess.

JVassie

To extract the information from the database you will need to use a MySQL SELECT query.

But as said, you will have to let everyone know what you know before anyone can help more so. 🙂

mricklefs

This is the enitre detail page. The parts I need the if statement is in red.. Please help.

Thanks,

Matt

quecoder

I think it's $row["year"] ,
try this :

if($row["year"] <=1998) { echo ' <a href="https://www.webstercityrv.com/credit_app/" target="_blank"><img src="../images/credit_app_button.jpg" width="121" height="30" border="0"></a>';}

JVassie

quecoder wrote:

I think it's $row["year"] ,
try this :

if($row["year"] <=1998) { echo ' <a href="https://www.webstercityrv.com/credit_app/" target="_blank"><img src="../images/credit_app_button.jpg" width="121" height="30" border="0"></a>';}

That looks ok, but you haven;t shown how you get the data from the database into the array $row.

Here is a function you could edit and use as a base.

function getyear(){
         global $conn;
         $q = "SELECT year FROM tablename";
         $result = mysql_query($q,$conn);
         $row = mysql_fetch_row($result);
         return $row[0];
}

Where the variable $conn contains the details to connect to the database.

How will the system know which year to select? Will the database only have 1 year in? or what?

Any questions please ask. 🙂