mysql_fetch_array weird results

[treyhunsucker]

Hello,

This is a piece of code from my script:

$result = mysql_query("SELECT complete.a2, dn_records.number FROM complete, dn_records WHERE complete.c3=dn_records.number AND dn_records.number='$data1'")
or die(mysql_error());

while($row = mysql_fetch_array( $result )) {
    echo $row[0];
    echo "<input type=text name=clec_customer value=" . $row[0] . ">";
}

The problem is that "echo $row[0]" echos "119 N Broadway" and the same thing inside the text box echos "119"

$row[0] echos the a2 information, I also switched everything from $row[0] to $row[a2] and had the same results.

Any Ideas?

 

[vacunita]

This is a PHP question not a mysql one, but, the problem you are having is neither.

The problem you are having is that values for text boxes need to be surrounded in quotes be it single or double, otherwise the value is taken up to the first space. Whatever follows the space is considered a new attribute for the text box declaration, so try to do this:

 echo "<input type=text name=clec_customer value=[red]'[/red]" . $row[0] . "[red]'[/red]>";

I added a single quote before and after the value.


----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[treyhunsucker]

that worked, thank you

 

[vacunita]

You are welcome.

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[treyhunsucker]

Hello,

In another instance I tried:

echo "<a href=update4.php?data='" . $row[0] . "'>Test Link</a>";

But again it didn't echo anything after the space

 

[treyhunsucker]

another example of what I've tried:

echo "<a href=update3.php?data=" . "{$row["0"]}" . ">Test Link</a>";

$row["0"] is this: Link Test

In the example above, only "Link" prints, instead of "Link Test

 

[treyhunsucker]

I got it

echo "<a href=\"" . htmlspecialchars("update3.php?data=" . urlencode($row[a2])) . "\"><b>Info</b>\n";

In the Example where a2 = Link Test it shows "Link+Test" which worked just fine

I found the info on this page:

http://www.mcs.vuw.ac.nz/technical/software/PHP/faq.html.html