2,568 Topics

Member Avatar for
Member Avatar for Kalaivani Nair

I'm referring to this tutorial: http://www.techfounder.net/2009/02/02/selecting-closest-values-in-mysql/ My query and code to execute search (This doesn't return any result).I need to get 100 closets value to the postcode given by user which is collected by $postcode = $data['postcode']; ERROR shown are: 1) Fatal error: in C:\wamp\www\search\ajax2.php on line 79 2) PDOException: …

Member Avatar for pritaeas
0
197
Member Avatar for Nikhilesh_1

Hi, I have a query ... I have changed php max_execution_time in **php.ini** to say 600 seconds. It worked on Windows platform. However the same code doesn't work in Linux redhat5. I even tried **ini_set('max_execution_time', 600);** in a php file but it still executes its default time that is **10 …

Member Avatar for diafol
0
256
Member Avatar for Israel_2

I need help parsing json data to a specific format so I can put it on a line chart. More specifically a line graph using [highcharts](http://www.highcharts.com/demo/line-basic) This data comes from a query $data['graph']=$this->mymodal->graphmodal($id); foreach ($data['graph'] as $row) { //modify array.. } echo json_encode($data['graph']); The result this produces is the following …

Member Avatar for Israel_2
0
201
Member Avatar for stokie-rich

Morning guys hope that you are all well. need to pick your brains because I'm ready to bang my head against a brick wall. I'm building a multipolchoice quiz I want to just show 20 random questions from the 80 questions that I have in the question bank, in my …

Member Avatar for stokie-rich
0
249
Member Avatar for Mike Askew

Me again... So now I am confused... I have a form: <form action="addanimal_submit.php" method="post" enctype="multipart/form-data" style="padding-left:10px"> <p>Name: <input type="text" name="name"></p> <p>Date of Birth: <input type="text" name="dateofbirth"></p> <p>Description: <input type="text" name="description"></p> <p>Available For Adoption? <select type="text" name="available"> <option value="1" selected>Yes</option> <option value="0">No</option> </select> </p> <p>Image Of Animal:</p> <p><input type="file" name="fileToUpload"></p> <input …

Member Avatar for Mike Askew
0
304
Member Avatar for masaker

**Student and Courses Record Management System (LinkList of LinkList)** In this Assignment you need to create a small student and courses record management system with following functionalities. 1- Add New Student This function will allow you to add a new student record,you can use any three attributes of your choice …

Member Avatar for David W
0
2K
Member Avatar for scomx

i have done a project is a web browser uses a sql server 2008 as a back end so i want make setup file for that project to work in a computer that has'nt sql server , in onother word i want bind my database with the project and make …

Member Avatar for mikeybware
0
690
Member Avatar for sanket044

Hello, I am right now having a dedicated server and when i try to execute a INSERT query in table of 2 Lakh rows it takes about 0.02 seconds. so i am having a website where i need to update all 2 Lakh rows every 15 mins. but it sims …

Member Avatar for pritaeas
0
656
Member Avatar for AntonyRayan

Hi, In a form, I have 4 select boxes(default), and two text boxes(default). If I click the first (static values) based on that next second(new) select box will come (it has been done by ajax), based on the new select box, I display checkboxes based on the select box values, …

Member Avatar for Gideon_1
0
3K
Member Avatar for G_S

Hello everyone. I am modeling a simple dictionary application using the presentation-business logic-data layer pattern. I already have the design but am not sure it is correct: My presentatioon layer is a simple GUI where users insert their queries. They have a form for entering new words and their definitiom …

Member Avatar for JamesCherrill
0
284
Member Avatar for Mihailo_1

I have 1 gridview with big table...colums:k,mi,ib and 3 textbox...texbox1 is first column,textbox2 is second and textbox3 is third! I want when i type some number in textbox1(That number is K),i want to textbox2 and textbox3 give me value of mi and ib in same row as k...but i got …

Member Avatar for Mihailo_1
0
261
Member Avatar for UK-1991

Hello Experts, I hate PHP when these things comes in front of me every time when i create and insert query I stuck up by viewing everything is ok but not working don't know why. please help me out previewuser.php <?php include_once('includes/header.php'); include_once('includes/session.php'); include_once('includes/functions.php'); include_once('includes/connection.php'); if(isset($_POST["submit"])) { echo add_user(); } …

Member Avatar for pritaeas
0
2K
Member Avatar for Mike_25

Hi, I have two computers (Desktop and laptop), The desktop is my office computer and I have been using it for my application development(Visual basic). I have Visual studio 2013 and SQL Server 2014 installed on both computers. I exported the database from my desktop computer to the laptop and …

Member Avatar for Minimalist
0
219
Member Avatar for batoolhussain

hi everyone. I have this code to retrieve image from sql server using asp.net with vb, the problem is the image cannot display in the web page and I don't know what is the problem can you please help me.` Imports System.Data.SqlClient Imports System.IO Imports System.Drawing Public Class _Default Inherits …

Member Avatar for David_50
0
191
Member Avatar for rony001

I am new to sql server .I have recently downloaded Sqlserver 2008 and connected from vb.net . I am trying to create dynamic tables with two columns such as name,amount by passing table names from text box . CREATE TABLE " & TblName & "( [Name] TEXT(10), [Amount] TEXT(6))] table1 …

