[PHP] List problem again...

2013-08-09 Thread Karl-Arne Gjersøyen
In my HTML5/PHP form I have this two rows.. trtd align=left valign=top0082/tdtd align=left valign=topExan E/tdtd align=left valign=topLEXE25NO/tdtd align=left valign=top200/td td align=center valign=topinput type=hidden name=leverandor value=Oricainput type=hidden

[PHP] Ambiguous?

2013-08-09 Thread Karl-Arne Gjersøyen
1) query foreach($varenr_inn_pa_lager as $vnr){ include('../../tilkobling.php'); $sql = SELECT * FROM exan,dynamit WHERE varenr = '$vnr' LIMIT 1; $resultat = mysql_query($sql, $tilkobling) or die(mysql_error()); 2) Result: Column 'varenr' in where clause is

[PHP] Operand error...

2013-08-08 Thread Karl-Arne Gjersøyen
$oppdater_lager_med_antall_kg = $kg_pa_lager + $kg_fra_transportdokument_inn_pa_valgt_lager; result: *Fatal error*: Unsupported operand types in * /Users/karl/Sites/kasen/io/kp/index.php* on line *2970 *I have also tried this: $kg_pa_lager += $kg_fra_transportdokument_inn_pa_valgt_lager; Both

Re: [PHP] Re: Operand error...

