[Resolved] if var = 1, a slight change in output page?

[cmccomas]

If I have two types of stories:
a) normal
b) game recap

And I have a radio button group on the add page to select if game is a recap or normal (1 = normal, 2 = recap). The story will be on story.php, but I was curious about doing something like:

If 1, normal story.

If 2, link to box score + normal story.

Can I do this? If so, what's the command, so I can look it up.

Thanks

[kevinsequeira]

post your code for story.php

reg
kevin

[cmccomas]

Here it is. Was wanting to add it near the top.

	--------------------------------------------------------------------------------
     <?php 
// includes 
include("../conf.php"); 
include("../functions.php"); 

// open database connection 
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 

// select database 
mysql_select_db($db) or die ("Unable to select database!"); 

// generate and execute query 
$query = "SELECT headline, author, story, timestamp FROM story WHERE id = '$id'"; 
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error()); 

// get resultset as object 
$row = mysql_fetch_object($result); 

// print details 
if ($row) 
{ 
?> 
    <font class="bigText"><?php echo $row->headline; ?></font> 
                    <br> 
                    <font class="captionText"><?php echo $row->author; ?></font> 
                  <br> 
    <font class="midText"><?php echo nl2br($row->story); ?></font> 


<?php 
} 
else 
{ 
?> 
    <p> 
    <font size="-1">This story could not be located in our database.</font> 
<?php 
} 

// close database connection 
mysql_close($connection); 
?>

[kevinsequeira]

STEP 1 : well change ure query to get the story type also

$query = "SELECT headline, author, story, timestamp,story_type FROM story WHERE id = '$id'";

im assuming its called story_type in your table, change it if its not

STEP 2 : modify the display code to include link

if ($row) 
{ 

if($row->story_type==2){
// here display the link to the score
}
?> 
    <font class="bigText"><?php echo $row->headline; ?></font>
                    <br>
                    <font class="captionText"><?php echo $row->author; ?></font>
                  <br>
    <font class="midText"><?php echo nl2br($row->story); ?></font>


<?php 
}  

.
.
.
.
.

reg
kevin

[cmccomas]

Is this right:

<?php
// includes
include("../conf.php");
include("../functions.php");

// open database connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

// select database
mysql_select_db($db) or die ("Unable to select database!");

// generate and execute query
$query = "SELECT id, headline, author, article, type, timestamp FROM story WHERE id = '$id'";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

// get resultset as object
$row = mysql_fetch_object($result);

// print details
if ($row) 
{ 

if($row->type==1){ 
 echo "<a href='http://www.pistonscentral.com/pc/boxscore.php?id=<?php echo $row->id; ?>' class='smallnewsLink'>Box Score </a>"
 }
?> 



<?php
}
else
{
?><font class="bigText"><?php echo $row->headline; ?></font> 
                    <br> 
                    <font class="captionText"><?php echo $row->author; ?></font> 
                  <br> 
    <font class="midText"><?php echo nl2br($row->article); ?></font> 

<?php  

}  

// close database connection 
mysql_close($connection);  

?>

[kevinsequeira]

at a glance it seems fine, does it work ? thats the best way to know if it fine 😃

EDIT :

make this change ...

echo "<a href=http://www.pistonscentral.com/pc/boxscore.php?id=".$row->id." class=smallnewsLink>Box Score </a>" ;

reg
kevin

[cmccomas]

What about this one mate:

If addimage field = 0, then the I want to have the same setup, but with an image, align=right. I have it set now to add the image, where would I put the rest for the non-image stories?

// get resultset as object
$row = mysql_fetch_object($result);

// print details
if ($row->addimage==1)
{
?>
                  <p><font class="bigText"><?php echo $row->headline; ?></font> 
                    <br>
                    <img src = image align="right">
<font class="smallerText"><?php echo $row->author; ?></font> 
                  </p>
                  <p> <font class="midText"><?php echo nl2br($row->byline); ?> 
                    <a href="http://www.pistonscentral.com/pc/story.php?id=<?php echo $row->id; ?>" class="normalLink">[+]</a></font> 
                  <p> 
                    <?php
}
else
{
?>
                    <?php
}

// close database connection
mysql_close($connection);
?>

[cmccomas]

Do I put the putput if addimage==0 below or above addimage==1 ?

[kevinsequeira]

im not sure what you mean ??

if u dont want anything when addimage = 0 then just do this

// get resultset as object
$row = mysql_fetch_object($result);

// print details
if ($row->addimage==1)
{
?>
                  <p><font class="bigText"><?php echo $row->headline; ?></font>
                    <br>
                    <img src = image align="right">
<font class="smallerText"><?php echo $row->author; ?></font>
                  </p>
                  <p> <font class="midText"><?php echo nl2br($row->byline); ?> 
                    <a href="http://www.pistonscentral.com/pc/story.php?id=<?php echo $row->id; ?>" class="normalLink">[+]</a></font>
                  <p>
                    <?php
}
?>

// close database connection
mysql_close($connection);
?> 

if you want something else when addimage=0 then do this

// get resultset as object
$row = mysql_fetch_object($result);

// print details
if ($row->addimage==1)
{
?>
                  <p><font class="bigText"><?php echo $row->headline; ?></font>
                    <br>
                    <img src = image align="right">
<font class="smallerText"><?php echo $row->author; ?></font>
                  </p>
                  <p> <font class="midText"><?php echo nl2br($row->byline); ?> 
                    <a href="http://www.pistonscentral.com/pc/story.php?id=<?php echo $row->id; ?>" class="normalLink">[+]</a></font>
                  <p>
                    <?php
}elseif($row->addimage==0){
// do whatever u want when no image here
}

// close database connection
mysql_close($connection);
?> 

[cmccomas]

Works like a charm. You da man, thanks!

[kevinsequeira]

no problem, could u mark this thread resolved, there is a link below

reg
kevin