String Problem with DBMS

AIX5L · Dec 31, 2003

Hi my Problem is, that my query Result in Database ex: ( This is a Test ) will only be diplayed in my HTML Code as "This" and where is the rest ?
Can anybody help me to understand my Problem ?

thanks

$query = "SELECT T2.TITEL,T2.SUCHTEXT,T2.BILDTEXT,T2.AUFNAHMEORT,T2.AUFNAHMEDATUM,T4.LAGERORT,T3.FIRMA,T2.IMAGE_ID FROM

http://WWW.IMAGE

T2,

http://WWW.KUNDE

T3,

http://WWW.IMAGE_DATA

T4 WHERE T2.KDNR = T3.KDNR AND T2.IMAGE_ID=$BILDERSUCHE";

$value = odbc_exec( $connect, $query );

while(odbc_fetch_row($value))
{

$TITEL = odbc_result($value,1);
$SUCHTEXT = odbc_result($value, 2);
$SUCHTEXT = strval($SUCHTEXT);
$BILDTEXT = odbc_result($value, 3);
$AUFNAHMEORT = odbc_result($value, 4);
$AUFNAHMEDATUM = odbc_result($value, 5);
$LAGERORT = odbc_result($value, 6);
$FIRMA = odbc_result($value, 7);
$DATAFILE = odbc_result($value, 8);
$PREVIEW="$DATAFILE.jpg";

echo "<table width=97% align=center border=0>";
echo "<tr><td>";
echo "<table width=100% align=center border=0>";
echo "<tr><td>";
echo "<tr><td width=30% valign=left><img width=91% border=2 src=temp/$PREVIEW align=top></td>";
echo "<td width=70% rowspan=3 colspan=2><textarea rows=13 name=BILDTEXT VALUE=$BILDTEXT  cols=71></textarea></td></tr>";
echo "<tr><td width=30%><a1><input type=text name=TITEL VALUE=$TITEL  size=30%></a1>";
echo "<tr><td width=30%><a1>Bildtitel</a1></td></tr>";
echo "<tr><td width=30%> </td><td colspan=2 width=70%><a1>Beschreibungstext zum Bild</a1></td></tr>";
echo "<tr><td width=30%><a1><input type=text name=AUFNAHMEORT VALUE=$AUFNAHMEORT&nbsp size=30%></a1></td>";
echo "<td width=30%><a1><input type=text name=AUFNAHMEDATUM value=$AUFNAHMEDATUM  size=30%></a1></td>";
echo "<td width=40%><a1><input type=text name=SUCHTEXT value=$SUCHTEXT  size=40%></a1></td></tr>";

echo "<tr><td width=30%><a1>Aufnahmeort</a1></td><td width=30%><a1>Aufnahmedatum (dd/mm/yyyy)</a1></td>";
echo "<td width=30%><a1>Suchtext</a1></td></tr>";
}

sleipnir214 · Dec 31, 2003

Could you post a simpler code sample which demonstrates the problem?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

sleipnir214 · Dec 31, 2003

Also, post your code inside [ignore]

Code:

...

[/ignore] TGML tags. The Tek-Tips TGML engine did strange things to your original post.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

AIX5L · Jan 1, 2004

Hi

I found the Solution for my Problem

To Display in HTML TD i used '$VALUE' instead of $VALUE and it works.
After this to submit the form i remove the blanks with rtrim, because the $VALUE is 48 Characters long ( As the DB field ).

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

String Problem with DBMS

AIX5L

Technical User

sleipnir214

Programmer

sleipnir214

Programmer

AIX5L

Technical User

Similar threads

Part and Inventory Search

Sponsor