7,368 Topics
 | |
 | i have a prinscreen of the problem http://i.imgur.com/GMJho9r.jpg i use mySQL to create the query and i have a database called tap that contains the events table I try SELECT sensor_id,event_type,value from tap.events where events.time = (SELECT MAX(events.time) from tap.events) group by sensor_id,event_type ORDER BY sensor_id,event_type; I get only the … |
| | |
| | i have a table fieldname like companyname and Created Date shown in below image. in that i want to display data's date wise ASC or DESC, like that if i click companyname the data's will show ASC and again if click will show DESC order format. and here i added … |
| | Hello. I have and event.php page and del_single.php page. event page has a form: <form action='del_single.php' method='get'>//<-i already have the method as get <input type='hidden' name='event_id' value='$id'> <input type='checkbox' name='check[]' class='check' value='$id'> <a href= '#' value='$id' name='e_n' onclick='getsum(".$id.")' >$name</a> <label>$formatDate</label> <input type='submit' name='del_single_event' value='Delete'> </form> as you can see i …  |
| | There is a String object called detailMessage in java.lang.Throwable class, which says the reason of any exception thrown in java code. This object is initialized through a constructor using super(string message) statement or setter or whatever from subclasses like Exception and again from its subclasses like SQLException. When SQLException is …  |
| | Hi i have installed prestashop 1.4.8.2, i want report from mysql, Number of orders per customer with customer name & customer id plus i want total amount of order customer wise. can you help me with SQL query so i can generate this report from phpmyadmin. thanks, regards, Ritesh |
| | Hi there, wanna ask if the sql syntax order by and group by the same? eg: i have a dropdownlist and the values displayed should be in ascending order. hence is there any difference if i use these 2 sql statements below. [CODE]sql1 = "select distinct * from t_staff group … |
| | Hello, I need for my game inventory function a mysql query which checks the next available free slot id. example: I have item on slot 1, 2, 3 and 5. Slot 4,6,7,8,9 ... are free.. Now I need query which would get the number 4. Something like SELECT * FROM …  |
| | Hi, I need to retrieve only 1 row for each 'message_id', with the Latest Date('sent_date'): ------------------------------------- message_id | sent_date | ------------------------------------- 805 | 2010-08-04 17:48:24 | <--- 805 | 2010-08-03 17:48:24 | 1007 | 2010-08-07 17:48:24 | 1007 | 2010-08-09 17:48:24 | <--- 1007 | 2010-08-08 17:48:24 | ------------------------------------- The … |
| | hey i have this code that always evaluates to true but it should only in the case of there being a value in the database i have selected, maybe im doing this wrong or maybe its something else but i cant seem to figure out the problem :( any assistence … |
| | I need to add a check box on the end of each value in my html table that will be checked if the user would like to remove that value from the mysql database, my current cod elooks like this: <?php $con = mysqli_connect("localhost", "root", "", "numbers") or die(mysqli_error($con)); // … |
| | I have five tables as listed below. Question: is it possible to join all five tables and output the result as show below? <table> <tr> <th>Subject</th> <th>Last update (date from table. nr.3)</th> <th>Last update (date from table. nr.4)</th> <th>Last update (date from table. nr.5)</th> </tr> <tr> <td>Mathematics</td> <td>2014-06-01</td> <td>2014-07-05</td> <td>2014-03-15</td> … |
 | Hi Friends, I am developing a Music download system. I thought to have two database tables. One for songs and other one is for artists because some songs have two or more artists. Then I created two tables call `songs` and `songartists`. Following are the structures of that tables. `songs` …  |
| | Hi.. I'm trying to extract the day, month, and year from a datetime to use it within a 'WHERE' statement. Table: workshops workshopid - int(10) workshopgroupcoursecode - text title - varchar(255) description - text Table: workshops workshopscheduleid - int(10) workshopid - int(10) startdatetime - datetime enddatetime - datetime timedescription - … |
| | I need to create a table to track page visits to landing pages on a website based on the page name / the member ID / the Year / the Month and maintain the count of visits based on each unique combination Basically, I think I can create a table … |
| | I need to copy only some selected rows from a table and insert these rows into another table (having the same structure) in another database. Is it possible? |
 | Hello, I wonder what's the difference between *.frm, *.MYD, *.MYI ? I have tried to transfer filelogs.frm to another xampp server and it works on one machine while it doesn't on the other one. Do I have to have all of the extension in order for the xampp server to … |
 | i got complete details in html table and willing to update 2 values |
| | Hello, I wonder what is mysql table name requirements? I have tried creating mysql table with these names: group_mgt --> squprime.group_mgt table does not exist file_uploads_log --> squprime.file_uploads_log table does not exist In order to make the table creation works I have turn group_mgt to group AND turn file_uploads_log to … |
 | I am using My SQL Database. I have two databases of My SQL which are used in a appplication simultaneaously as backend and log databases. So i need to stop services of log database only to view some results relating to my application. Is there any way to stop the … |
| | Hi, I would like to loop the data-attribute to contain all column names and values from a mysql table. This is what it looks like today: while ($row = $result->fetch()) { echo "<div id='{$row['namn']}' data-column1='{$row['column1']}' data-column2='{$row['column2']}'... So some kind of magic :) loop inside there so I don't have to … |
| | How can I send some data to a MySQL database? I'm using php. |
 | I am still trying to get a grasp on the php/mysql interaction. Why does something like this not work and without all the error catching, can one do something like this? [CODE] $result = mysql_query("SELECT * FROM stadium WHERE gametime = `$_z`;"); $row = mysql_fetch_row($result); $bababa[name] = $row[0]; $bababa[town] = … |
 | I'm using: Windows 7 Home Premium 64-bit operating system Netbeans IDE 8.0 WAMP Server 2.5 Here is my issiue. I am attempting to follow the E-commerce tutorial in the Netbeans Java EE & Java Web learning trail (Section 3 "The NetBeans E-commerce Tutorial - Setting up the Development Environment"). In … |
| | I use the following code to generate a uuid concat with CMRC it works fine uuid is generated in lower case i.e. CMRC+someString in lower case I could not find anything to resolve this i had to post this on here for help how can I convert this generated uuid … |
| | I'm creating an Web-Based Inventory System, currently stucked at this module where I need to scan QR code. The process flow that I want to achieve should be like this: 1. Scan QR code containing the inventory ID wirelessly using an Android app 2. Show the information retrieved from the … |
 | hp $mysql_hostname = "localhost"; $mysql_user = "root"; $mysql_password = ""; $mysql_database = "farm_house"; $prefix = ""; $bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect database"); mysql_select_db($mysql_database, $bd) or die("Could not select database"); $myysql= "SELECT customerinformation.CustomerFullName, customerinformation.CustomerID, customerinformation.Housenumber, customerinformation.Sector, customerinformation.StreetNumber, customerconsumption.MilkDelieveredCow, milkrate.CowMilkRate, (customerconsumption.MilkDelieveredCow*milkrate.CowMilkRate) AS t_amount_cow, customerconsumption.MilkDeliveredBuffalow, milkrate.BuffaloMilkRate, (customerconsumption.MilkDeliveredBuffalow*milkrate.BuffaloMilkRate) AS t_amount_buff, …  |
| | Table: numdata id numb 1 123 2 456789 3 123 4 456789 5 123 6 456789 7 123 8 456789 9 123 10 456789 11 123 12 456789 13 123 14 456789 ...... What i would like to do is combine the data in numb only, so the desired data … |
 | I am retriving image from mysql database and want to hyperlink this processed image but not able to find solution for ($i = 0; $i < $rows; $i++) { $description = mysql_fetch_array($result); $img_str= base64_encode($description["nImage"]); echo '<a id="zoom" href="data:image/jpeg;base64,'.$img_str.'"><img src="data:image/jpeg;base64,'.$img_str.'" width="150" height="150" /></a>'; if($i%3 == 2) echo "</br>"; } |
| | Hi friends, In my site, simply I want to save the configuration data, site details in the php file. For an example, in vBulletin they are using config.php file to save all the general details. // ****** DATABASE TYPE ****** // This is the type of the database server on … |
The End.