<?php Select Newstext from news where (BEST SOLUTION?)

**koolbrian** · Jun 8, 2001 08:32

hey,
i'm "trying" to make my own content management as a newbie. You should understand that i'm getting some problems

.
What's the best way of showing("select") the latest news on a page. By using the curdate() ??? or anything esle ?

i've tried this, in vain!
could u correct the code and tell me the best command to get the latest news please?

PHP Code:


<?php

mysql_select_db("articles");

$curdate = curdate()

$news = mysql_query("select newstext from news where newsdate2 >= $curdate");



if ($news) {

echo("Here are the latest news of $curdate");

}

else {

echo("No News were found!");

}



while ( $row = mysql_fetch_array($news) ) {

 echo("<P>" . $row["newstext"] . "</P>");



}

?>

Brian

**petesmc** · Jun 8, 2001 08:47

HI,

You could try:

select newstext from news ORDER BY ID DESC LIMIT 1

That'd print out the latest news, and only one.

**koolbrian** · Jun 8, 2001 10:07

you meant the latest news added in the database?, also, i think it'll change automatically when a new news will be added no?, please tell me a bit more about this function please?

Brian

**koolbrian** · Jun 8, 2001 10:20

another problem,
could somebody please tell me why this script doesn't add the news to the database?

PHP Code:


<?php

mysql_select_db("articles");



if ($action == "add") {

$add = mysql_query("INSERT INTO news SET newstext='$text', newsdate='$date'");



if($add) {

echo("News has been added!");

}

else{

echo ("There had been a problem inserting the news");

}

}

Thanx again!
Brian

**petesmc** · Jun 8, 2001 10:28

Hi,

1. The first one gets the latest news from the database and displays it. Once you add more news, that is shown.

2. You didn't connect to the database in the other one.

**koolbrian** · Jun 8, 2001 11:33

no it isn't necessary to connect to the database on my localhost. I dunno why, it works without connecting!, i think because i didn't set any password. I prefer like this thought!, with the script i showed (2nd problem), i found out that it added the news but with empty news, and date, maybe i should put the whole script for you too test it, try it,

PHP Code:


<html>

<head>

<title>Areacool [add news]</title>

</head>

<body>

<h3><p><b>Here Brian, you can add some news which wil appear as the latest news</b></h3></p>



<p>Type your news:</p>



<FORM ACTION=<?php echo($PHP_SELF); ?> METHOD=POST>

Current Date <INPUT TYPE=TEXT NAME="date"><BR>

<TEXTAREA NAME="news" ROWS=50 COLS=60 WRAP></TEXTAREA><BR>

<INPUT TYPE=SUBMIT VALUE="GO">

</FORM>



<p><h4>Check your news</h4></p>

<?php

echo("Date written: <b>$date</b><p>News: $news</p>");

?>





<p><b><h3><a href="add.php?action=add">ADD THOSE NEWS</a></b></h3></p>



<?php

mysql_select_db("articles");



if ($action == "add") {

$add = mysql_query("INSERT INTO news SET newstext='$text', newsdate='$date'");



if($add) {

echo("News has been added!");

}

else{

echo ("There had been a problem inserting the news");

}

}



?>

<p><a href="select.php">View the news!</a></p>

Thanx!
Brian

**koolbrian** · Jun 8, 2001 11:36

oh sorry, i forgot that you can't test it, as you don't have the database,......
sorry again

Brian

**petesmc** · Jun 8, 2001 12:04

For the news you forgot to actually get the information using select *....etc in that one.

Also, are news and date actually set when you want to add the information to the database?

**exbabylon** · Jun 8, 2001 13:32

you can't declare CURDATE() as $curdate without first declarinf the variable. And it IS nessicary to connect to the database as far as I know. Unless you're running a really weird form of pconnect().

Remember, you MUST either use PHP to declare what $curdate and $date, etc are, or you must use the built in MySQL functions. CURDATE() TIMESTAMP() UNIX_TIMESTAMP, etc.

God Bless,

Alex Stanton

**koolbrian** · Jun 8, 2001 23:21

is there a way to save the current date in a variable ?, maybe like this?

$curdate= Curdate()
or
$curdate = mysql_query(curdate()) ,or something of that sort?

Brian

**7stud** · Jun 9, 2001 01:02

lol...what a train wreck.

**exbabylon** · Jun 9, 2001 08:50

Have you read Kevin's PHP/MySQL tutorial? Not trying to discourage you, but you have not quite grasped the rules, regulations, and theory behind PHP, or any true scripting language for that matter.

PHP, like any other scripting language uses vaiables, which can be called anything, but can hold anything. A variable can hold from one integer to the entire works of Shakespear. This allows a programmer to be able to have lot's of different types of data, and be able to work with them. In PHP variables are associated with a dollar sign ($), but in other languages there may not be any accoiated character. PHP (which is one reason why I love it) allows you to use a variable without calling it, which is very usefull. but unless you have given the variable a value, either by POST, URL (GET), or declared in your code somewhere:

