You are here: varchar problem « All PHP « IT news, forums, messages
varchar problem

Posted by Terry on 06/18/05 04:24

I apparently do not correctly understand varchar - everything I have
read indicates that text entered into a MySQL table with varchar
characteristics will automatically have any space characters stripped
from both ends of the line.

while ($row=mysql_fetch_array($result,MYSQL_NUM)) {

echo "<img title=\"$row[3]\" alt=\"$row[3]\" src=\"images/$row[0]\"
height=\"$row[2]\" width=\"$row[1]\">\n";

The source code of the html shows filler spaces at the beginning of some
lines for the title/alt (which IE displays - grr). I first uploaded a
text file with a ; delimiter in a tabbed format - got spaces on all
tags. Next I uploaded a ; delimiter with no spaces - some have spaces,
most do not.

I did one file each time and erased the old stuff. All ideas welcomed.

--
TK
http://www.wejuggle2.com/
Still Having a Ball







..

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация