Ad:

PHP Discussion Thread
Marked Solved
Views: 490

Jul 24th, 2009

string variable question

Expand Post »

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 Syntax (Toggle Plain Text)
 
 
<?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 ///////////////////////////////

<?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 ///////////////////////////////

Similar Threads

how to enable/disable ToolStripMenuItem Name using String variable in VB.NET
setting a string as a variable name in Python
Convert string variable into form object in VB6 in Visual Basic 4 / 5 / 6
Double quotes inside string variable. e.g " my name is "jaikit" and what is " in ASP.NET
how to use a string variable in C++

k2k

Reputation Points: 15

Solved Threads: 1

Posting Whiz

Offline

351 posts
since Nov 2007

Permalink

Jul 24th, 2009

Re: string variable question

Try replacing the problem area with the following:

php Syntax (Toggle Plain Text)
$cResult=mysql_fetch_array(mysql_query($qry));
$fn=$cResult[0];
$ln=$cResult[1];
$email=$cResult[2];
$street=$cResult[3];
$cResult=mysql_fetch_array(mysql_query($qry));
$fn=$cResult[0];
$ln=$cResult[1];
$email=$cResult[2];
$street=$cResult[3];

cwarn23

Sponsor

Featured Poster

Reputation Points: 410

Solved Threads: 258

Occupation: Genius

Offline

3,004 posts
since Sep 2007

Permalink

Jul 24th, 2009

Re: string variable question

Click to Expand / Collapse Quote originally posted by cwarn23 ...

Try replacing the problem area with the following:
php Syntax (Toggle Plain Text)
$cResult=mysql_fetch_array(mysql_query($qry));
$fn=$cResult[0];
$ln=$cResult[1];
$email=$cResult[2];
$street=$cResult[3];
$cResult=mysql_fetch_array(mysql_query($qry)); $fn=$cResult[0]; $ln=$cResult[1]; $email=$cResult[2]; $street=$cResult[3];

i will try again later but i think i already tried that and didn't work.

k2k

Reputation Points: 15

Solved Threads: 1

Posting Whiz

Offline

351 posts
since Nov 2007

Permalink

Jul 24th, 2009

-1

Re: string variable question

Just a thought, is your 4th field (street) long enough to take the whole street name. Check in phpmyadmin or whatever you use to admin your db to see if the data in 'street' is complete.

If this ain't a problem, have you got any strange characters following the first word?

ardav

Sponsor

Featured Poster

Reputation Points: 1048

Solved Threads: 947

Sarcastic Poster

Offline

6,680 posts
since Oct 2006

Permalink

Jul 24th, 2009

Re: string variable question

Click to Expand / Collapse Quote originally posted by ardav ...

Just a thought, is your 4th field (street) long enough to take the whole street name. Check in phpmyadmin or whatever you use to admin your db to see if the data in 'street' is complete.

If this ain't a problem, have you got any strange characters following the first word?

nope, no strange characters. the field is long enough and the street i inserted "132 main street" was already stored in the table.

but it is weird that [code] echo "$cResult[3]" returns me only "132"

k2k

Reputation Points: 15

Solved Threads: 1

Posting Whiz

Offline

351 posts
since Nov 2007

Permalink

Jul 25th, 2009

Re: string variable question

Click to Expand / Collapse Quote originally posted by k2k ...

but it is weird that [code] echo "$cResult[3]" returns me only "132"

Perhaps it is an error in the part of the script that inserts into the table. Try using the mysql_real_escape_string() function to see if it escapes the spaces. And remember to put quotes around each string to be inserted. Below is an example:

php Syntax (Toggle Plain Text)
echo '`column`="'.mysql_real_escape_string('132 main street').'"';
mysql_query('INSERT INTO `table` SET `column`="132 main street"') or die(mysql_error());
echo '`column`="'.mysql_real_escape_string('132 main street').'"';
mysql_query('INSERT INTO `table` SET `column`="132 main street"') or die(mysql_error());

And check if the first line returns whats in the mysql query.

cwarn23

Sponsor

Featured Poster

Reputation Points: 410

Solved Threads: 258

Occupation: Genius

Offline

3,004 posts
since Sep 2007

Permalink

Jul 25th, 2009

Re: string variable question

still don't know why, but it magically works now with $street= $cResult[3]

and echo "$cResult[3]" return "132 main street"

..... thanks everyone tried to help.

k2k

Reputation Points: 15

Solved Threads: 1

Posting Whiz

Offline

351 posts
since Nov 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: ImageCreateFromPNG

Next Thread in PHP Forum Timeline: Free Open Source Software

DaniWeb Message

Cancel Changes

User Name
Password