jhollin1138

From the reviews I read online, the PHP/MySQL for Dummies book doesn't seem that good. I had one when I was learning Unix and wasn't to impressed. I learned more from the HP-UX reference manuals that came with the server then I did with the "Dummy" book. Based on some of the reviews I read, I ordered a copy of "PHP and MySQL Web Development, Second Edition" by Luke Welling & Laura Thomson. I probably am still going to need something that strictly focuses on MySQL, but I am going to wait and see if I can figure it using the sites people have mentioned and the book I ordered. Thanks for all the good suggestions!

Thanks for the help. I don't have a problem with the PHP side, it is more the MySQL query structure I am confused with. PHP.net is a good source, if you know what you are looking for. Unfortunately, their examples of queries are limited and pretty basic. As for W3 Schools, they don't have anything on MySQL queries that I could find. It is an excellent site, I have used it before to learn CSS and as a basic HTML resource.

Thanks Don, that looks very helpful. Of course if anyone knows of more sites, it wouldn't hurt.

First off, I am a MySql newbie and I just started teaching myself PHP. I am trying to figure out how to query a MySql database and I have no idea how to structure it. I have read a few things online, but the sites I found still left me confused. Does anyone good resources (either online or book) on doing MySql? The more examples of queries the better.

You don't need to create a gallery to use SPGM. All you really need to do is copy your pictures and thumbnails to a folder, and it generates the gallery. You can, if you like, name your gallery using a text file called "gal-desc.txt" that contains your gallery title. Also, yo can caption your pictures/thumbnails using another text file called "pic-desc.txt" (in the case of SPGM-Vid, it should be called "vid-desc.txt"). Neither are required to actually generate the gallery.

You are right; however I really don't want to say to much about the project I am working on because I don't want people (although probably nobody here) to say "are you done yet?" I am just a hobbyist and I play around with PHP after I get the kid to bed on the nights my wife works. So I have no actual date for completion. The must import thing that really is needed to be known is what I explained in my posts. That an existing script is generating "table 2", the overall height of which can be changed (however it can be predicted, it just takes allot more work to do so and will more then triple the complexity of the PHP script). Table 1, is what my script will generate and will be an add-on navigation menu for table 2. I admit it; I was just trying find a "lazy" solution for getting the bottom of table 1 and table 2 to line up. At this point, it doesn't sound like there is an easy solution to do it. I'll come back to it later or just adjust my layout and concept.

Thanks John & Serpentine: I really need to have two separate tables, the project I have started working on will only truly work as two tables. Without letting the "cat out of the bag" table 2 is already being generated by "script 1". What I am working on is table 1, it will generate a navigation system for table 2. Any change to the "two table concept" will require a significant change to "script 1" and I cannot do that. Right now, the changes required to "script 1" for using "two tables" are minor (adding the "table", "tr" and "td" open and closed tags). I think, at this point I am going to not worry about the bottom of the two tables always lining up. It would have given the two tables a cleaner look, but everything will still function if they don't line up. I might come back to this problem after I get everything else working.

I'm not sure I understand, rookie html person here. Can you give me an example? Maybe this might be a better explanation. I am writing a PHP script to generate a web page. Table 1 is going to be for site navigation and table 2 is going to contain the main site information. Both tables are generated by the script, that is why the information may vary. The last row for table 1 will be for the site update date, and the last row for table 2 will be for the site copyright information. I understand now that I might be going at it the wrong way with using two tables, I am open to other suggestion.

That works, until this happens: ><table border="2"> <tr valign="top"> <td> <table border="2"> <tr> <td>Some stuff, table 1</td> </tr> <tr> <td> </td> </tr> <tr valign="bottom"> <td>Some more stuff, table 1</td> </tr> </table> </td> <td> <table border="2"> <tr> <td>Some stuff, table 2</td> </tr> <tr> <td> Some more stuff, table 2<br /> Second line of stuff in this cell. </td> </tr> <tr valign="bottom"> <td>Even more stuff, table 2</td> </tr> </table> </td> </tr> </table> This is what happens. I always want the bottom rows of table 1 and 2 to be in line. The page I am working on, the content of both tables can vary.

I need some help with tables. Let's say I have this: ><table> <tr> <td> <table> <tr> <td>Some stuff, table 1</td> </tr> <tr valign="bottom"> <td>Some more stuff, table 1</td> </tr> </table> </td> <td> <table> <tr> <td>Some stuff, table 2</td> </tr> <tr> <td>Some more stuff, table 2</td> </tr> <tr valign="bottom"> <td>Even more stuff, table 2</td> </tr> </table> </td> </tr> </table> I want the last rows of table 1 and 2 to line up along the bottom and that isn’t what I end up with. I know how to set the height of table 1 and 2 to 100%, but that seems to auto-adjust the height of the two rows in table 1. I would rather only the bottom row be the one that is adjusted. I also know I can just put the last row of table 1 and 2 in a row for the main table, that doesn't really doesn't solve my problem since I need table 1 and 2 to remain whole. Lastly, I know I can fix the height of all the rows except the last row of table 1 and 2, and set the table’s heights to 100%. I really don’t want to fix the height of the rows since the content of each row could exceed the fixed height. Is there any way to auto-adjust only one row? Any other ideas?

