next »

[Nieeru]

Hey there! Quite new to these forums.

I'm working on a script that fetches data from an external XML and stores it into a database.

What I want to achieve is to have set variables outside the loop defining 10 instances of classId as true, then loop the returned MySQL results and set unpopulated classId's as false.

I know that I can use if(count($data['classId'] == 1) < 1) whthin a foreach loop. But I can't use this kind of logic within a while loop from MySQL. I want to avoid having to create seperate queries for every instance of classId if possible.

I can't really find a solution to the problem either, so, I'm hoping that some of you guys can point me in the right direction.

Cheers,
- Nieeru

[Phaëton]

How about using a stored procedure with a cursor and a handler?

example:

Code:

PROCEDURE movePW()
BEGIN
   declare thisID, thisPass varchar(64);
   declare keepGoing tinyint;
   declare original cursor for select id, user_pass from user1;
   declare continue handler for not found set keepGoing = 0;
   set keepGoing = 1;
   open original;
   fetch original into thisID, thisPass;
   while keepGoing = 1 do
      update wp_users set user_pass=thisPass where id=thisID;
      fetch original into thisID, thisPass;
      end if;
      fetch items into thisID;
   end while;
END

[perkiset]

Nice Phae - am I to assume that code was built and tested using that bitchin phpMyIDE package?

(I'll comment on the first post in a bit, walking into a meeting ATM)

[Phaëton]

If you dont mind it Keepgoing forever... LOL

[Phaëton]

Yes, i have used phpMyide its awesome.... that code was actually not tested ... its rife with a few major issues but demonstrates the power of stored procedures, cursors and handlers to 'iterate' and 'test' completely on the Mysql server... good stuff!

theres a 'end if' where ther is no 'if' and it will keepgoing forever , assuming it doesnt error on the 'end if' with no 'if' first