Emir

Ah, thanks for mentioning that. I didn't know browsers would do such a thing. For some reason my Firefox isn't doing it. It is opening it in a new window even though the 'open new windows in tabs' setting is enabled. Regardless, I was planning on using a Lightbox-type script at some point anyway, so I'll go ahead and find one to implement. Thanks again. Any other tips are also welcome if someone wants to chime in. Alex

Hi Everyone, Just thought I would try to get some thoughts on my site at http://www.imgwarehouse.com. I'm not a web designer, so what I did simply consisted of altering a template. Anyway, the site is suppose to offer cheap stock photos/images with any of the preview images being free. Alex

Hey everyone, Looks like I was finally able to figure out what to do. I was able to fix everything with a couple RewriteRule statements. RewriteRule ^[a-zA-Z/]*/images/(.*)$ images/$1 RewriteRule ^[a-zA-Z/]*/includes/(.*)$ includes/$1 That pretty much fixed everything for the image, css, etc links. Thanks for looking though. Maybe someone else might find this useful? Emir

Hello, I have having a bit of trouble getting my images to display properly when using a MVC system with mod_rewrite. I have the following in a .htaccess file: RewriteEngine on RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule ^(.*)$ index.php?route=$1 [L,QSA] For the most part it works just as I want: If I type in 'http://www.mysitehere.com/users/login/' it would interpret the request as 'http://www.mysitehere.com/index.php?route=users/login'; however, the trouble I have is that now my images link to something like 'http://www.mysitehere.com/users/login/images/logo.gif'. It should be something like 'http://www.mysitehere.com/images/logo.gif'. Anyone have any ideas how I can use mod_rewrite to correct this as well? Any other method would be greatly appreciated as well. Thank you for your time! Emir

Hmm, well, nevermind, I think I found what I wanted. Could I do this with AJAX? Does anyone know of a good site for learning it?

Hello, I was wondering if anyone knew of any tutorials or anything on how to load data dynamically from a server as it is needed. I am thinking of something like Kelly Blue Book does: http://www.kbb.com/kbb/UsedCars/default.aspx In other words, I want to be able to change an option on my dropdown field, and the data for the next dropdown will be downloaded from the server. I don't want every single value to be loaded into an array; It would waste too much time and bandwidth for me. Anyway, I am trying to do this on a WAMP server, so If someone could help me out, I would greatly appreciate it! Thanks, Emir

Hello, Maybe someone could help me figure out why my phpMyAdmin 2.9.1.1 setup won't work anymore. As far as I last knew, this worked on the setup I currently have; however, I have reinstalled Apache 2.2.3, PHP 5.2.0, and MySQL 5.0.27, but now the the setup script for phpMyAdmin won't work. It only refreshed the page (or acts like it) when I click to add a server or anything (except for donating or going to phpMyAdmin's Homepage). Does this script use different dynamic extentions that I need to enable or something? On a side note, I can use a previous config file and phpMyAdmin itself will work; however, there appears to be no style to it. Even the table menu is in a straight vertical line, which is annoying because the list of Browse, Query, Insert, etc now take up the whole page to list them all (new lines after each of them) Anyway, if someone could help it would be greatly appreciated! Emir

Hmm, what is the "nums" table. As far as I know, I don't have a table equivalent to "nums." Thanks.

The subscription table also has a [u]begin date[/u] as well as a [u]due date[/u]. I am guessing that after the payment is received that someone manually (or a script) changes the [u]begin date[/u] and the [u]due date[/u] of the [b]subscription[/b] to the next interval. Say someone has a [u]begin date[/u] of 01-04-2006 and their payment is [u]due[/u] 04-04-2006. I am guessing that on the [u]due date[/u] or when the payment is received, the data is changed to having the [u]begin date[/u] of 04-04-2006 and the [u]due date[/u] of 07-04-2006. This is all assuming that the [b]subscription[/b] is for a [b]service[/b] that has a quarterly [u]occurence[/u]. Thanks for the SQL, I'll try it to see if it works!

Hello, Basically, I am dealing with a database that has customer [b]subscriptions[/b] to [b]services[/b]. each [b]subscription[/b] has a [u]due date[/u] for their next payment. Each [b]service[/b] has a monthly [u]occurence[/u] field that contains a number for what the payment interval is (1 is monthly, 3 is quarterly, 12 is yearly, etc), and it also the has the payment [u]amount[/u] for each [b]service[/b]. The problem I am having is that I can't figure out how to forecast the data correctly. I can create a query perfectly fine that lets me see [i][b]by month[/b][/i], how much would be due [i]currently[/i]; however, I cannot, for the life of me, figure out how I can forecast the data: I need the [u]amount[/u] for a [u]due date[/u] in January to also be added to also be added to the total in April, for example. Basically the report that I want generated would appear like this: [table][tr][td]MONTH NAME[/td][td]TOTAL DUE[/td][/tr] [tr][td]January[/td][td]2314.00[/td][/tr] [tr][td]February[/td][td]3251.00[/td][/tr] [tr][td]March[/td][td]4251.00[/td][/tr] [tr][td]And so on for a whole year[/td][/tr] [/table] I can get this report to generate just fine with the current [u]due dates[/u], but I somehow need to be able to forecast the next payments into the proper months. A quarterly payment that has a [u]due date[/u] in January, needs to also be added to April, July, and October's totals. If someone could help me from ripping my hair out, I would appreciated it GREATLY! Is this even possible? Thank you, Emir

So if that is the case, would I set the length of my table field to 40 in order to be able to contain all of the encrypted characters? So, in the end I would have a PHP/HTML form with a maxlength of 30 (or something), while I would set the length of the database table field to 40. That is where I am getting confused. Thanks again for the help.

Hello, This may be a stupid question, but I was wondering whether the PASSWORD() function stores the data as a larger or smaller size in the destination table field: Say I have a PHP/HTML form that has a password input. I have the maxlength property of 30 for this field. I happen to enter a password that is 30 characters in length. When this field is sent to the database and encrypted with the PASSWORD() function, does it make it larger, smaller, or the same size. I am just wondering this because I am not sure whether I should keep the same size for my Form and for my Table's Field. Any help would be greatly appreciated, Thank you, Emir

I apologize for coming across as wanting a script to solve my problems. I only desired to be "pointed in the the right direction." Anyway, Caesar, thank you for your time, what you have given me should help me greatly!

Hello, Basically, I am wanting something like this to happen: A php script copies a file from a directory that is unreadable by the public to a directory is readable. The person then downloads this file and somehow the file is deleted afterwards. Is there a way to detect when a person is done downloading a file? I am not sure if this is a good or even feasible way of accomplishing what I want. If you know how to do this, of some tutorials, or any other alternative method, please let me know. I simply am wanting to make a site where someone purchases a "file" and the file is delivered to them while keeping the files unreadable at their source. Any help would be greatly appreciated! Thank you, Emir