Detail Page shows Record 1

bstanic · bstanic

Was working my way through Matt Brown's Tutorial (Recordstore on Macromedia
site
[url]http://www.macromedia.com/devnet/mx/dreamweaver/articles/record_store.html[/url]) but
have experienced problems with the Detail page and Edit page. I used MySQL and
PHP on a Remote Server and Database. No mater what record you click on in the
Master page, it shows the same value in the detail Page i.e. the Deault Record.
When running a test on the Variable within the Recordset (Detail page), it
returns the Default record only. Same applies when editing a page from a link
in the Master page. When creating the Variable within the Recordset (Detail
page), the Tutorial gives the values to be input; Variable Name = colname,
Default = 1, and Run Time Value =$HTTP_GET_VARS['albumid']. I have checked,
rechecked and checked again to no avail. Can anyone help? Please find code
attached <?php require_once('Connections/THP.php'); ?> <?php
$colname_albumdetail = '1'; if (isset($HTTP_GET_VARS['albumid'])) {
$colname_albumdetail = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['albumid'] :
addslashes($HTTP_GET_VARS['albumid']); } mysql_select_db($database_THP, $THP);
$query_albumdetail = sprintf('SELECT * FROM album, artist WHERE album.artistid
= artist.artistid AND albumid = %s', $colname_albumdetail); $albumdetail =
mysql_query($query_albumdetail, $THP) or die(mysql_error()); $row_albumdetail =
mysql_fetch_assoc($albumdetail); $totalRows_albumdetail =
mysql_num_rows($albumdetail); ?> <html> <head> <title>Untitled Document</title>
<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'>
</head> <body link='#0000FF' vlink='#0000FF'> <div align='center'> Album Detail Page 
<table width='80%' border='1' cellspacing='2' cellpadding='2'> <tr>
<td>ID</td> <td><?php echo $row_albumdetail['albumid'];
?></td> </tr> <tr> <td>Album</td> <td><?php echo $row_albumdetail['albumname']; ?></td> </tr>
<tr> <td>Artist</td>
<td><?php echo
$row_albumdetail['artistgroupname']; ?></td> </tr> <tr>
<td>Style</td> <td><?php echo $row_albumdetail['artiststyle'];
?></td> </tr> <tr> <td>Artist Names</td> <td><?php echo $row_albumdetail['artistnames']; ?></td>
</tr> <tr> <td>Notes</td> <td><?php echo $row_albumdetail['albumnotes']; ?></td> </tr>
<tr> <td>Price</td>
<td><?php echo
$row_albumdetail['albumprice']; ?></td> </tr> <tr>
<td>&nbsp;</td>
<td>&nbsp;</td> </tr>
</table> <a href='artistlistadd.php'>Add Artist</a> | <a href='albumadd.php'>Add Album</a> | <a
href='artistlistadmin.php'>Artist List Admin</a> | <a href='albumadminlist.php'>Album List</a>
 </div> </body> </html> <?php mysql_free_result($albumdetail); ?> Master
Page code is as follows: <?php require_once('Connections/THP.php'); ?> <?php
$maxRows_catalog = 10; $pageNum_catalog = 0; if
(isset($HTTP_GET_VARS['pageNum_catalog'])) { $pageNum_catalog =
$HTTP_GET_VARS['pageNum_catalog']; } $startRow_catalog = $pageNum_catalog *
$maxRows_catalog; mysql_select_db($database_THP, $THP); $query_catalog =
'SELECT * FROM album, artist WHERE album.artistid = artist.artistid ORDER BY
artist.artistgroupname'; $query_limit_catalog = sprintf('%s LIMIT %d, %d',
$query_catalog, $startRow_catalog, $maxRows_catalog); $catalog =
mysql_query($query_limit_catalog, $THP) or die(mysql_error()); $row_catalog =
mysql_fetch_assoc($catalog); if (isset($HTTP_GET_VARS['totalRows_catalog'])) {
$totalRows_catalog = $HTTP_GET_VARS['totalRows_catalog']; } else {
$all_catalog = mysql_query($query_catalog); $totalRows_catalog =
mysql_num_rows($all_catalog); } $totalPages_catalog =
ceil($totalRows_catalog/$maxRows_catalog)-1; ?> <html> <head> <title>Untitled
Document</title> <meta http-equiv='Content-Type' content='text/html;
charset=iso-8859-1'> </head> <body link='#0000FF' vlink='#0000FF'> Album Admin
Area <table width='80%' border='1' align='center' cellpadding='2'
cellspacing='2'> <tr> <td>ID</td> <td>Album</td> <td>Artist</td>
<td>Style</td> <td>Price</td> <td>&nbsp;</td>
</tr> <?php do { ?> <tr> <td><?php echo $row_catalog['albumid']; ?>&nbsp;</td>
<td><a href='albumdetail.php?<?php
echo $row_catalog['albumid']; ?>='><?php echo $row_catalog['albumname'];
?></a></td> <td><?php echo
$row_catalog['artistgroupname']; ?></td> <td><?php echo $row_catalog['artiststyle']; ?></td>
<td><?php echo
$row_catalog['albumprice']; ?></td> <td><a href='albumadminupdate.php?<?php echo
$row_catalog['albumid']; ?>='>Edit</a></td> </tr> <?php } while
($row_catalog = mysql_fetch_assoc($catalog)); ?> </table> <div align='center'>
<a href='artistlistadd.php'>Add
Artist</a> | <a
href='albumadd.php'>Add Album</a> | <a href='artistlistadmin.php'>Artist List
Admin</a> </div> </body> </html> <?php mysql_free_result($catalog);
?>

Paul Whitham TMM · Paul Whitham TMM

I can't read PHP but the usual problem is that the Master page is not
passing across the variable to the detail page. Check the link from the mast
page has a URL variable named exactly how you have it in the SQL on the
detailed page.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"bstanic" <webforumsuser@macromedia.com> wrote in message
news:d19m6e$ps2$1@forums.macromedia.com...

> Was working my way through Matt Brown's Tutorial (Recordstore on

Macromedia

> site
>

[url]http://www.macromedia.com/devnet/mx/dreamweaver/articles/record_store.html[/url])
but

> have experienced problems with the Detail page and Edit page. I used MySQL

and

> PHP on a Remote Server and Database. No mater what record you click on in

the

> Master page, it shows the same value in the detail Page i.e. the Deault

Record.

> When running a test on the Variable within the Recordset (Detail page), it
> returns the Default record only. Same applies when editing a page from a

link

> in the Master page. When creating the Variable within the Recordset

(Detail

> page), the Tutorial gives the values to be input; Variable Name = colname,
> Default = 1, and Run Time Value =$HTTP_GET_VARS['albumid']. I have

checked,

> rechecked and checked again to no avail. Can anyone help? Please find code
> attached <?php require_once('Connections/THP.php'); ?> <?php
> $colname_albumdetail = '1'; if (isset($HTTP_GET_VARS['albumid'])) {
> $colname_albumdetail = (get_magic_quotes_gpc()) ?

$HTTP_GET_VARS['albumid'] :

> addslashes($HTTP_GET_VARS['albumid']); } mysql_select_db($database_THP,

$THP);

> $query_albumdetail = sprintf('SELECT * FROM album, artist WHERE

album.artistid

> = artist.artistid AND albumid = %s', $colname_albumdetail); $albumdetail =
> mysql_query($query_albumdetail, $THP) or die(mysql_error());

$row_albumdetail =

> mysql_fetch_assoc($albumdetail); $totalRows_albumdetail =
> mysql_num_rows($albumdetail); ?> <html> <head> <title>Untitled

Document</title>

> <meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'>
> </head> <body link='#0000FF' vlink='#0000FF'> <div align='center'>

<font

> size='5' face='Arial, Helvetica, sans-serif'>Album Detail Page

> <table width='80%' border='1' cellspacing='2' cellpadding='2'> <tr>
> <td>ID</td>

<td><font

> face='Arial, Helvetica, sans-serif'><?php echo

$row_albumdetail['albumid'];

> ?></td> </tr> <tr> <td> sans-serif'>Album</td> <td> sans-serif'><?php echo $row_albumdetail['albumname']; ?></td>

</tr>

> <tr> <td><font face='Arial, Helvetica,

sans-serif'>Artist</td>

> <td><?php echo
> $row_albumdetail['artistgroupname']; ?></td> </tr> <tr>
> <td>Style</td>

<td><font

> face='Arial, Helvetica, sans-serif'><?php echo

$row_albumdetail['artiststyle'];

> ?></td> </tr> <tr> <td> sans-serif'>Artist Names</td> <td><font face='Arial,

Helvetica,

> sans-serif'><?php echo $row_albumdetail['artistnames']; ?></td>
> </tr> <tr> <td> sans-serif'>Notes</td> <td> sans-serif'><?php echo $row_albumdetail['albumnotes']; ?></td>

</tr>

> <tr> <td><font face='Arial, Helvetica,

sans-serif'>Price</td>

> <td><?php echo
> $row_albumdetail['albumprice']; ?></td> </tr> <tr>
> <td>&nbsp;</td>
> <td>&nbsp;</td>

</tr>

> </table> <a href='artistlistadd.php'> sans-serif'>Add Artist</a> sans-serif'> | <a href='albumadd.php'>Add Album</a> | <a
> href='artistlistadmin.php'>Artist List Admin</a> | <font

face='Arial,

> Helvetica, sans-serif'><a href='albumadminlist.php'>Album

List</a>

> </div> </body> </html> <?php mysql_free_result($albumdetail); ?>

Master

> Page code is as follows: <?php require_once('Connections/THP.php'); ?>

<?php

> $maxRows_catalog = 10; $pageNum_catalog = 0; if
> (isset($HTTP_GET_VARS['pageNum_catalog'])) { $pageNum_catalog =
> $HTTP_GET_VARS['pageNum_catalog']; } $startRow_catalog = $pageNum_catalog

*

> $maxRows_catalog; mysql_select_db($database_THP, $THP); $query_catalog =
> 'SELECT * FROM album, artist WHERE album.artistid = artist.artistid ORDER

BY

> artist.artistgroupname'; $query_limit_catalog = sprintf('%s LIMIT %d, %d',
> $query_catalog, $startRow_catalog, $maxRows_catalog); $catalog =
> mysql_query($query_limit_catalog, $THP) or die(mysql_error());

$row_catalog =

> mysql_fetch_assoc($catalog); if

(isset($HTTP_GET_VARS['totalRows_catalog'])) {

> $totalRows_catalog = $HTTP_GET_VARS['totalRows_catalog']; } else {
> $all_catalog = mysql_query($query_catalog); $totalRows_catalog =
> mysql_num_rows($all_catalog); } $totalPages_catalog =
> ceil($totalRows_catalog/$maxRows_catalog)-1; ?> <html> <head>

<title>Untitled

> Document</title> <meta http-equiv='Content-Type' content='text/html;
> charset=iso-8859-1'> </head> <body link='#0000FF' vlink='#0000FF'> align='center'>Album

Admin

> Area <table width='80%' border='1' align='center'

cellpadding='2'

> cellspacing='2'> <tr> <td> sans-serif'>ID</td> <td> Helvetica, sans-serif'>Album</td> <td> face='Arial, Helvetica, sans-serif'>Artist</td>
> <td> sans-serif'>Style</td> <td> Helvetica, sans-serif'>Price</td> <td>&nbsp;</td>
> </tr> <?php do { ?> <tr> <td> sans-serif'><?php echo $row_catalog['albumid']; ?>&nbsp;</td>
> <td><a

href='albumdetail.php?<?php

> echo $row_catalog['albumid']; ?>='><?php echo $row_catalog['albumname'];
> ?></a></td> <td><?php

echo

> $row_catalog['artistgroupname']; ?></td> <td> Helvetica, sans-serif'><?php echo $row_catalog['artiststyle'];

?></td>

> <td><?php echo
> $row_catalog['albumprice']; ?></td> <td> Helvetica, sans-serif'><a href='albumadminupdate.php?<?php echo
> $row_catalog['albumid']; ?>='>Edit</a></td> </tr> <?php } while
> ($row_catalog = mysql_fetch_assoc($catalog)); ?> </table> <div

align='center'>

> <a href='artistlistadd.php'><font face='Arial, Helvetica,

sans-serif'>Add

> Artist</a> | <a
> href='albumadd.php'>Add Album</a> | <a href='artistlistadmin.php'>Artist

List

> Admin</a> </div> </body> </html> <?php

mysql_free_result($catalog);

> ?>
>

bstanic · bstanic

Paul, thank you for your feedback. After looking at the problem, I sort of
arrived at the same conclusion. Unfortunately, I am a Newbie (learning fast)
and unable to fully understand the code. I have checked the URL Variables for
any obvious mistakes but to no avail. I have even re-read the Tutorial a few
times and I would appear to have followed the instructions accurately (with the
exception of using Remote Servers and database). So I am still none the wiser,
unfortunately. Thanks again for you input.

bstanic · bstanic

Problem Fixed. As always, it was a mistake, easy to overlook. For anyone with
the same problem, here is what I did to rectify the problem. When creating the
link in the Master page (to the detail page), press the Folder Icon to choose
the file for the Detail Page, then click the Parameters button. Enter the field
Name in the first box (in my case it was, albumid. Then tab over to the Value
box and click the lightning Bolt and choose the Field that will be mapped to
the name you just put in (in my case the field name was the same as the
Parameter Name, albumid. The first mistake I made in the above was; I clicked
the Lightning Bolt next to the Name box and chose the Field from there. This
was obviously the wrong Bolt I clicked. When Tabbing over to the Value box, a
new Lightning Bolt appears. This is the one you want to click to map the Field
ID to the Parameter name. The second error I made, and mentioned by Paul, was
'albumid' was lower case in the Master page and uppercase in the Detail page. I
checked this so many times, I do not know how I missed it. The moral behind
the story is; if it does not work first time, don't panic and think you have
lost the plot. the answer will probably turn out to be something quite simple.:D

Paul Whitham TMM · Paul Whitham TMM

Just a point of reference, the second error you found, namely the difference
in letter case is only a problem if you are running on a Unix box (which a
lot of cheap PHP hostings are) as a windows box is not bothered by letter
case used in this way.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"bstanic" <webforumsuser@macromedia.com> wrote in message
news:d1bvqb$bnr$1@forums.macromedia.com...

> Problem Fixed. As always, it was a mistake, easy to overlook. For anyone

with

> the same problem, here is what I did to rectify the problem. When

creating the

> link in the Master page (to the detail page), press the Folder Icon to

choose

> the file for the Detail Page, then click the Parameters button. Enter the

field

> Name in the first box (in my case it was, albumid. Then tab over to the

Value

> box and click the lightning Bolt and choose the Field that will be mapped

to

> the name you just put in (in my case the field name was the same as the
> Parameter Name, albumid. The first mistake I made in the above was; I

clicked

> the Lightning Bolt next to the Name box and chose the Field from there.

This

> was obviously the wrong Bolt I clicked. When Tabbing over to the Value

box, a

> new Lightning Bolt appears. This is the one you want to click to map the

Field

> ID to the Parameter name. The second error I made, and mentioned by Paul,

was

> 'albumid' was lower case in the Master page and uppercase in the Detail

page. I

> checked this so many times, I do not know how I missed it. The moral

behind

> the story is; if it does not work first time, don't panic and think you

have

> lost the plot. the answer will probably turn out to be something quite

simple.:D

>

Detail Page shows Record 1

Thread Tools

Display

Detail Page shows Record 1

Similar Questions and Discussions

Edit page shows blank page!

Page is updated on publish but contribute shows oldversion of page

Can I open a page as a popup using GOTO DETAIL PAGE

Detail Page ALWAYS SHOWS RECORD 1

Detail Page ALWAYS SHOWS RECORD 1

Re: Detail Page shows Record 1

Re: Detail Page shows Record 1

Re: Detail Page shows Record 1

Re: Detail Page shows Record 1

Posting Permissions