Expert Challenge?? Please Help..

[kpowning]

I have built a website for a client in .php and the website takes for ever to load. The website is: http://www.rickhays.com . Can anyone tell me why. I have built many websites with .php and I have never ran into this problem before...

Any help would be greatly appreciated..

Thanks,
Kyle😕 😕 😕

[Dread]

I am not sure why your site is loading so slowly, are you making any queries to a database? Do you have any javascript running in a loop? I have a suggestion tho for the flash buttons on the left. Instead of making one for each link, make a template button with a dynamic text field. You can pass the title of the button and its url through the code for the embed of the button, for example:

template_button.swf?title=Band Bio&url=band_bio.html

Of course you will need to configure the button to accept the url as a variable as well.

[kpowning]

Thanks for the input.. This is the only .php scripting on the webpage.

<?php require('Connections/gspot.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    

    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "newsletter")) {
  $insertSQL = sprintf("INSERT INTO Rhaysnewsletter (Name, `Email Address`) VALUES (%s, %s)",
                       GetSQLValueString($HTTP_POST_VARS['Name'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Email_Address'], "text"));

  mysql_select_db($database_gspot, $gspot);
  $Result1 = mysql_query($insertSQL, $gspot) or die(mysql_error());

  $insertGoTo = "/conf/newsconfirm.php";
  if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}
mail($Email_Address,"www.rickhays.com Fan Club Confirmation","
Dear: $Name,\r\n
We are glad that you have taken the time to sign-up to our fan club monthly newlsetter. You will recieve the latest information
on the band, concerts, new songs and much more. Feel free to ride this pony for as long as you can hold on.\r\n
Sincerely,
Rick Hays & American Steel
[url]www.rickhays.com\r\n\r\n[/url]
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
To Unsubscribe: [url]http://www.rickhays.com/conf/unsubscribe.php?Email_Address=[/url]$Email_Address",
"From: [email][e-mail][/email]\r\n". 
"Reply-To: [email][e-mail][/email]\r\n". 
"Return-Path: [email][e-mail][/email]\r\n"); 
?>