$result1 = mysql_query("SELECT * FROM news,authors ORDER BY `id` DESC",$db);

I think something like "WHERE news.id=author.id" is missing .....
And I made a few scripts like this one, and i think you should "ORDER BY
date" .....

    (-        Nayco,
    //\        [EMAIL PROTECTED]
    v_/_     http://nayco.free.fr

----- Original Message -----
Sent: Wednesday, September 12, 2001 12:04 PM
Subject: [PHP] news display

Hey all!

I have a slight problem I was hoping you could help me with. I'm writing a
little news script for my site, and well here is the scenario:

I have 2 tables in a mysql database, one holds author information (name,
email, password, etc.)
The other table holds the news that they submit (news, date, time, headline,

Now I am trying to display the news on a page, ordered of course by date (or
id in this case) and well i'm using the code below.


$db = mysql_pconnect("localhost");

$result1 = mysql_query("SELECT * FROM news,authors ORDER BY `id` DESC",$db);

echo "<table cellpadding=0 cellspacing=0><tr><td><img
src=images/r13.gif></td><td background=images/r14.gif

width=100%><p><font size=2 face=verdana color=white><strong>" .
$myrow["headline"] . "</strong></FONT>
<font size=1 face=verdana color=white><br>Posted by <A HREF=mailto:"; .
$myrow["email"] . ">" .

$myrow["author"] . "</A> at " . $myrow["time"] . $myrow["$tod"] .

src=images/r15.gif></td></tr></table><br><FONT COLOR=white SIZE=2
FACE=verdana>" . $myrow["news"] .


So the results would look something like:

Posted by $author at $time


and it would of course just repeat, for however many entries there is.

Now the problem:
If I enter 4 news posts a day, I want to show 1 date above all the news
posts. (Instead of 1 date next to each news post) Any idea how I can do this
(In easy to understand lingo/code please)?



PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to