gizmola

The wildtangent plugin might be something you want to look at. As far as calling directx functions from PHP, I suppose conceptually that's possible.

An iframe is basically a little mini browser window inside your page. That is to say, that wherever you use an iframe, you can embed a totally independent web page. In general the iframe should be avoided.

Basically you backed yourself into a corner by giving out misinformation, and now you don't want to admit you were wrong? md5() shouldn't be used for encryption/decryption. The "rules" were made by the people who devised the algorithm. As better solutions have now been provided, I guess we can move on. As an aside, hostility on this forum is something we try and avoid.

Morpheus: md5() is a one way hash. It was not meant to be used for encryption/decryption and should not be used for such, even via an exploit. Furthermore it's clear from the question that the source (SSN#) is more than 5 characters. With php the standard way to do encryption/decryption is to use the mcrypt library: http://us4.php.net/mcrypt

Start reading the php manual at php.net.

I picked up that you were not a native english speaker. I understand Cody's points, but I also get the feeling you were not trying to use "Dewdspeak" or any of the other annoying things that often help indicate that the person is just going to end up wasting our time. Also, we did outline in our forum posting guidelines that it is never ok here to mention your urgency. Nobody here could care less about the deadlines of people asking for free help. With that said, one key point not to overlook, is the availability of Cody's ext_skel replacement, that he rather humbly mentioned. Read the past messages in this forum for more details. Best of luck.

How did you update your site? Typically people use ftp to upload changes/new files. Any ftp client will allow you to ftp to your site and copy the files back to your computer. Dreamweaver has this capability built in as well, as mentioned in one the of the previous responses to you.

Don't crosspost. Read the forum posting guidelines, link in my sig.

I am personally not going to read posts here anymore. I will be reading them over at the Mysqlfreaks.com forum.

I agree with your comment, except for this part: As you stated, if the database is focused on recording data about students, including classes taken, grades given, teachers etc... then this should be reflected in a normalized database structure. Here\'s a quick data model I did illustrating a full featured database model with a few assumptions made, that -Records All classes by subject -Records a semester (grade period in this model) where class was offered -Indicates teacher who taught class for semester -Records students in the class -Records tests given to class -Records grade for each student for each test given in class This supports any number of teachers, students and classes in combination. It doesn\'t support a class having more than one teacher, but that could be easily added at the cost of a little more complexity.

You definately do not need mysql. If you\'re content to use flat files for any storage you can learn quite a bit of php without touching any of the database api\'s. PHP supports all sorts of databases, and the main reason that it is synonymous with PHP is that compared to most relational databases, mysql is very easy to install and get running (and of course it\'s open source and free) You\'re absolutely right.. that learning these seperate disciplines can be extremely confusing. When the time is right, leann about SQL, relational database design and use, and mysql, then come back to PHP and the mysql functions.

Could you describe why you would have bunch of tables with different people\'s \"Usernames\" in the tablename? Is this for educational purposes... for a school where students will be learning using tables? If so, each student should have their own database, and in that case, the tables will all have the same names. If there\'s some other reason for this design, I suspect you\'ve gotten off on the wrong track.

Can we get some terminology straight? You say you have 2 fields called sales and price, but it sounds like you have two \"Tables\". Mysql works like this: Database contains --Tables are defined by a set of ----Columns You insert Rows into a Table. (A row is synonymous with a \"Record\" or \"Tuple\") Your misuse of the proper terminology makes it impossible to answer your question with anything but a guess.

Did you try and just use the mysql command line utility?

MySQL doesn\'t support subqueries, except perhaps in the most recently released (beta?) version(s). Check your version to determine the status... I don\'t keep abreast of what\'s going on with MySQL development status well enough to give you the specifics.

Ok, you can then order by that column without applying any type of format. Formatting is converting the column to a string, and it\'s underlying format is an integer which will intrinsically sort as you would expect. If you want to format the columns for display, that is not a problem and can be done seperately from the order by, which is to say that you can have columns in your order by that are not in your select list. In your example, simply use a different alias for your formatted date, rather than re-aliasing the original column name and all should work as you want it to.

All I can suggest is that you look at re-installing mysql again. If the chown command didn\'t work then I would submit that you\'ve missed something, or misunderstood a direction. Some things to check out: Your my.cnf file. Take a look at this and verify that your directories are pointing to where they should be and that permissions are appropriate. For example, does your datadir directory have these permissions: drwxr-xr-x 20 mysql mysql 4096 Dec 30 02:58 mysql I suspect your initial issues with permissions may be the root of your series of problems.

All I can suggest is that you take a look at the error logs for mysql and try and determine why it crashed. Security is just a function of entries in a few mysql database tables. There\'s nothing I can think of that would explain what you are seeing.

Using the GRANT SQL statement you can create new users and GRANT them access to resources. Mysql has a data dictionary in the mysql database. The admin account can see this database but other users usually can\'t. There are a couple of tables that get updated when you use the GRANT command: user and db. Between these two tables mysql handles security.

Mysql has a data dictionary which is a database called mysql. If you can use that database, you can set permissions for individual users by using the grant statement (which also allows you to create users). I have a few examples in a mysql section of the tech page off my homepage. Link is in my sig. If you are in a hosted environment, chances are you have had a database user created for you, and will not have access to the mysql database.

What type is the column you are trying to order by?

If people are able to upload scripts to your webspace, then that\'s where your security problem lies. Using the raw functions will do nothing at all unless people know that you have certain include files that you use which provide a database connection.

Well the problem as I understand it is that your RewriteCond\'s are Ands. So i If 1st condition AND 2nd Condition And 3rd Condition. Hence when you have will not work, because while the http://domain.etc does match the first regex, it will not match the 2nd, and so it falls through. Anything to do with mod_rewrite is tricky, but I\'d question why you are trying to make two different rules when one can satisfy both conditions. On the other hand, simply adding the OR to your Flags might work. If you want to try my swag at having only one rule: RewriteEngine on RewriteCond %{HTTP_REFERER} !^$ RewriteCond %{HTTP_REFERER} !^http://(.*.|)domain.(.*)/.*$ [NC] RewriteRule (.*.(gif|jpg|avi|mpg|mp3|wmv|wma|rm)$) http://domain.com/hotlinking.php [R,NC] For your existing rule, it\'s certainly worth trying this first however: RewriteEngine on RewriteCond %{HTTP_REFERER} !^$ RewriteCond %{HTTP_REFERER} !^http://domain.(.*)/.*$ [NC,OR] RewriteCond %{HTTP_REFERER} !^http://(.*).domain.(.*)/.*$ [NC] RewriteRule (.*.(gif|jpg|avi|mpg|mp3|wmv|wma|rm)$) http://domain.com/hotlinking.php [R,NC]

Are you using the same user that phpnuke is configured with?

I did understand you, and I believe I addressed your question. There is no magic bullet that I know of with pure mysql SQL for this. If there is a way, it would have to involve some sort of computational column, but I doubt there\'s anything that will get around the group by issue. So you\'re really down to deciding whether one query with the group by works best, or seperate queries for each group does. *If* there was some sort of magic way to handle this, it would have to involve a computational trick involving a mysql function, but I couldn\'t thing of any that even warranted an experiment. Typically this would be handled easily (using a cursor) if Mysql offered stored procedures, but it does not. As to which of your two choices makes sense, as you stated, if you can limit the single result set down to a manageable number of rows my gut instinct is that will be faster than doing a whole series of seperate queries. If I come up with any brainstorms I\'ll let you know (digs for old copy of SQL for smartys)