You can add multiple parameters to the url query string with an ampersand sign (&), only the first field name has to be prefixed with a question mark (?): In your case topics_categories.php?id=13&page=1 0 solved Edit the link to accept the id of category and the number of page
SELECT x.* , x.cf1+x.cf2 sub_total , SUM(y.cf1+y.cf2) running FROM 1_bugs x JOIN 1_bugs y ON y.id <= x.id GROUP BY x.id; +—-+————+—–+—–+———–+———+ | id | date | cf1 | cf2 | sub_total | running | +—-+————+—–+—–+———–+———+ | 1 | 2016-07-19 | 3 | 2 | 5 | 5 | | 2 | 2016-07-19 | 2 … Read more
With the help of STR_TO_DATE and DATE_FORMAT function you can achieve this: SELECT DATE_FORMAT(STR_TO_DATE(dateUs,’%Y%m%d’) + INTERVAL HourMins+0 >= 1200 DAY ,’%Y%m%d’) AS dateLoc FROM your_table Demonstration: SET @str := ‘20160919’; SET @HOUR := ‘1215’; SELECT ( STR_TO_DATE(@str, ‘%Y%m%d’) + INTERVAL (@HOUR + 0) >= 1200 DAY ) AS date, DATE_FORMAT( STR_TO_DATE(@str, ‘%Y%m%d’) + INTERVAL (@HOUR … Read more
Just call 2 queries separately like this : if($money >= 400) { $query1 = “UPDATE users SET spam = spam + 1, money = money – 400 WHERE user_id=”.$_SESSION[‘user’]; $query2 = “UPDATE users SET score = score + 2500 WHERE user_id=”.$_SESSION[‘user’]; $update1 = mysqli_query($conn,$query1); // call 1st query $update2 = mysqli_query($conn,$query2); // call 2nd query … Read more
Each user should have a record in a users table users id,… Each image should have a record in an image table images id,created_date,file_path,… Each vote should have a record in a junction table that looks like: image_votes user_id,image_id,vote_value where the value is 0 for a down vote, 1 for an upvote, and no record … Read more
The answer is d. But google is ideal platform for this kind of query or go to https://www.w3schools.com/sql/default.asp solved Which of following sql instructions do not is Standard SQL? [closed]
In the derived table the total sales are calculated at ( year,phone ) combination. Once the total sales are calculated all the top rows( rank = 1 by sales ) should be identified for each year. By using correlated sub-queries and having clause the first row is identified from each group( year ) and displayed … Read more
You need to do a join on the tables in order to get the columns of all of them. Warning: using * to get all columns is bad practice. You should qualify (name) all the columns you need. Here is an example: SELECT * FROM table1 t1 INNER JOIN table2 t2 ON t1.key2 = t2.key2 … Read more
SELECT MONTHNAME(curdate()); Doc or if you only need the first 3 letters SELECT substr(MONTHNAME(curdate()), 1, 3); 0 solved I want get month() function return value as ‘jan’,feb etc
What you want is a content management system (CMS), such as Drupal or Joomla. There are CMS that are specific to e-commerce as well, such as Magento or OpenCart. 1 solved How to create e-commerce website [closed]
Store now() in a variable and then compare using where clause. Also see this and this Update :<?php $timeZone=”Asia/Kolkata”; //variable for indian timezone date_default_timezone_set( $timeZone); //default timezone set to indian time $now = date(“m/d/y G.i:s”); echo $now; ?> Check for date functions in PHP 2 solved Select database where datetime>now()? [closed]
Example of database connection : //ENTER YOUR DATABASE CONNECTION INFO BELOW: $hostname=”localhost”; $database=”dbname”; $username=”username”; $password=”password”; //DO NOT EDIT BELOW THIS LINE $link = mysql_connect($hostname, $username, $password); mysql_select_db($database) or die(‘Could not select database’); Exemple of INSERT array in database : $json = file_get_contents(‘php://input’); $obj = json_decode($json,true); //Database Connection require_once ‘db.php’; /* insert data into DB */ … Read more
I made the assumption that this is SQL Server and it didn’t look like there was a where clause requirement so I provided this query for that. If you need for mysql please update question. Select co.com_name,c.c_name,b.b_id,b.b_name from Country c inner join Company co on c.c_id = co.c_id inner join branch b on co.com_id = … Read more
Try this: $query = “select * from table_name where 1 “; if(!empty($_POST[‘field1’]) ) { $query .= ” AND field1 like ‘”.trim($_POST[‘field1’]).”‘”; } if(!empty($_POST[‘field2’])) { $query .= ” AND field2 like ‘”.trim($_POST[‘field2’]).”‘”; } // and so on $result = mysql_query($query); 1 solved Search query using php and mysql [closed]
As database schema is not available, I’m assuming the structure like this. Change it where you need. registration table Id | firstName | lastName | email | …. Where, Id is Primary Key and auto-incremented orders table orderId | userID | orderName | … Where, orderId is Primary Key and auto-incremented ; userID is Id … Read more