Display results as URL - click to display record

tanaka99

here's my existing code ... how can I modify it to echo the results with the Dealer Names as URLs, when clicked on will display that record?

<?php

if ($DlrAccess == 888) {
$searchedit = $HTTP_POST_VARS['searchedit'];
if (strlen($searchedit) < 1) $searchedit = $HTTP_POST_VARS['searchedit'];

session_register("searchedit");
$searchedit = $HTTP_POST_VARS['searchedit'];

<table width="760" border="0" cellspacing="0" cellpadding="5" background="images/common/logoback.jpg">
<tr><td colspan="2" valign="top">
<font face="Verdana,Geneva,Arial,Helvetica,sans-serif" size="-2"><b><a href="index.php">Home</a> > Select User To Edit<br></b></font><p align=center>
<font face="verdana,Arial" color=#000000 size=4>Tanaka's Partner Area - EDIT USER INFORMATION</font><br>
<form action="http://www.tanaka-usa.com/index.php?d=5&b=edit1" name=edit1 method="post">

<table width=480 border=5 cellpadding=5 align=center background="images/common/logoback.jpg">
<tr><td bgcolor=#EE7218 align=center>
<font face="verdana,Arial" color=#000000 size=2><b>Enter UserID to Edit<b></font></td></tr>

<tr><td align=center>
<font face="verdana,Arial" color=#000000 size=2>UserID:</font>
<input type="text" name="searchedit" size="10" maxsize="15">

<br>

<?php

include("dbinfo.inc.php");

mysql_connect(localhost,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");

$query = "SELECT * FROM Dealers WHERE DlrName LIKE '$searchedit%'";

$result=mysql_query($query);
$num=mysql_numrows($result);

$i=0;

echo "<table border=\"2\" align=\"center\"><tr valign=\"middle\" align=\"center\"><td bgcolor=\"#c0c0c0\"><font size=2><b>User Name</b></td><td bgcolor=\"#c0c0c0\"><font size=2><b>User City</b></td><td bgcolor=\"#c0c0c0\"><font size=2><b>User ID</b></td><td bgcolor=\"#c0c0c0\"><font size=2><b>Dlr Number</b></td></tr>";

while ($i < $num) {

$EditName=mysql_result($result,$i,"DlrName");
$EditCity=mysql_result($result,$i,"DlrCity");
$EditID=mysql_result($result,$i,"UserID");
$EditNumber=mysql_result($result,$i,"DlrNumber");

echo "<tr align=\"left\" valign=\"top\"><td><font size=2>$EditName</td><td><font size=2>$EditCity</td><td align=\"right\"><font size=2>$EditID</td><td align=\"center\"><font size=2>$EditNumber</td></tr>";

++$i;
}

echo "</table><br><font size=\"2\" face=|\"verdana,arial\"><br><br><br>";

}

</body>
</html>

batman

Try this:

$id = $_GET['DlrName']; 
if(isset($id)) 
{ 
$query = mysql_query("SELECT * FROM table WHERE id='$id'"); 
$rows = mysql_num_rows($query);
$results = mysql_fetch_array($query);
if($rows > 0)
{
$EditName=$results['DlrName']; 
$EditCity=$results['DlrCity']; 
$EditID=$results['UserID']; 
$EditNumber=$results['DlrNumber']; 
}
echo "<tr align=\"left\" valign=\"top\"><td><font size=2>$EditName</td><td><font size=2>$EditCity</td><td align=\"right\"><font size=2>$EditID</td><td align=\"center\"><font size=2>$EditNumber</td></tr>"; 
} 
else 
{ 
$query = mysql_query("SELECT * FROM table"); 
$row = mysql_fetch_array($query); 
foreach($row as $id) 
{ 
$id2 = $row['UserID']; 
echo "<a href=\"$PHP_SELF?id='$id2'\">$id</a>"; 
} 
}

tanaka99

My whole site is encased in an index.php script. does the php_self still work on a page with this kind of address:

http://www.tanaka-usa.com/index.php?d=5&b=edit1

batman

There are two different ways you can go. If the d and b and / or whatever else variables there are are not nessecary, then just leave my code how it is. If it is nessecary, then just add some variables then change the link around.

$id = $_GET['DlrName'];
$d = $_REQUEST['d'];
$b = $_REQUEST['b'];

if(isset($id))  

{  

$query = mysql_query("SELECT * FROM table WHERE id='$id'");  

$rows = mysql_num_rows($query); 
$results = mysql_fetch_array($query); 
if($rows > 0) 
{ 
$EditName=$results['DlrName'];  

$EditCity=$results['DlrCity'];  

$EditID=$results['UserID'];  

$EditNumber=$results['DlrNumber'];  

} 
echo "<tr align=\"left\" valign=\"top\"><td><font size=2>$EditName</td><td><font size=2>$EditCity</td><td align=\"right\"><font size=2>$EditID</td><td align=\"center\"><font size=2>$EditNumber</td></tr>";  

}  

else  

{  

$query = mysql_query("SELECT * FROM table");  

$row = mysql_fetch_array($query);  

foreach($row as $id)  

{  

$id2 = $row['UserID'];  

echo "<a href=\"$PHP_SELF?d='d'&b='b'&id='$id2'\">$id</a>";  

}  

}

tanaka99

the 'd' and 'b' variables indicate the folder and file type. So the above code should work in this case?

tanaka99

When I implement the code ... irregardless of what I put in the seach box ... the first record in the database table is displayed in this fashion:

10011001BOBSENGINE CLINICBOBSENGINECLINIC129METHOWST129METHOWST ...

So it's pulling the first record, duplicating each field, and when I click on it, it brings me to the home page, which is the catch all default. ??????

What I'm hoping to achieve is to type a Dealer Name (or partial name) into the search box, get a list of results with the dealer name hot linked, so when it's clicked it displays the entire record of the selected dealer.

batman

Ok..try this. Type in a dlr name in the textbox and see if it does what you want. The links won't work though, but I'm just trying to get this a step at a time. 🙂

<?
$id = $_POST['dlrname']; 
$d = $_REQUEST['d']; 
$b = $_REQUEST['b']; 


if(($submit) && (isset($id)))   

{   

$query = mysql_query("SELECT * FROM table WHERE id LIKE '%$id%'");  

$row = mysql_fetch_array($query);   

foreach($row as $id)   

{   

$id2 = $row['UserID'];   

echo "<a href=\"$PHP_SELF?d='d'&b='b'&id='$id2'\">$id</a>";   

}   

}
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="<?$PHP_SELF?>">
  <input type="text" name="dlrname">
  <input type="submit" name="Submit" value="Submit">
</form>
</body>
</html>

tanaka99

the search box comes up, but when I type something in it just resets ... nothing ... just the search box again.

Is there away to tweak my existing code ... it seems I'm so close?