PHP - Order Article By Id!

I'm feeling a little overwhelmed/burned-out/confused...   

I have a page "article_index.php" that contains a summary of each article plus a link to it, e.g.

Code: [Select]
<a href="<?php echo WEB_ROOT; ?>articles/postage-meters-save-you-money">
When you click on a link, it goes to "article.php" and uses a mod_rewrite to transform the "pretty URL" to regular URL that "article.php" can use to query the correct article from my database.

-----

Here is what I need help with...

When a user is on a given article page, I want to sto

- ReturnToPath
- ArticleID

in the SESSION.

I am drawing a blank on how to get the "ArticleID" when a user is on a give page?!   

Hope you guys follow me?!


Debbie

I'm building an article system, what im trying to do is when a user choose the article to be published tomorrow to able to.  Write today the article but the system will show it from tomorrow

Code: [Select]
        $gettoday = date("Y:m:d");
$query = "SELECT * FROM tblnews WHERE MainArticle = 1 AND NewsDate = '".$gettoday."'  ORDER BY `Id` DESC LIMIT 1";
$result = mysql_query($query);

This is my code, but when i use this and the article is not posted for today is not showing anything.. any suggestions please?

Thank you

I am developing a CMS with articles and categories.  I am making a feature for the admin panel that shows all the categories.  In the table, I would like to include each category's latest article.  My traditional method is to select just the categories in one query, loop through the results, and then inside the category loop have a query that gets the information on the latest article... So something like...

$query = "
     SELECT category_id, title, description
     FROM categories
     ORDER BY title ASC";
 
if($query = mysql_query($query)){
 
     while($cat=mysql_fetch_assoc($query)){
 
            $query_article = "
                 SELECT article_id, category_id, title
                 FROM articles
                 WHERE category_id = ".$cat['category_id']."
                 ORDER BY article_id DESC
                 LIMIT 1";
 
            $last = mysql_fetch_assoc($query_article);
 
       }
 
}

          How could I use joins and/or subqueries to achieve my goal of combining these two queries into one?  I have come up with a query which is below:

SELECT
c.category_id, c.title, c.description,
a.article_id, a.category_id, a.title, COUNT(a.article_id) AS total_articles
FROM article_categories AS c
LEFT JOIN articles AS l ON (
SELECT
article_id AS article_id, category_id, title AS article_title
FROM articles AS l
WHERE l.category_id = c.category_id
ORDER BY l.article_id
DESC LIMIT 1)
LEFT JOIN articles AS a ON (c.category_id = a.category_id)
GROUP BY c.category_id
ORDER BY c.title ASC

  When I use the above query, I get an error saying "Operand should contain 1 column(s)"   I would also like to add something that counts the total number of articles in the category.   Thanks for your time!  

This topic has been moved to Apache HTTP Server.

http://www.phpfreaks.com/forums/index.php?topic=322454.0

Hello,

I am trying to create article directory for learning PHP MySql and i want to write a script for recording number of views for an article and store it in Database. Can anyone please direct me to a nice simple tutorial or help me with the steps or algorithm?

Suppose the link for an article is http://www.domain.com/article.php?id=123
Do i need to put extra variables and create a tracking PHP file for it?

hi there,

basically in my database i have  DATETIME for when an article was posted, using this, I'd like to make it possible for viewers of the article to see when it was posted in a "Posted Today", "Posted Yesterday" or Posted 23 hours ago" format. If it was posted longer ago than yesterday, then I would like it to just be the normal date.

I know how to work out if it was posted today, just through:

$date = date('j F', strtotime($rows['date']));
$today=date('j F');

but not sure how to do the hours.

thanks!

i need to submit 1 article (3 input fields: title, category, description), to multiple sites. it must be done with 1 click.

one more thing... each site to which i have to submit has different input names, but are the same 3, also 1 is for title 1 for category and 1 for description.

Hi all -

I'm setting up a custom PHP blog. It pulls the data from a MySQL database which includes HTML tags (<p><div><span> etc...).

I would like to display only up to 50 words per post on the blog page, which users can then read and click a link to then see the entire post.

I've developed some code which does this, however, it seems to be stripping my HTML tags... Very sad!

