you can try sth like this SELECT customers FROM orders WHERE price > (select AVG(price) from orders) ; solved I want to select customers whose price is higher than the average price
You are missing ;’s at the end of your lines. <?php $conn = mysql_connect(localhost, root, usbw); mysql_select_db (‘veiling’); $bid = $_GET[‘bod’]; $name = $_GET[‘naam’]; $item = $_GET[‘item’]; $maxbid = mysql_query(“SELECT MAX(bod) FROM veiling WHERE item=1”); $maxbid = mysql_fetch_array($maxbid); if( $bid =< $maxbid[0] ) { die(); } else { mysql_query(“INSERT INTO veiling (bod, naam, item) VALUES … Read more
In your CheckQuantity() method, you are: Only querying items that have the same quantity of the first ProductInfo that you’re constructing. Displaying the quantity from that single ProductInfo instead of the value you are querying from the database. Instead, this should work better: public static void CheckQuantity(CustomToolTip _customToolTip, IWin32Window _window, int _x, int _y, int … Read more
suggest that if your above SQL statement can query the result. maybe you can just skip the “order by” and simply just select * from (/* your SQL statement without “order by”*/) a order by a.message_id desc sorry that as it is difficult to see your screen capture and help you to resolve the SQL … Read more
You can get the output you desire with grouping and some CASE statements inside SUM aggregate functions: SELECT dbo.TableB.TrackingID, dbo.TableA.ParcelCode, dbo.TableC.CustID, SUM(CASE WHEN dbo.TableB.FinanceType=”Invoice” THEN dbo.TableA.TotalAmount ELSE 0 END) AS TotalAmount, SUM(CASE WHEN dbo.TableB.FinanceType=”Invoice” AND TransType=”Card” THEN dbo.TableA.TotalAmount ELSE 0 END) AS CardInvoice, SUM(CASE WHEN dbo.TableB.FinanceType=”Invoice” AND TransType=”Cash” THEN dbo.TableA.TotalAmount ELSE 0 END) AS CashInvoice, … Read more
I will approach your question like this: I assume you are firmly interested in big data database use already and have a real need for one, so instead of repeating textbooks upon textbooks of information about them, I will highlight some that meet your 5 requirements – mainly Cassandra and Hadoop. 1) The first requirement … Read more
A good approach might be to use count(*) and GROUP BY. So you get a count of the number of answer rows per user per list in the completed table then join to a subquery which gets you a total count of items in the list. Something like this: select user_id, c.list_id, count(user_id) as list_count, … Read more
You can store the number of clicks in a mySQL column and increment it every time a user clicks the button and then check if the click falls in the past 1 hour interval and if so, tell them they have to wait. Something like this: select count(*) as clicks_in_the_past_hour from table where click_time >= … Read more
If you’re hosted on a cPanel server then it’s pretty normal for daily, weekly and monthly backups to be taken. These backups contain everything, this includes your MySQL databases. I would get in touch with your host asap and see whether they have anything. solved My database is replaced with a new database . is … Read more
Take a look at Java Collections. You can use a List like Luiggi suggested, or you may want to use a Map so that you can look them up by name or Id. import java.util.HashMap; import java.util.Map; public class Employee { private final String name; private final int Id; private static Map<String, Employee> employeesByName = … Read more
You should probably look at message queues (the Microsoft version is called MSMQ and is built into Windows. Other message queues are available). They are designed for exactly this sort of scenario. Essentially, your application write an event to it’s local message queue. This will attempt to send it to the remote queue (on the … Read more
I understand that you want, for each day: the sum of order_items.energy_used for all orders created that day the created_at and order_sum that correspond to the latest order created on that day Your sample data is not very representative of that – it has only one order per day. Also it is unclear why created_at … Read more
Your final code should be identical to: <?php $con = mysqli_connect(“localhost”, “root”, “”, “radian”); if (!$con) { exit(“Couldn’t connect: ” . mysqli_connect_error()); } mysqli_set_charset($con, “utf8”); $insert_data = “UPDATE enquiries SET ResponseDate=”” . $current_date . “”, Response=”” . $txtResponse . “”,Enquiry_No = ‘” . $_SESSION[‘ses_staff’] . “‘ WHERE Enquiry_No = ‘” . $txtStudentId . “‘”; $execute … Read more
Your issue “there is always only one table created”, will be due to the very common misconception that the onCreate method, in DatabaseHelper.java (generally termed the Database Helper) runs every time the App is run. Actually the onCreate method is only automatically invoked once for the lifetime of the database. If the data held in … Read more
There is no native mapping of db table to email, so you have to first select, then retrieve then send $query = $this->db->query(“SELECT emailAddress from table”); //select email addresses $sendTo=array(); foreach ($query->result() as $row) //loop to build array { $sendTo[]=$row->emailAddress; //add to array } $this->email->to($sendTo);//send email Of course I have had to guess you tables … Read more