FacebookTwitter
Hatrack River Forum   
my profile login | search | faq | forum home

  next oldest topic   next newest topic
» Hatrack River Forum » Active Forums » Books, Films, Food and Culture » Bit of PHP MySQL help needed...

   
Author Topic: Bit of PHP MySQL help needed...
Troubadour
Member
Member # 83

 - posted      Profile for Troubadour   Email Troubadour         Edit/Delete Post 
Calling all code gurus...

Having some issues with a piece of open source gallery software that I'm trying to modify... despite the fact that I know almost nothing about php or MySQL. I'm essentially trying to add another field to the upload page (which also collects image information already), store that new info in the db, and have it called back when the image is viewed (like the other info collected.)

Now I've been basically using the Dreamweaver "find all in site" function to manually hunt through the code. I've got it so the field appears both in the upload and view stage. I'm just getting nothing back on that field after an upload.

Is there any software out there (preferably shareware) that allows you to trace through this sort of thing? I really just need to replicate what one other field is already doing, I only want another field for easier viewing for the user.

Failing that, is there something I'm missing in DW that will make life easier?

Posts: 2245 | Registered: Nov 1998  |  IP: Logged | Report this post to a Moderator
TomDavidson
Member
Member # 124

 - posted      Profile for TomDavidson   Email TomDavidson         Edit/Delete Post 
Have you added the SQL UPDATE statemnt for that field (and the field to the SQL SELECT), or have you just added the field itself? For that matter, have you already modified the database to contain that field?

[ September 11, 2004, 11:24 AM: Message edited by: TomDavidson ]

Posts: 37449 | Registered: May 1999  |  IP: Logged | Report this post to a Moderator
fugu13
Member
Member # 2859

 - posted      Profile for fugu13   Email fugu13         Edit/Delete Post 
Copy/paste a code snippet surrounding what you're altering.

Also, it doesn't sound like you've modified the DB to accomodate the new field.

Posts: 15770 | Registered: Dec 2001  |  IP: Logged | Report this post to a Moderator
Troubadour
Member
Member # 83

 - posted      Profile for Troubadour   Email Troubadour         Edit/Delete Post 
I had already added the new fields to the DB and only used code snippets from the field I want to copy, simply modifing them to utilise a new variable (which I believe I've declared in the correct place) and point towards the new field....

So... no software that helps track through?

And Thanks!

[ September 11, 2004, 08:22 PM: Message edited by: Troubadour ]

Posts: 2245 | Registered: Nov 1998  |  IP: Logged | Report this post to a Moderator
fugu13
Member
Member # 2859

 - posted      Profile for fugu13   Email fugu13         Edit/Delete Post 
As before, code snippets would be helpful. And no, there's really no software that does that sort of thing. Its both considered simple enough (though sometimes isn't in practice [Wink] ) that one shouldn't need a code tool and can be done so many different ways there's really no way of just analyzing the problem completely and telling you the answer.

There are of course tools which can help you analyze the situation, but without having a better idea of what your problem is (which is still somewhat blank to me), I can't much point you in the right direction.

If you posted snippets surrounding all the code you modified, I'm pretty certain I could either solve the problem or come close, though.

Posts: 15770 | Registered: Dec 2001  |  IP: Logged | Report this post to a Moderator
fugu13
Member
Member # 2859

 - posted      Profile for fugu13   Email fugu13         Edit/Delete Post 
Oh, and it sounds like your code just isn't inserting the information into the database, but I can't tell without more information.
Posts: 15770 | Registered: Dec 2001  |  IP: Logged | Report this post to a Moderator
Troubadour
Member
Member # 83

 - posted      Profile for Troubadour   Email Troubadour         Edit/Delete Post 
Cool... hmm.. well, too many code snippets to paste here, I'll contact you off the forum, Fugu...
Posts: 2245 | Registered: Nov 1998  |  IP: Logged | Report this post to a Moderator
   

   Close Topic   Feature Topic   Move Topic   Delete Topic next oldest topic   next newest topic
 - Printer-friendly view of this topic
Hop To:


Contact Us | Hatrack River Home Page

Copyright © 2008 Hatrack River Enterprises Inc. All rights reserved.
Reproduction in whole or in part without permission is prohibited.


Powered by Infopop Corporation
UBB.classic™ 6.7.2