On Thu, Jan 30, 2003 at 11:40:06AM -0500, Anna Noel Leavitt wrote:
>
> > Hello all-
> > I am using MySql, php and forms in HTML to update information. When I
> select results from column type VARCHAR, if the information stored
> > in the column has a space in it (for example, Tampa Bay), it will only
> > return Tampa (I have the length set at 30 so it is not a length issue).
> > I tried changing the column type to text to no avail. I
> > searched the documentation and couldn't figure it out. Can someone
> > provide some insight for me?
Hello Anna,
It sounds like the data is getting truncated before it reaches MySQL
or after it is selected and displayed.
Try echoing out the query that you are sending to MySQL using PHP.
Does the query look well-formed and complete? If not, then it is
likely a problem in the PHP code.
If the query seems fine, then try selecting the data directly
using the MySQL command line client? i.e.
mysql -uuser -p -e"SELECT col FROM table WHERE col like 'Tampa';"
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
Managing MySQL
MySQL Training: Washington DC, March 19-21, 2003
Visit http://mysql.com/training for more information
GreenPeace: Raising Environmental Awareness (http://greenpeace.org)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
