SELECT * FROM news ORDER BY id DESC Need a hand

Paragon

$result = mysql_db_query($dbname, "SELECT * FROM news ORDER BY id DESC");

I was just wondering what the DESC in that line means. Is it just a varible?

ScubaKing22

DESC stands for DESCending, as well as ASC stands for ASCending. These two things are in what order the information will be pulled from the database. DESC will be Z-A, while ASC will be A-Z. Same goes for numbers ordering as well.

Paragon

How exactly would I pull only id 1 or only id 2 ?

ScubaKing22

$query="SELECT id FROM table_name WHERE id='1'";

This would select the information in id where id=1, but since you already know it will contain 1, it would be useless. You could change SELECT id FROM to SELECT*FROM, that would select everything from the table where id=1.

Paragon

Well I have a news system I want to pull them seperatly not just all at once. like this area would have the newest news 1 another area would have the 2nd newest news and so on.

id int(11) No auto_increment

thats the way the table looks.

ScubaKing22

Well for starters you should have id be auto_incremented. That way you don't have to insert the ID each time you insert news; it will automatically be incremented from the last one. As for the pulling out, just do the following:

$query="SELECT*FROM table_name WHERE id=1 LIMIT 1";

That LIMIT 1 means to only select one starting with the row that matches the specified WHERE if there is one included. Otherwise it will just select the first row period. So then if you wanted the second news item, just change id=1 to id=2.

Paragon

How do I display that? When I go echo"$query" it just shows me the actual command.

Paragon

Well I guess I didnt explain well enough. There are 3.

My Id is my primary key. I want the news from ID 1 only. Or only ID 2.

id  int(11)   No    auto_increment  Change  Drop  Primary  Index  Unique  Fulltext  

   news  mediumtext   No      Change  Drop  Primary  Index  Unique  Fulltext  

   event  datetime   No  0000-00-00 00:00:00    Change  Drop  Primary  Index  Unique  Fulltext

Paragon

<?php
   mysql_connect("localhost", "username", "password") or
       die("could not connect");
   mysql_select_db("news");
   $result = mysql_query("SELECT id=1, uname, news, event FROM newscontent");

   while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
       printf ("id: %s  uname: %s", $row[1], $row["news"]);
   }

   mysql_free_result($result);
?>

Thats what I am using now. It grabs more than 1 row. ANy help would be great.

ScubaKing22

That'll work fine just look up a tutorial for more information on MySQL databases.

Paragon

It works. It doesnt only show 1 row though. It shows alll news.

Here is my new code.

<?php

   mysql_connect("localhost", "username", "password") or
       die("could not connect");
   mysql_select_db("news");
   $result = mysql_query("SELECT id=1, uname, news, event FROM newscontent ORDER BY id DESC");


   while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   $username = $row['uname'];
   $news = $row['news'];
   $date = $row['event'];

echo "$username<BR>";
echo "$news<BR>";
echo "$date<BR>";
echo "<BR>";
   }

   mysql_free_result($result);
?>

ethos

Change this...

mysql_query("SELECT id=1, uname, news, event FROM newscontent ORDER BY id DESC")

to this..

mysql_query("SELECT id, uname, news, event FROM newscontent WHERE id=1 ORDER BY id DESC")

This will return news id 1... if you want to get id 2... just change 1 to 2 and so on..

Paragon

Perfect thanks. Is it possible to do the highest number?

Like do a check for the highest number in the DB and post that?

I mean a simple way. If not I would love some pointers. thanks.

ethos

Can't give you the exact query u'd need to execute off hand but the basic idea is you need to make a query to get the highest id then spit that out to a variable lets say $HIGEST_ID so you can change the id=1 to id='$HIGEST_ID'

coreyp_1

Why not this?

mysql_query("SELECT id, uname, news, event FROM newscontent ORDER BY id DESC LIMIT 1")

And if you don't need the query to return the id, leave it off, too.

HTH