This is topic Bit of PHP MySQL help needed... in forum Books, Films, Food and Culture at Hatrack River Forum.


To visit this topic, use this URL:
http://www.hatrack.com/ubb/main/ultimatebb.php?ubb=get_topic;f=2;t=027327

Posted by Troubadour (Member # 83) on :
 
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?
 
Posted by TomDavidson (Member # 124) on :
 
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 ]
 
Posted by fugu13 (Member # 2859) on :
 
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.
 
Posted by Troubadour (Member # 83) on :
 
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 ]
 
Posted by fugu13 (Member # 2859) on :
 
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.
 
Posted by fugu13 (Member # 2859) on :
 
Oh, and it sounds like your code just isn't inserting the information into the database, but I can't tell without more information.
 
Posted by Troubadour (Member # 83) on :
 
Cool... hmm.. well, too many code snippets to paste here, I'll contact you off the forum, Fugu...
 


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