Jump to content

rlgriffo

Members
  • Content count

    41
  • Joined

  • Last visited

About rlgriffo

  • Rank
    Dedicated Member

Users Experience

  • Experience
    Beginner
  • Area of Expertise
    I'm Learning

Profile Information

  • Location
    Australia
  1. The weirdest problem I've seen

    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
  2. div to bottom of table cell

    hi thanks for the reply, yes I have tried that. The particular reason is because it is a request of my client.
  3. div to bottom of table cell

    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.
  4. thanks for the replies ...am looking into it now!!
  5. 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
  6. sorry the part with all the dates & "news" that expand etc
  7. Hi, I am wondering how hard a system like this page is to implement into a website - what is inviolved?
  8. 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
  9. searching database from browser

    I thought the `sql search` was referring to the search field?
  10. searching database from browser

    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
  11. searching database from browser

    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 ?>
  12. searching database from browser

    sorry Pat, another question, do i add the sql search field in the "results" file? Is anywhere in there fine?
  13. searching database from browser

    hmm no i dont...thank you...ill try again
  14. searching database from browser

    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..
  15. current page display in nav

    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!!
×