Well I hate to quote my own post, but here is the link I promised: Emily Rose. The streaming video gallery is a MOD I wrote that adds Streaming Video support to a SPGM photo gallery. It can be found at spgm-vid.jhollin1138.com.

The last time I submitted a ticket to the helpdesk that related to phpBB and cPanel my forum got erased. I think I'll pass for now.

Not on server 76, it still says phpBB "2.0.11 Setup" which 3 version old!

Trust me, I am never going to use cPanel again for something I can do myself. Plus, upgrading my phpBB forums with cPanel would do me more harm then good with the MODs I have installed. I am just shocked that something as dangerous as this doesn't seem to be taken to seriously. A thread that is older then 30 days unless one knew it existed would easily be missed, acting as the warning of this bug isn't really an effective form of communication.

I was wondering, what is the status of this problem?

I use a couple of cron jobs and back-up every evening automatically. For the actual back-up, I use the method described here. I also have cron job set up to save a copy of last nights back-up before starting a new back-up This way, if my new back-up fails, or me MySQL becomes corrupt prior to the next scheduled back-up I should only lose 24 hours. I do need find an automatic way to keep a copy off the server in case of a disk or server failure. I am going to look into "dbsender" for this, thanks again Bruce.

Lots of PHP errors on that page.

After using Web Album Generator for sometime I decided I needed a change. WAG, is pretty simple to use except it generates "HTML" pages that I would need to change to get it to do what I wanted. Plus, adding a picture to an existing album was a pain that needed me to edit a number of "HTML" pages. So just in time for my latest update to my photo gallery, I found this thread. I tried three of the "programs" mentioned; Coppermine, Gallery & SPGM. After trying them all, SPGM is the one for me. Here are some of my reasons. Coppermine: Seemed way to powerful for what I needed. It also seems to be sluggish at times and a little to ridged. I have several "albums" on a few sub-domains, and I felt it would take me multiple copies and forever to get it working the way I wanted it to. Gallery: I admit it, I couldn't figure out how to get it installed and gave up. SPGM: I love this one. In less then the time it took me to get Coppermine configured, I had a photo album on-line with SPGM. After you get SPGM uploaded, all you need to do is create a directory with your pictures and their thumbnails in the "gal" directory (BTW, this can be changed) and you have a photo album. To add a picture, just put it and the thumbnail into the album's directory and it is added to album. It is also highly customizable and can be reformatted to fit my needs. As an added bonus, I was also able to get into to work with my sub-domains and multiple photo albums will not be a problem. All I need to do is have copies of the basic setup files on each sub-domain and only have the "brains" installed once. Like jnull, the author of SPGM will be getting a donation from me real soon. When I am finihsed making my changes, I post a link to my new photo albums.

I am the one that was the lucky guy to find the cPanel phpBB install bug. Lucky me! Yep, cPanel is providing 2.0.11 and 2.0.13 is the current version. I use cPanel's install to help me set up the "config.php" file and the MySQl database, what can I say I'm lazy. It takes less then a minute to set everything up with Cpanel. I don't recommend using cPanel to make any upgrades to phpBB, it is easier to do them by hand in most cases. Plus if you have installed MODs, the upgrade with cPanel doesn't play nicely with them.

@helpbytes: Thanks allot. I think now I understand what I really need to do to HotLink only a few directories. Plus, as an added bonus, you have given me a way to track who is trying to use "my stuff."

@helpbytes: Thanks so much. What can I say am a "htaccess" noob. So if I am reading your post correctly, if I put a "htaccess" file (that I have formated correctly) into a directory, it will affect the subdirectories as well? In addition, placing a "htaccess" into a subdirectory will "override" the "htaccess" of its parent directory? Also, care to share your "php" script?

Is there a way exclude certain folders from HotLink? For example let's say I have a folder I use to post images to the various forums I visit. It would be to much of a pain to add each URL to the list each time I want to post to a new forum. It would be much easier if I could just un-HotLink a folder. Can you do this?

Thanks, I'll look there too.

It is just the images in some folders. I'll have a look at .htaccess, thanks. Password protecting a folder, I can use that too for something else. Now how do I do that?

I am interested in using Hotlink, or something, to prevent information in some folders of my web-space from being used by others. I only want to be selective on the folders I am protecting and not everything. Is there some simple way to do it?