DaniWeb Forum Index > Web Development > PHP

HELP!!!

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jul 2007

Posts: 258

Reputation: Designer_101 is an unknown quantity at this point

Solved Threads: 12

Designer_101 Designer_101 is offline

Offline

Posting Whiz in Training

HELP!!!

Mar 21st, 2008

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

 Help with Code Tags 
 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

•

Join Date: Nov 2007

Posts: 86

Reputation: sagedavis is an unknown quantity at this point

Solved Threads: 6

sagedavis

Offline

Junior Poster in Training

Re: HELP!!!

Mar 22nd, 2008

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.

 Help with Code Tags 
 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

•

Join Date: Jul 2007

Posts: 258

Reputation: Designer_101 is an unknown quantity at this point

Solved Threads: 12

Designer_101 Designer_101 is offline

Offline

Posting Whiz in Training

Re: HELP!!!

Mar 22nd, 2008

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