Neverside

News id="bla"

I have made a simple news script, but I want the news to be www.bla.com/news.php?id=1 and so on, so can somebody help me with it. I know how to make it so it can link to it, just not so it can be like that

I don't quite understand try explaining again, and what do you mean 'link to it'

___________________

Fomerly known as lasnaranjas. Holler.

PHP:

<?php

$link = mysql_connect("localhost","sdbz_game","hide"); 
    mysql_select_db("sdbz_gamedb",$link); 
    $result = mysql_query("SELECT * FROM news WHERE id='$id' limit 10") or die (mysql_error());

?>

There's the code I've got so far, some guy tells me I need to do

PHP:

<?php

if ( $id == ); 

then some crap here...

elseif ( I dont know )

?>

Ah, so you're wanting to link to individual news items through the ID url variable? I'll dig out some code if Jerome doesn't beat me to it.

___________________

Omicron Software UK
http://www.omicron-software.co.uk

PHP:

<?php
$id = $_GET['id'];
$link = mysql_connect("localhost","sdbz_game","hide"); 
    mysql_select_db("sdbz_gamedb",$link); 
    $result = mysql_query("SELECT * FROM news WHERE id='$id' limit 10") or die (mysql_error());
?>

Then write an if the else statement so that the script will display an error message stating that there is no such id.

Last edited by Zeratul, July 20th, 2004 08:25 PM (Edited 1 times)

Oh, I know what you're asking. Google for it. I know phpdeveloper has articles, so does devshed.com, and if you must, spoono.com

___________________

Fomerly known as lasnaranjas. Holler.

I already showed him the solution

Now is that all I need to do?

So watch should I put in the IF and Else parts, I know Im dumb

Last edited by X-plozive, July 20th, 2004 08:36 PM (Edited 1 times)

Ok, I'll put it in English :P
If $id exceeds the number of rows in the database,
display an error message.
If $id is not found in the database,
display an error message.

PHP:

<?php

if ($id == )
What do I put here?

elseif ( $id == huh )
echo 'Error: Sorry, News ID cannot be found!!!'

?>