2,531 Topics
| |
Sir, i have a little problem regarding my queries.. I try to display data from two different table using left outer join. but I found some error.. here's my code please check and tell me what is wrong.. f(isset($_GET['id'])){ $id = preg_replace('#[^0-9]#i','',$_GET['id']); $result = mysql_query("SELECT A.cus_id, A.complaint, A.admin, A.datetime, B.firstname, … | |
i want to copy data from an access database to a sql database 2008 through coding in vb.net any help ? NB : I WANT ALSO TO CHECK FOR DUPLICATES EACH I SELECT FROM ACCESS TO COPY IN SQL | |
hello sir, i have a php code like <?php $count = 0; foreach($_POST as $item) { $count += (is_array($item)) ? count($item) : 1; } // echo "Items = $count"; $db=$_POST["db"]; $skills = explode(",", $_POST["skills"]); $table = explode(",", $_POST["table"]); $city = explode(",", $_POST["city"]); $region = explode(",", $_POST["region"]); $country = explode(",", $_POST["country"]); … | |
I am currently confused and not sure why. I believe I have stared at this for to long. I am currently just trying to populate a ComboBox with the data that is read in from a SQL DB through a SQL query. Currently I have the below code. I am … | |
hey, I need help with this code, I have made database and code for inserting data, now I need code that will display data for group, in database I have groupnaziv, and id, here is code for inserting which works great, after that I will post code that I need … | |
i want to display first priority wise after that remaining data if no priority will display all data by select DISTINCT s.Companyname,s.id as companyid,s.LogoImage,s.LogoPath,s.Url,ck.MainCatagory,c.city,st.state,sub.Subcatagory,sub.MainCatid,p.priority,rc.RelatedCatagory from spa s left join relatedcatagories rc on rc.spaid=s.id left join catagorykeywords ck on ck.id=rc.mainCatagoryid left join subcatagorykeywords sub on sub.id=rc.RelatedCatagory left join city_place cp on … | |
Not sure where else to put this, I apologise in advance if its in the wrong place. I'm trying to migrate a program from one server to the next without having to completely re-edit every configuration file. To do this, I need to enable the sql SA account, which I … | |
hi i want to insert date through mysql query <?php require_once('auth.php'); require_once('connection/config.php'); //Connect to mysql server $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if(!$link) { die('Failed to connect to server: ' . mysql_error()); } //Select database $db = mysql_select_db(DB_DATABASE); if(!$db) { die("Unable to select database"); } ?> <form method ="post" action =""> … | |
I just have one month for preparation. 1-What to prepare most part in asp.net and php to cover in one month.I have basic knowledge of asp php and c#.sql server 2005/08.Quick way to prepare 2.What type of demo project should i make to show them. 3-How to show my 2 … | |
I'm testing out wdcalendar, a jquery based calendar for a wesbite. Some info on it: [url]http://www.webappers.com/2010/06/08/wdcalendar-jquery-based-google-calendar-clone/[/url] The installation instructions are simple, but not detailed so maybe im screwing up somewhere. They go as follows: Copy the unzipped directory into the apache www directory/sub-directory. For a database: Create a database, execute … | |
Hello I have use 'LIKE' query in Model $this->db->like('job_title','keywords','both'); $query = $this->db->get('job_description',$data); which generate Query Output like SELECT * FROM (`job_description`) WHERE `job_title` LIKE '%keywords%' LIMIT 1 **Problem:** How could i remove the LIMIT that automatic generate in Query **OR** can i given Infinite LIMIT in CI Query. Can you … | |
I am trying to connect a Crystal report to my database.mdf i.e SQL Server database. When using the wizard At the [I]Database Expert[/I] window after choosing the [I]OLE DB (ADO) [/I]i can not find any server and a database in the drop down menu. how to get that? i have … | |
index.php code <html> <head> <meta charset="UTF-8"> <title>Our Local site</title> </head> <body> <form action="welcome.php" method="post"> <input id="t1" name="t1"type="text" placeholder="table name"><br> <input id="s1"type="text" name="skill[]"placeholder="skill or item or spec"> <input id="s2" type="text" name="skill[]" placeholder="skill or item or spec"> <input id="s3" type="text" name="skill[]" placeholder="skill or item or spec"> <input id="s4"type="text" name="skill[]" placeholder="skill or item … | |
<html> <head> </head> <body> <script type="text/javascript"> function ajaxFunction(choice) { var httpxml; try { // Firefox, Opera 8.0+, Safari httpxml=new XMLHttpRequest(); } catch (e) { // Internet Explorer try { httpxml=new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { try { httpxml=new ActiveXObject("Microsoft.XMLHTTP"); } catch (e) { alert("Your browser does not support AJAX!"); return … | |
I tried updating my data like so but it doesn't work <?php require("config.inc.php");//this piece of code us for authentication and it works fine. if(!empty($_POST)) { /** the values below in the POST are valid not empty values **/ $shell = $_POST['shell']; $reporter = $_POST['reporter']; //query $query = "UPDATE `shellingdb` SET … | |
hi i created login page using php and mssql but i got an error **"Fatal error: Call to undefined function mssql_query() "** **heres my log in code** <form name="log" action="log_action.php" method="post"> Username: <input class="form" type="text" name="name"><br /> Password: <input class="form" type="password" name="ssn"><br /> <input name="submit" type="submit" value="Submit"> </form> **log_in form** … | |
Hi Guys I am trying to display friends of a logged in user for my website, the user(person1 is friends with person2 and I would like this to display when either person1 or person2 log in( this should be under the hyperlink) Friends. and also to be able to see … | |
Hi there, Thank you for accepting me within your community My name is Bernard, I'm a French-speaking Belgian citizen living and working in Thailand since December 2003. I'm not an IT expert. I've been using VBA since Excel supports it (Excel 5-1995?). I work here as a school administrator and … | |
i'm new learn php and mysql and i got stuck can't get better logic for my brain i want to get message from page if i type url like **index.php?user=user1** and page will show with data table and if username doesn't exist and page show no username found so this … | |
This is the scenario: I have one table (main_tbl) with columns RECID(primary key),JOBNAME(text),STATUS(text). Now, I created an application that will query to the database and get one jobname and update the status. How can I make sure that multiple users wont get the same jobname when they executed the query … | |
HI, I a have inhrited administration of a work database. we currently have the ability to export data to a xls file from a customers table, but i want to add employers information from the employers table i.e employers name, address etc along with each record exported. This section deals … | |
hello world, myself kishan kumar, iam new to web developing...my task is interrelated to edit,save & cancel....which is similar to edit button in shine.com...Iam doing in php language.the work is when user clicks on edit button he must be able to edit and after on editing he can save it … | |
Good day, I need some advise. I have two database servers(primary & secondary) and both has installed the MS SQL Server 2008 r2. The idea is, the secondary server should setup as standby in case the primary servers down. How do I set it up? thanks in advance. | |
Hi guys hope your all well, I want to put a quiz into my website that I'm doing. I've found some code for a Multiple Choice-True False Quiz Here is the code, (yes I know its long and there are some reputation in it) You have to add questions by … | |
Please help me to connect my forms I created in Visual Studio 2010 to Sql server 2012. | |
Anyone will help me to solve this? this is about ER diagram and some other stuff about database. This is the exercise: ----------------- "Project a DataBase to support a architectural studio which offers its customers proposals refurbishment. Each component of furniture ( table , chairs , ... ) is characterized … | |
what i need is a single set of output for each procedures, but my this query is giving me 2-3 sets of answers, between this time period.. i need distinct set of answers.. if(isset($_POST['submit'])) { $to= $_POST['to']; $too = date("d/m/y",strtotime($_POST['to'])); $from= date('Y-m-d');; echo " <br><h2> PROCEDURE REPORTS UPTO <b>'$too' </b> … | |
I am importing data from an excel worksheet in to a sql table, one of the columns in the table is set to nvarchar(50), the data i am importing are barcodes, but the problem i am having is the column is changing the data for example the number "5900397732209" is … | |
I am developing a C# Windows Form Application. Now i am trying to select value from Listbox and load corresponding value in List view using the stored procedure. And this is my stored Procedure: ALTER PROCEDURE [dbo].[spPOExport] @BST_BESTELLUNG INT AS BEGIN SELECT BH.BST_LIEFERANT AS Product Name, BZ.BDT_REFNUMMER AS Unit Price, … | |
Having problems with a malware I had to reinstall Win7 OS with recovery mgr.After I had to reinstall all my web development tools such as Visual Basic Express 2008, Visual Web Developer Express 2010, SQL server express 2008, MySql, Workbench.I cannot reinstall PHP and PhpMyAdmin no matter what I try. … |
The End.