varchar problem
- From: Terry <tknospa@xxxxxxxxxxxxx>
- Date: Fri, 17 Jun 2005 20:24:19 -0500
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 =---- .
- Follow-Ups:
- Re: varchar problem
- From: Geoff Berrow
- Re: varchar problem
- Prev by Date: Need variable help
- Next by Date: executing PHP code from db?
- Previous by thread: Need variable help
- Next by thread: Re: varchar problem
- Index(es):