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 am
In my HTML5/PHP form I have this two rows..
0082Exan ELEXE25NO200
0081Dynamit -
papirpatron - 22x180EDY22X180K100
Then I have this in PHP source to handle it...
$antall_varenr = count($varenr_in
2013/8/8 Jim Giner
> On 8/8/2013 1:56 PM, Karl-Arne Gjersøyen wrote:
>
>> 2013/8/8 Jim Giner
>>
>> On 8/8/2013 1:43 PM, Karl-Arne Gjersøyen wrote:
>>>
>>> 2013/8/8 Jim Giner
>>>>
>>>> On 8/8/2013 1:32 PM, Karl-Arne
2013/8/8 Jim Giner
> On 8/8/2013 1:43 PM, Karl-Arne Gjersøyen wrote:
>
>> 2013/8/8 Jim Giner
>>
>> On 8/8/2013 1:32 PM, Karl-Arne Gjersøyen wrote:
>>>
>>> $oppdater_lager_med_antall_kg = $kg_pa_lager +
>>>> $kg_fra_transportdokum
2013/8/8 Jim Giner
> 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 *
>> /U
$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 o
2013/8/2 Dušan Novaković
> $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
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)
2013/7/26 Davi Marcondes Moreira
> 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, &qu
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);
W
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
Date: 2013/7/24
Subject: What wrong am I doing now?
To: PHP Mailinglist
mysql> SELECT DATE_FORMAT(dato,
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
Liam.
> 3Sharp Ltd.
>
> T: 0845 6018370
> F: 0845 6018369
>
> -Original Message-
> From: Karl-Arne Gjersøyen [mailto:karlar...@gmail.com ]
> Sent: 22 July 2013 12:39
> To: PHP Mailinglist
> Subject: Re: [PHP] Foreach and mydql_query problem
>
> 2013/
2013/7/22 Stuart Dallas
> On 22 Jul 2013, at 12:56, Karl-Arne Gjersøyen wrote:
>
> > 2013/7/22 Stuart Dallas
> >
> >>
> >> On 22 Jul 2013, at 08:04, Tamara Temple
> wrote:
> >>
> >>> On Jul 22, 2013, at 1:19 AM, Karl-Arne Gjersøy
2013/7/22 Tim Streater
> On 22 Jul 2013 at 12:56, Karl-Arne Gjersøyen 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 that will be updated
2013/7/22 Stuart Dallas
>
> On 22 Jul 2013, at 08:04, Tamara Temple wrote:
>
> > On Jul 22, 2013, at 1:19 AM, Karl-Arne Gjersøyen
> wrote:
> >
> >> Hello again.
> >> I have this this source code that not work as I want...
> >>
> >>
2013/7/22 Tamara Temple
>
> On Jul 22, 2013, at 1:19 AM, Karl-Arne Gjersøyen
> 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
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:
" required="required">
the php source code look like this:
";
$sql = "UPDATE item_table SET number_item = '$item' WHERE date
= '$todays_d
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 al
2013/7/10 Lester Caine
> Karl-Arne Gjersøyen wrote:
>
>> // start the table
>>>
>>
> $total = 0;
>
> >echo "";
>>> >echo "ProductAmount";
>>>
>>> >
>>> >// loop thru each item found
2013/7/10 Jim Giner
> 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
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
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 l
My PHP Source
=
";
var_dump($kg_pa_lager);
?>
My var_dump() value;
==
string(84) "SELECT kg_pa_lager FROM dynamit WHERE valgt_lager = 'Tengs' AND
varenr = 'EDY22X180'"
NULL
My Database table:
===
mysql> SELECT * FROM dynamit;
++-
My PHP Source
=
";
var_dump($kg_pa_lager);
?>
My var_dump() value;
==
string(84) "SELECT kg_pa_lager FROM dynamit WHERE valgt_lager = 'Tengs' AND
varenr = 'EDY22X180'"
NULL
My Database table:
===
mysql> SELECT * FROM dynamit;
++-
2013/7/5 Stuart Dallas
> On 5 Jul 2013, at 15:05, Karl-Arne Gjersøyen wrote:
>
> > 2013/7/5 Stuart Dallas
> >
> >> On 5 Jul 2013, at 14:56, Karl-Arne Gjersøyen
> wrote:
> >>
> >>> Hello. I have a form in HTML/PHP with for loops that generate
2013/7/5 Tedd Sperling
> On Jul 5, 2013, at 9:56 AM, Karl-Arne Gjersøyen
> wrote:
> > The lists look like this:
> >
> > http://localhost/%7Ekarl/kasen/io/kp/index.php>"
> > method="post"> > value="1-25" selected="selected&quo
2013/7/5 Stuart Dallas
> On 5 Jul 2013, at 14:56, Karl-Arne Gjersøyen 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++ ){
> >
> > }
> >
> > The lists look l
Hello. I have a form in HTML/PHP with for loops that generate a selected
list like this:
for($i = 1; $i< 25;$i++ ){
}
The lists look like this:
http://localhost/%7Ekarl/kasen/io/kp/index.php>"
method="post">1-2512345678910111213141516171819202122232425 Kg 26-502627282930313233343536373839404142
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, in
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
Date: 2013/6/24
Subject: Is it
$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
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
> On 23-6-2013 17:11, Karl-Arne Gjersøyen wrote:
>
>> Hello again. I Got the solution for my last mention problem. Now I can
>&
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.
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
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 whil
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 wer
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:
Bildegalleri
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 www-
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 emp
s not set, additionally
> check if it is empty
>
> Kind regards/met vriendelijke groet,
>
> Serge Fonville
>
> http://www.sergefonville.nl
>
> Convince Google!!
> They need to add GAL support on Android (star to agree)
> http://code.google.com/p/android/issues/detail?i
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
-
O
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,
em
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 mentio
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 without
45 matches
Mail list logo