2013-08-08 Thread Karl-Arne Gjersøyen
2013/8/8 Jim Giner jim.gi...@albanyhandball.com On 8/8/2013 1:32 PM, Karl-Arne Gjersøyen wrote: $oppdater_lager_med_antall_kg = $kg_pa_lager + $kg_fra_transportdokument_inn_**pa_valgt_lager; result: *Fatal error*: Unsupported operand types in * /Users/karl/Sites/kasen/io/kp/**index.php

Re: [PHP] Re: Operand error...

2013-08-08 Thread Karl-Arne Gjersøyen
2013/8/8 Jim Giner jim.gi...@albanyhandball.com On 8/8/2013 1:43 PM, Karl-Arne Gjersøyen wrote: 2013/8/8 Jim Giner jim.gi...@albanyhandball.com On 8/8/2013 1:32 PM, Karl-Arne Gjersøyen wrote: $oppdater_lager_med_antall_kg = $kg_pa_lager + $kg_fra_transportdokument_inn_pa_valgt_lager

Re: [PHP] Re: Operand error...

2013-08-08 Thread Karl-Arne Gjersøyen
2013/8/8 Jim Giner jim.gi...@albanyhandball.com On 8/8/2013 1:56 PM, Karl-Arne Gjersøyen wrote: 2013/8/8 Jim Giner jim.gi...@albanyhandball.com On 8/8/2013 1:43 PM, Karl-Arne Gjersøyen wrote: 2013/8/8 Jim Giner jim.gi...@albanyhandball.com On 8/8/2013 1:32 PM, Karl-Arne Gjersøyen

[PHP] How to delete 3 months old records in my database?

2013-08-02 Thread Karl-Arne Gjersøyen
Hello again, folks! I wish to delete records in my database that is older than 3 months. $todays_date = date('Y-m-d'); $old_records_to_delete = ??? if($old_records_to_delete){ include(connect.php); $sql = DELETE FROM table WHERE date = '$old_records_to_delete'; mysql_query($sql, $connect_db) or

Re: [PHP] How to delete 3 months old records in my database?

2013-08-02 Thread Karl-Arne Gjersøyen
2013/8/2 Dušan Novaković ndu...@gmail.com $query = DELECT FROM `__table_name__` WHERE `__date__` BETWEEN NOW() - INTERVAL 3 MONTH AND NOW() This delete everything from now and 3months backwards. I want to store 3 months from now and delete OLDER than 3 months old records. Karl

[PHP] From 24/7/2013 to 2013-07-24

2013-07-26 Thread Karl-Arne Gjersøyen
Below is something I try that ofcourse not work because of rsosort. Here is my code: --- $lagret_dato = $_POST['lagret_dato']; foreach($lagret_dato as $dag){ $dag = explode(/, $dag); rsort($dag); $dag = implode(-, $dag); var_dump($dag); What

Re: [PHP] From 24/7/2013 to 2013-07-24

2013-07-26 Thread Karl-Arne Gjersøyen
2013/7/26 Davi Marcondes Moreira davi.marcondes.more...@gmail.com Hi! I suggest you to try this: $foo = DateTime::createFromFormat('d/m/Y'); $newDate = $foo-format('Y-m-d'); Thank you veyr much. With a small modification this work perfec! Karl Em 26/07/2013 09:19, Karl-Arne Gjersøyen

[PHP] What wrong am I doing now?

2013-07-24 Thread Karl-Arne Gjersøyen
mysql SELECT DATE_FORMAT(dato, '%e-%c-%Y') FROM transportdokument WHERE dato = '2013-07-20' AND dato = '2013-07-24' GROUP BY dato DESC; +---+ | DATE_FORMAT(dato, '%e-%c-%Y') | +---+ | 24-7-2013 | | 23-7-2013

[PHP] Fwd: What wrong am I doing now?

2013-07-24 Thread Karl-Arne Gjersøyen
http://www.php.net/manual/en/datetime.format.php have the solution. Sorry for asking before I look at php.net!!! Karl -- Forwarded message -- From: Karl-Arne Gjersøyen karlar...@gmail.com Date: 2013/7/24 Subject: What wrong am I doing now? To: PHP Mailinglist php-general

Re: [PHP] Foreach and mydql_query problem

2013-07-23 Thread Karl-Arne Gjersøyen
6018369 -Original Message- From: Karl-Arne Gjersøyen [mailto:karlar...@gmail.com javascript:;] Sent: 22 July 2013 12:39 To: PHP Mailinglist Subject: Re: [PHP] Foreach and mydql_query problem 2013/7/22 Tamara Temple tamouse.li...@gmail.com javascript:; On Jul 22, 2013, at 1:19 AM

[PHP] Foreach and mydql_query problem

2013-07-22 Thread Karl-Arne Gjersøyen
Hello again. I have this this source code that not work as I want... THe PHP/HTHML form fields is generated by a while loop and looks like this: input type=number name=number_of_items[] size=6 value=?hp echo $item; ? required=required the php source code look like this: ?php

Re: [PHP] Foreach and mydql_query problem

2013-07-22 Thread Karl-Arne Gjersøyen
2013/7/22 Tamara Temple tamouse.li...@gmail.com On Jul 22, 2013, at 1:19 AM, Karl-Arne Gjersøyen karlar...@gmail.com wrote: Hello again. I have this this source code that not work as I want... THe PHP/HTHML form fields is generated by a while loop and looks like this: input type

Re: [PHP] Foreach and mydql_query problem

2013-07-22 Thread Karl-Arne Gjersøyen
2013/7/22 Stuart Dallas stu...@3ft9.com On 22 Jul 2013, at 08:04, Tamara Temple tamouse.li...@gmail.com wrote: On Jul 22, 2013, at 1:19 AM, Karl-Arne Gjersøyen karlar...@gmail.com wrote: Hello again. I have this this source code that not work as I want... THe PHP/HTHML form fields

[PHP] Re: Foreach and mydql_query problem

2013-07-22 Thread Karl-Arne Gjersøyen
2013/7/22 Tim Streater t...@clothears.org.uk On 22 Jul 2013 at 12:56, Karl-Arne Gjersøyen karlar...@gmail.com wrote: Yes, i know that only one a singe row is updated and that is the problem. What can I do to update several rows at the same time? Which several rows? The row

Re: [PHP] Foreach and mydql_query problem

2013-07-22 Thread Karl-Arne Gjersøyen
2013/7/22 Stuart Dallas stu...@3ft9.com On 22 Jul 2013, at 12:56, Karl-Arne Gjersøyen karlar...@gmail.com wrote: 2013/7/22 Stuart Dallas stu...@3ft9.com On 22 Jul 2013, at 08:04, Tamara Temple tamouse.li...@gmail.com wrote: On Jul 22, 2013, at 1:19 AM, Karl-Arne Gjersøyen karlar

[PHP] Split/Group date together.

2013-07-18 Thread Karl-Arne Gjersøyen
Hello again. In my program I have this: mysql SELECT * FROM transportdokument WHERE dato = '16/7/2013' AND dato = '18/7/2013'; This list all reccrds for 3 days. I need a way to split it up for every day even when the requst is as above and don't know in what way I can do it. I like to have all

[PHP] Hmmm.. I think I need your advice here to get in correct direction...

2013-07-10 Thread Karl-Arne Gjersøyen
I am almost ready with my learning project in PHP/MySQL. I can register new product in stock. Add and increase the number and weight. I can move products between different storehouses I can also transfer products from store and onto a truck document but that's it and here I need some advice. I

[PHP] Fwd: Hmmm.. I think I need your advice here to get in correct direction...

2013-07-10 Thread Karl-Arne Gjersøyen
Sorry, the first mail in this subject run out for me. This is an updated one. I am almost ready with my learning project in PHP/MySQL. I can register new product in stock. Add and increase the number and weight. I can move products between different storehouses I can also transfer products from

Re: [PHP] Re: Fwd: Hmmm.. I think I need your advice here to get in correct direction...

2013-07-10 Thread Karl-Arne Gjersøyen
2013/7/10 Jim Giner jim.gi...@albanyhandball.com On 7/10/2013 8:37 AM, Karl-Arne Gjersøyen wrote: Sorry, the first mail in this subject run out for me. This is an updated one. I am almost ready with my learning project in PHP/MySQL. I can register new product in stock. Add and increase

Re: [PHP] Re: Fwd: Hmmm.. I think I need your advice here to get in correct direction...

2013-07-10 Thread Karl-Arne Gjersøyen
2013/7/10 Lester Caine les...@lsces.co.uk Karl-Arne Gjersøyen wrote: // start the table $total = 0; echo table border=1; echo trthProduct/ththAmount/th/tr; // loop thru each item found while ($results = $qrslts-fetch(PDO::FETCH_ASSOC)) { echo trtd.$results['product_

[PHP] Can this work?

2013-07-05 Thread Karl-Arne Gjersøyen
Hello. I have a form in HTML/PHP with for loops that generate a selected list like this: for($i = 1; $i 25;$i++ ){ option value=?php echo $i; ??php echo $i; ?/option } The lists look like this: form action=index.php view-source:http://localhost/%7Ekarl/kasen/io/kp/index.php method=postselect

Re: [PHP] Can this work?

2013-07-05 Thread Karl-Arne Gjersøyen
2013/7/5 Stuart Dallas stu...@3ft9.com On 5 Jul 2013, at 14:56, Karl-Arne Gjersøyen karlar...@gmail.com wrote: Hello. I have a form in HTML/PHP with for loops that generate a selected list like this: for($i = 1; $i 25;$i++ ){ option value=?php echo $i; ??php echo $i; ?/option

Re: [PHP] Can this work?

2013-07-05 Thread Karl-Arne Gjersøyen
2013/7/5 Tedd Sperling tedd.sperl...@gmail.com On Jul 5, 2013, at 9:56 AM, Karl-Arne Gjersøyen karlar...@gmail.com wrote: The lists look like this: form action=index.php view-source:http://localhost/%7Ekarl/kasen/io/kp/index.php method=postselect name=valgt_dynamit_polse_1-25kgoption

Re: [PHP] Can this work?

2013-07-05 Thread Karl-Arne Gjersøyen
2013/7/5 Stuart Dallas stu...@3ft9.com On 5 Jul 2013, at 15:05, Karl-Arne Gjersøyen karlar...@gmail.com wrote: 2013/7/5 Stuart Dallas stu...@3ft9.com On 5 Jul 2013, at 14:56, Karl-Arne Gjersøyen karlar...@gmail.com wrote: Hello. I have a form in HTML/PHP with for loops that generate

[PHP] Hmm.. I got NULL here. Why?

2013-07-05 Thread Karl-Arne Gjersøyen
My PHP Source = ?php include('../../tilkobling.php'); $sql = SELECT kg_pa_lager FROM dynamit WHERE valgt_lager = '$valgt_lager' AND varenr = '$varenr'; $resultat = mysql_query($sql, $tilkobling) or die(mysql_error()); while($rad = mysql_fetch_array($resultat)){

[PHP] Fwd: Hmm.. I got NULL here. Why?

2013-07-05 Thread Karl-Arne Gjersøyen
My PHP Source = ?php include('../../tilkobling.php'); $sql = SELECT kg_pa_lager FROM dynamit WHERE valgt_lager = '$valgt_lager' AND varenr = '$varenr'; $resultat = mysql_query($sql, $tilkobling) or die(mysql_error()); while($rad = mysql_fetch_array($resultat)){

[PHP] Hello again. new newbie querstion

2013-07-03 Thread Karl-Arne Gjersøyen
I have done as you explain for me an it works very vell in the halft part of my application. But below is my snippet of my source code where the number of items and weight not will update itself. This code do as what number I write in the oppdater_stk_nonel_tenner[] field is written as result,

[PHP] Re: One more newbie question. About foreach..

2013-06-24 Thread Karl-Arne Gjersøyen
WOW! Thank you very, very much! This is so good! Thanks to all of you for spending time to learning me programming! Karl 2013/6/23 Maciek Sokolewicz maciek.sokolew...@gmail.com On 23-6-2013 17:11, Karl-Arne Gjersøyen wrote: Hello again. I Got the solution for my last mention problem. Now I

[PHP] Is it possible???

2013-06-24 Thread Karl-Arne Gjersøyen
$item_amount_in_store = 223; $update_amount = 7; $update_item_amount_in_store += $update_amount; $update_amoint_in_store is now 227; Why? That should be 230! Karl

[PHP] Fwd: Is it possible???

2013-06-24 Thread Karl-Arne Gjersøyen
Error in my last post This is corrected: $item_amount_in_store = 223; $update_amount = 7; $item_amount_in_Store += $update_amount; It show the result = 227 and not 230. Why is this happen? Karl -- Forwarded message -- From: Karl-Arne Gjersøyen karlar...@gmail.com Date: 2013/6

[PHP] Hmm remarkable things?

2013-06-23 Thread Karl-Arne Gjersøyen
Hello again. Thanks for last answere. It works very well but now I have another remarkable things. Perhaps logic but not for me yet.. I have this source code: (In norwegian but I translate my thoughts through it in english.) The problem with this source code is that it work very well if I select

[PHP] One more newbie question. About foreach..

2013-06-23 Thread Karl-Arne Gjersøyen
Hello again. I Got the solution for my last mention problem. Now I can update several rows at once by one single submit action. In my form I have many records and therefor I use an checkbox to just mark those records I like to update. This work just fine in PHP/HTML5 form and I got it as I want.

[PHP] Newbie form question

2013-06-21 Thread Karl-Arne Gjersøyen
Hello. I have an application that generete HTML5 form in PHP. The form is written in a while loop and therefore the form field has exact same name for every row in the loop. And that is the problem. Because when my PHP document shall handle submitted data it only take the very last row in the

[PHP] Sort question..

2012-04-25 Thread Karl-Arne Gjersøyen
Hello again. I have a photo album that show all images in a specified directory. but I like to sort them by filename as one possibillity and random sort the photos as another feature. I don't know how to do this.. Here is my soruce-code: !DOCTYPE html html lang=no head

[PHP] Find/count different word in a text

2012-04-25 Thread Karl-Arne Gjersøyen
Hello again. I am looking for a way to find and count different word in a text.. I am thinking on save the text as array and iterate through the array. Then I like to register all different words in the text. For example. If bread is used more than one time, I will not count it. After the check

[PHP] Hmm.. this is strange..

2012-04-24 Thread Karl-Arne Gjersøyen
Hello. I have a upload form in a html file and a corresponding PHP file that shall take care of the information. But I am doing something newbie error here.. What am I doing wrong? (The text is norwegian, but you still see and understand the PHP code) bildegalleri.html -

Re: [PHP] Hmm.. this is strange..

2012-04-24 Thread Karl-Arne Gjersøyen
/android/issues/detail?id=4602 2012/4/24 Karl-Arne Gjersøyen karlar...@gmail.com: Hello. I have a upload form in a html file and a corresponding PHP file that shall take care of the information. But I am doing something newbie error here.. What am I doing wrong? (The text is norwegian

Re: [PHP] Hmm.. this is strange..

2012-04-24 Thread Karl-Arne Gjersøyen
Thank you very much Tolga! if(empty($_FILES['filbane']['name'])) 24.04.2012 17:54 tarihinde, Karl-Arne Gjersøyen yazdı: Here I try to check if the input file is empty or not. But still it did not work. I receive OK even when the input file field is empty.. ?php if(!isset($_POST

[PHP] What is wrong here?

2012-04-24 Thread Karl-Arne Gjersøyen
Hello again. I can't figure out what is wrong here. move_uploaded_file() get error message from die() and can't copy/move temp_file into directory bilder I have try to chmod 0777 bilder/ but it did not help. Also I have try to chown www-data.www-data bilder/ since Ubuntu Server run apache as

[PHP] Att: saeed ahmed

2012-03-31 Thread Karl-Arne Gjersøyen
Try this: mysql CREATE DATABASE addressbook; Query OK, 1 row affected (0.00 sec) mysql USE addressbook; Database changed mysql CREATE TABLE userData(id INT(4) NOT NULL AUTO_INCREMENT PRIMARY KEY, firstName VARCHAR(50) NOT NULL, lastName VARCHAR(50) NOT NULL, telephone INT(12) NOT NULL,

[PHP] Pear Auth problem

2012-03-21 Thread Karl-Arne Gjersøyen
Hello. I am trying to use pear Auth packet but am doing something wrong. I am currently looking at the simple example in the documentation, but something is wrong in my source code, because if I write a username and a password in the fields and hit the submit button, I receive a blank pages

[PHP] PEAR_Error reporting

2012-03-21 Thread Karl-Arne Gjersøyen
Hello. I ran into trouble with a PEAR module and got only a blank (empty) page after filling in a loginform with PEAR::Auth I have error reporting in php.ini that create ordinary error message on my CentOS box, but it do not write error message when using PEAR. In a book I have is PEAR_Error