I can, but I'm interested in the general application, php "theory" in a sense, not the actual example.

Hi Everyone!

The title pretty much explains it all! I have a variable which holds the site's root url, but to make it work online and offline on my xampp, I need to make some differences. When the...

Hi!

Thanks for the input, I thought this was the case, but I hoped there was something easier. As I said in my reply earlier, jquery does have a function for this:

$("div").live("click",...

I sort of solved my own problem, but I don't know if it's the ideal way to do things.

Basically I decided that I probably need to reattach everything, so that is what I did. Basically I put...

Hi Everyone!

I don't think this is a hard question for all of you well versed in javascript and jQuery, but I seem to be having some problems.

I am building a forum and I am experienced in...

Hi Everyone!

I want to make a nice floating bar at the bottom of the screen, which hovers about 15px from the bottom. I am doing this to make a site look good in small and big resolutions. The...

Hi ithelp!

Ok, I'm not that amateur :) I know how to use it, and very basic syntax, but I would appreciate a sort of "use this rule" help.

Hello everyone!

If you guys have a sec, can you help me out with some URL rewriting? I am transfering a site from typepad to wordpress for someone and the typepad links to post look like this:
...

Hi, thanks for the responses!

I have three separate tables holding very different elements, and I can not use autoincrement in three tables at once. I can use them in each, but this will not mean...

Hi Everyone!

I have a general database question, I'll try to keep it short :)
I am building a social site where users can log in and add status messages (like twitter), share photos, keep a blog...

Hi Andrieux!

Ah I see. In this case you should be able to use JOIN to count it, something like this:


SELECT
count(posts.ID)
FROM
posts
JOIN

Yes, I agree, in my last post I mean timestamp, not datetime. Timestamp is also a great way to hold dates because MySQL can insert the current timestamp in when you insert entries automatically.

I'm not a huge expert on database speed, but I believe it is recommended NOT to use BLOB a lot because file systems are much more quicker at handling files.

Personally I never use blogs, I store...

I agree that databases are not meant to be read by humans, but I disagree that this is causing the error.

If a field is in the datetime format for example you will still have no problem sorting...

Hi there!

I have a nice piece of code I use for queries like this, take a look.


function mysql_fetch_values($result, $numass=MYSQL_BOTH)
{
$i=0;...

Yes, the code above should work for you. In fact, even if you used a non-date format it should work.

And also, please post the code you are using in php, since so many other things could go...

Hello! First of all, I hope I can help, let me explain how I would do this, I think this is your setup, but I can't be sure.

If you are doing a forum, then whenever someone ads a post, you should...

I know this is a bit basic, but for many fields, where the user inputs longer data (subject line, or textarea input), I always use the function trim() to delete all whitespaces and line breaks before...

Hi digital-ether!

Thanks, your post cleared up most of my questions :) I am actually, I think quite proficient at databses and mysql but I am self taught and haven't had time to go into the "hard...

Hi DiGSGRL

I don't think what you are saying really applies here, especially the security issue. What I want to get around is recounting how many comments someone has made after every refresh.
...

Hi DiGSGRL!

Thanks for your help, but I don't really need to time it, I am sure its faster since I am saving the time of 3-4 queries. All data in a session variable this way. My question was...

Hi everyone!

I'm working on coding my own forum and I have no problem with this, I would like to ask those of you knowledgable about the inner workings of php and mysql about which method is...

Thanks for the tip!
It didn't solve my problem, but I started thinking. In the end, I modified my onchange and my script itself.

the answer was to modify the onchange to facilitate two...

Ah, thanks guys! Such a simple solution kkeith29! I actually didn't get an answer as such, but now I can easily check for myself :)

Hi everyone!

I'd like to ask a simple question to which I can't really find a definitive answer. If I condense my code a lot, will this mean an increase in loading times which is significant...

Hello Everyone!

This is my first post, so please excuse me for any breaches of netiquette.

I am building my own from validation script, which uses separate functions for each input box like...