Weird query results / <title> issues

[guitarromantic]

Hey everyone.

I'm editing some stuff I did last summer, trying to bugfix and improve
stuff. One improvement (or an oversight of the original design) is
adding dynamic <title> tags to my pages. Here's how I originally
structured my php pages:

include header.php (contents are basically my HTML/CSS up to the
<!--begin content--> point)
<php code>
include footer.php (contents are from <!--end content--> onwards).

Obviously this meant I had the same <title> as defined in header.php
for every page, not cool. I went through and revised the structure to
this:

include doctype.php (HTML from the opening document declaration down to
just before <title>)
Then began my query(s), and once the results were grabbed:
echo "<title>$bandNa me - recordName review</title";
include header.php (this file now contains everything below <title>
down to <!--begin content-->)
<php code to output content>
include footer.php (as above)

This worked great for almost all of my pages but one. Here's the link:

http://www.threechords.org/spb/reviews/678

This might look normal to you, but try clicking some of the other
reviews in the left panel. The cover image and headings stay the same,
and the author information at the bottom again stays the same, which is
of course incorrect. I'm not sure where I'm going wrong with my code,
so I'll post up what I'm doing:

http://www.threechords.org/spb/revie...layreview.phps

That file has doctype.php, header.php and footer.php physically
included so you can see their contents too (ordinarily they're included
with php includes).

Any advice as to why I can't get this to work/ how terrible my code
structuring is would be really helpful.

Matt

[joe]

> $author = mysql_query("SE LECT Staff_id, displayname, email FROM users WHERE Staff_id='$Revi ewer_Name'");

Is Staff_id an integer and Reviewer_Name something else, e.g. varchar?
Seems like you would want to compare displayname with Reviewer_Name (I
could be wrong here obviously).

One thing that's odd is that the tite is correctly holding the
Record_Name value, but later in the script it gets lost somehow....

[joe]

Do those other includes (latestreviews. php, latestreviews2. php) have
variables with the same name as those in displayreview.p hp (like
$Band_Name, Cover_Image)?

This may be stating the obvious but from what I could tell, the
variables getting lost/displaying incorrect info are Band_Name,
Record_Name, Cover_Image, and displayname. The rest seem to be coming
through ok, since the text of the review changes appropriately, as does
the score, the link to the band's site, etc.

[guitarromantic]

joe wrote:

$author = mysql_query("SE LECT Staff_id, displayname, email FROM users WHERE Staff_id='$Revi ewer_Name'");
Is Staff_id an integer and Reviewer_Name something else, e.g. varchar?
Seems like you would want to compare displayname with Reviewer_Name (I
could be wrong here obviously).

One thing that's odd is that the tite is correctly holding the
Record_Name value, but later in the script it gets lost somehow....

Despite the names, Reviewer_Name is an integer as well. I changed the
db structure around and was too lazy to change it to something more
meaningful (and thus all the references to it elsewhere).. I suck,
haha.

Yeah, see what I mean? It's a weird error.
joe wrote: Do those other includes (latestreviews. php, latestreviews2. php) have
variables with the same name as those in displayreview.p hp (like
$Band_Name, Cover_Image)?

Yeah they do, I'll try removing the includes for those files and see
what happens.

[Jerry Stuckle]

gu************@ gmail.com wrote:

Jerry Stuckle wrote:

Again, what is there?

Also, please quote what you're replying to. Not everyone has access to
previous messages.

Apologies for that.

Well, we can compare the dev site with the live one:

Live: http://www.scenepointblank.com/reviews/679

Dev: http://www.threechords.org/spb/reviews/679

Try changing the numbers in the URLs: the image, band name, record and
review name are all messed up. Both sites use the same database (the
dev site is a duplicate of the live one).

Again - are you sure you don't have a corrupted database?

Did you try echoing the values you retrieved from the database like I
suggested?

Sometimes an echo here and there does wonders for debugging!
--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===