[Resolved] pass $myrow[0] to another page via url - help needed please!!

ioloop

hi people

i have a database query that returns multiple rows which are iterated and displayed. the problem ive got is that i want to display one row element on another page when a user clicks on a result row. i need to pass this one bit of info via a url in something like the form:

detail.php?detail=$myrow[0]

$myrow[0] typically contains a large amount of text. it passes through to the detail page but passes as the text string - which obviously only then displays the first word...

i dont need to pass an entire array so dont need to serialize.. how can i do it?

thanks for any help

Drakla

Pass the primary key for the row, have you got an auto incrementing primary key? If not it might be useful to get one.

Or if it's a search the search parameters and the index needed, assuming you have reproducable results you could use LIMIT offset, 1

ab4net

thats right, if you use the primery key is better ..
but now for your problem ...
i suggest that to creat a form ... and the user clicks on a bot ...
and include a hidden field in the form named any thing and assing a value of whatever you want to post in the next page :
<input type='hidden' name='details' value='<?php echo $myrow[0]?>'>

or if you like .. try the :

$details=urlencode($myrow[0]);

and pass the $details in the URL ..
try it ..
:bemused:

ioloop

Originally posted by Drakla
Pass the primary key for the row, have you got an auto incrementing primary key? If not it might be useful to get one.

Or if it's a search the search parameters and the index needed, assuming you have reproducable results you could use LIMIT offset, 1

yes i have an auto incrementing primary key but i wouldnt know how to use it...

here is my actual line of code:

if ($myrow[0]) {
printf("<a href='detail.php?detail[0]=urlencode($myrow[4])"' target='detail'>%s</a>",$myrow[0]);

}

ioloop

got it working!!

i used :

if ($myrow[0]) {
$detail = urlencode($myrow[4]);
echo "<a href='detail.php?detail=$detail' target='detail'>$myrow[0]</a>";
}

thanks for your help 😃