ways of writing (inserting) to your database

Hoangsta

I am using MySQL to store data. so far, I can store data from

My point to this message is when user enter in a description and that description is store in my MySQL. my field that stores the description is wrapping and makes the MySQL looks unattractive. is there a way to just make it flow into one line in MySQL instead of wrapping. I know that with a database such as ACCESS, it doesn't wrap, but keeps on going unless u expand the column.

This other question is unrelated, but can u make

and

be related...meaning, if u select any option from the <option> it will be transfer to an <input type="text"> I really do not want it to be a 'text' field where people can edit, but more like a label for them to see what they have selected.

thanks in advance...

sid

i honestly have no idea what you mean with the first part - but the second one is an easy javascript operation.

Hoangsta

i'll try to explain the first part.

say this is your page

Description about your instructor<br>
<textarea rows="8" cols="30" id="message" name="message">
</textarea>

</body>
</html>

You take the information from the message (description) and try to store that into your database via MySQL in a field name desc_instru. Let's say you typed in 400 characters in your description. Once the information is stored, your field "desc_instru" will wrap and make your database look very ugly. is there a way to not wrap it with MySQL? What I mean by wrapping is word wrap.

If you have a MySQL database, go in and edit a field. make it about 20 words, and see if it wraps into a second line. Try to do that when you have about 20,000 descriptions and your trying to maintain the database.

I just want to only see one line of description, if i want to see the rest of the description, i'll just hit "edit" on MySQL to see the rest. I do not want to see the whole description being display. Is it possible? I hope that you understand my point of view.

TheIceman5

edit the particular script in phpmyadmin that causes it. modify it to show only the first 20 or so characters

superwormy

Yeah... first of all, MySQL is just a database, you arn't actually viewing the records in MySQL, you're more than likely viewing them through phpMyAdmin, am I correct?

MySQL DOES NOT wrap lines automatically. Some program you are using is doing that for you. So you need to take that issue up with the program, not MySQL.

Hoangsta

you guys are right about phpMyAdmin. I am trying cause it to just show only the first line of data...are u guys familiar with it? if so, can u help me with it?

sid

Originally posted by Hoangsta
you guys are right about phpMyAdmin. I am trying cause it to just show only the first line of data...are u guys familiar with it? if so, can u help me with it?

no - cos phpmyadmin doesnt do that...

use 2 fields if you want to see the first line only in phpmyadmin so bad: field currenttext (or whatever its called right now) and field "firstline" which only holds the first line ($insertLine = explode("\n", $inserttext); INSERT INTO xxx (firstline) VALUES ($insertLine[0]))

superwormy

Actually sid... some versions of phpMyAdmin DO do this. Either edit phpMyAdmin to display as you'd like it to, or GET OVER IT!

It is actually storign the data correctly, it's just not showing it how you'd like it to show it.

Write your own program or edit phpMyAdmin if you can't deal with how it displays.

sid

really? well - the only thing i could think of is editing the value of how many characters of LONGTEXT are being displayed - but this will not equal the "first line" either.