vendlus

ooh... I like it... I'm off to play with it.... I'll be back later... or sooner if I get frustrated

ok, good. my cgi-bin folder is being evil. well... actually, I just don't enough about what I'm doing with it to get it to work. I can get a test script to work, but not that createdb one. Oh well. What all do you want it to do if rewritten in php??

Sorry I haven't gotten back to you on this. It's been a hectic few days and now I'm sitting at home sick. I'm hoping to figure out what the deal is tonight though. I should have time to look into it.

I don't think I've ever heard of the PEAR package.... what is it??

wow, I'm really impressed that actually works.

You said your tables are populated, correct?? In that case, I'm not sure what the problem is with your being able to see nothing. I went in and manually put an entry into my table (since I know nothing about running perl scripts, which is what I think that tabfu_createdb file is). Anywhat, I got my artist name to come up when I click the correct letter. >http://bohicagaming.com/testing/tab/tabfu.php?showdir=a Click the name then shows the correct file in there. The problem then is that the script is written for the folder to be named 'tabs' and to be off of the home directory. I can fix that easily enough, but it doesn't seem that you can even see the names yet, so there's no use in doing that yet. Give me an example of one of your table fields for the song and artist fields. Mine is like this... I'm honestly not even sure what the artistdir field does since the page does a query to get the song list. If it becomes important, I'll go in and look at the code. So give me an example so that I can compare what we've got going on here and I'll see what I can come up with for you. ---------------------------------------- btw, mods.... Is this thread ok, or should we take this to pm's (assuming he hasn't resolved this a couple of days ago)?? I was putting it out here in case the problem is something people could learn from. - Vendlus ...... another thing... the guy who wrote that script blows at giving instructions.

I'm a little confused, but I'll try and help you out (extra coding/php experience is always a good thing). Your basic problem is that there are simply no results found, correct?? From the link you gave, I didn't get any errors, just no results to anything. Are there other issues that you're having with it?? I'm going to try and set it up as a test here and see what I can come up with. - vendlus

Ok, question. Obviously, I'm testing my site on my computer before uploading it. Since I tend to make a lot of minor changes, things get uploaded quite a bit. For this reason, I have a config.php file that holds my various addresses that will change. For example, this is what I have on the test server... >$pubdir = "F:/myTesting/phpdev/www/"; // public directory for site $siteurl = "http://localhost"; // site url for homepage $imagesite = "http://localhost/images/site"; //url for where the site images are located I then simply don't upload the config file and there's one already there with the real site info on it. Here comes my problem.... At the moment I'm hardcoding the location of the config file into the pages that use it (which is almost every single one since I have my image folder listed in there). What's the best way to change the hardcoded location on my computer's testing station (F:/myTesting/phpdev/www/conf.php) to the site's (/home/bohican/public_html/conf.php)?? I'm currently thinking of opening all of the files and doing a mass 'find/replace' in all of them. Is there a better way?? ................... I just realized that there must be relative folder positioning for includes with php.... what's the syntax for that and would that do what I want?? I remember being wary of relative positioning but I'm forgetting why at the moment. Is it a security issue? Does anyone know what it may have been?? oh well, I guess that's enough of my rambling. - Vendlus *edit* after thinking about it (well... after working on something else and this popping into my head), I'm wondering if relative includes can be used for a folder outside your public_html folder?? If not, am I stuck using a mass find/replace??

wow... for now at least, that looks awesome Dennis. I do want to eventually setup a second comp to run apache and all on, but for now that's a great little link.

Thanks guys. I'm in no huge hurry to get this done, so I'll check out everything and decide what I feel like dealing with. I've got enough parts lying around that I'm thinking of building a new box that I may put apache on. I just need another comp case and some sort of graphics card to do that though (I'm sure I have one somewhere). I'll probably stick with having mySQL on my server, but thanks for letting me know that I'd have to get remote connectivity turned on to do it the other way. I probably would have racked my head for days trying to figure out what the problem was.

I want a way to test my php scripts without having to upload them. Let me see if I have this correct. I'll need php installed. I'll need a server of somesort installed, right?? Will I need mySQL installed (since almost all of my php accesses a database at some point), or can I just point it to my mySQL database on the server here?? Anything else I'll need??

I'm confused. What script are you using??

Yeah, I think that like surefire said, it's important not to confuse what each one does. This is how I see/use them. HTML/CSS are all about how things look. Whether you use tables or divs or whatever, these two are simply there to make things pretty. I'd certainly start by learning this first (I didn't and am still no good at css). PHP is used to do things. This could be processing a contact form on your site, or a poll that you've setup, or simply retrieving information from a database to display. PHP doesn't care what the info looks like, it just processes the info/text. mySQL is simply a database to store your data. That's it. I personally don't use SSI or CGI. In practice (for me at least), it all works like this. mySQL stores all of my data for my pages. php connects to mySQL and gets that data. HTML puts that data in somesort of layout. CSS then makes it all pretty. Hopefully that makes a little bit of sense. - Vendlus

Which forum are you using?? If you're using Invision, go to the Admin CP. In the left pane, click on "Users and Groups" Click on "Delete User(s)" Search on 'clandsc' Click the delete button on the page that comes up.

I'm not sure about this, but I am not sure what you want can be done. Currently, www already is a subdomain that points to your public_html folder. So what you're looking for is a way to change where a subdomain points to, correct? (You want it to point to '/public_html/blog' instead of '/public_html'.) Anyone know how the server knows to send www to public_html?? I would think that is where the change would need to be made (or at least, that's what htaccess would have to override, if possible). *edit* after reading the link surefire gave, it does indeed claim to do what you want. I'm not entirely sure what it's doing either, but that is what it claims to do.

change the above to.... >document.write(today); That should do it. *edit* which if I was actually reading and not just replying, I would have noticed that Wilexa had said this. So... do what Wilexa said.

You should be able to use an .htaccess file in your forum's directory to do what you want. It should affect that folder (and any below it, like 'forum/sigs'), but not others. Here's a thread with what you need to know (I think... I'm new to htaccess). http://forums.devshed.com/t54474/s.html *edit* yes, htaccess does use the referer property, which isn't ideal since it can be faked if the person knows what they are doing. But the odds that enough people will know how (and care enough to go through the trouble) to affect your bandwidth is slim. besides, the only other way I've seen to do it is convoluted, requires sessions, and is fairly slow and cpu intensive (comparatively).

My mother actually got this one a few weeks ago. She doesn't even have an account with paypal. She was smart enough to contact me and ask my opinion before doing anything with it though.

Well, I started off by using SQL Server a few years ago. I had planned to get my MS cert for it, but haven't gotten around to it yet. The site I'm creating is going to be heavily driven by mySQL, so almost all of the coding I've been looking at for the past good while is database code. Since the people who will be helping on the site are mostly database newbies, I've been spending a lot of time writing pages so that they never have to see a query string or care how the tables are connected. Stare at it long enough and you get to know what's going on. It's a good thing I really enjoy it, or I'd go nuts.... now if I could only get someone to pay me to do it....

Ugh... this is twice today that I've found my answer within minutes of posting here. (I really did look all morning for this answer before posting too. ) Anywhat, >SHOW TABLE STATUS does what I want. The comment is one of the fields returned. Thanks anyway to those of you that I know would have answered me. Rock Sign

When you create a table in mySQL, you can add a comment to it. phpMyAdmin let's you do this as a text field at the bottom of the create table form, and the comment is added to the end of the create table query. My question is how to you retrieve the comment?? I found in the mySQL docs about how to set it in the create table statement, but couldn't find how to actually view it. phpMyAdmin displays it on your page when you view the table, so I know it's possible. Does anyone know? Or can point me to a really good mySQL reference site? *edit* for reference, here is the create table statement so that you can see what I'm talking about. I copied this from the statement phpMyAdmin created. The comment I want to retrieve is at the end. >CREATE TABLE `test` ( `id` INT( 10 ) NOT NULL , `comment` VARCHAR( 50 ) NOT NULL , PRIMARY KEY ( `id` ) ) COMMENT = 'This is a test table.'; - Vendlus

go to your cPanel and select 'phpmyadmin' from the bottom right. Select your database on the left. Click on the 'SQL' at the top of the main pane. Either copy that SQL statement into the large textarea there and click 'Go'.... or use the smaller text field below it to select the 'database.sql' file that you have and click 'Go'. Either one should do the same thing. That's it. You should get a success screen from there.

*edit* sorry, double post

ah, I was wondering what those were for. I just figured they were part of the services and didn't mess with them. But since they're just frontpage, I'll probably do as you mentioned and get rid of them (since I really really can't stand frontpage ).

What I've got above seems to be working correctly. I have a news editor who doesn't know anything about sql. I have a couple of different tables that I want him to be able to insert values into, but I don't want to have to write a new page for each one, or have to change the code if I change the table. So I'm writing a page that takes in the name of the table and creates a simple form based on what the fields in the table are. For that reason, I need the 'Type' field split into type and size. I'm using substr_count to check for the field types (I know, I'm sure there's a better way, but I was already using the function elsewhere, so I just copied it over ), but I needed to pull out the length of the fields. Like I said, the code I put up above seems to work for me so far. Sorry if I've confused you by replying to my own question before anyone else could get to it.