Ad:

PHP Discussion Thread
Unsolved
Views: 769

Mar 21st, 2008

HELP!!!

Expand Post »

HI
CAN ANYONE SEE Y THIS IS ECHOING OUT TWICE THE AMOUNTS OF EACH FIELD IN MY DATABASE???

PHP Syntax (Toggle Plain Text)
<?php
$count = 0;
$data = array();
 
$query = "SELECT * FROM profile WHERE ID = '1' ";
$result = MYSQL_QUERY($query);
$line = mysql_fetch_array($result);
 
foreach ($line as $col_value) {
 $data[$count] = $col_value;
 echo $data[$count];
		   $count++ ;
};
<?php
$count = 0;
$data = array();

$query = "SELECT * FROM profile WHERE ID = '1' ";
$result = MYSQL_QUERY($query);
$line = mysql_fetch_array($result);

foreach ($line as $col_value) {
 $data[$count] = $col_value;
 echo $data[$count];
		   $count++ ;
};

MUCH APPRECIATED

Last edited by peter_budo; Mar 22nd, 2008 at 5:48 pm. Reason: Keep It Organized - please use [code] tags

Designer_101

Reputation Points: 12

Solved Threads: 16

Posting Whiz

Offline

314 posts
since Jul 2007

Permalink

Mar 22nd, 2008

Re: HELP!!!

hmmm,
first off, I don't know why your code isn't throwing an error to begin with.
you have an extra ";" at the end there... once you end a function } you don't need to use a ;

I think your problem might be the $count++ but I can't be 100 p on that.
also put a . before the = in your foreach statement and I think that does what you are trying to do.

PHP Syntax (Toggle Plain Text)
$query = "SELECT * FROM profile WHERE ID = '1' ";
$result = MYSQL_QUERY($query);
$line = mysql_fetch_array($result);
 
foreach ($line as $col_value) {
$data[$count] .= $col_value;
echo $data[$count];
}
$query = "SELECT * FROM profile WHERE ID = '1' ";
$result = MYSQL_QUERY($query);
$line = mysql_fetch_array($result);

foreach ($line as $col_value) {
$data[$count] .= $col_value;
echo $data[$count];
}

Sage

sagedavis

Reputation Points: 10

Solved Threads: 6

Junior Poster in Training

Offline

86 posts
since Nov 2007

Permalink

Mar 22nd, 2008

Re: HELP!!!

hey
thanks for the advise
but i tried using a different variable names and it worked perfectly, maybe a reserved word in php or something.

Yeh anyways much appreciated ;D

thanks

Designer_101

Reputation Points: 12

Solved Threads: 16

Posting Whiz

Offline

314 posts
since Jul 2007

Permalink

Mar 22nd, 2008

Re: HELP!!!

oh, duh,
was it "count" that was the reserved word?
sage

sagedavis

Reputation Points: 10

Solved Threads: 6

Junior Poster in Training

Offline

86 posts
since Nov 2007

Permalink

Mar 23rd, 2008

Re: HELP!!!

count is not a reserved word AFAIK. hmmm..

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

Mar 23rd, 2008

Re: HELP!!!

intresting ?
Anyway

like i said thanks

Designer_101

Reputation Points: 12

Solved Threads: 16

Posting Whiz

Offline

314 posts
since Jul 2007

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: adding name 2login

Next Thread in PHP Forum Timeline: PHP-MySQL connection error

DaniWeb Message

Cancel Changes

User Name
Password