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

[guitarromantic]

Anyone?

[Steve]

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

I see this:

mysql_query($q2 ) or die;

but before that line I don't see any connection code. Maybe there
should be some connection code?

---
Steve

[guitarromantic]

Ah, I removed my included config.php and opendb.php just for security
purposes so my password/hostname etc weren't posted up here, should
have specified.

[Jerry Stuckle]

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

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

Did you dump your database and check it? What's actually in the
'Cover_Image' column for the row with id 679, for instance?

It might help as a debugging aid to echo the results returned by your query.
--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[guitarromantic]

Yeah, I know for a fact that row #679 is definitely not holding all of
the data being displayed there. SOME of it is, just not certain fields,
they stay the same no matter what the ID.

[Jerry Stuckle]

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

Yeah, I know for a fact that row #679 is definitely not holding all of
the data being displayed there. SOME of it is, just not certain fields,
they stay the same no matter what the ID.

Again, what is there?

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

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[guitarromantic]

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).

[Steve]

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).

It occurs to me that you must be using Apache's modrewrite to map fancy
URLs to your script displayreview.p hp?id=xyz - is it set up identically
for live and dev?

---
Steve

[guitarromantic]

Steve wrote:

It occurs to me that you must be using Apache's modrewrite to map fancy
URLs to your script displayreview.p hp?id=xyz - is it set up identically
for live and dev?

Yeah - the dev site is an exact replica of the live one, only with URLs
changed etc for functionality. You can use URLs of that form you
specified with this system, I've tried both and it makes no difference.