Re: values from string query

Angelo Zanetti wrote:

[snip...] $q="select * from prospects where p_id = '$p_id'"; $result=mysql_query($q, $this->link) or die ("".mysql_error()); while($a_row=mysql_fetch_array($result)) { $c_query="Insert into client (c_name, c_company, c_worktel, c_directtel, c_hometel, c_fax, c_cell, c_email, c_address, c_city, c_pcode, c_country) VALUES ($a_row['p_name'], $a_row['p_company'], $a_row['p_worktel'], $a_row['p_directtel'], $a_row['p_hometel'], $a_row['p_fax'], $a_row['p_cell'], $a_row['c_email'], $a_row['c_address'], $a_row['c_city'], $a_row['c_pcode'], $a_row['c_country'])"; Should you use $a_row->[0], $a_row->[1] ... to refer to each individual value, since $a_row is a reference to an array?

mysql_query($c_query,$this->link) or die ("".mysql_error()); } I echo'd out the values from the Select just to make sure it was getting the correct values. How have you done that?

Best Bao

any help will be appreciated, thanx in advance Angelo --------------------------------------------------------------------