ignace

You may also be interested in: $query = 'SELECT field1, field2, field3 FROM table WHERE ..'; $result = mysql_query($query); list($field1, $field2, $field3) = mysql_fetch_row($result);

I found this on MySQL manual UTC is the way to go apparently. I also found: For more information http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html

<a href="#" onClick="return submitForm('formName');">text</a> <script type="text/javascript"> function submitForm(formName) { var form = document.getElementById(formName); form.submit(); return false; } </script>

& Practice.

Is this a loop? and yes, it uses integers, also wouldn't $in be - ,13 (If the ID is 13 that is) No this is not a loop it uses the IN operator to delete all rows with the corresponding ID's (=integers provided by $_POST['checkedItems']) And if you pass 13 it will show up as 13 if you pass 12 and 13 it will show up as 12, 13

do: echo $sqlquery; after $sqlquery = "DELETE .. and tell us what is says

Query with both $_GET['id'] as you $_SESSION stored user_id

No a far better approach then the foreach () would be: $in = implode(',', $_POST['checkedItems']);// I recommend that you verify that 1) the user is allowed to do this 2) it's an array containing only integers $query = "DELETE FROM table WHERE id IN ($in)"; $result = mysql_query($query);

np although I do advice you to pick up a book or take a course on the matter it will enable you to spot errors/flaws and correct them yourself. these corrections will be made based on domain knowledge (what I am currently missing due to the fact I don't know every angle of your project)

No but you can do: <!ATTLIST option sex (male|female) #REQUIRED>

There are a few ways you can do this? I don't suggest using tables as you will have to make sure each row contains exactly 4 images or that you give the correct colspan to the correct <TD> So a far easier method is to just put every <img> in a <div> float:left each div and make sure the total width of the containing element fits the total size of 4 images. It will put the other images on the next line automatically while maintaining valid HTML

What happened to CrayonViolent's LaserShark's? Are they still in production? They seemed to be quiet effective

Yes? I don't see a problem? tbl_orders would look like: 1, 1, 3, 5, 2010/4/2 -- John bought 5 medium-sized skirts on 2010/4/2 2, 1, 10, 1, 2010/4/2 -- John also bought 1 small-sized dress on 2010/4/2

Your looking for FOUND_ROWS http://dev.mysql.com/doc/refman/5.5/en/information-functions.html#function_found-rows SELECT SQL_CALC_FOUND_ROWS * FROM users LIMIT 0, 10 SELECT found_rows() as found_rows -- OR -- SET @found_rows = found_rows() -- allows for later use

Depends on what you consider complex. echo date_diff($timestamp)->format('%d days %i minutes');

It will be "removed" yes but administrative personnel is still able to read the messages.

You have a logic error if mysql_num_rows() returns something different then 1 the variable $theTeam does not exist and results in NULL and a warning (do you have error_reporting and display_errors set correctly in your php.ini?). The solution is to simple include all your code in the if (mysql_num_rows($result) === 1) block.

You could set a delete field with a 0 or 1 then when retrieving WHERE delete = 0

WHERE date >= now() ORDER BY date

How did you try it did you enter: http://<WAN-IP>/

tbl_orders (id, customer_id, product_has_size_id, quantity, purchase_date) If you wonder why not: tbl_orders (id, cart_id) Then the answer is simple if he clears his cart your customer history is gone

ORDER BY points, goals, for, against, name All in ascending order

It makes no sense to include the comment remove it. This is also why you get the same record twice your result is DISTINCT

You misunderstood this table maps products to shops Remove the tbl_subcategories and add the field parent_id to the tbl_categories table. It won't, it would show up as NULL not all customers like to login/register prior to shopping. Use session_id() while the customer has not yet logged in. Then (probably) on checkout ask all required information (shipping address and such) register the account, get the id (mysql_last_insert_id()), update the customer cart with UPDATE tbl_carts SET customer_id = $cid WHERE session_id = $sid

Use salathe's method I misread your post