rlgriffo

im not sure if it's because you have already fixed the problem, but I just tested it on Firefox using OSX and it's working perfectly. Firefox vs 3.0.4 OSX vs 10.5.2 hope that helps

hi thanks for the reply, yes I have tried that. The particular reason is because it is a request of my client.

Hi I am having a bit of trouble getting the "contact us" button http://rachellegriffin.com/billo/index.php to align to the bottom of it's cell (the brown/grey bit). I want it to be sitting basically a few millimeters off the bottom of the cell Would appreciate some much needed help, Rachelle PS css file is available http://rachellegriffin.com/billo/billo.css if needed.

thanks for the replies ...am looking into it now!!

Hi, I am wondering the cost I'd be looking at to outsource the flash nav on this website http://www.arvato.com The one with all the balls moving around everywhere.... Would appreciate your feedback, Thanks

sorry the part with all the dates & "news" that expand etc

Hi, I am wondering how hard a system like this page is to implement into a website - what is inviolved?

Hi a website i made has a google map, I want to know whether it is possible to add additional place markers of CERTAIN businesses & points of interest on the website's map only - rather than just having the place marker of my business only? I have read about google my maps or something however It doesnt say anywhere that you can add these to your website - from what I understand you can only link to it? Thanks

I thought the `sql search` was referring to the search field?

Thanks Jameset, Am i allowed to list 7 different columns to be searched eg: $query_Recordset1 = sprintf("SELECT business_name, industry, address1, suburb, phonenumber, keywords, business_catagory, info `sql search` FROM business WHERE `name, industry, suburb, address1, keywords, info, catagory` LIKE '%%%s%%'", $colname_Recordset1); Or is it not that simple? Thanks heaps

