hi, i selected everything from the table and the direct variable $cResult[3] would give me something like "street address with space as delimiter" ... however, when i tried to use it, it will give me only "street" instead of "street address with space as delimiter".
does anyone know how i can fix it so it will show the whole field?
thanks
<?php
require_once('auth.php');
require_once('config.php');
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link)
{
die('Failed to connect to server: ' . mysql_error());
}
//Select database
$db = mysql_select_db(DB_DATABASE);
if(!$db)
{
die("Unable to select database");
}
$cid = $_SESSION['SESS_CUSTOMER_ID'];
$qry="SELECT fname, lname, email, streetAddress,zip_id, passwd FROM customer WHERE customer_id='$cid'";
/////////////////// problem begin //////////////////////////////////
$cResult=mysql_fetch_array(mysql_query($qry));
$fn= "$cResult[0]";
$ln= "$cResult[1]";
$email= "$cResult[2]";
$street= "$cResult[3]"; //---> this will give me only part of the field (the first word basically)
///////////////// problem end ///////////////////////////////