RE: MSSQL 7.0 and PHP
| From: | Carlos Andre Marques Moreira | Date: | Wed, 24 Oct 2001 12:18:35 +0000 |
| Subject: | RE: MSSQL 7.0 and PHP | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-9988@lists.php.net to get a copy of this message | ||
I've seen this problem here before. Some guys posted this is a problem in
the mssql.dll, don't know if this has been fixed.
I had this problem here before, and i "fixed" it changing data type to TEXT
Carlos André
-----Original Message-----
From: Franco Breciano [mailto:fbrecia@fi.uba.ar]
Sent: quarta-feira, 24 de outubro de 2001 00:02
To: php-windows@lists.php.net
Subject: MSSQL 7.0 and PHP
I'm using php to retrieve a Query from a SQLServer 7.0 database.
My code is this one:
$base = mssql_select_db($db,$conexion);
$sql="SELECT MarcasSolicitante FROM Marcas";
$result = mssql_query($sql,$conexion);
while ($myrow = mssql_fetch_array($result))
{
$mensaje= $myrow["MarcasSolicitante"];
?>
<p><strong><font size="4"><u>Mensaje:</u></strong>
   </u> <font
size="3"><?echo $mensaje;?> </font></a></P>
<hr>
<....>
<....>
The problem is that the field MarcasSolicitante in the database is
VarChar(7000), and php receives a Char(255), what I'm I doing wrong? Isi
there any parameter I can modify in order to retrieve correctly the fields??
Thanks in advance