2,570 Topics
 | |
 |  I have cretaed the data set above with a query and now I need to export ONLY a portion of it to a .csv file with PHP. The higlighted portions in the images are what needs to be exported to a .csv file. Basically, each time an account_manager_id … |
| | i have this code which doesnt work completely...csv file is generated but query string named as $s is not shown... <?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"]); …  |
 | Hi All, These days I am implimenting a Hotel Room Reservation system. I have a small problem in Check Availability' page. below I listed my database structure. *rooms* rid int(11) <--- AI name varchar(255) ppn varchar(50) facilities mediumtext *reservations* resid int(11) <--- AI rid int(10) arrival date departure date System … |
 | Hi ! I need to have a single mysql query which should get COUNT of two different values in a single field, suppose i have a field in a table 'approved', and there are only two values ie. approved=0 or approved=1, and have suppose 100 rows for them,so how to … |
| | I have MySQL search query which takes input from drop down values and pass on values to my search query. This works perfectly on my website. But the same when I run on my Mobile it does not give me results(blank) as well its not consistent in displaying results, means … |
| | can i use submit button inside a form to access a function in other php file?because i have 2 buttons on same page but want them to do different function..one to query database other to update table.. |
 | Hello thanks in advance i working on project i used query select project_table.project_id as proid,resource_request.*,sum(resource_table.resource_budget)as resourcecost,resource_table.* from project_table left join resource_request on resource_request.project_id = resource_request.project_id left join resource_table on resource_table.resource_id = resource_request.resource_id GROUP BY proid ORDER BY proid DESC its worked but resourcecost is displaying for all project id if … |
| | Hi I have the following code that uploads images and other files to an SQL Server DB on GoDaddy via a FileUpload Control on an aspx page. Public Function InsertData(ByVal cmd As SqlCommand) As Boolean Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString Dim con As New SqlConnection(strConnString) cmd.CommandType = CommandType.Text cmd.Connection … |
 | 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 … |
The End.