Try echoing your query and pasting it into mysql to make sure that the
problem isn't in the structure of your query.
Your connect statement selects a db, right?
Ian
On Thu, 2004-03-25 at 14:01, Angelo Zanetti wrote:
> HI all I have a Select that get a resultset, once I get this then I use the
> values of this resultset to enter them into another table using an INSERT
> statement. I get no errors from the statement but it just doesn't seem to
> see my variables from the recordset,
>
> below is my code:
>
>
>
> $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'])";
> 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.
>
> any help will be appreciated, thanx in advance
>
> Angelo
>
> --------------------------------------------------------------------
> Disclaimer
> This e-mail transmission contains confidential information,
> which is the property of the sender.
> The information in this e-mail or attachments thereto is
> intended for the attention and use only of the addressee.
> Should you have received this e-mail in error, please delete
> and destroy it and any attachments thereto immediately.
> Under no circumstances will the Cape Technikon or the sender
> of this e-mail be liable to any party for any direct, indirect,
> special or other consequential damages for any use of this e-mail.
> For the detailed e-mail disclaimer please refer to
> http://www.ctech.ac.za/polic or call +27 (0)21 460 3911
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
