47 Topics

Member Avatar for
Member Avatar for Kcachilove

Hello I have an SQL query that i want to concatenate the fields and display it in a way that those concatenated fields will be displayed first row will have 4 columns,second row will also have 4 columns....etc. for instance the query `SELECT imageurl, caption, template FROM template; The Result …

Member Avatar for anejose
0
1K
Member Avatar for lloyd.farrell.7

Hi Everyone, Got a really strange problem with a mysql select query not displaying results in select dropdown. I have a small db table id,position,name and I am trying to display just the names where the position is GK Here is my query $result_dglass = mysql_query("select name from team where …

Member Avatar for nobita2811
0
213
Member Avatar for nadiam

hello. I have a table populated by name. The names are links when clicked will pop up a form for editing. each input (for editing) is populated by the equal value from database but im having trouble with one particular text box. this text box is for date of birth …

Member Avatar for diafol
0
579
Member Avatar for Praveen_10

#include <iostream> #include <cstdlib> using namespace std; // function prototype for add int add (int x, int y); int sub (int q, int r); int mul (int s, int t); int divi (int u, int v); int main () { int a,b; char ch; loop:cout<<"ENTER CHOICE OF OPERATION: + - …

Member Avatar for Praveen_10
0
272
Member Avatar for punith_1

hi i'm new to php but i tried to make my own edu website but i'm facing lot of problem to fetch the result using php external site is about one of the Engineering university where 10k students result will be displayed by this website bcoz of this its server …

Member Avatar for diafol
-4
2K
Member Avatar for Start4me

I need to make one statement to select either of the items in listbox and show the same label, regardless of which item is selected. I've tried someting like If Me.ListBox1.SelectedItem = "R115" Or "Bay, Charles" Then Label1.Text = "Address Information Avaliable" End If But it doesn't work. The code …

Member Avatar for Start4me
0
249
Member Avatar for iv_jo

Hi! Can anyone know the result of this query: SELECT COALESCE(MAX(ID),0) + 1 FROM Table123

Member Avatar for pritaeas
0
215
Member Avatar for cereal

Hello, so I was trying few relations between tables and I noted an unexpected behaviour when using `group_concat()`. Let say I have three tables: fruits, fruitstock and fruitprices. These are the structures: create table fruits ( id tinyint unsigned not null auto_increment primary key, name varchar(50) not null, quality varchar(50) …

Member Avatar for cereal
1
4K
Member Avatar for Deegirl

can someone help me to find out why my label display is listing the result of the textboxes instead of adding up the values of the text boxes? here are my codes: Dim strstudentName As String = (" ") Dim dblAssignment1 As Double Dim dblAssignment2 As Double Dim dblAssignment3 As …

Member Avatar for Reverend Jim
0
266
Member Avatar for aspertrace

<?php $username = $_SESSION['username']; $result = 'sample'; $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } $sql = "Select FirstName from Person Where LoginID = (Select LoginID from UserLogin Where Username = '$username')"; $result = mysql_query($sql,$con); echo $result; ?> I'm kinda new to this server-side scripting …

Member Avatar for aspertrace
0
214
Member Avatar for -acir-

//compute percentage for Parent1 DecimalFormat df = new DecimalFormat("#.##%"); rs = s.executeQuery("SELECT " + "(SELECT COUNT(*) FROM genetic.blood_type where diseases = '" + disease1 + "')" + "/COUNT(*) AS rowcount FROM genetic.blood_type where btype = '" + btype1 + "'"); rs.next(); int result = rs.getInt("rowcount"); rs.close(); out.println(disease1 + " is …

Member Avatar for -acir-
0
220
Member Avatar for garyjohnson

I am making a mysql query that gathers comments for a user, it works properly, I connect to the database and recieve the comments for a user, but it is not showing the first comment for the user. Here is the code function comments(){ //connect to db connect_db_members(); //start query …

Member Avatar for garyjohnson
0
302
Member Avatar for Start4me

I want to create an integer generating program where the user enters any number in TextBox1 and TextBox2 and presses the Generate button and in another textbox the integers shows up. REFER TO THE LINK to see what I mean. [Click Here](http://picturepush.com/public/11671143)

Member Avatar for tinstaafl
0
224
Member Avatar for cussel

>Hi guys,..i've two arrray data1 and data2 then i do intersect to get same value between data1 and data2, and >use count to get total same value,..how to ARSORT count result from intersect array multidimensional? <?php $data1 = array( array( '7' => 'chelsea everton', '8' => 'everton villa', '9' => …

Member Avatar for broj1
0
326
Member Avatar for tonyfonseca

I have the following code to search the stores by name and and order by transaction date by Asc which works perfect. My questions is how to performe a subtraction by row (checkamount-redeposited-replacement-paidcash = balance) and totalize by columns (total checkamount, total redeposited, total replacement, total paidcash and total balance) …

Member Avatar for tonyfonseca
0
297
Member Avatar for FaisalSarfraz

Hi every one!! I need help to match user data from database inorder to log in to admin panel. Here is what I am trying. it works ok but it is giving dialog box containing text "Sorry! You have no access to Database" here is the code. Please help String …

Member Avatar for FaisalSarfraz
0
289
Member Avatar for daniel36

i have writeen following query in my code. $tquery="SELECT questions.id,questions.date,questions.title,users.user_name,subjects.subject FROM questions INNER JOIN users ON questions.student_id=users.id INNER JOIN topics ON questions.topic_id=topics.id INNER JOIN subjects ON topics.subject_id=subjects.id WHERE subjects.id=".$_SESSION['sub1']." OR subjects.id=".$_SESSION['sub2'].";"; but when i am trying to echoing its result it is not displaying anything.

Member Avatar for daniel36
0
186
Member Avatar for joshl_1995

Hello, I want to combine all my database table in to one line so i can put it all in the url e.g. Name | Times __________________________ test1 | 1 __________________________ test2 | 2 __________________________ This is how i want it to look in the url (Result.php?loggedin=true&links=test1-1_newline_test2-2)(_newline_ means that will …

Member Avatar for jstfsklh211
0
275
Member Avatar for calebcook

HI. I've tried other codes, but they don't seem to work. What I'm trying to do, is grab a result from google's shopping page, and display it on my page. I only want the title, which is in the tag:[CODE]<h3 class="result-title">TITLE</h3>[/CODE] How do I do that in PHP? Thanks!

Member Avatar for karlmarsh05
0
2K
Member Avatar for tough

select name, REPLACE(format, ' – ', '/') as format, CAST(price AS UNSIGNED INTEGER) as price, CONCAT('http://www.example.com/',url_key) as url, id, delivery, sku from Database1 where delivery <> 'finished' INTO OUTFILE 'test.txt' FIELDS TERMINATED BY '\t'; this query returns empty result while select name, REPLACE(format, ' – ', '/') as format, CAST(price …

0
119
Member Avatar for gotboots

Hi All Im trying to get this to work, but can only get it to work without putting the form tags in, and wont work with more than one set of the inputs. the below is the result when i use ajax to search for item names, then want to …

Member Avatar for gotboots
0
3K
Member Avatar for beastpanda

Hi all, I am new to php and I have a problem that I am looking into it for 1 day and can't understand it please help. here is my html code : <html> <head> <title> Calculation Form </title> </head> <body> <form action=calculate.php method="POST"> value one: <input type="text" name"val1" size=10 …

Member Avatar for broj1
0
186
Member Avatar for DaveyMoyes

Hi Everyone, I have been trying to understand mysql a little further - with some small steps in the right direction. but I have come across a problem I am unable to fix / get working. I have a form, that has a variable $country - I am trying to …

Member Avatar for DaveyMoyes
0
251
Member Avatar for blivori

Hi, I have a table called BookTitle that holds book information. I have an SQL statement that lists all books that have the same value of a book called 'Northern Lights'. The code works but what I want to do is to exclude 'Northern Lights' from the result. This is …

Member Avatar for hfx642
0
2K
Member Avatar for Benjip

I'm stumped as to why this might be happening. A website I had completed for a client over a year ago, was working fine until a couple of days ago when the web host went and moved the site onto a new server without warning any of their customers (myself …

Member Avatar for Benjip
0
237
Member Avatar for SUGARRUSH

Hey guys. I've been searching and searching but none of the information I get makes any sense. I have a simple problem. On my checkout page, I allow my customers to select a charity to donate to. I can't however figure out how to get the information from which checkbox …

Member Avatar for diafol
0
190
Member Avatar for Hazkhan

I want to build a program for my c language project.What i need to do is that the user should enter the number of students,number of questions,correct answers,each students answers answers and then the program should calculate the number of correct answers,and their standing,the most wronged question . the problem …

Member Avatar for adityatandon
0
2K
Member Avatar for kikiritce

; multi-segment executable file template. data segment string db "THis is LuxUR in Summer." ends stack segment dw 128 dup(0) ends code segment start: ; set segment registers: mov ax, data mov ds, ax mov es, ax mov bx, offset string mov al, 0 ; lower letters in word mov …

Member Avatar for sbesch
0
248
Member Avatar for MitchellJ

Hi Everyone- We are building a database that needs table(purchaser) to check table(paypal) for a matching telephone number. Table(paypal) has 'purchaser telephone' as PK and table(purchaser) has 'purchaser telephone' as FK. I can insert and see the data in both tables, but running a select query returns an empty result. …

Member Avatar for MitchellJ
0
3K
Member Avatar for skran

HELP!! I try to bind a textbox to a datatable but i cant.. I checked if the datatable is filled (it includes the results of a sql query)and it s ok.. i can depict the result in a combo box but not in textbox. I wait for only one result …

Member Avatar for adam_k
0
1K

The End.