PHP Help Needed

4WebHelp Addict Joined: 07 Jan 2002 Posts: 1060

I have the following PHP/SQL in a CMS Script

@$outcome=mysql_query("SELECT * FROM articles ORDER BY adate ASC,atime ASC LIMIT $id");
if ($sectionID) @$outcome=mysql_query("SELECT * FROM articles WHERE sectionID='$sectionID' AND adate<='$date' ORDER BY adate ASC, atime ASC LIMIT $id");

I want the ASC Limit to be the value of $id -1, how would I do this in PHP, it seems ery simple, but have never had to do something like this before, hence why I'm asking.

Team Member Joined: 06 Jan 2002 Posts: 2564

Is this what you mean?

Code:

@$outcome=mysql_query("SELECT * FROM articles ORDER BY adate ASC,atime ASC LIMIT $id");
if ($sectionID) @$outcome=mysql_query("SELECT * FROM articles WHERE sectionID='$sectionID' AND adate<='$date' ORDER BY adate ASC, atime ASC LIMIT " . ($id-1));

I think that should do it if that's what you were after.

4WebHelp Addict Joined: 07 Jan 2002 Posts: 1060

Thanks

What I want to do now, is for it to take into account the ID of the article, which is specified in a URL string such as: www.domain.com/news/viewarticle.php?id=1

Take the value of id= and then look in the article database and retrieve the five previous article ID's prior to that. EG if the URL specifies id=9,I want it to display articles 8,7.6,5,4 if you see what I mean.

The id value matches the value of the id column in the database, so it shouldn't be too hard to do, I'm not just 100% sure on how to do it.

If you need any further help let me know. Basically it's going to be used to list the previous five articles under the news article it's showing.

Posted: Sat Jun 25, 2005 7:30 pm (18 years, 9 months ago)

LIMIT can accept two values the first teeling it which row to start from the second how many rows to retrieve.

for example this would take 5 rows strating from row 3
LIMIT 3,5

So maybe you need to start by taking the starting point 6 rows before the ID and then taking the following 5.
LIMIT ($id-6),5

I'm totally guessing here.
Also not sure what will happen if you end up with a negative start point e.g. if you started with an id of 3 there are only 2 preceding records.

Hope that helps

4WebHelp Addict Joined: 07 Jan 2002 Posts: 1060

seem to get a DB error for that, to check I'm not doing something silly, could you put the exact MySQL statements I should be using on this forum or PM them to me, just want to ensure I'm doing it right.

I should know all this really, but I haven't really done anything apart from simple PHP for the last 12 months so I've kinda got a bit rusty.

4WebHelp Addict Joined: 07 Jan 2002 Posts: 1060

Don't matter, done it now, I figured out what I was doing wrong. Used this in the end.

@$outcome=mysql_query("SELECT * FROM `articles` WHERE ID<$id ORDER BY ID DESC LIMIT 5");
if ($sectionID) @$outcome=mysql_query("SELECT * FROM articles WHERE sectionID='$sectionID' AND articleId`>=($id-5) ORDER BY 'articleId'");