|
|
Posted by Lennart Anderson on 03/19/07 19:41
"Jerry Stuckle" <jstucklex@attglobal.net> skrev i meddelandet
news:wvSdnUTGP722TWPYnZ2dnUVZ_rylnZ2d@comcast.com...
> Lennart Anderson wrote:
>> "Jerry Stuckle" <jstucklex@attglobal.net> skrev i meddelandet
>> news:0oGdneT-v7svMmPYnZ2dnUVZ_s3inZ2d@comcast.com...
>>> Lennart Anderson wrote:
>>>> "Jerry Stuckle" <jstucklex@attglobal.net> skrev i meddelandet
>>>> news:ybqdnXJcAfixAmDYnZ2dnUVZ_vPinZ2d@comcast.com...
>>>>> Lennart Anderson wrote:
>>>>>> "Jerry Stuckle" <jstucklex@attglobal.net> skrev i meddelandet
>>>>>> news:xtCdnUF-VpfLF2DYnZ2dnUVZ_rbinZ2d@comcast.com...
>>>>>>> Lennart Anderson wrote:
>>>>>>>> I'm having a MySQl table wih a lot of information. I want to
>>>>>>>> present some main fields in a table on one page. Each record do, of
>>>>>>>> course, have a unique ID. The presnted table will have one field as
>>>>>>>> a linked field. I want to be able to click this link, retreive the
>>>>>>>> ID information for that record and then present detailed data for
>>>>>>>> that record on the next page.
>>>>>>>> How do I retreive the ID?
>>>>>>>> Any hints are very much appreciated.
>>>>>>>> Thanks
>>>>>>> Put the id in the link itself.
>>>>>>>
>>>>>>> --
>>>>>>> ==================
>>>>>>> Remove the "x" from my email address
>>>>>>> Jerry Stuckle
>>>>>>> JDS Computer Training Corp.
>>>>>>> jstucklex@attglobal.net
>>>>>>> ==================
>>>>>> I think I get the idea but I don't know how to doo that. Can you give
>>>>>> me an aidea of how such a link with, I guess, embedded ID would look
>>>>>> like?
>>>>> Do you know how to do it in html? Same idea - just generated with a
>>>>> PHP echo statement instead.
>>>>>
>>>>> --
>>>>> ==================
>>>>> Remove the "x" from my email address
>>>>> Jerry Stuckle
>>>>> JDS Computer Training Corp.
>>>>> jstucklex@attglobal.net
>>>>> ==================
>>>> No, I do not know how to do that in HTML.
>>>> But, once again, the problem is that I have a number of records
>>>> presented in a table. All records do have unique ID. When preseneted by
>>>> the hTML page they are parsed into "hard-coded" HTML and although I can
>>>> have a field to act as a link I can't get the ID for the special record
>>>> I am selecting. Only the ID for the last presented record will come
>>>> through since that ID is still present in the array. Any hint of how to
>>>> get the ID from any selected record?
>>> OK, posting the code you're using would help a lot.
>>>
>>> --
>>> ==================
>>> Remove the "x" from my email address
>>> Jerry Stuckle
>>> JDS Computer Training Corp.
>>> jstucklex@attglobal.net
>>> ==================
>>
>> Here is the essential part of the code with the presneted table where one
>> of the records field will be a link. I want to retreive the ID for any
>> selefted record from, say, 25 presented.
>>
>> mysql_select_db('db2') or die ('Unable to select database!');
>> // create and execute query
>> $query = "SELECT ID, DATE_FORMAT(addate, '%m-%d') AS adday,
>> DATE_FORMAT(addate, '%H:%i')as adtime, addate, adnamn, adcat,
>> adheader,adtext,adprice,adcats.catname FROM ads, adcats where ads.adcat =
>> adcats.catid order by ID DESC";
>> $result = mysql_query($query)
>> or die ('Error in query: $query. ' . mysql_error());
>> // check if records were returned
>> if (mysql_num_rows($result) > 0)
>> {
>> // iterate over record set
>> // print each field
>>
>> echo '<h2>Test on data retrieval from the data base</h2></br>';
>> echo '<table border=0 cellpadding=2 width = 100% bgcolor="#FFFF99"
>> bordercolor="#FFFFFF">';
>> echo '<tr>
>> <td>Ad-No.</td>
>> <td>Day</td>
>> <td>Time</td>
>> <td>Ad-header</td>
>> <td>Price CI$</td>
>> <td>Category</td>
>>
>> </tr>';
>>
>> while($row = mysql_fetch_object($result))
>>
>> {
>> echo '<tr>';
>> echo '<td width=5% bgcolor="#FFFFFF" align = "right">' . ($row->ID) .
>> '</td>';
>> echo '<td width=4% bgcolor="#FFFFFF">' . ($row->adday) . '</td>';
>> echo '<td width=5% bgcolor="#FFFFFF">' . ($row->adtime) . '</td>';
>> echo '<td width=40% bgcolor="#FFFFFF">' . '<a href= "advertinfo.php" >' .
>> ($row->adheader) . '</td>';
>> echo '<td width = 6% bgcolor="#FFFFFF" align = "right">' .
>> ($row->adprice) . '</td>';
>> echo '<td width = 18% bgcolor="#FFFFFF">' . ($row->catname) . '</td>';
>> echo '</tr>';
>>
>>
>> }
>>
>> echo '</table>';
>>
>> }
>> else
>> {
>> // print error message
>> echo 'No rows found!';
>> }
>>
>>
>
> OK, if you're going to make it a link, you have to pass the id as a
> parameter in the link, i.e.
>
> echo '<td width=40% bgcolor="#FFFFFF">' . '<a href= "advertinfo.php?id=' .
> $row['id'] . " >' . ($row->adheader) . '</td>';
>
> This will pass the link as "advertinfo.php?id=3", for example.
>
> Then in advertinfo.php you use access it with $_GET['id'].
>
> Be sure to use isset($_GET['id']) in case someone comes to this page
> without an id being passed.
>
>
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
Thanks. This seems most promising but don't I need to have some kind of
form method to pass the $_GET variable. Just now the table is presented
without any kind of form tags.
> jstucklex@attglobal.net
> ==================
Navigation:
[Reply to this message]
|