[Solved] How to sum when they have same color with sql?
select sum(count), max(productNo) from Table where date between 117 and 118 group by product, productNo with this it works 🙂 1 solved How to sum when they have same color with sql?
mysql
[Solved] Need to show costs for last 6 months on complicated sub queries
Right I have an answer which works, but it is not the best solution by any means. I really wanted to answer my question with one query, but the only solution I have come up with is to use php and loop the mysql. Yes I know this is not ideal, but I needed to … Read more
[Solved] php / mysql application to work offline when network is lost
You can host the application locally and access it through your browser as localhost/myapp Take a look at WAMP. It should set you up with the things you need to host locally. Once you come online, you can run a script that will diff your local mySQL database with your remote and sync changes. Let … Read more
[Solved] How to check if a value exists in a database, then return the row of data
Your code has a few issues: Don’t mix more than one library. You are using mysql_ and mysqli_ together. Don’t use mysql_* functions. They are deprecated. No need of mysqli_close() function. You don’t need to repeat the table. You are not printing anything from the query’s result. The problem with your code is, you need … Read more
[Solved] Error in SQL Syntax [closed]
“delete from ombrellone where PosizioneX='” + i + “‘ AND PosizioneY = ‘” + j +”‘”; solved Error in SQL Syntax [closed]
[Solved] php / mysql application to work offline when network is lost
Introduction The ability to work offline when the network is lost is an important feature for any application. This is especially true for applications that rely on a database, such as those written in PHP and MySQL. With the right setup, it is possible to create a PHP/MySQL application that can continue to function even … Read more
[Solved] How to check if a value exists in a database, then return the row of data
Introduction When working with databases, it is often necessary to check if a certain value exists in the database and then return the row of data associated with that value. This can be done using a variety of methods, depending on the type of database you are using. In this article, we will discuss how … Read more
[Solved] how find count average using mysql?
Here you go. SELECT countrycode , COALESCE(SUM(CASE WHEN label=”A” THEN 1 END)/COUNT(*),0) a FROM my_table GROUP BY countrycode; You can figure out the rest. 4 solved how find count average using mysql?
[Solved] mySQL Fetch the row which has the Max value for a column
First, you shouldn’t name your column update, choose another name, let’s say “date_of_update” If you want to select only the row with the most recent update, you can simply use something like this : SELECT * FROM table_name ORDER BY date_of_update DESC LIMIT 1. This will give you only one row with the max date! … Read more
[Solved] VB.net Database User Validation [closed]
I did the important part. Optional is not needed for me but would’ve been good. Here: https://www.youtube.com/watch?v=ovoVfHW3Q8Y. solved VB.net Database User Validation [closed]
[Solved] Empty query no matter what
You need to fix the backticks and quoting on your query. You have – $sql=`SELECT * FROM PRICES WHERE TES LIKE “%” . $TES . “%” `; It should be – $sql=”SELECT * FROM PRICES WHERE TES LIKE ‘%” . $TES . “%’ “; You should only have to check for a query error once … Read more
[Solved] How to run a query with the values of a windows open PHP
If you send data using GET method within your url you should update your query in main.php getting: $day = $_GET[‘year’]; $month = $_GET[‘month’]; $year = $_GET[‘day’]; $sql = “SELECT HoraIni,MinutoIni,HoraFim,MinutoFim,CdCurso,NmCurso,DgTpMarcacao FROM marcacaosalas Where Data=”$year-$month-$day””; Anyway i dont understand why you don’t easly send the whole data to the page simpli using a fomith a … Read more
[Solved] Highcharts column graph colors via sql data
And I had finally figured out how to make it work colors: [ <?php $num_counts = count($count); $on = 1; foreach($count as $bit => $bit_counts) { if($bit == ‘STEEL’){echo”‘#FF9999′”;} else if($bit == ‘STEEL CROWN’){echo”‘#FF9999′”;} else if($bit == ‘SLIM’){echo”‘#9999FF'”;} else if($bit == ‘KYMERA’){echo”‘#FF2626′”;} else if($bit == ‘HYBRID’){echo”‘#FF2626′”;} else if($bit == ‘EZC’){echo”‘#FFFF26′”;} else if($bit == ‘EZR’){echo”‘#FFFF26′”;} else … Read more
[Solved] MYSQL how to convert varchar to bigint
Here you go: select REPLACE(REPLACE(REPLACE(‘2017-10-10 23:59:21.087’, ‘-‘, ”), ‘:’, ”), ‘ ‘, ”) If it’s a field in a table, just do this: SELECT REPLACE(REPLACE(REPLACE(forex_lastupdate, ‘-‘, ”), ‘:’, ”), ‘ ‘, ”) FROM noksek_tickdata_copy; 2 solved MYSQL how to convert varchar to bigint
[Solved] Need a help in Inserting data of nested checkboxes into database as given in the below image.how to save days and it’s timing in an array in php
Need a help in Inserting data of nested checkboxes into database as given in the below image.how to save days and it’s timing in an array in php solved Need a help in Inserting data of nested checkboxes into database as given in the below image.how to save days and it’s timing in an array … Read more