Philip

select `sup` from `sprint` WHERE `sup` IS NOT NULL GROUP BY 'sup'

Not sure why you are trying to escape those quotes

You can with one of these functions: round, floor, ceiling

I haven't tried it, but I've heard that using TIMESTAMPADD() works sometimes. I'll see if I can pull up that article

Try: $query = "SELECT * FROM `records` WHERE firstName LIKE '$firstName%' OR lastName LIKE '$lastName%' OR age LIKE '$age%' OR sex LIKE '$sex%' OR raceName LIKE '$raceName%' OR distance LIKE '$distance%' OR city LIKE '$city%' OR state LIKE '$state%' OR `date` LIKE '$date%' OR `time` LIKE '$time%' OR place LIKE '$place%' OR divPlace LIKE '$divPlace%' OR pace LIKE '$pace%'";

Use the datetime functions: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html

Haha there are quite a few nutty cars around here. Thanks Austin, TX for being so damn weird.

UPDATE `user` SET `hours`=`hours`+200 WHERE `user_id` = 1 You don't need the quotes around the col name like that

It's not practical, but in one line (not cheating like Maq ) return implode(array_slice(explode(':',$content),2,1));

$text = 'I have spaces'; $output = str_replace(' ','', $text); echo $output; // shows 'Ihavespaces'

I'll second that. I prefer my Border Collie, how can you say no to this: http://img5.imageshack.us/img5/4143/n59213246710497069583.jpg

This page will help you http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-reference-reservedwords.html

to is a reserved word. Either rename the column or change it in the query to `to`

<?php phpinfo(); ?>

http://css-tricks.com/css-trick-creating-a-body-border/ That should border in everything

http://www.motif-services.com/Farid-KH/leight.htmt Is also called a "modal box" or "modal popup" http://foohack.com/tests/vertical-align/dialog.html Without the fancy page blackout, and you just want to show or hide a div: http://blog.movalog.com/a/javascript-toggle-visibility/

Pagination? http://www.phpfreaks.com/tutorial/basic-pagination

I've run into that problem. As soon as you think of a great name, you check the domain and its taken >.<

Or we could just throw you, CV, out and you pick you up in a few weeks and you can tell us what you needed.

#5: Computer with internet mine: Air Food Water Shelter Fire

Or, if the sql file is too big to copy paste, place this under the comments in your sql file and above your first DROP IF...: USE `filehost`; That'll tell it to import into the database name filehost.

Should read: <input type="button" name="View" value="View" OnClick="location.href=\''.$files.$row["file"].'\'" class="button_60"> Using a syntax highlighter would help: echo '<input type="button" name="View" value="View" OnClick="location.href=\''.$files.$row["file"].'\'" class="button_60">';

Yeah, it has some good hardware in there.

I still get a lot more satisfaction when I build my own. The thing is (as said before), you can get higher quality products and DIY, or go with cheaper products and be lazy/safe Personally, I would go and build my own (and if you don't know how, I'm sure you know somebody that would build it for you for a fraction of the cost.) However I think you already knew what you were going to do when you asked the question in the original post.

The specs aren't that bad, but I still think it's a bit overpriced. I got better specs off of newegg (OS not included) for $2400 (US dollars ofc.) Hell, you could even switch out the processors for the BE EE, and still be under $3k (and thats 300MHz faster + easier to OC) Your only trade offs are: you dont have to build it yourself, and you have a complete warranty. But it's your call, after all it's your money