Member Avatar for BitBlt
0
705
Member Avatar for berserk

I cant seem to understand the issue with this statement, admittedly i have not written this code myself but have found it and modified it to work with what im doing, as most open source code is. This is for a secure login script that will pull a salted password …

Member Avatar for berserk
0
1K
Member Avatar for ribrahim

Hello, I hope that I can get an answer for this question. I have a MYSQL table for charges which contains the following fields: ChargesID, ChargesTitle, OfficialFees and ProfessionalFees. What I need is to make a dropdown list which contain ChargesTitle and upon selection to autofill the OfficialFees and ProfessionalFees. …

Member Avatar for ribrahim
0
4K
Member Avatar for Papa_Don

Group, I'm extracting some month and year values from dates. I need to ensure they are NUMBERS as I'm going to multiply, add and subtract. I'm assuming I need to DECLARE these as NUMBERs. However I'm not sure how to do this correctly as I'm getting errors preventing me to …

0
125
Member Avatar for sam1

hi, I am creating a form for user to update their details which is saved in the database. So far i can show their details in the form where i have a submit button but the updating part doesnt work(it doesnt update at all). here is the code: [CODE] <html> …

Member Avatar for diafol
0
3K
Member Avatar for mmonclair

Here's my scenario: I have been trying to re-establish mirroring on my SQL Server 2008 R2 instance since a VMWare outage took it down a few months ago. Here are the servers I'm using: Primary- prodDB.mydomain.com, on DataCenter1 Mirror- recoveryDB.mydomain.com, on DataCenter2 Witness- testDB.mydomain.com, on DataCenter2 DataCenter1 and DataCenter2 are …

0
142
Member Avatar for mad_1

Hi , i need some help in completing a small task . " How to insert,update,delete record in data grid view using inline i.e (suppose if we update a record in the data grid then after click on the next row the data which is updated should be save directly …

Member Avatar for deceptikon
0
231
Member Avatar for nimz143

Hi! I'm using Microsoft Visual Studio 2008, Microsoft SQL Server Management Studio. I need help. I cant figure out this if else statement for this condition: ///to check condition either the way ID exist in database ///if not exist then way ID can be delete ///if exist, message box appear …

Member Avatar for nimz143
0
162
Member Avatar for nimz143

Hi. Im using VS2008 and SQL Server Management Studio 2008. I want to ask, i have two different table, TableA and TableB in same database, DatabaseX. Both table have two same column, ColumnY but the data are different within this table. Example: TableA, ColumnY : A1, B2, C3, D4 TableB, …

Member Avatar for nimz143
0
281
Member Avatar for Papa_Don

Group, I'm using TOAD to query the Oracle database. My better expertise is in VB.net. I have very little SQL experience. My question: Can I create a variable in TOAD/SQL to prompt for a date(s)? Here is what I want to do: Question 1: Enter Beginning Date (user to enter …

Member Avatar for Papa_Don
0
3K
Member Avatar for cy163

I have two tables tb1 and tb2. I would like to sum up field values from two tables. How to do this using a SQL statement. tb1 Name Salary Bob 1000 Tom 2000 John 3000 Winson 4000 tb2 Name Bonus Bob 100 Tom 200 I would like to get the …

Member Avatar for rpv_sen
0
11K
Member Avatar for Papa_Don

Hi group! I'll be up front and say I'm very new to SQL. I'm just now getting my feet under me in my new job. So I have lots of questions. I'll start simple (I hope). I've created my own tables (2) that have multiple columns of data that looks …

Member Avatar for Papa_Don
0
243
Member Avatar for batoolhussain

hi everyone. I want to retrieve image from sql server database using asp.net with vb, but the image is not display and I don't know what is wrong with my code. please help me. Imports System.Data.SqlClient Imports System.IO Imports System.Drawing Public Class _Default Inherits System.Web.UI.Page Public sqlcon As SqlConnection = …

Member Avatar for G_Waddell
0
337
Member Avatar for Benyam

public partial class Form4 : Form { private OleDbConnection connect = new OleDbConnection(); public Form4() { InitializeComponent(); connect.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Bino Unity\Desktop\user1.accdb;Persist Security Info=False;"; } private void Form4_Load(object sender, EventArgs e) { } private void login_button_Click(object sender, EventArgs e) { connect.Open(); OleDbCommand command = new OleDbCommand(); command.Connection = connect; command.CommandText …

Member Avatar for JerrimePatient
0
253
Member Avatar for zizo.ahmed.779

hello everybody...nice to back again i m working on project to calculate measures and numbers and insert data inside datagridview(dgv) from number.text and measure.text but if value of measure.text present in dgv son update number cell with new value + present value problem is how to do so.... i tried …

Member Avatar for zizo.ahmed.779
0
3K
Member Avatar for Hari om

The End.