[echolike]

Hi guys,

i am currently write a few lines code to display all news from mysql by date.
db is abc, and there is table called news.

here is the code:

PHP Code:

<?php 

                $username = "xxx";

                $password = "xxx";

                $hostname = "localhost";    

                $db = mysql_connect($hostname, $username, $password) 

                or die("Unable to connect to MySQL");

                $selected = mysql_select_db("abc",$db) 

                or die("Could not select abc");

                

 $result = mysql_query('SELECT * FROM news' . 'ORDER BY date DESC');



                $news = array();

                while ($result = $db->row_array()) {

                $news[] = $result;

                }

                 ?>

but this code seems doesn't work at all.

i need help to show news on outside pages like anywhere in html or php pages.

Thanks guys!!!

sean

[FiRe]

what are you selecting from news??

SELECT * FROM news ORDER BY date DESC

you should have:

SELECT title, news, author, date FROM news ORDER BY date DESC

then the whole thing would look like:

PHP Code:

<?php

//Connect

$username = "xxx"; 

$password = "xxx"; 

$hostname = "localhost";     

mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL"); 

mysql_select_db("abc",$db) or die("Could not select abc");



//Query

$query = mysql_query("SELECT title, news, author, date FROM news ORDER BY date DESC");



//Repeat

while($r = mysql_fetch_array($query)) {

$title = $r['title'];

$news = $r['news'];

$author = $r['author'];

$date = $r['date'];



//Echo news

echo "Title: <b>$title</b>

<br><br>

$news

<br><br>

<i>Posted by $author on $date.</i>";



}



//Close database

mysql_close();

?>

[Keith]

One problem in your original code may have been this query:

Code:

mysql_query('SELECT * FROM news' . 'ORDER BY date DESC');

When you remove the concantonation, the query would read:

Code:

mysql_query('SELECT * FROM newsORDER BY date DESC');

You'll see there's no space between 'news' and 'ORDER'.

[echolike]

Hi guys,

Thank you so much, that help me a lot.



sean

[jordie]

FiRE you can use * to select all the columns. Much simplier then typing them all out

[Keith]

But that can also slow down queries and call unnecessary info, so be careful when using a wildcard.