Maq

Your credentials are wrong. Are you sure you don't have a password?

Echo out the POST to see what the value is.

We need more information. Some relevant code, how this has to do with the browser, an example of what's going on, etc...

Couldn't agree more, but at the same time "ignorance is bliss" so just trying to get a better understanding of everything It would be interesting to see what techniques, tools etc. you have used to increase performance for your script. Keep us updated!

Something like: $cat = new categories(); $cat->delete($_GET["id"]);

Can you echo out '$gvarsemail' so we know exactly what you're passing in.

If this is the case then you're going to have to catch invalid characters before you send them. There are a few ways to do this. One is to use regex and let the user know that there are invalid characters. You could convert them to something valid or you could just strip them out.

(Moving to Miscellaneous unless you have a specific PHP Coding question)

This topic has been moved to Miscellaneous. http://www.phpfreaks.com/forums/index.php?topic=321105.0

Optimization comes from how well your code is designed/written and what techniques/methods you used. Things like using string database performance, repeating code, images, even using regex operations when you don't have to. Tools such as firebug and YSlow can also help you determine what is slowing down your pages. But .04 and .05 don't seem like numbers to be worried about.

You need to create the categories object first. What is the class name from categories.class?

OK, I thought you had some PHP code, but no problem. Are you having trouble putting the data in the database or just the population from the database? (Please use tags)

Just an FYI, there are a few more values that will qualify as 'empty'. From the manual (empty):

So what part are you stuck on? Some code would also be helpful.

Like something you didn't change.

If you're going to use HTTP then use GET, if you're using POST, then you should be using POST.

If you didn't change anything something else changed.

This topic has been moved to MySQL Help. http://www.phpfreaks.com/forums/index.php?topic=321097.0

Formatting your code would also help greatly.

What's the error?

Sounds like you need a new host ;/

Glad you got it working but you didn't have any conditions in your original code.

There may be a shorter way but this should work: SELECT products_name FROM orders_products WHERE orders_products_id IN(SELECT MAX(orders_products_id) FROM orders_products GROUP BY products_name); (I tried the GROUP BY ORDER BY and it didn't work, same with DISTINCT.)

Let me clarify. You want to get the latest purchase for each p#?

Good. Yeah LIMIT can take 2 params. I think the first is where you want to start, and the second is how many you want from there. So results 5-10 would be: LIMIT 5,5 (I think)