Parse error

[alen]

I'm making a news management script!

So far I have managed to make the script add news, so that I can view it on the index page. Now I've started with the edit part.

First off I got an error ... then I added a mysql_error to check it.

This is the result of the new error:

[b]Parse error:[/b] parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in [b]/path/path/rediger.php[/b] on line [b]8[/b].

I can't seem to find any extra spaces in the script, so I don't think that's causing the error.

Here's my code, http://anigma.sitees.com/rediger.txt and http://anigma.sitees.com/lagre.txt

It consist's of two parts, firstly I have to extract the news from my database, and secondly I have to display this data.

I have chosen to display the latest 10 newest posts.

[redbullmarky]

if line 8 is
[code]
$query = "SELECT title, news FROM nyheter WHERE id = $_GET['id']";
[/code]
then try
[code]
$query = "SELECT title, news FROM nyheter WHERE id = {$_GET['id']}";
[/code]

[alen]

Now I get:

Notice: Undefined index: id in path/path/rediger.php on line 8

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[redbullmarky]

that'll be because you havent got an 'id' in the URL. tack on a rediger.php?id=1 or something to your URL and try it out. you'll need to decide what you want to do in the event that 'id' hasnt been passed in the URL, and put in a check to handle it before you query the DB

[alen]

I tried rediger.php?id=1 and then I got this:

Table 'nyheter.nyheter' doesn't exist

Where do I ask for the nyheter.nyheter table?

[redbullmarky]

on this line:
[code]
<?php
$query = "SELECT title, news FROM nyheter WHERE id = $_GET['id']";
?>
[/code]
have you actually made a database table called nyheter yet?

[Hypnos]

[code]mysql_select_db ($db_name) or die ("Databasen er imidlertid nede."); [/code]

Replace with:
[code]mysql_select_db($db_name) or die("Databasen er imidlertid nede."); [/code]

[alen]

Of course I have a database named nyheter.. and the table is named news.. However, the query should be getting something!

[keeB]

Then your code would be

[code=php:0]$query = "SELECT * FROM news WHERE id = {$_GET['id']}"; [/code]

[alen]

Hey it works!

[alen]

How would I make the newest posts be listed on the rediger.php site? From 1 to 10..

[redbullmarky]

assuming you've got a column/field for the date, then something like:

[code]
<?php
$query = "SELECT * FROM news WHERE id = {$_GET['id']} ORDER BY date DESC LIMIT 10";
?>
[/code]

[alen]

This is how my edit script looks like right now,

http://anigma.sitees.com/rediger.txt
and
http://anigma.sitees.com/lagre.txt

I keep getting a notice error..

[b]Notice:[/b] Undefined index: id in [b]rediger.php[/b] on line [b]8[/b]

Should I just get this away with, error_reporting(E_ALL ^ E_NOTICE); ?

[alen]

Yes I have a field/column for the date, but I got this,

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY date DESC LIMIT 10' at line 1

[redbullmarky]

you could, but it's best to deal with your errors rather than hide them. especially as considering your query, an undefined index (and hence no value) would make your query fail. ([b]edit[/b] which is what your reply you just posted has shown)

replace the query line with the following:

[code]
<?php
if (isset($_GET['id']))
{
  $query = "SELECT * FROM news WHERE id = {$_GET['id']}";
}
else
{
  $query = "SELECT * FROM news ORDER BY date DESC LIMIT 10";
}
?>
[/code]

which means if an ID is passed in the URL (notice the 'isset' check), then that record will be picked and displayed. otherwise, the latest 10 records order by most recent first will be displayed.

cheers
Mark

[alen]

That was better, but... I want to have links on the rediger.php site to each post.

Let's say this is the page:

rediger.php :

Random test (the first post i posted)
Whatever (the second)
etc...

And then I want to make each title to a link like rediger.php?id=1 (which is Random test since it was the first post i posted), and then I click on the title and then I would be able to edit/save the content.

[alen]

Are we on the same page on this?

[Mr.x]

[code]$content = mysql_query("SELECT * FROM news WHERE id = {$_GET['id']}")

while ($row = mysql_fetch_assoc($content)) {

echo "<a href='rediger.php?id=".$row['id']."'>".$row['title']."</a> <br>";

}[/code]

[alen]

How would I put that together with the rest of the code?