reading data and passing to array

[osusano]

hello there i have 2 DB and the DB1 have the data i need to read and parse it so that i can insert the info to my DB2 and from parsnig the result should be passed to DB1.

sample:

$sql = "select * from inbox where recId='1'";
$makeQuery = new queryRecord( $sql );
$res = mysql_query ($makeQuery->sqlQry);
while ( list ( $var1, $var2, $var3, $var4, $var5, $var6 ) = mysql_fetch_row($res) ){
$record = $var1.'|'.$var2.'|'.$var3.'|'.$var4.'|'.$var5.'|'.$var6; // to assign each field separated by pipe sign
$addRecord .= $record.', '; // to assign per row separated by comma
}
$recordArray = ( $addRecord );

print count($recordArray);

this will just give me 1 record. dont know why?

can somebody help me with this or tell me whats the best query should i do?

thank you in advance

[osusano]

forget it..

i think i already figure out whats wrong ..

i never assigned the variable as array 🙂

[swr]

You have "where recId='1'" in the select statement. Does that select only 1 row? Remove the where clause if you want to get all rows.

Consider [man]implode[/man] for joining the records together. It's simpler than splitting an array into a list and concatenating them like you are doing.

Also, if you're joining the things into a single string for insert into another DB, keep in mind that having multiple items in a single field is usually bad DB design. Google for "database normalization" for info on how to do things right.