You will have to check if there is no starting and trailing comma’s in the $columns or $values variables. Plus, just to be sure, put appropriate quotes around the columns and values individually. public function insert($data, $table) { $columns = “”; $values = “”; foreach ($data as $column=>$value) { $columns .= “`” . $column . … Read more
SELECT ppmap_d.*, p_prob.*, ppmap_h.*, p_probgroup.*, p_prod.*, ppmap_d.prob_id AS probid, ppmap_d.map_id AS mapid, ppmap_h.pg_name AS probgname, ppmap_h.m_id AS modelid FROM p_prob INNER JOIN p_prod ON ppmap_d.prob_id = p_probgroup.prob_id INNER JOIN ppmap_h ON ppmap_h.map_id = ppmap_d.map_id AND ppmap_h.pg_name = p_probgroup.pg_name INNER JOIN ppmap_d ON p_prod.m_id = ppmap_h.m_id INNER JOIN p_probgroup ON p_prob.prob_id = p_probgroup.prob_id; 4 solved MS … Read more
Your sql is wrong. Apart from the gaping wide open SQL injection attack vulnerability, you’re generating bad sql. e.g. consider submitting “Fred” as the first name: $First_Name2 = “Fred”; $query = “UPDATE people SET Fred = First_name WHERE ….”; now you’re telling the db to update a field name “Fred” to the value in the … Read more
To refresh a page without reloading, you have to load the contents of the page through ajax. You could do this as follows: index.php <html> <head> <script type=”text/javascript”> $(document).on(‘ready’, function(){ setInterval(function() { $.ajax({ type: “GET”, url: “ajax_refresh.php”, success: function(result) { $(‘body’).html($result); } }); }, 3000); }); </script> </head> <body> <div class=”header”> Header of website here … Read more
I will make the assumption that there is at least one record in sales_flat_order that satisfies condition status != ‘holded’ and whose customer_email is NULL. (NOT) IN is notoriously tricky with NULLs, here is an example. Consider the following query: SELECT 1 WHERE 1 NOT IN (SELECT 2 UNION ALL SELECT 3) This yields a … Read more
I am not sure if I got your question all clear, this query below will give you the latest employee record if there are multiple user records – SELECT * FROM employmentrecords WHERE id IN(SELECT MAX(id) FROM employmentrecords WHERE ((date_end >=’2017-08-22′ OR date_end IS NULL OR (date_end <=’2017-08-22′ AND date_end >=’2017-08-08′)) AND date_hired <=’2017-08-22′) GROUP … Read more
General Format, query =select * from table_name where table_col1=”+getvalue1()+” && table_col2=”+getvalue2()+”; in order your database, query=”select * from userVO where familyno=”+udto.getFamilyno()+” && date=”+udto.getDate()+”;”; 2 solved where conditon to get date in two columns familyno and date
Oracle Query: SELECT * FROM ( SELECT client_id, priority, phone_number, phone_type FROM client_table c LEFT OUTER JOIN phone_table p ON ( c.phone_id = p.phone_id ) ) PIVOT ( MAX( phone_type ) AS phonetype, MAX( phone_number ) AS phonenumber FOR priority IN ( 1 AS Prio1, 2 AS Prio2, 3 AS Prio3 ) ); Output: CLIENT_ID … Read more
This line of code isn’t closed: $this->query(“INSERT INTO testing_Rand (number1, // etc and you are missing a ; after this line: $newRand.=implode(‘,’, $varNum) If I get it, you meant to write this instead: public function insert_SQL($varNum ) { $this->query(“INSERT INTO testing_Rand (number1, number2, number3, number4, number5, number6, number7, number8, number9, number10) VALUES (“.implode(‘,’, $varNum).”)”); } … Read more
Use this: <?php $sql=mysql_query(“SELECT ID FROM emp WHERE user=”$login_session””); // its currently zero $row=mysql_num_rows($sql); $b = 3; $tot=$b – $row; echo “$tot”; if($row < $b) { echo “good”; } else { echo “wrong”; } ?> You have been trying to output variables, which is not defined. You code was: Ouput undefined variables Assign something to … Read more
Well, you gave a different name for the file in the input file tag in your form. Change this <input type=”file” name=”image” ><br> to this <input type=”file” name=”file” ><br> and it should work. Let me know if it doesn’t. You may also consider putting the contents in upload_file.php in an if-conditional to prevent it from … Read more
1) you will get string as the value of radio so it will be varchar type 2) for check boxes any one can have multiple values so you need to create a separate table(working_project) for this values( data type will be same as radio) and another table for mapping(user_working_project) user_working_project table will containing user id … Read more
I don’t understand your problem: def get_dangerous_query(): # do some database access # For a demo, just return what we know the table contains return “SELECT * FROM TABLE WHERE COL1 = ‘%s’ and COL2 = ‘%s'” qry = get_dangerous_query() % (var1, var2) “”” vs ” only has an effect on string literals. Quotes are … Read more
In SQL, this type of query needs what is known as an EXCEPTION JOIN. Some RDBMSs actually implement this as a separate type (such as DB2), while others need to use a workaround. In your case, it amounts to (in SQL): SELECT User.* FROM User LEFT JOIN UserHouse ON UserHouse.id_user = User.id WHERE UserHouse.id_user IS … Read more
Try this : Use LEFT JOIN SELECT * from propertyfield as pf LEFT JOIN property as p ON (pf.pfid = p.propID) From your question, It says that p.propID has null values. So let the propertyfield be your left tabe, which gives all data from it. and property be your right table, which gives the corresponding … Read more