PHP Code:


$var = "data";

I'm newer than you are to scripting, and younger in age, and after I read Kevin's article I have constructed a lot of programs that are currently in use by thousands of users daily.

So I just would exort you to read through that article, get a book from Wrox press, and devour any post on this forum, as well as any tutorial or manual (http://www.mysql.com).

God Bless,

Alex Stanton

**Theiggsta** · Jun 9, 2001 09:04

SELECT * FROM news WHERE TO_DAYS(FROM_UNIXTIME(unix_timestamp(),'%Y-%m-%d')) - TO_DAYS(FROM_UNIXTIME(post_date,'%Y-%m-%d')) = '1' ORDER BY ID DESC

the $id can be any number of days back from the current day, 0 being today and anything higher to x number of days back.

Try using that query, its fast and involves mysql to do all the work.

Thats how I made a news script with newsposts categorized by day.

**koolbrian** · Jun 9, 2001 10:06

exbabylon, i've read half of kevin's tutorial, and i've just finished creating a rather simple and small content management, where i can update my news, simply as that, but for my first "real" script, i've very happy! , don't worry, i know about variables, .............
I'm just doing some errors that most of begginers do. But that's part of the of work. I'm really glad of having learned php. I can't imagine i can update my news!,
Now, i should start learning how to present the data from the database to the html page, i mean presenting with arrays........

Any links?
Brian

**exbabylon** · Jun 9, 2001 10:53

Ok, great! I would reccomend that you read through the entire tutorial, because it takes you through the entire process.

Theiggsta, what exactly does that query do? I guess you lost me on that

would you mind explaining?

**koolbrian** · Jun 9, 2001 11:38

petersmc gave me a very cool select query that showed the last news inserted in the database, but now, i would like to know how to show the 10 or 20 latest news, understand ???, the 10 latest news on a page, by descending order, from newer to older?, thanx!

Brian

**exbabylon** · Jun 9, 2001 13:10

I figured out what you did, I'd never seen the TO_DAYS or FROM_UNXTIME, before, so I was wondering. If you care to send a URL to where the definitions of those may be, or to explain the depths of them I would be gratefull, it is always good to expand the mind!

**koolbrian** · Jun 9, 2001 23:03

petersmc gave me a very cool select query that showed the last news inserted in the database, but now, i would like to know how to show the 10 or 20 latest news, understand ???, the 10 latest news on a page, by descending order, from newer to older?, thanx!

Brian
any reply ?

**freakysid** · Jun 10, 2001 00:49

Originally posted by petesmc
HI,

You could try:

select newstext from news ORDER BY ID DESC LIMIT 1

That'd print out the latest news, and only one.

Is this the query you were refering to? In this case, then just change the LIMIT to the number of records you want. For example, for the last 10 records:

SELECT newstext FROM news ORDER BY ID DESC LIMIT 10

**koolbrian** · Jun 10, 2001 01:07

thanx, i'l try!,
coming back after,
Brian

**koolbrian** · Jun 10, 2001 01:25

it worked, thanx again!

Brian
another question, can i put several forms that adds different data on ONE PAGE ? won't there be some problems ?

**koolbrian** · Jun 10, 2001 10:32

why does this doesn't show the text ( with 70 characters ?),
when i view it on a browser, i see the name (author) , but not the text!

PHP Code:


<?php

mysql_select_db("articles");

$view = mysql_query(

 "select left(text, 70), date, name from ich ORDER BY ID DESC LIMIT 1");





while ($row = mysql_fetch_array($view)) {

 $datext = $row["text"];

 $daname = $row["name"];

 $dadate = $row["date"];

 



echo( "<p><font face='Courier New, Courier, mono' size='2'><b><font color='#000066'>Author</font></b><font color='#999999'>:</font><font color='#000000'><b> 

  <font color='#3300FF'>$daname</font></b></font></font>

</p>

$datext

"

);

What's the problem ?, in fact, can i use Left(text, 70), ......
with mysql_query and with php ?
Brian

**petesmc** · Jun 10, 2001 12:24

Try:

left(text, 70) as text

**koolbrian** · Jun 11, 2001 10:46

i didn't really understand your reply. Use it as text HUH ?,
remember that "text" is the name of a column in my database.

Brian
Any other replies would be VERY appreciated!

**freddydoesphp** · Jun 11, 2001 10:59

In order to refer to a function's output in MySQL you must assign the output of the function an alias name to refer to in your disaply, so pete is saying assign the result of left(text, 50) to the alias name text so you can call it from your script like you did:

$datext = $row["text"];

User Tag List

Thread: <?php Select Newstext from news where (BEST SOLUTION?)

Thread Tools

Display

<?php Select Newstext from news where (BEST SOLUTION?)

Bookmarks

Bookmarks

Posting Permissions