Maq

Then that may not be the column/table you need to be checking. Which table has the product price in it?

If you have 2 functions named the same thing, how do you expect javascript knows which one to use. Like Dj Kat said, rename one and see what happens. Does firebug give you an error?

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

Use LIMIT: SELECT * FROM users ORDER BY dirStamp DESC LIMIT 10

Google my man Basic: http://www.w3schools.com/php/php_get.asp The manual: http://php.net/manual/en/reserved.variables.get.php

I think you want this: AND patrib.options_values_price > 0.00 The column name feels weird but it's the only one that the price could possibly be. Is options_values_price the price you're trying to check?

Even if that worked, I don't see the difference between the two, it's essentially the same thing minus the two variables. Did you want to get the emails from a form? Tell us what you're trying to do.

Oh, I wasn't sure exactly what the column name or the table name was. I just assumed the product's price would reside in the product attribute table (pa). You may have to find the correct table and column name.

This topic has been moved to PHP Regex. http://www.phpfreaks.com/forums/index.php?topic=321050.0

What's the error?

Add a condition in the query that selects the items and check for price. AND pa.products_price > 0.00

This topic has been moved to PHP Installation & Configuration. http://www.phpfreaks.com/forums/index.php?topic=321067.0

You're using it appropriately and there are ways to check this. An except from the manual:

This topic has been moved to Beta Test Your Stuff!. http://www.phpfreaks.com/forums/index.php?topic=320980.0

Google 'php browser detection', you should get plenty of hits.

Yes, there is a fatal error which in return shows a blank page. For temporary debugging you can add these 2 lines directly after your opening <?php tag to see the error: ini_set ("display_errors", "1"); error_reporting(E_ALL); (Please use tags)

I would think that the INSERT would be executed every time since you are assigning $row to 1: if ($row = 0) { which is always true. I think you want: if ($row === 0) {

If you use the first one you can use a more descriptive variable name. Also, if you define a new variable the POST then you only have to manipulate it one time. For example, if you want to sanitize your POST value you would only have to call mysql_real_escape_string once. If you used the latter example, then you would need to call it every time you wanted to use it.

Good point Pika. Depending on what you want to do this might be better.

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

You most likely have some sort of auto-incremented id in which you can use with a basic query: SELECT * FROM table ORDER BY id DESC LIMIT 1

This topic has been moved to Third Party PHP Scripts. http://www.phpfreaks.com/forums/index.php?topic=320884.0

That's relative to what you're working on. Check out - Database Normalization.

Sounds like you're asking if you should use a relational database or not? Most likely yes, but in some cases no. Depends on what exactly you're trying to do.

Hmmm..... ok good.