Hi Pat, I bet you regret offering your help by now I added the sql search field at the top of the results page.... the error has now changed to:Unknown column 'sql search' in 'where clause' Would appreciate your help again - and thank you so much for your time so far!! <input name="sql search" type="text" /> <?php require_once('connect.php'); mysql_select_db($database, $connection); ?> <?php $currentPage = $_SERVER["PHP_SELF"]; $maxRows_Recordset1 = 20; $pageNum_Recordset1 = 0; if (isset($_GET['pageNum_Recordset1'])) { $pageNum_Recordset1 = $_GET['pageNum_Recordset1']; } $startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1; $colname_Recordset1 = "-1"; if (isset($_GET['search-q'])) { $colname_Recordset1 = (get_magic_quotes_gpc()) ? $_GET['search-q'] : addslashes($_GET['search-q']); } mysql_select_db($database, $connection); $query_Recordset1 = sprintf("SELECT business_name, industry, address1, suburb, phonenumber, keywords, business_catagory, info `sql search` FROM business WHERE `sql search` LIKE '%%%s%%'", $colname_Recordset1); $query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1); $Recordset1 = mysql_query($query_limit_Recordset1, $connection) 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; $queryString_Recordset1 = ""; if (!empty($_SERVER['QUERY_STRING'])) { $params = explode("&", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_Recordset1") == false && stristr($param, "totalRows_Recordset1") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams)); } } $queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1); ?> =========================================================================== <?php if ($totalRows_Recordset1 > 0) { // Show if recordset not empty ?> <?php do { ?> <table width="100%" border="1"> <?php if ($totalRows_Recordset1 > 0) { // Show if recordset not empty ?> <tr> <td><a href="<?php echo $row_Recordset1['hyper_link']; ?>"><img src="<?php echo $row_Recordset1['business_name']; ?>" alt="" name="sensual" style="width:100px; height:100px;" border="0"></a></td> <td width="20%" style="padding-left:4px;"><a href="<?php echo $row_Recordset1['hyper_link']; ?>"><span class="style5"><?php echo $row_Recordset1['suburb']; ?></span></a></td> <td style="padding-left:4px; padding-right:4px;"><a href="<?php echo $row_Recordset1['hyper_link']; ?>"><span class="style2"><?php echo $row_Recordset1['phonenumber']; ?></span></a></td> <td style="padding-left:4px; padding-right:4px;"><a href="<?php echo $row_Recordset1['hyper_link']; ?>"><span class="style2">£<?php echo $row_Recordset1['address1']; ?></span></a></td> </tr> </table> <?php } // Show if recordset not empty ?> <?php if ($totalRows_Recordset1 > 0) { // Show if recordset not empty ?> <?php } // Show if recordset not empty ?> <?php if ($totalRows_Recordset1 > 0) { // Show if recordset not empty ?> <br /> <?php } // Show if recordset not empty ?> <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?> <div align="center" class="style59Copy"> <?php if ($totalRows_Recordset1 > 0) { // Show if recordset not empty ?> <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, max(0, $pageNum_Recordset1 - 1), $queryString_Recordset1); ?>"><br> Back </a> <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, min($totalPages_Recordset1, $pageNum_Recordset1 + 1), $queryString_Recordset1); ?>">Next</a> <?php } // Show if recordset not empty ?></div> <?php } // Show if recordset not empty ?> <p align="center" ><?php if ($totalRows_Recordset1 > 0) { // Show if recordset not empty ?> <span class="style43Copy">Page:</span> <?php for ($i=0; $i <= $totalPages_Recordset1; $i++) { $TFM_PagesEndCount = $i + 1; if($i != $pageNum_Recordset1) { printf('<a href="'."%s?pageNum_Recordset1=%d%s", $currentPage, $i, $queryString_Recordset1.'">'.$TFM_PagesEndCount."</a>"); }else{ echo("<strong>$TFM_PagesEndCount</strong>"); } if($i != $totalPages_Recordset1) echo(" "); } ?> <?php } // Show if recordset not empty ?>

sorry Pat, another question, do i add the sql search field in the "results" file? Is anywhere in there fine?

hmm no i dont...thank you...ill try again

Hi Pat (or anyone else) I have had a go at the script - i have made on file called "connect.php" and another called "results.php" The connect file seems to be connecting to the database fine, so i think that isnt the problem, when i open the "results.php" page i get this error: Unknown column 'sql search' in 'field list' Im hoping you can give me some more hints.... This is the code in my "results.php" file <?php require_once('connect.php'); mysql_select_db($database, $connection); ?> <?php $currentPage = $_SERVER["PHP_SELF"]; $maxRows_Recordset1 = 20; $pageNum_Recordset1 = 0; if (isset($_GET['pageNum_Recordset1'])) { $pageNum_Recordset1 = $_GET['pageNum_Recordset1']; } $startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1; $colname_Recordset1 = "-1"; if (isset($_GET['search-q'])) { $colname_Recordset1 = (get_magic_quotes_gpc()) ? $_GET['search-q'] : addslashes($_GET['search-q']); } mysql_select_db($database, $connection); $query_Recordset1 = sprintf("SELECT business_name, industry, address1, suburb, phonenumber, `sql search` FROM business WHERE `sql search` LIKE '%%%s%%'", $colname_Recordset1); $query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1); $Recordset1 = mysql_query($query_limit_Recordset1, $connection) 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; $queryString_Recordset1 = ""; if (!empty($_SERVER['QUERY_STRING'])) { $params = explode("&", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_Recordset1") == false && stristr($param, "totalRows_Recordset1") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams)); } } $queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1); ?> =========================================================================== <?php if ($totalRows_Recordset1 > 0) { // Show if recordset not empty ?> <?php do { ?> <table width="100%" border="1"> <?php if ($totalRows_Recordset1 > 0) { // Show if recordset not empty ?> <tr> <td><a href="<?php echo $row_Recordset1['hyper_link']; ?>"><img src="<?php echo $row_Recordset1['business_name']; ?>" alt="" name="sensual" style="width:100px; height:100px;" border="0"></a></td> <td width="20%" style="padding-left:4px;"><a href="<?php echo $row_Recordset1['hyper_link']; ?>"><span class="style5"><?php echo $row_Recordset1['suburb']; ?></span></a></td> <td style="padding-left:4px; padding-right:4px;"><a href="<?php echo $row_Recordset1['hyper_link']; ?>"><span class="style2"><?php echo $row_Recordset1['phonenumber']; ?></span></a></td> <td style="padding-left:4px; padding-right:4px;"><a href="<?php echo $row_Recordset1['hyper_link']; ?>"><span class="style2">£<?php echo $row_Recordset1['address1']; ?></span></a></td> </tr> </table> <?php } // Show if recordset not empty ?> <?php if ($totalRows_Recordset1 > 0) { // Show if recordset not empty ?> <?php } // Show if recordset not empty ?> <?php if ($totalRows_Recordset1 > 0) { // Show if recordset not empty ?> <br /> <?php } // Show if recordset not empty ?> <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?> <div align="center" class="style59Copy"> <?php if ($totalRows_Recordset1 > 0) { // Show if recordset not empty ?> <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, max(0, $pageNum_Recordset1 - 1), $queryString_Recordset1); ?>"><br> Back </a> <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, min($totalPages_Recordset1, $pageNum_Recordset1 + 1), $queryString_Recordset1); ?>">Next</a> <?php } // Show if recordset not empty ?></div> <?php } // Show if recordset not empty ?> <p align="center" ><?php if ($totalRows_Recordset1 > 0) { // Show if recordset not empty ?> <span class="style43Copy">Page:</span> <?php for ($i=0; $i <= $totalPages_Recordset1; $i++) { $TFM_PagesEndCount = $i + 1; if($i != $pageNum_Recordset1) { printf('<a href="'."%s?pageNum_Recordset1=%d%s", $currentPage, $i, $queryString_Recordset1.'">'.$TFM_PagesEndCount."</a>"); }else{ echo("<strong>$TFM_PagesEndCount</strong>"); } if($i != $totalPages_Recordset1) echo(" "); } ?> <?php } // Show if recordset not empty ?> Also this is my table layout in case that helps..

thank you so much I figured it out!! yay its working When I am drawing the header in on each page the includes says: <? php $bodyid="pagenamehere"; include("header.php"); ?> and then when I am setting the body id in the common header file it says: <body id="<?php echo$bodyid; ?>"> And it works a treat!!! so exciting when something works!! Thanks heaps!!