Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : Whats wrong...

[Philipf]

PHP Code:

<?php

include("header.php");
include("connect.php");

$query = mysql_query("select maxno from news limit 1");
       $result = mysql_query('$query');
               while($maxno = mysql_fetch_array($query));


$query = mysql_query("select * from news order by date desc limit $maxno");
$result = mysql_fetch_array($query));
               extract($result) {

$date = $row['date'];
$title = htmlentities ($row['title']);
$news = nl2br (strip_tags ($row['news']));
echo("<b>$title on $date<BR><BR>$news</b>");

}

?>

This thing refuses to work, i know theres likely to be basic mistakes in here....but im new to php

Thanks, Philip

[Protollix]

You had some extra stuff going on in your code. Give this a try:

PHP Code:

<?php

include("header.php");
include("connect.php");

$query = mysql_query("select maxno from news limit 1");
$result = mysql_query('$query');
list($maxno) = mysql_fetch_array($query);


$query = mysql_query("select * from news order by date desc limit $maxno");
while ($result = mysql_fetch_array($query)) {
extract($result) 

$title = htmlentities ($title);
$news = nl2br (strip_tags ($news));
echo "<b>$title on $date<BR><BR>$news</b>";
}
?>

[Philipf]

Parse error: parse error in /home2/btihost/public_html/psfnews/main.php on line 12

same as before

Thanks, Philip

[MGCJerry]

Originally posted by Protollix
You had some extra stuff going on in your code. Give this a try:

PHP Code:

<?php

include("header.php");
include("connect.php");

$query = mysql_query("select maxno from news limit 1");
$result = mysql_query('$query');
list($maxno) = mysql_fetch_array($query);


$query = mysql_query("select * from news order by date desc limit $maxno");
while ($result = mysql_fetch_array($query)) {
extract($result); // Missing semi-colon

$title = htmlentities ($title);
$news = nl2br (strip_tags ($news));
echo "<b>$title on $date<BR><BR>$news</b>";
}
?>

You were missing a semi-colon with the extract($result) line.

[Philipf]

And an extra ) on line 12

[Philipf]

Thanks for the help guys, got it almost working