any help on this error please. thanks

[russlock]

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource

<?php if (isset($HTTP_GET_VARS["searchcatalog"])) { ?>
		<?php if ($totalRows_Search == 0) { ?>
		No albums match your search. Try looking for something else. 
	<?php } else { ?>
		<table width="100%" border="0" cellpadding="2">
			<tr> 
			  <td>&nbsp;</td>
			  <td><strong>Album</strong></td>
			  <td><strong>Artist</strong></td>
			  <td><strong>Style</strong></td>
			  <td><strong>Location</strong></td>
			</tr>
			<?php do { ?>
			  <tr> 
			  <td><img src="<?php echo $row_Search['AlbumCoverThumbnailURL']; ?>"></td>
			  <td><a href="albumdetail.php?AlbumID=<?php echo $row_Search['AlbumID']; ?>">
			  <?php echo $row_Search['AlbumName']; ?></a></td>
			  <td><?php echo $row_Search['ArtistGroupName']; ?></td>
			  <td><?php echo $row_Search['ArtistStyle']; ?></td>
			  <td><?php echo $row_Search['AlbumLoc']; ?></td>
			</tr>
			<?php } while ($row_Search = mysql_fetch_assoc($Search)); ?>
		</table>
		<?php } ?>
<?php } else {?>
		<table width="100%" border="0" cellpadding="2">
			<tr> 
			  <td>&nbsp;</td>
			  <td><strong>Album</strong></td>
			  <td><strong>Artist</strong></td>
			  <td><strong>Style</strong></td>
			  <td><strong>Location</strong></td>
			</tr>
			<?php do { ?>
			<tr> 
			  <td><img src="<?php echo $row_Catalog['AlbumCoverThumbnailURL']; ?>"></td>
			  <td><a href="albumdetail.php?AlbumID=<?php echo $row_Catalog['AlbumID']; ?>">
			  <?php echo $row_Catalog['AlbumName']; ?></a></td>
			  <td><?php echo $row_Catalog['ArtistGroupName']; ?></td>
			  <td><?php echo $row_Catalog['ArtistStyle']; ?></td>
			  <td><?php echo $row_Catalog['AlbumLoc']; ?></td>
			</tr>
			<?php } while ($row_Catalog = mysql_fetch_assoc($Catalog));   ?>
			   </table> 
			   <?php } ?>	

</td>

[laserlight]

Where does $Catalog come from?

Have you connected to your database server, selected the database etc?

[russlock]

yes, connections are there.

[laserlight]

You need to answer my first question: where does $Catalog come from?

It should contain a resource returned from a query.

[russlock]

sorry, just started at this. this is the first portion of an example i am trying to learn on.

<?php require_once('Connections/RecordstorePHP.php'); ?>
<?php

/ set the allowed order by columns /
$default_sort = 'ArtistGroupName';
$allowed_order = array ('AlbumName', 'ArtistGroupName','AlbumLoc');

/ if order is not set, or it is not in the allowed
list, then set it to a default value. Otherwise,
set it to what was passed in. /
if (!isset ($GET['order']) ||
!in_array ($GET['order'], $allowed_order)) {
$order = $default_sort;
} else {
$order = $_GET['order'];
}

mysql_select_db($database_RecordstorePHP, $RecordstorePHP);
$query_LatestNews = "SELECT * FROM news";
$LatestNews = mysql_query($query_LatestNews, $RecordstorePHP) or die(mysql_error());
$row_LatestNews = mysql_fetch_assoc($LatestNews);
$totalRows_LatestNews = mysql_num_rows($LatestNews);

mysql_select_db($database_RecordstorePHP, $RecordstorePHP);
$query_Search = "SELECT * FROM Album, Artist WHERE Album.ArtistID = Artist.ArtistID ORDER BY $order";
$Search = mysql_query($query_Search, $RecordstorePHP) or die(mysql_error());
$row_Search = mysql_fetch_assoc($Search);
$totalRows_Search = mysql_num_rows($Search);

$colname_Search = "1";
if (isset($HTTP_GET_VARS['searchcatalog'])) {
$colname_Search = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['searchcatalog']
: addslashes($HTTP_GET_VARS['searchcatalog']);
}

mysql_select_db($database_RecordstorePHP, $RecordstorePHP);

$query_Search = "SELECT * FROM album, artist WHERE
(album.AlbumName LIKE '%%$colname_Search%%' OR album.AlbumLoc LIKE
'%%$colname_Search%%' OR
artist.ArtistGroupName LIKE '%%$colname_Search%%' OR
artist.ArtistStyle LIKE '%%$colname_Search%%') AND
album.ArtistID = artist.ArtistID ORDER BY ArtistGroupName";

$Search = mysql_query($query_Search, $RecordstorePHP) or die(mysql_error());
$row_Search = mysql_fetch_assoc($Search);
$totalRows_Search = mysql_num_rows($Search);

?>

[russlock]

SORTED.
Where i had the word search, it should have read catalog.

working fine now, but thanks a lot !!

mysql_select_db($database_RecordstorePHP, $RecordstorePHP);
$query_Search = "SELECT * FROM Album, Artist WHERE Album.ArtistID = Artist.ArtistID ORDER BY $order";
$Search = mysql_query($query_Search, $RecordstorePHP) or die(mysql_error());
$row_Search = mysql_fetch_assoc($Search);
$totalRows_Search = mysql_num_rows($Search);