6,934 Topics
 | |
| | 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 … |
| | I have read from different forums, PHP website and Microsoft website how to connect PHP to MS SQL Server but the provided solutions didn't worked for me. If you could help me in this would be greatly appreciated. |
 | I have following tables for photo album script. How to display Album title and album cover inside anchor tag? (Display Albums cover on homepage and redirect to gallery page, when clicked, to see images inside that album) * get id of album * get album title * get album cover … |
 | i got the following entry in my dtabase.. field: poNo 001 002 003 004 005 006 007 008 009 0010 0011 0012 0013 if i issue in my php program this sql statement: $query = "SELECT * FROM po ORDER BY poNo ASC"; the result is: 001 0010 0011 0012 … |
 | Hi Ive been using my sql server lately but for this past few days, its been crashing. I'm trying to find solution but seems nothing works or I'm just doing it wrong. Its sql server 2008 R2 Error details: Problem signature: Problem Event Name: BEX Application Name: Ssms.exe Application Version: …  |
| | Hi guys, is it possible for me to downgrade server . i tried to restore .bak file from 2008 r2 to 2005 but it has a compatibility error./ can anyone could help me on this matter. Thanks in advance .  |
 | 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 … |
 | HY I HAVE THIS SQL CODE select id,category,sum(q1) Total from articles group by category order by id AND I WHANT TO INTEGRATE IN MY PHP SCRIPT TO SHOW IT LIKE A TABLE INCLUDING THE TOTAL, HOW CAN I DO THIS ?  |
| | Hi guys. I wanted to create a quiz for my website. I have found some code from a website called (getcode.org) (prev world of webcraft). The quiz now works as it should and I'm very happy it does. There is one problem I have adapited it to the needs of …  |
| | Hi! I already established an iDB2Connection, now what I want to know, is how could I execute SQL Queries for INSERT, DELETE and UPDATE. I had tested the code already and it works. The code for count works; I get the total number of records. My question is that for … |
| | |
 | 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 am trying to insert records in a SQL table from Excel sheet with VBA code. Data contains of a range with all the rows to be inserted. I am using below code for the same. Insert INTO [odbc;Driver={SQL Server};Server=myserver;Database=mydb;Uid=abc;PWD=abc].DPR Select * FROM [TempRange] I am getting error as above. …  |
| | This should be an easy question. I just need to make so that when you click on some function in pgAdmin 3 and then click the SQL button on the top (the focus glass icon) the code form the selected function (showing in the sql pane) to automatically show in … |
| | I want to import/upload excel files to sql server via cake php, it will occur Undefined variable: ext and Undefined index: the code are shown as below. Is there any mistake in my code? Thanks in advance! <?php App::import('Vendor', 'php-excel-reader/excel_reader2'); class UploadsController extends RealTimeAnalysisAppController { public function upload() { $destination …  |
| | 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 * … |
| | Hello everyone I have a windows form application in Visual Studio 2012, with a datagridview. I need to save new data on this datagridview to a SQL database. Could anyone help me with the code or a procedure. The database name is PRISOON, and the table records to be added …  |
| | 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 … |
| | I have vb.net application with MDF-Sql database. I retrieves data from Table in MDF-Sql into datagridview by TableAdaptermanager/binding navifator. Although it displays data but when I want to save by this code, its not working.This code is working in vb.net with OleDb application but not here. Is there any another …  |
 | 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> |
| | 1. What exactly is a surrogate primary key? 2. Is a surrogate primary key just a made up attribute inserted into a table by the database administrator? All I know is that you use a surrogate key when there is no primary key or the natural key may not be … |
| | Does anyone sees any fault? <?php $sql = 'SELECT * FROM messages'; $result = $database->sql_query($sql); while ($row = $database->sql_fetchrow($result)) { echo $row['message']; } ?> and my database connection `$database = mysql_select_db(DB_DATABASE) or die(mysql_error());` |
| | Hi all , I am a new in PHP my code don't save information in db and password confirmation code doesn't work correctly this is my simple code : <?php // decleration for varible $name=$_POST['nameTxt']; $username=$_POST['userNameTxt']; $passTxt=$_POST['passTxt']; $passConTxt=$_POST['passConTxt'] ; $email=$_POST['email']; $website=$_POST['website']; $errors=0; $submit=$_POST['btn_done']; // connection to mysql $con=mysqli_connect('localhost','root','root'); if(!$con){ die('Could … |
The End.