[RESOLVED] array issues

[rbblue8]

Hey,

according to php.net a good way to put things into an array is as follows.

$i=array(1, 2, 3, 4);

now keeping with that respect....

I'm looking to do a "last viewed page" setup. Where all the user names are stored in a sql row in the forum of user1, user2, user3, user4, user5.

so! when i pull it of the mysql table and pop it into an aray it will look like php.net example!

//from above
$i=array(1, 2, 3, 4)

//from my code
echo $result['last_viewed'];
//out put
user1, user2, user3, user4, user5

so i then should be able to do the following!

$i=array($result['last_viewed']);

right??

my end goal would be to seperate each value @ the , and give each value a number. where i would then advance each value by one, replace the last value with the current user, put it back the form of user1, user2, user3, user4, user5 and put it back in to the mysql table.(with a little error checking to be sure it's not the same user over and over again).

so i have this

	//get the current list of 5 :)
	$g_lv_string=("SELECT last_view FROM profile WHERE username='$view_user'");
	$g_lv_query=mysql_query($g_lv_string, $db) or $error='<center id="error">Error while getting the last 5 from the database <br />'.mysql_error().'</center>';
	$g_lv_result=mysql_fetch_assoc($g_lv_query);

$my_array =array($g_lv_result['last_view']);

if(is_array($my_array))echo 'yes';

for($c='0'; isset($my_array[$c]); $c++)
	{
	echo $my_array[0];
	}

basically along the same thinking from php.net

//from php.net
<?php
$arr = array(1, 2, 3, 4);
foreach ($arr as &$value) {
   $value = $value * 2;
}
// $arr is now array(2, 4, 6, 8)
?> 

[rbblue8]

LOL..

i fixed it.. I guess I had to think a little.

wow...

	//get the current list of 5 :)
	$g_lv_string=("SELECT last_view FROM profile WHERE username='$view_user'");
	$g_lv_query=mysql_query($g_lv_string, $db) or $error='<center id="error">Error while getting the last 5 from the database <br />'.mysql_error().'</center>';
	$g_lv_result=mysql_fetch_assoc($g_lv_query);


$str = $g_lv_result['last_view'];
$chars = preg_split('/,/', $str, -1, PREG_SPLIT_NO_EMPTY);

//add one to the count :0
$user0=$user;
$user1=$chars[0];
$user2=$chars[1];
$user3=$chars[2];
$user4=$chars[3];


$string1=$user0.', '.$user1.', '.$user2.', '.$user3.', '.$user4;
    $string=("UPDATE profile SET last_view='$string1' WHERE username='$view_user'");
    $query=mysql_query($string, $db);

[jdorsch]

// Make an array
$x = array( 1, 2, 3, 4 ) ;

$string = "1, 2, 3, 4" ;

// This doesn't do the same as the $x array
$y = array( $string ) ;

print_r($y) // prints array( [0] => "1, 2, 3, 4" ) ;

From your post I assumet that you are storing last_viewed as a comma delimited list of 5 items (this is not good database design btw).

If so then as in my example this is what you want

// This won't work
$i = array( $result['last_viewed'] ) ;

// Split the string result into an array delimited by commas
$i = explode( ',', $result['last_viewed'] ;

Then you are talking about replacing each user with a number and incrementing them, you lost me there.

[rbblue8]

jdorsch wrote:

// Make an array
$x = array( 1, 2, 3, 4 ) ;

$string = "1, 2, 3, 4" ;

// This doesn't do the same as the $x array
$y = array( $string ) ;

print_r($y) // prints array( [0] => "1, 2, 3, 4" ) ;

From your post I assumet that you are storing last_viewed as a comma delimited list of 5 items (this is not good database design btw).

If so then as in my example this is what you want

// This won't work
$i = array( $result['last_viewed'] ) ;

// Split the string result into an array delimited by commas
$i = explode( ',', $result['last_viewed'] ;

Then you are talking about replacing each user with a number and incrementing them, you lost me there.

what would be a good db design??

[Weedpacket]

rbblue8 wrote:

what would be a good db design??

Basically, you want to search for the phrase "database normalization", and create another table to put the things that you're separating by commas into their own rows.

[rbblue8]

ah.. i was going to go that way... b/c it would have made things a little more "easy". But i figured that it was not the norm.

lol....

so it is ok to have a row for each pice of data?? i bet that makes some db's huge w/ rows.