linking to more info from queried list

[rfigley]

I have a page which I list people from a directory using a search which gives a result like:

Name Address Phone Details
Name1 address1 phone1 detail_link
name2 address2 phone2 detail_link
etc

Of course each of these records has an ID but also a lot of additional information. I want the "detail_link" to use the ID of the selected link (record) to retrieve that information. Not sure how the code should go to do that.

[bretticus]

Is your search database driven? What have you tried thus far?

[rfigley]

yes sorry, it is PHP running on MySQL

The link is going to a page that Queries all the data for each record, but it needs the ID from the initial querie passed to it and not sure how to do it.

[bretticus]

Please post the query used, the loop to display the records, and your table structure.

[bretticus]

Ok, well, I'll give the generic answer then...

Your table should have an AUTO_INCREMENT id field. Maybe it's called PersonID or ID (I dunno 'cause you never posted the things I asked for.)

You'll have an SQL query like 'SELECT ...' or 'SELECT Name, Address, Phone, Details ...'. If it's the variant--if that field exists in your table--you can use something like:

echo "details.php?id=" . $rows['PersonID'];

On your details page, use the same query (or one specifying more table fields) and append something like:

$query = "SELECT ... WHERE PersonID = " . $_GET['id']; 

to the query.

If you can't be more specific, I suggest you read the manual, there are many examples.

[rfigley]

Yeah sorry I didn't get that to you.

Table structure as follows:
tenant_ID int(5) No

client_name varchar(30) No

date_filed varchar(12) No

time varchar(4) No

tenant_name varchar(30) No

tenant_address varchar(30) No

tenant_case_no varchar(5) No

tenantcase_no varchar(6) No

answer varchar(5) No

answer_by date No 0000-00-00

court_date date No 0000-00-00

judgement_date date No 0000-00-00

writ varchar(5) No

writ_date date No 0000-00-00

scheduled varchar(5) No

paid varchar(5) No

skipped varchar(5) No

details_link varchar(30) No

Depending on the search, I use

$query = ("SELECT * FROM tenant_profile");[/I]
for a full list or

$query = ("SELECT FROM tenant_profile WHERE $query = ("SELECT FROM tenant_profile WHERE client_name LIKE '%$query%'");
to sear by client

once that is done I want to hyper link the "details_link" to a page that will search from the ID retrieved.

[rfigley]

sorry about that [/I] that was supposed to make that line italicised and left out the other .

[Roger_Ramjet]

I use the following code for this. It creates a table of results and each field in the table is hyperlinked to the details page. If you want just one link for each row then modify accordingly

while ($row = mysql_fetch_array($result)) {
	$link = '<a href="main.php?go_search=1&go_field=track&go_string=' . $row['track'] . '" target="mainframe">';
  	echo '<tr><td>' . $link . $row['track'] . '</a></td>
  		<td align="left">' . $link . $row['ref'] . '</a></td>
  		<td align="left">' . $link . $row['d_name'] . '</a></td>
  		<td align="right">' . $link . $row['curr'] . $row['amt'] . '</a></td>
  		<td align="right">' . $link . $row['curr'] . $row['amt_due'] . '</a></td>
  		<td title="' . $row['status'] . '">' . $link . $row['code'] . '</a></td></tr>';
}

The target script main.php uses $_GET to recover the ID (track) passed in the link url, and then uses that ID to query the database.

The above script generates the following html so you can see what I mean

	<tr><th>track</th><th>Demo ref</th><th>name</th><th>amount</th><th>balance</th><th>status</th></tr><tr>29118</a></td>
		<td align="left"><a href="main.php?go_search=1&go_field=track&go_string=29118" target="mainframe">123456</a></td>
  		<td align="left"><a href="main.php?go_search=1&go_field=track&go_string=29118" target="mainframe">SMITHS PATISSERIE</a></td>
  		<td align="right"><a href="main.php?go_search=1&go_field=track&go_string=29118" target="mainframe">£17317.65</a></td>
  		<td align="right"><a href="main.php?go_search=1&go_field=track&go_string=29118" target="mainframe">£0.00</a></td>
  		<td title="Part 36 settlement received - balance to w/o"><a href="main.php?go_search=1&go_field=track&go_string=29118" target="mainframe">P06</a></td></tr>
  	<tr><td><a href="main.php?go_search=1&go_field=track&go_string=29119" target="mainframe">29119</a></td>
  		<td align="left"><a href="main.php?go_search=1&go_field=track&go_string=29119" target="mainframe">123457</a></td>
  		<td align="left"><a href="main.php?go_search=1&go_field=track&go_string=29119" target="mainframe">JONES MACHINERY LTD</a></td>
  		<td align="right"><a href="main.php?go_search=1&go_field=track&go_string=29119" target="mainframe">£1257.35</a></td>
  		<td align="right"><a href="main.php?go_search=1&go_field=track&go_string=29119" target="mainframe">£0.00</a></td>
  		<td title="Paid in full"><a href="main.php?go_search=1&go_field=track&go_string=29119" target="mainframe">P07</a></td></tr>
  	<tr><td><a href="main.php?go_search=1&go_field=track&go_string=29120" target="mainframe">29120</a></td>
  		<td align="left"><a href="main.php?go_search=1&go_field=track&go_string=29120" target="mainframe">234567</a></td>
  		<td align="left"><a href="main.php?go_search=1&go_field=track&go_string=29120" target="mainframe">BILL BRIGGS STAINED GLASS</a></td>
  		<td align="right"><a href="main.php?go_search=1&go_field=track&go_string=29120" target="mainframe">£1637.52</a></td>
  		<td align="right"><a href="main.php?go_search=1&go_field=track&go_string=29120" target="mainframe">£0.00</a></td>
  		<td title="Paid in full"><a href="main.php?go_search=1&go_field=track&go_string=29120" target="mainframe">P07</a></td></tr>
  	<tr><td><a href="main.php?go_search=1&go_field=track&go_string=29126" target="mainframe">29126</a></td>
  		<td align="left"><a href="main.php?go_search=1&go_field=track&go_string=29126" target="mainframe">345678</a></td>
  		<td align="left"><a href="main.php?go_search=1&go_field=track&go_string=29126" target="mainframe">BOLDER PROMOTIONS LTD</a></td>
  		<td align="right"><a href="main.php?go_search=1&go_field=track&go_string=29126" target="mainframe">£329.44</a></td>
  		<td align="right"><a href="main.php?go_search=1&go_field=track&go_string=29126" target="mainframe">£0.00</a></td>
  		<td title="Paid in full"><a href="main.php?go_search=1&go_field=track&go_string=29126" target="mainframe">P07</a></td></tr>

[rfigley]

OK, this looks good, so how would the main.php script go? Or am I missing something?

[rfigley]

or what if in place of:

a href="main.php?go_search=1....

I used:

a href="$_GET['tenant_ID']?go_search=1....

?

[Roger_Ramjet]

Sorry I took so lone to reply - my user id got screwed up and I could not login for a while.

I may have confused you a bit with my GET vars: I use so many here.

The generated link needs to pass the selected ID back to the target script , as a minimum. Mine target script is very general-purpose so I also tell it that it needs to process a search 'go_search=1' and what field or fileds to search on 'go_field=track'.
I'm also using frames.
You probably don't need to go that far so would only need to use a link like this

$link = '<a href="target.php?id=' . $row['id'] . '>';

your 'target.php' would take the ID from GET vars and insert it into a query string then display the results

<? target.php
$query = "SELECT * FROM tenant_profile WHERE ID = " . $_GET['id'];
?>