Using Arrays!

bjblackmore

I was wondering if anyone might be able to help!
I want to let users select an option, and if they select 1 particular option, the database is searched and the results are then entered into a table. So far I have got it to insert the 1st result, but if there are more that 1, I can't get it to work.
They can either select Yes or No. If they select No, then no is entered into the database, but if they select Yes the following code is run.

'if ($value == Yes) {
$sql="SELECT values FROM table WHERE userid='$userid'";
$result=mysql_query($sql);
while($row=mysql_fetch_array($result)){
$value = $row['values'];
};
}
else....'

I know I am resetting the value of $value, this is because at the end of this script, I insert $value into the database. Which is either 'No' or the results in the array.
If someone could provide some help, it would be most appreciated.
Brian

Anon

I think you need to disclose a bit more of your code.... you talk about a select that works and an insert that doesn't.... but the code you've posted shows the select but not the insert...

This makes it very difficult to be of help

🙂

bjblackmore

Sorry, i've been thinking about this, and all I want to do is..
if the $value = Yes, select all the values from the table for that user, and then assign them to $value (over writting the Yes value, with the results of the query).

I have a piece of code after that, which inserts $value into a table, this works for $value = No, as its just 1 value, however if $value = Yes it needs to insert the multiple values!

Am I making sense? Probably not. Below is my current code, that doesn't actually work.
Any help you can provide is greatly appreciated.
Brian

'if ($value == Yes) {
$query = "SELECT values FROM table WHERE userid='$userid'";
$result = mysql_query($query);
while($row = mysql_fetch_array($result));
$value = $row['values'];
}'

Anon

Aha I see (I think)

Would suggest that $value is an array regardless of number of entries

then on condition = "no" you only have
$value[0]

but when there's more you can have
$value[0], value[1]

then you can do a count($value) to get number of items to insert and while loop through them....

does that help??

Anon

I might see what you're trying to do there.

Is there any point to having an array?

First make a page like this:
<form action=blah.php method=post>
<input type=select name=value>
<option value=yes>Yes</option>
<option value=no>No</option>
</select>
<input type=submit value="Make your choice">

And then on the next page you'll have:
if ($value == "yes") {
//do this
}

if ($value == "no) {
//do this
}

(Don't use elseif because that might cause some problems with nasty user input.

Anon

Ooops I misunderstood

Do this:
(I assume you want to get the choices from the database and then let the user make the selection)

echo("<form action=blah.php method=post> ");
echo("<input type=select name=value> ");

$sql="SELECT values FROM table WHERE userid='$userid'";
$result=mysql_query($sql);
while($row=mysql_fetch_array($result)){
$value = $row['values'];
echo("<option value ="."$value".">"."$value"."</option");
}
echo("</select>")

and blah.php should look like this:

if ($value == "yes") {
//do this
}

if ($value == "no) {
//do this
}

bjblackmore

Yeah, i have the code for the select menu, that pulls the values out, and displays them. But what I need is for it to pull them all out, when 'Yes' is selected. And then insert all the values. I could do...

if ($value == "yes") {
//do this
}

if ($value == "no") {
//do this
}

however however the code for "no" is very long, and it would be almost identical for "yes". It consists of lots of if statements, and updates currents records, if they exist, and checks for certain stuff, it would be pointless to duplicate it. Much easier to simply assign the $value a different value before inserting/updating/checking with it.
If there was someway so $value could contain all the values assigned to that userid, and then insert then as separate records it would be much easier.
i.e.

no = 'no'
insert 'no' into table

yes = 'a'
'b'
'c'
insert 'a' into table
insert 'b' into table
insert 'c' into table

Cheers
Brian

Anon

Can you not make the code for "no" into a function and then do

if (function()) {
//do this
}

Anon

addendum to last post

If the answer to this is "no because I'd have to pass loads of variables to the function then write a class that returns a 1 on success (i.e. "no" is correct) or a 0 on fail, set the data slots first then do the test....

i.e.

$codeforno=new myclass();
$codeforno->dataslot1 = value;
blah, blah.......
if($codeforno->functioninclassthatdoesthetest()) {
// do stuff
}

bjblackmore

I dunno, thats sounds kinda complex! I'm sure i'm almost there, what you said in your 1st post sounded promising! Do you have any example code? I've got it to pull the info out of the other table i think, but it only adds the 1st (or it might be last) record, it either doesn't store all the values, or it doesn't cycle through and add them all.
Cheers
Brian

rsterbin

Brian Smith wrote:

no = 'no'
insert 'no' into table

yes = 'a'
'b'
'c'
insert 'a' into table
insert 'b' into table

insert 'c' into table

I'd have to see the code you're using to assign "yes"/"a,b,c" or "no" to $value to be sure, but assuming $value ends up holding either Array("no") or Array("a", "b", "c"), you could do something like:

foreach($value as $val){

do some stuff where "no" or

"a" or "b" or "c" all work

the same way.

}

or,

for ($i=0; $i<count($value); $i++){

do some stuff with $value[$i].

}

Hope this helps,

Reha