Is this right?

[npereira]

Hi all, need a litle help.

Is this correct if I want to take multiple table contents from a db and echo it to the same file using the
<?php echo $pagename; ?>
statement?

<?
include ("db_connect.php");

$tablename="page";

$result = mysql_query("SELECT title, changedate, date, author, pagename, document, sideheadline, sidedocument FROM $tablename WHERE id=$pagenumber");   

while($array = mysql_fetch_row($result))
{
$title=$array[0];
$changedate=$array[1];
$date=$array[2];
$author=$array[3];
$pagename=$array[4];
$document=$array[5];
$sideheadlines=$array[6];
$sidedocument=$array[7];
}
?>

The reason I ask is that the page keeps giving me an error on line 7 which is the while() statement....?!?

And the error is

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in ....

[bubblenut]

whack a "or die(mysql_error())" on the end of the mysql_query() statement. That should tell you the error that it's coming accross. Syntactically it looks OK. Probably just a spelling error
Good Luck
Rob

[npereira]

added the piece and it says parse error on line 8!?

[bubblenut]

This line

$result = mysql_query("SELECT title, changedate, date, author, pagename, document, sideheadline, sidedocument FROM $tablename WHERE id=$pagenumber"); 

Should look like this

$result = mysql_query("SELECT title, changedate, date, author, pagename, document, sideheadline, sidedocument FROM $tablename WHERE id=$pagenumber") or die(mysql_error()); 

I can garuntee it's not got a parse error in it.

[npereira]

well now it's givin me an

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[Tracer]

1) look for typos in your table names....

2) Make sure that your $pagenumber and $tablename are set and have no typos...

[npereira]

Thanks that helped!

Now I gotta figure how to add a page into the db, hmmmmm...... Damn!