Would be very very grateful if one (or more) of you kind lot would have a look at my code and let me know if there is a easier (I'm all for easy) and proper way of implementing this so that it works without stripping my HTML tags.

Cheers!!!

Code: [Select]
// Counts number of blog words in the content
$blog_content_words = str_word_count($blog["content"], 1);

// Sets the blog_words variable to 0
$blog_words = 0;

// Prints title on page as a permalink to a post
echo '<h1><a href="blog.php?id='.$blog["id"].'">'.$blog["title"].'</a></h1><p>';

// Loops while blog_word is under 50
while($blog_words < 50) {

// Prints a word from blog_content_words array of blog post and adds a space afterwards
echo $blog_content_words["$blog_words"]." ";

// Adds 1 to the blog_words counter
++$blog_words;
}

// Adds a read more link to the post which links to full blog post
echo '... <a href="blog.php?id='.$blog["id"].'">[read more]</a></p>';

I've got.

So i have this CMS that is used by lots of users and generally they do have rights to edit each others article. So now i'm thinking how can i at least warn them that somebody else is already editing it. Just that.

maybe with sessions? but what happens when a user just closes the windows, will it destroy it. i taught about storing the value to mySQL but again what if the user closes the windows and so on.

i never did this and i could use a boost. thanks guys

Currently i have a query which at the end has this
Code: [Select]
order by (value/counter) desc");

which works fine, however i was wondering, if in the case that 2 rows have the same, is it possible to set a second value to order by?

Hello,


I have classes in a database with no set UNIX date, just the day like Wednesday and in two other columns the start and end dates.


I want to be able to order by the day first and then by end_time but php orders the day column by spelling and not the day it holds in chronological order.


Is there anyway to change the query to order the day column as a date?


See the query below?


Code: [Select]
$query = "SELECT * FROM zumba_timetable WHERE end_time>'$current_time' ORDER BY day, end_time ASC LIMIT 0,1";

Hi there, just registered and in need of help, this looks a good place to start!
I'm a php beginner so please bear with me

I have a mysql database which holds 3 pieces of info
id:
match:
1:

I'm trying to sort the results using ORDER BY match ASC but for some reason it's just not for having it...
Can't work out if it's an error with my php code or my table. I can order by "ID" no problem but I when I try ordering alphabetically by "match" it won't.

my code is:

Code: [Select]
mysql_connect("***.***.***") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());


$query = "SELECT * FROM employees WHERE flag = 'tv' ORDER BY match ASC";
$result = mysql_query($query) or die ("Query failed");

$numrows = (mysql_num_rows ($result));


       

// loop to create rows
if($numrows >0){
echo "<table width = 100% border = '0' cellspacing = '2' cellpadding = '0' >";
// loop to create columns
$position = 1;
while ($row = mysql_fetch_array($result)){
if($position == 1){echo "<tr>";}
 
echo " <td align = 'center'><a href=\"http://www.website.eu/sport-stream/1/{$row['id']}.html\" target=_blank>{$row['match']}
<br>
<img src=\"{$row['8']}\" width=\"100\" height=\"70\" /> </a>
</td>

";
if($position == 4){echo "</tr> "; $position = 1;}else{ $position++;}
}//while

$end = "";
if($position != 1){
for($z=(4-$position); $z>0 ; $z--){
$end .= "<td></td>";
}
$end .= "</tr>";
}

echo $end."</table> ";
}//if
And here's a cap of my database:


any help for a php n00b would be greatly appreciated!

I got this code from a previous thread:

Code: [Select]
mysql_query("SET @rows = 0;");
$res = mysql_query("SELECT @rows:=@rows+1 AS view_rank,COUNT(id) AS views, credit_members_id FROM vtp_tracking GROUP BY credit_members_id ORDER BY views DESC");
$n   = array(1 => 'st', 2 => 'nd', 3 => 'rd');
while($row = mysql_fetch_row($res))
{
   if ( $row[2] != $members_id )
      continue;
   if ( substr($row[0], -1) < 4 )
   {
      $row[0] .= $n[$row[0]];
   }
   else
   {
      $row[0] .= 'th';
   }
   echo ' You are in ' . $row[0] . ' place with ' . number_format($row[1]) . ' views.';
   break;
}
Everything seems ok except it orders by the "credit_members_id" and not "views" as entered.

Can someone explain why, and how to fix this?