Folks,
I have a table in a Mysql DB that has a bunch of fields. One of those
fields "dbdesc" is a text column type that contains the string "This is a
testdb". Below is the output from doing a select * from that table using
the mysql binary (truncated for brevity).
| dbname | dbdesc | dbsid | and on and on ...
+---------+------------------+-------+
| test1db | This is a testdb | test1 | and on and on ...
I am trying to retrieve all the columns from a specific row using the
code below.
connect_to_mysql_db();
$sth = $dbh->prepare
("SELECT dbname, dbdesc, dbsid, dbport, dbhostname, dborahome,
dborabase, dbsqluser, dbsqlpass, dbhostuser, dbhostpass FROM
dbinfo WHERE dbsid=\"$sidloc\"");
$sth->execute ();
my @val = $sth->fetchrow_array ();
$sth->finish ();
disconnect_mysql_db();
This works great.. I get all my data out of the database
BUT when I go to print out the "dbdesc" column I only
get the word "This" in $val[1]. It should be printing out the
entire sentance contained in that entry "This is a testdb"
print "Database Description: <input type=text maxlength=300 size=50
name=desc value=$val[1] ><br>\r\n";
Why does $val[1] only contain "This" and not "This is a testdb"?
Any idea where I am going wrong?
Thanks,
Mike
