Don't know where to start...

The_Chancer

I think I know what I want to happen, but whether or not it is possible is another matter.

I have a database with entries (suprisingly), and in one of the columns it has a list of names, split by \n. What I am looking to do is to get the names out and into an array. Am I right in thinking that explode would do the trick for this ?

Now, after I have done that for the first record in the "SELECT" sql array, I move onto the second.

If this record has the same name as one already in the array, I need it to be ignored, and only different ones put onto the end of the array. This is the bit I can't get the hang of though... and have no idea where to start. So any ideas would go down a treat.

Thanks,

aSa

[man]array_unique[/man]

😉

gtibok

hello

It's realy complicated what u are doing. Why don't you use the easy way :
create a field named "names" and insert a new record for eatch name!

herve

Hi,

yes explode() will do the stuff you need.

In the loop (where you work with the results of
the SELECT command)

1) fill a new array with explode()

2) for each of the element of this array

2 bis) check to see if the name is not 
       already in a 2nd array

2 ter) if not, then add it to the 2nd array

3) loop for the next result of the SELECT command

step 2 bis) can be done like this

function verify_name($name)
{
global $second_array;

$found=0;

for $i=0 to $max_index
{
if ($second_array[$i] == $name)
{
$found = 1;
}
}

return ($found)
}

$max_index is the maximum number of names
in the 2nd array ; it need to be incremented
each time you add a new name to the 2nd array
(case 2 ter)

We can do more efficient things, but this
one is easy to understand/begin with.

Regards,
Hervé.

The_Chancer

Sorry, I went away and looked at array_unique... so....

$query=do_query("SELECT * FROM enquiry WHERE agtco_name='".addslashes($result['company'])."'");
$array=array();
while($hotelvar = mssql_fetch_array($query))
{
$newarray = explode("\n",$hotelvar['hotel_var']);
array_push($array, $newarray);
$array = array_values(array_unique($array));
}

Might also do the trick ?

herve

Hi,

well frankly, I don't know, but it's so simple
that way ... just try it 🙂 ! And if it does not
work then, go back to my solution.

You know, like every coder in the world, the
less I can work ... 🙂))

Hervé.

The_Chancer

Very odd - seems to work, yet when I do

$var=implode("\n",$array);
echo $var;

It says simply Array...

But I had split it via implode hadn't I ?

herve

Is the content or $array OK ? (I mean, it's
not an empty array for instance ?)

The_Chancer

I set the array first by $array=array();
Then run the query and push the $newarray on the end of it - so it shouldn't be an empty array.

Although trying echo $array[0]; also gives Array - which would lead me to believe it is...

Urm - it is not empty, but every value in the array is "ARRAY"... odd, something has gone wrong somewhere...

herve

My advice : double check everything (by printing
them on screen), the $newarray value, etc.
you will find the culprit 🙂 !

The_Chancer

One step ahead of you.. done it already....

$newarray = OK
$array = array

So... from the code below:

$array=array();
while($hotelvar = mssql_fetch_array($query))
{
	$newarray = explode("\n",$hotelvar["hotel_var"]);
	print("0: $newarray[0]");
	array_push($array, $newarray);
	print(" 1: $array[0]");
}

The error must lie in the array_push line.... but I am buggered if I can see it...

herve

Well, I'm not sure, but I haven't read
in PHP manual that the second parameter of
array_push() can be an array.

The first one is, of course, but the second one
or followers are supposed to be "simple" var,
not array themself (?)

So if that's the pb, you just need to add a loop
using array_push() for each element of $newarray

The_Chancer

Ahhh now what would I do without the forum...

$array=array();
while($hotelvar = mssql_fetch_array($query))
{
	$newarray = explode("\n",$hotelvar["hotel_var"]);
	foreach($newarray as $item)
	{
		array_push($array, $item); //add variable to array
	}
}
$array = array_values(array_unique($array)); //resort array
$maxcount=count($array);
$i=0;
while($i!=$maxcount)
{
	echo "$array[$i]<br>");
	$i++;
}

Now works a treat.

:-) I can retire a happy man for the day.