Intermittent problem Accessing URL:..

Anon

Hello,

    I hope somebody out there can help me. The information I am about to give out is sketchy but its all I have.  I have a site which I have just moved from one ISP to another. it is a simple framed ,database backed site which allows people to click on a category type such as household goods and then be given a list of what is in that category. The database is simply one table with a catid column with different numbers representing different categories. I use php 4 and mysql. 

     Now all works ok most of the time but every now and again and too often to be acceptable one gets the following error message

 The attempt to load 'Accessing URL:http:www.mydomain.com/php/filename.php?catid=7' failed

 I have contacted my ISP regarding this and they are checking it out but give me the impression  that I am really on my own with this one. I know the details above are sketchy but I just thought I would ask. Thanks in advance to anyone who taxes their brains on this one.

Regards

John

Anon

well... first off, POST THE CODE TO THE SCRIPT!!

seriously read your message and then figure out what even the greatest php guru would say?

........ you have an error on line 7, off by 1........

this is why you aren't getting any responses.

Anon

MIchael,

See below for code snippet, I hope it helps you give me an answer.

<?php
include ("minibasket.inc");
$db_name = "dbname";
$connection = @mysql_connect("hostname","dbname","password") or die("couldn't connect");
$db = @mysql_select_db($db_name,$connection) or die("couldn't connect");
$today = date("M dS Y");
?>

<head>
	<meta http-equiv="content-type" content="text/html;charset=ISO-8859-1">
	<title>Liptons Discount Store</title>
	<csscriptdict import>
		<script src="../GeneratedItems/CSScriptLib.js"></script>
	</csscriptdict>
	<link rel="stylesheet" href="../valu.css">
	<csactiondict>
		<script><!--

CSInit[CSInit.length] = new Array(CSILoad,/CMP/'button6',/URL/'../i/buttons/add.gif',/URL/'/i/buttons/add0.gif',/URL/'','');
CSInit[CSInit.length] = new Array(CSILoad,/CMP/'button7',/URL/'../i/buttons/add.gif',/URL/'/i/buttons/add0.gif',/URL/'','');

// --></script>
</csactiondict>
</head>

<body bgcolor="#ffffff" leftMargin="0" topMargin="0" onload="CSScriptInit();">
	<?php
	if  ($searching == "yes")
	{
	$searchresult = mysql_query("select * from products where proddesc like \"%$searchdesc%\" ");
	$newsearchdesc=$searchdesc;
		if (!$searchresult)
		   {
		   	echo  ("error performing query 1 ". mysql_error());
    		exit();	
    	   }
    	If (mysql_affected_rows()) 
			{
   			echo ("<p> your product search found " . mysql_affected_rows() . " products </p> "); 
   			}
   		?>
	<table border="0" cellpadding="0" cellspacing="0" width="524">
		<?php
		While ($row = mysql_fetch_array($searchresult)) 
		{
		?>
			<tr height="205">
				<td height="205" colspan="3">
					<table border="0" cellpadding="0" cellspacing="2" width="515">
						<tr>
							<td width="160" valign="top"><img src='<?php echo $row["prodimageaddress"]?>' width="160" height="200" border="0"></td>
							<td>
								<div align="center">
									<table border="0" cellpadding="0" cellspacing="2" width="347">
										<tr>
											<td colspan="2">
												<div align="center">
													<h2><?php echo $row["prodname"] ?></h2>
												</div>
											</td>
										</tr>
										<tr>
											<td colspan="2">
												<div align="left">
													<p><?php echo $row["proddesc"] ?></p>
												</div>
												<div align="left">

												</div>
											</td>
										</tr>
										<tr>
											<td>
												<div align="center">
													<p><?php echo $row["prodorderno"] ?></p>
												</div>
											</td>
											<td>
												<div align="center">
												<csobj w="114" h="28" t="Button" ht="/i/buttons/add0.gif"><a href="<?php echo $PHP_SELF; ?>?proddesc=<?php echo $proddesc; ?>&searching=yes&searchdesc=<?php echo $newsearchdesc;?>&id=<?php echo $row["prodorderno"] ?>&price=<?php echo $row["prodpricepunt"]?>&basket=<?php echo $row["prodname"] ?>" target="_self" onmouseover="return CSIShow(/*CMP*/'button6',1)" onmouseout="return CSIShow(/*CMP*/'button6',0)" onclick="return CSButtonReturn()"><img src="../i/buttons/add.gif" width="114" height="28" name="button6" border="0"></a></csobj></div>
											</td>
											</td>
										</tr>
										<tr>
											<td>
												<div align="center">
													<h2>&pound;<?php echo $row["prodpricepunt"]?></h2>
												</div>
											</td>
											<td>
												<div align="center">
													<h2>&euro;<?php echo $row["prodpriceeuro"] ?></h2>
												</div>
											</td>
										</tr>
									</table>
									<h2></h2>
								</div>
							</td>
						</tr>
					<?php
	}
	?>
					</table>