2,570 Topics
 | |
| | I need help trying to get my mysqli_query() function to work right. I have this so far: $raw_results = mysqli_query($con, "SELECT * FROM numdata WHERE numb='%".$k."%' UNION SELECT * FROM numdata2 WHERE numb='%".$k."%' UNION SELECT * FROM numdata3 WHERE numb='%".$k."%' UNION SELECT * FROM numdata4 WHERE numb='%".$k."%' UNION SELECT * … |
| | I have vb.net application with SQL server express. Here is my code to save data to database, but itn not working. Here ID is not the primary key. Imports System.Data.SqlClient Imports System.Data Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click Dim cmd As New SqlCommand Dim … |
| | Whats wrong with this query? For example $brand holds the value 'apple' Then I get the error 'unknown column 'apple' Can anyone see the problem? if(isset($_GET['brand']) ? $_GET['brand'] : 0){ $brand = (isset($_GET['brand']) ? $_GET['brand'] : 0); $sql = mysqli_query($link, "SELECT COUNT(id) FROM products WHERE brand = $brand AND status … |
| | i'm not sure what is the syntax error. I try in this source code in dreamweaver, it shows line 8 is a syntax error. $destination = realpath(‘../../app/webroot/uploads/excel/’); App::import(‘Vendor’, ‘php-excel-reader/excel_reader2’); //import statement class UploadsController extends RealTimeAnalysisAppController public function upload() { $destination = realpath(‘../../app/webroot/uploads/excel/’); //Set your upload path here if(isset($_FILES['Upload']['XLS_File'])); $ext = … |
| | Hi i am trying to display records in access database that have pictures saves binary data i have created typed dataset that populate the crystal report but the problem is the images do not display code is as below i have attached sample report Imports System.Data Imports System.Configuration Imports System.Data.OleDb …  |
 | -->>Hello,My problem is how will a trigger a php Function based up on Change event of a listbox value. My Page has the Field as those in the screenshot below the code: So when a driver is selected on the list all his/her details should be populated in the remaining … |
| | i tried to mimic the code of a tutorial for a live updatable table....dat is connected to the MYSQL server .... i copied it and edited it a bit...but its not working... i was not able to understand the code so dont knw where the problem is here is the … |
 | hi all! it might look similar to previous question but actually different.. i'm trying to calculate stock value. for this i want to use "average last purchase value" of item. like if closing stock is 14 and purchase detail is like this 2014/2/2 15pc @ 38000 2014/2/15 5pc @ 36000 … |
 | In true Microsoft fashion they have made the download process so counterintuitive that your chances of getting what you want is near impossible. Fortunately someone has created a "simple" [12 step process](http://www.istartedsomething.com/20140616/the-12-step-process-to-download-microsoft-sql-server-express-2014/). For yuks, see also [here](http://www.istartedsomething.com/20121216/downloading-sql-express-2012-from-microsoft-com/). And to see how little things have improved see [Bill Gates Chews Out … |
| | This code was to create a simple database with a table and add records with the following. toIm having trouble with the 'id' auto_increment. <?php $con=mysqli_connect("localhost","root","distortion","my_databs"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } // Create table $sql="CREATE TABLE empl(ID INT NOT …  |
| | Hi, I want to display the department no. and the no. of employee in each department from EMP Table.(in a Single Row). Pls help me how to write the query for that. I had one query which display the result in 3 rows. select deptno, count(*) from emp group by … |
| | [code=sql]insert into desg values(" & Val(txtsno.Text) & ",'" & Trim(txtdesg.Text) & "'," & Val(txtbasic.Text) & ");[/code] this how i used for inserting data to my access table in vb code. how to do in c#?  |
 | Hi, How ru guys.why we need to give max and min width both in media queries. I use only max-width and it works fine for me. Is there any specific reason for using the max-width and min-width at same time. Do i need to use both when i define media … |
| | hi i need to show employee attendance based on device logins with employess various information like department,designation,device_person_id,person_id,logid etc..... joining 3 tables i.e dbo.tempdevicelogs,dbo.employee_settings,dbo.persons_profile i tried this one Select Device_Person_id,personal_id,Date1,( cASE WHEN eXISTS( SELECT Device_Person_id FROM tempDeviceLogs AT WHERE T.personal_id=AT.Device_Person_id AND T.date1=AT.logDateTime ) then 'P' Else 'A' End )as Status FROM …  |
 | hy i have question i have this code and i whant to print it one by one not all the page the script is <?php $qry=mysql_query("SELECT * FROM articles order by articles.id DESC ", $con); if(!$qry) { die("Query Failed: ". mysql_error()); } /* Fetching data from the field "title" */ …  |
| | how to retrieve particular node.. i.e., if b node had value like <b id="1"> means it will return b's child nodes.. output must be: <c>text</c> <c>stuff</c> Here is my code: <?php $string = <<<XML <a> <b> <c>text</c> <c>stuff</c> </b> <b id="1"> <c>code</c> </b> <d> <c>item</c> </d> </a> XML; $xml = … |
| | Hello everyone, Im very new to c++ and dont have very much experience. But Im working on a programm and for that programm I need ms sql connection. Ive already googled much but I couldnt find what I need. Now I would like to ask here if someone know where …  |
| | Hi, Not sure what exactly is happening here as I'm used to dealing with Microsoft SQL server rather than Oracle but here goes: I have a C# project that connects to an Oracle database using the OracleCommand Object to bring back records but I've been noticing some strange behaviour. Here … |
| | Suppose I have a tow SQL tables: Fathers id | name ------------- 1 | Clinton 2 | Gates 3 | Bush 4 | Clinton Sons id | fatherid | name --------------------- 1 | 1 | bill 2 | 1 | suzy 3 | 2 | mera 4 | 2 | … |
| | Salam all :) anyone can help me to understand this query in venn diagram SELECT e.id, e.name FROM emp e INNER JOIN deptid D_X ON e.empid = d_x.empid AND deptid = 'X' LEFT JOIN deptid D_Y ON e.empid = d_Y.empid AND deptid = 'Y' WHERE d_Y.empid IS NULL |
| | Hi there, I just can't figure this out and I hope someone may be kind enough to help me. I am trying to paginate search results from a simple form. The script I am using works fine for the first page of results but resorts to displaying all the rows …  |
| | Hi all , i have 2 tables first one called emp have 2 columns id and name second one called dep have id and empid and nameOfDep if i want to list all emp that have X dep (But they don't have) Y dep how i can make it ? … |
| | Having trouble with header redirection passing variables from the url. <? ob_start(); ?> <?php require_once ("Includes/config.php"); require_once ("Includes/connectDB.php"); include("Includes/header.php"); confirm_is_admin(); $lid = $_GET['lid']; $yr = $_GET['yr']; $gid = $_GET['gid']; $pid = $_GET['pid']; $pn = $_GET['pn']; if (is_admin()) { $aid = $_GET['aid']; $query = "DELETE FROM articles WHERE article_id = ?"; … |
| | if(isset($_GET['Id'])){ $Id=$_GET['Id']; $query = mysql_query("SELECT * FROM page WHERE ID='$Id'"); $row = mysql_fetch_array($query); $PageId=$row['PageId']; $MenuName=$row['MenuName']; $ParentMenuId=$row['ParentMenuId']; $LinkWidth=$row['LinkWidth']; $OtherUrl=$row['OtherUrl']; $Status1=$row['Status']; $OnMainMenu=$row['OnMainMenu']; $FooterMenu=$row['FooterMenu']; } ?> <form style="width:100%" action="" method="post" id="form1"> <table class="viewjob" align="center" > <tr class="tableheader"> <td align="center" colspan="4"> Update </td> </tr> <tr class="tablerow"> <td>Page Id</td> <td><select name='PageId' class="select"> <option value='0' >select …  |
| | These are my prerequisites software: * Crystal Reports * SQL Server 2008 Express * Windows Installer 4.5 * .net Framework 4 full The problem is Crystal Reports installation is first and it needs Windows Installer 4.5 and the .net 4 Framework. So the order of prerequisites must be like this: …  |
| | I NEED TO WRITE A CODE IN VB.NET , THAT LET ME EXPORT DATA FROM ACCESS DATABASE ( THE TABLE ATTACHED AS IMAGE ) AND IMPORT IT INTO SQL SERVER 2008 R2 . **NB : TAKING INTO CONSIDERATION DUPLICATION ** Example : if you see in the image the access …  |
 | hello i have a problem understanding how a function works for example i wrote this php code <?php $face = $Wall->Profilepic($profile_pic_path); $query = mysql_query("SELECT * FROM `messages` WHERE type ='A' AND uid_fk = '$uid'"); while($row=mysql_fetch_array($query)) { echo '<a href="'.$base_url.'roves/'.$row['msg_id'].'" ><img src="'.$face.'" class="small_face" original-title="'.$row['message'].'" ></a>'; } ?> and i named a … |
 | Hello everyone. Here just page refresh Counter++. $this->db->select('Counter_field'); $this->db->where('id', $id); $cnt = $this->db->get('Job_Description'); $new_cnt = $cnt+1; $data = array('Counter_field'=>$new_cnt); $this->db->where('id',$id); $query = $this->db->update('Job_Description',$data); What is wrong with above Query.. Every time i want increment and go to update results store in DB.  |
| | Can somebody please explain exatly what surrogate, natural and candidate keys are and how they differentate from each other? Thankyou |
| | I am trying to put rows from my database to a select this is the code, <select name='network' id='network'> <option selected>None</option> <?php $query = mysql_query("SELECT * FROM `countries` "); while($row=mysql_fetch_array($query)) { echo $row['name'].'<br>'; } ?> </select> |
The End.