Jump to content

jmd87

Members
  • Posts

    1
  • Joined

  • Last visited

About jmd87

  • Birthday August 13

Previous Fields

  • Languages
    HTML/CSS/PHP/ASP/JAVASCRIPT

Profile Information

  • Location
    UK
  • Interests
    Coding / Music / Guitar / Singing / Gaming

jmd87's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. Hi, Currently I have the below code which grabs the tables and the correct row when i load my website using my row ID (for example: mydomain.com/page.php?ID=1) What I would like it to do is rather than put a number in that I can put the page title in so its displayed like this: Mydomain.php?ID=Home How can I do this please? As I can change this: SELECT * FROM system_setup, menu_item JOIN dow ON dow.id_content = menu_item.id WHERE id = %s to: SELECT * FROM system_setup, menu_item JOIN dow ON dow.id_content = menu_item.id WHERE title = %s but what it does is I can now type in "Mydomain.php?ID=Home" but if I move to another page like "Mydomain.php?ID=contact" it just shows the home page content not the contact content if that makes sense? Can any help please? $maxRows_DetailRS1 = 10;$pageNum_DetailRS1 = 0;if (isset($_GET['pageNum_DetailRS1'])) { $pageNum_DetailRS1 = $_GET['pageNum_DetailRS1'];}$startRow_DetailRS1 = $pageNum_DetailRS1 * $maxRows_DetailRS1; $colname_DetailRS1 = "-1";if (isset($_GET['ID'])) { $colname_DetailRS1 = $_GET['ID'];}mysql_select_db($database_design_online_connection, $design_online_connection);$query_DetailRS1 = sprintf("SELECT * FROM system_setup, menu_item JOIN dow ON dow.id_content = menu_item.id WHERE id = %s", GetSQLValueString($colname_DetailRS1, "int"));$query_limit_DetailRS1 = sprintf("%s LIMIT %d, %d", $query_DetailRS1, $startRow_DetailRS1, $maxRows_DetailRS1);$DetailRS1 = mysql_query($query_limit_DetailRS1, $design_online_connection) or die(mysql_error());$row_DetailRS1 = mysql_fetch_assoc($DetailRS1); if (isset($_GET['totalRows_DetailRS1'])) { $totalRows_DetailRS1 = $_GET['totalRows_DetailRS1'];} else { $all_DetailRS1 = mysql_query($query_DetailRS1); $totalRows_DetailRS1 = mysql_num_rows($all_DetailRS1);}$totalPages_DetailRS1 = ceil($totalRows_DetailRS1/$maxRows_DetailRS1)-1; Kind Regards Joe
×
×
  • Create New...