Re: [PHP-DB] displaying info in a form

[Paul Burney]

on 3/29/02 10:54 AM, Natividad Castro at [EMAIL PROTECTED] appended the
following bits to my mbox:

> I'm trying to display data in a form, but for some reason I can display the
> entire value of every field that has more than two words in the text box.
> For example, if I want to display the name CASTRO TRUCKING, the text field
> only display the first word CASTRO.

> >

Just following up on what someone else said.  If the Name field has a quote
in it, such as <> that could also cause
problems.  

To remedy, do this:



HTH,

Paul Burney
http://burney.ws/





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] displaying info in a form

[biorn]

I have come across this before.  Make sure you put "" around the value field 
and then single quotes around the variable, ie.


> 
>  (NOTE: if this is an int 
value, you do not need to use the single quotes around $id)
> 
> 
> 
> 
> 
> 
> 


HTH

MB

Natividad Castro <[EMAIL PROTECTED]> said:

> Hi to all,
> I'm trying to display data in a form, but for some reason I can display the
> entire value of every field that has more than two words in the text box.
> For example, if I want to display the name CASTRO TRUCKING, the text field
> only display the first word CASTRO.
> 
> I tried to use the trim() function, but it didn't work.
> 
> Any idea?
> 
> Thanks in advanced.
> Nato
> 
> here is the code
> 
> 
> 
>  include "./connection.php";
> //include "./common_db.inc";
> //$link_id = db_connect('test_bia');
> 
> $result = mysql_query("SELECT * FROM test LIMIT 0, 1");
> 
> //while($query_data = mysql_fetch_array($result)) {
> 
> echo"";
> while($query_data = mysql_fetch_array($result)){
> 
> 
> 
>   $tracking_num = $query_data[0];
> 
>   $id = $query_data[1];
> 
>   $name = $query_data[2];
> 
>   $user = $query_data[3];
> 
>   $comment = $query_data[4];
> }
> ?>
> 
>  
> >
> 
> >
> 
> >
> 
> >
> 
> 
> >
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 



-- 




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php