RE: [PHP] MSSQL 7.0 and PHP

[Nick Richardson]

my understanding (and i could be totally wrong) is varchar only accepts
values up to 255 (so does char).  To get larger than that you have to use
'text' (i.e. create table <name> (<column> text not null......);

-----Original Message-----
From: Franco Breciano [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 7:59 PM
To: [EMAIL PROTECTED]
Subject: [PHP] 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> &nbsp &nbsp</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



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]