473,387 Members | 1,534 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

When my query is returned and posted in a text box only one word is posted

I am new to php and I want to figure out ways on ho to incorporate database with it.

I have a page wherein it has a textbox and a submit button in it. The textbox must be filled in with a student number. When submitted it will return another page with 2 textboxes for the student name and student address. Well, of course a name and an address has more than 1 word in it.

But when my query was processed and the page loaded, the first word of the student's full name was the only one that appeared, that was what happened also in the address textbox. Say for example in my database the student_name= "Melvin De Rosa", student_address="81 B, Ph 2, One Village". The query only returned to the textboxes the values "Melvin" and "81" only in the Student Name and Student Address respectively.

I figured out what if I divides the fields into different significant fields. Say the full name of the student, it will be divided into first name and last name. With the address: Lot Number, Street, Village, City. But when I programmed it again, it occurred to me that some first and last names has have two words in them, so when i run it again the same problem arises. Help me! what can I do to fix this.
Nov 6 '10 #1
1 1904
Dormilich
8,658 Expert Mod 8TB
what is the code you have?
Nov 7 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Jerome | last post by:
Hi, I've got the following problem: I want my ASP page to display a certain number (based on a COUNT query), it works fine if the result is at least 1! If there are no records to be counted...
10
by: Alex | last post by:
Hi, How would I go about writing the results of an SQL query to a text file? I cannot find any info in the Online help files. For example, I would like the results of: SELECT * FROM...
0
by: Rob | last post by:
I doubt this is the best way to do it, but what I came up with was to hide the XML in an HTML Comment then edit the file deleting the HTML stuff and keep the XML results. If anyone has a better...
2
by: Nathan Sokalski | last post by:
I have a page which reads the the first line of every *.txt file in a certain directory of mine to use as the Text property of a HyperLink Control. However, in one of my recently added text files...
5
by: paii, Ron | last post by:
Is there a setting to not word wrap text on a unbound text box. in A97?
11
by: dhirajpriya | last post by:
hi everyone when i create single text box on page and press enter the page refresh how can i stop to refresh the page.... dhiraj
2
by: kev | last post by:
Hi Folks, I have created a search query in which it successfully returns correct results. When there are no records returned, instead of giving out a blank form i created a pop-up msg which is...
3
by: Chris McFarling | last post by:
What's the most efficient method to export the result set of a SQL query to a text file using ASP.NET? There could potentially be a few thousand rows.
4
by: kstevens | last post by:
(Yes... i capitalized the S on purpose) I didnt know before today that dlookup only found the first result. I am actually trying to display the results of a query in a report, but there are...
2
by: slenish | last post by:
I am having some trouble doing a conversion. What I have is a combo box where if you type in the word All it knows to pull all the records. But because on the query I have running behind the input...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.