[4n7hr4x]

ok, i use php quite frequently, and i have done many news scripts, and today i did another one, i used the code i use almost every time, here it is:

PHP Code:

<?php

    

    require ('config.php');

    

    $query = "SELECT * FROM th_news";

    $result = @mysql_query ($query);

    while ($row = mysql_fetch_array($result, MYSQL_NUM)) {

    

    $date = $row[4];

    $date = substr_replace($date, '', 10);

    

    if ($result) {

        echo '<table width="581" border="0" cellpadding="0" cellspacing="0" align="left">';

        echo '<tr><td>';

        echo '<b><u>' . $row[2] . '</u></b><br></td></tr>';

        echo '<tr><td>' . $row[3] . '</td></tr><tr><td>---</td></tr>';

        echo '<tr><td><i>Written by: </i><b>' . $row[1] . '</b>, <i>on</i> ' . $date . '</td></tr></table><br><br>';

    } else {

        }

    }

            

    ?>

For some reason, this is returning only 1 news post, and i don't know why, any one else does?

[cristiu]

why do you test if ($result)? you don.t need this...try without if..else

[4n7hr4x]

ok i'll do that right now, thanks

[4n7hr4x]

that didnt work, same thing =(

[4n7hr4x]

I took out the tables and it worked, funny how that was the problem.

[moronovich]

you can run the query in your mysql console first, and let's see what will happen to the query.

[moronovich]

oops, you typed faster than me..

[4n7hr4x]

lol, yeah, thx anyway