Hi,
For modifications, I have to extract data from one table and insert it in another one, after this I have to get the new id from the second table and place it in the first table.
More or less, it should be so:
For every record loop
select law_item from table_one;
insert law_item into table_two;
insert into table one(law_id) values(table_two_sequence.currval);
End loop;
I saw (and I tried) many thing on Internet... (as type, bulk collect...) but did not succeeded in it.
Does anybody have a solution ?
Thank you in advance
Help with looping
I have a comma separated list of colors taken from a database ($ICo) and a directory of images named "color". The images are named the "color.jpg"I am attempting to loop through
PHP template help
Ok, I don't know if anyone can help me but I am using PHP templates to make a site. I am a newbie and so I am finding this quite difficult so I thought I would ask some folks much better than me. I
MYSQL gen help
This is my Mysql gen. can anyone tell me why this echosMID(networkset.networkid, 3, 3) AS "MNC" SELECT FROM scan JOIN gps ON scan.gpsid = gps.gpsid JOIN gsmscanset ON scan.scanid =
weeks in a year
hi,i found this snippet on php.netQuoteFor the week number for weeks starting on Sunday:<?phpfunction week_of_year($month, $day, $year) {$day_of_year = date('z', mktime(0, 0, 0, $month, $day,
Need help: how to catch acess of undefined class properties
Hello. I am learning OO with PHP and have hit a problem.Some code runs as perfectly valid code, where i would like PHP to issue a warning / error.I guess this is because of the loose typing of PHP,
Comma seperated implode & modifying returned string.
I have a PHP post form that posts up to 4 variables. I need whatever variables are passed to be combined into one comma seperated string (eg variable1,variable2,variable3,variable4). This i can do
Confused with Loop
guys, i got confused with Looping...this is the caseI have 3 stocks, let say "Stock A", "Stock B", "Stock C" and the owner of each stock A --> Mr.Jamesstock B
Taxonomy? Classification? Categorisation?
Not sure if there is a way around this classification problem
How to search for several parameters from objects in a database?
I have a database with lots of information about objects.Now I would like to search for 4 or 5 parameters at the same time (from a form) like this:I choose from a select-box one parameter and then
Time script, set to my time zone?
I am using this line to get the date and timeCode: $time = date(F." ".d.", ".Y." ".g.":".i.":".sa,time());How could I change this to my time zone here
