Hello!,
im not that new with regards to php and mysql but its been a while since my last program that i was developed!...heheheheh
Newei i have a problem here:
my problem is that I tried to combine the values of field 1 and field 2 from table 1 and put the new value to my option list or drop down list.I was able to get the new value and put it on my drop down list but here a new problem,I want to save the new value (field1 field2) to another table but the problem is only values from field1 was being save to the other table...
i have here the code,could u try to check it out for me...thanks!
require_once("../../db_fns.php");
$sql = "select from users order by 'Fname' limit 0 , 30 ";
$sql1 = "select from users order by 'Lname' limit 0 , 30 ";
// execute the query and put results in $result
$result = mysql_query( $sql ) or die ( "unable to execute query." );
$result1 = mysql_query( $sql1 ) or die ( "unable to execute query." );
$num_rows=mysql_num_rows( $result );
$num_rows1=mysql_num_rows( $result1 );
while ( $a_row = mysql_fetch_row($result))
while ( $a_row = mysql_fetch_row($result1))
{
echo "<option value=""/.$a_row[1]." ".$a_row[1]./"">;
echo $a_row[1]." ".$a_row[2]."</option>\n";
}
hope you can help me with this one....
