[HELP] not sure what the title should be..

[Sledmore]

Hey,

Er, I've coded part of a news system, And it works like /news?id=1 - How would I make this say, "Article not found!" ?

- Thanks.

 

[Menstral]

I'm not sure your entirely on about but maybe try and make it redirect to another page...

 

[Dayron1234]

So you want it to make it get an error?

EDIT:
This what your looking for?

<?php
if (some coding here)
{
die("Article not found!");
}
else
{
//some coding here
}
?>

 

[Kryptos]

$id = $_GET['id'];
$query = MySQL_query("SELECT * FROM news WHERE id='$id'") or die("article not found");

I haven't tested this, but I'm pretty sure that's how it should be, anyways. Let me know if it worked.

 

[StrongFaith II]

<?php
$id = $_POST['id']; // or $_GET['id']
$sql = mysql_query("SELECT * FROM news WHERE id = $id");
require('./config.php');
if($sql) {
if($row = mysql_fetch_array($sql)) {
echo " " . $row['title'] . "<br><br>";
echo " " . $row['story'] . "<br><br>";
echo " " . $row['author'] . "<br><br><br>";
}
else {
?>
<font color="red"><b>Article not found</b></font>
<?php  } } ?>

isnt tested , hope this works!

@obrienray1
i dont think that sledy dont know this , i guess he needs one with mysql etc. that is full

EDIT : This is tested and it works !

 

[Markshall]

This should work:

<?php
$news_id = mysql_real_escape(strip_tags( $_GET['id'] ) );
if( !$news_id )
{
    echo 'No News article selected!';
}
else
{
    $check = mysql_query( "SELECT * FROM news_articles WHERE `id` = '$news_id'" );
    if( mysql_num_rows( $check ) == 0 ) //article not found/doesn't exist
    {
        echo 'This news article does not exist!';
    }
    else
    {
        $n = mysql_fetch_array( $check ); //get all rows from the news article
        echo '<h1>' . $n["title"] . '</h1><p>' . $n["content"] . '</p>';
    }
}
?>

 

[StrongFaith II]

This should work:

<?php
$news_id = mysql_real_escape(strip_tags( $_GET['id'] ) );
if( !$news_id )
{
    echo 'No News article selected!';
}
else
{
    $check = mysql_query( "SELECT * FROM news_articles WHERE `id` = '$news_id'" );
    if( mysql_num_rows( $check ) == 0 ) //article not found/doesn't exist
        echo 'This news article does not exist!';
    }
    else
    {
        $n = mysql_fetch_array( $check ); //get all rows from the news article
        echo '<h1>' . $n["title"] . '</h1><p>' . $n["content"] . '</p>';
    }
}
?>

there is much easier way that works same as this , anyways why is needed the last "}" in PHP code , it ends nothing !

 

[Markshall]

It is needed, it ends the first if statement...

The

if( !$news_id )

one

 

[StrongFaith II]

No ?

<?php
$news_id = mysql_real_escape(strip_tags( $_GET['id'] ) );
if( !$news_id )
{ //starts
    echo 'No News article selected!';
} //ends
else
{ // starts
    $check = mysql_query( "SELECT * FROM news_articles WHERE `id` = '$news_id'" );
    if( mysql_num_rows( $check ) == 0 ) //article not found/doesn't exist
        echo 'This news article does not exist!';
    } // ends
    else
    { //start
        $n = mysql_fetch_array( $check ); //get all rows from the news article
        echo '<h1>' . $n["title"] . '</h1><p>' . $n["content"] . '</p>';
    } //ends
} // nothing ?!
?>

 

[Markshall]

I'm sorry but are you thick?
If you miss out that last bracket, PHP will throw an error - it needs to end the If statement, there is no end it it.

}
else
{

is just a tidier way of doing

}else{

There's no difference so if you don't have the '}' connecting to the '{' PHP will automatically throw an error.

I know what I'm doing, I've been doing PHP for just over a year, I'm sure I know how to program an If statement...

 

[Kryptos]

No ?

<?php
$news_id = mysql_real_escape(strip_tags( $_GET['id'] ) );
if( !$news_id )
{ //starts
    echo 'No News article selected!';
} //ends
else
{ // starts
    $check = mysql_query( "SELECT * FROM news_articles WHERE `id` = '$news_id'" );
    if( mysql_num_rows( $check ) == 0 ) //article not found/doesn't exist
        echo 'This news article does not exist!';
    } // ends
    else
    { //start
        $n = mysql_fetch_array( $check ); //get all rows from the news article
        echo '<h1>' . $n["title"] . '</h1><p>' . $n["content"] . '</p>';
    } //ends
} // nothing ?!
?>

Just to clear things out, that is wrong.
Way it is:

<?php
$news_id = mysql_real_escape(strip_tags( $_GET['id'] ) );
if( !$news_id )
{ //starts
    echo 'No News article selected!';
} //ends
else
{ // starts
    $check = mysql_query( "SELECT * FROM news_articles WHERE `id` = '$news_id'" );
    if( mysql_num_rows( $check ) == 0 ) //article not found/doesn't exist
        [B] { [/B] //start
        echo 'This news article does not exist!';
    } // ends
    else
    { //start
        $n = mysql_fetch_array( $check ); //get all rows from the news article
        echo '<h1>' . $n["title"] . '</h1><p>' . $n["content"] . '</p>';
    } //ends
} [B] /*end*/ [/B]
?>

[mod] Threrad closed, if you want to reopen the thread @thread starter just PM me [/mod]