Jessica

BTW you might want to rename two of those columns to be more clear. Plus the one has a bad word in it

Try SELECT referrer, whoreferred, SUM(reward) FROM referrers GROUP BY referrer, whoreferred

USE CODE TAGS Based on your further clarification, this is a javascript question. You'll need to create a js function that gets both values and concats them, and assign that to each of the drop down's change events.

0,10 would retrieve the first 10. it's start/offset and number of records. 10,19 would be 19 records starting with # 10. http://dev.mysql.com/doc/refman/5.1/en/select.html

1. Use code tags 2. I don't see anything in there that actually handles the user submitted search terms and searches.

try if(strlen($_POST['searchtext'])) as this will check if the string has more than 0 characters.

Agreed.

Maybe that's why you didn't understand? I'm not trying to be rude, I'm just pointing out if you've never used a screenshot application you wouldn't know what one would consist of? All of the paid ones I've used in the past had all those features and more, without being a photo editor. Jing looks good but it gave me an error about .NET when I started install, and I haven't had a chance to try and figure out what's wrong with it. The list Maq found looks great, I'll probably find something there. If I don't, guess I'll just pay for SnagIt since that's the one I know best. Thanks guys!

Wat?

Leave out the id and '' parts. The second way you did it is fine, and looks nice. You could also use concatenation but it's a bit harder to read. $query = "INSERT INTO current_xeep (user_id, user_name) VALUES ('".$_SESSION['user_id']."', '".$_SESSION['user_name']."'"; There's a way to use {} but I find it even harder to read.

That's psuedo code, you have to replace the text with actual code.

I'm trying to take screenshots... I understand that Print Screen does this. I like the added functionality that SnagIt offers like grabbing just the open window automatically or cropping to a defined area, graphics/arrows/boxes, text, copy to clipboard or save to file. I don't want to use Paint because it sucks, and Gimp/Photoshop are overkill for this. I currently use a firefox add on for web shots but I need to be able to do any program and also get the address bar in Fx. Maybe I'll just give in and buy a license for snag it, it's for work so I will talk to them about buying it. I'm surprised that this is confusing, it's something I've had to do as part of work for over 5 years, and the companies I've worked with have always supplied SnagIt or a similar program, I know there are a ton of them out there.

I hate Gimp and don't have photoshop. I guess the question wasn't clear. I'll keep looking at stuff I find via google, I was just hoping someone who actually uses a specific screenshot software would be able to say I use X and like it. And it's free.

No. I'm used to using SnagIt but I need a free tool which can do similar - easily crop and add arrows/boxes etc.

On XP SP2 :/

Need to get a free non trial screenshot program for a windows computer. Not F12 and Paint, a program to do it for me. What do you use?

I'm a ninja.

I've only used WAMP but I know when you set it up you can just go to localhost and it will show you everything you have in www along with links to phpmyadmin etc. Does XAMP do this too?

You could use checkdate() on the php side to validate it before attempting to insert. Anything you validate with JS must ALSO be validated with PHP.

I agree, and I wish it was possible to do <?php= $var ?> Then we could all be happy. It's still shorter but won't cause the same problems as short tags.

When you say unlimited levels, that makes me say recursive function.

When you have a blank page you probably need to enable error_reporting.

This is why I never do strings like that. OP, use an editor with syntax highlighting.

If you don't understand how loops work you will probably need to learn basic development before attempting this. How are you currently using PHP to read the .xls

What's the code for line 155? What this means is you have more fields listed than supplied values, usually due to a variable being empty that you think should have value.