2. PHPRunner General questions
  3. [SOLVED]  SQL queries
This topic is locked
[SOLVED]

 SQL queries

 		8/27/2012 6:24:50 PM
PHPRunner General questions
W
 wildwally author

Looking for some help to query one db and transfer the results to another db both on the same server - just different user/creditials.
I'm trying to use a Insert into Select query
C
 		cgphp 8/27/2012

Check this thread: http://www.asprunner.com/forums/topic/16088-insert-data-in-another-data-base/
W
 		wildwally author 8/28/2012

OK, I got this to work; however, I'm not seeing anything entered into my database. Is it possible to conduct a custom query in one database and use the while to insert each row into my main database?
while($row = mssql_fetch_array($result))

{

INSERT QUERY HERE

}
C
 		cgphp 8/28/2012

Post your whole code.
W
 		wildwally author 8/28/2012



Post your whole code.


Thanks - I found what I was doing wrong - calling the wrong connection on the insert command.