Coding error help

[mikka23]

I get the following error: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/mikka24/public_html/PSDSHAPES/news/view.php on line 11
On page: http://www.mcwebdesign.jamroll.net/P.../news/view.php
I am using dreamweaver to create a table to show a record set with the following code. I don't see what is wrong with it.

PHP: Select all

<table border="1">
  <tr>
    <td>title</td>
    <td>content</td>
  </tr>
  <?php do { ?>
    <tr>
      <td><?php echo $row_Recordset1['title']; ?></td>
      <td><?php echo $row_Recordset1['content']; ?></td>
    </tr>
    <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>
<?php require_once('../Connections/PSDshapes.php'); ?>
<?php
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
  $pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
mysql_select_db($database_PSDshapes, $PSDshapes);
$query_Recordset1 = "SELECT * FROM newscontent";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $PSDshapes) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
if (isset($_GET['totalRows_Recordset1'])) {
  $totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
  $all_Recordset1 = mysql_query($query_Recordset1);
  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
mysql_free_result($Recordset1);
?>

All help is appreciated.

[grahame]

The immediate answer is that $Recordset1 needs to be a result set variable that's returned by a function such as mysql_query(), but it isn't. It might be that you've not run any mysql_query() - there certainly isn't one that I've spotted in the sample code - or it might be that you did run a mysql_query() but it failed.

[mikka23]

I know no php. What coding do I have to put where to get this to work?

[mikka23]

Im using a different script now which is working. I was wondering how I make the css of the headers and text the same as my site and make the php script echo on my website .html page in the right column div tag.

The News Script (working):Link
My webpage where I want the news (on the right inplace of text, headers with same style as the headers which are already there): Link


All help is appreciated.

I have managed to include the php news script after changing the .html files to .php. Now I have different questions:
1. Can I include the php news script in a .html files?
2. How do I change the css class of the text which is defined in the php script?
3. How do I make it so you need to login to post news? as the submit.php is available to all.