Barand

I agree with ch0cu3r. The data in tabe1 is correctly normalized and you should keep it like that. If you want to display the data in the format of table2, do it on output after querying table1.

Use DateTime class. $startTime = '13:30:00'; $endTime = '14:00:00'; $dt1 = new DateTime($startTime); $dt2 = new DateTime($endTime); $diff = $dt1->diff($dt2); echo $diff->format('%h:%I'); //--> 0:30

Both I and gizmola have given you the correct syntax. What's your problem?

$summary = substr(strip_tags($text),0, 200); echo $summary; maybe?

Brought on by storing the markup with the data. Solution: Don't.

Your first challenge is to look at the data you need to store and the processes involved and design a relational database model that supports both.

If it's not correct, what happens? Do they try again until they get it right, so everyone finally finishes the test with 100% correct?

Have you forgotten the ".=" and just used "$results ="

You said that there was already a WHERE clause. Have you added extra conditions to gizmola's WHERE clause using AND? Can you post the actual query you are now running.

Not sure prepare and multiple insert syntax work together. Try $query = "INSERT IGNORE INTO blogTags (tag) VALUES (?)"; $stmt = $this->db_connect->prepare($query); foreach($this->blogTags as $tag){ $stmt->bindValue(1, $tag, PDO::PARAM_STR); print "param: $param<br /> tag: $tag<br />"; $stmt->execute(); }

That returns the value then increments (post-increment). Either use ++$param or start with a value of 1 instead of zero.

to round x to the nearest multiple of y result = round(x/y) * y (eg round(563/25) * 25 = 575) If you want to round down as in your example, use floor() instead of round()

As Gizmola said in his reply UPDATE product p INNER JOIN ( SELECT product_id, SUM(price) as tot -- you FROM -- would ( -- need SELECT product_id, price FROM product_a -- these UNION ALL -- eight SELECT product_id, price FROM product_b -- lines ) ab -- of the GROUP BY product_id -- query ) tots ON p.id = tots.product_id SET p.total = p.total + tots.tot;

Yes. If $result is the result from your query execution, then something like $row = $result->fetch_assoc(); echo $row['total']; // print the total

A query can find no records without failing, it's a perfectly normal result. You need to check the number of rows in the results.

Instead of output buffering, use pagination with mysql LIMIT clause. http://lmgtfy.com/?q=mysql+pagination

The query string needs to be enclosed in double quotes, not single, if you want to expand variable values in the string. Table and column names should not be in quotes $insert = "INSERT INTO XXXXXXXXXX (ID, FirstName, LastName, City, State) VALUES (NULL,'$FirstName','$LastName','$City','$State')";

But, should you want to update regardless, assuming you add a "total" column to the product table UPDATE product p INNER JOIN ( SELECT product_id, SUM(price) as tot FROM ( SELECT product_id, price FROM product_a UNION ALL SELECT product_id, price FROM product_b ) ab GROUP BY product_id ) tots ON p.id = tots.product_id SET p.total = p.total + tots.tot; If you combine the a and b tables as suggested then UPDATE product p LEFT JOIN ( SELECT product_id, SUM(price) as tot FROM product_ GROUP BY product_id ) tots ON p.id = tots.product_id SET p.total = p.total + tots.tot;

If I were you I wouldn't store the product total at all. Just calculate it from a query when required. Don't store derived data in a database. Also, why two tables, a and b, with identical structures. Have a single table with an extra column to identify a and b. DECIMAL type is better option than FLOAT for prices. If you do store the product total, you will need a column for it which you don't currently have according to your model.

The last line of the query looks odd ...ORDER BY sala_ocupacao.`id_ocup`id_ocup;'

your code to create the array $car = array(); $car["vw"] = array( "name" => "volkswagen"); $car["tyta"] = array( "name" => "toyota"); will give you Array ( [vw] => Array ( [name] => volkswagen ) [tyta] => Array ( [name] => toyota ) ) It would be better and simpler to $car = array(); $car["vw"] = "volkswagen"; $car["tyta"] = "toyota"; giving Array ( [vw] => volkswagen [tyta] => toyota ) But why not just give them a dropdown menu of valid types to select from

I was thinking Imperial Purple, but then Gold.

No, you don't want it to look like that. You should not use "SELECT * " and numeric values should not be quoted. What is the relationship between "start" and "end" that you pass to your script via the URL and "bidStatus" and "department"

The last insert id is only available for the current connection. You need to get it and store it ($_SESSION) as soon as possible after the insert. When the script ends the connection closes automatically

Change your single quotes to double quotes and vice versa