Fwd: Hmm.. I got NULL here. Why?

[email protected] (Karl-Arne Gjersøyen)
Newsgroups php.general
Message-ID <CAN78Z6AVFXs70Cu1KFLCsaTw3C6ns+398kCqOGkmXKFx+bnLLA@mail.gmail.com>
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)){
        $kg_pa_lager = $rad['kg_pa_lager'];
        echo "$kg_pa_lager";
        }
        var_dump($sql);
        echo "<br />";
        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;
+------------+-------------+---------------+--------+-------+----------+------------+-------------+
| leverandor | valgt_lager | type          | dim_mm | un_nr | varenavn |
varenr     | kg_pa_lager |
+------------+-------------+---------------+--------+-------+----------+------------+-------------+
| Orica      | Tengs       | Papirpatroner | 22x180 | 0081  | Dynamit  |
EDY22X180K | 100         |
| Orica      | Tengs       | Papirpatroner | 25x180 | 0081  | Dynamit  |
EDY25X180  | 100         |
| Orica      | Tengs       | Plastpølse   | 45x540 | 0081  | Dynamit  |
EDY45X540  | 100         |
+------------+-------------+---------------+--------+-------+----------+------------+-------------+
3 rows in set (0.00 sec)

mysql>

The Problem:
==========
If I do this:
$sql = "SELECT kg_pa_lager FROM dynamit WHERE valgt_lager = '$valgt_lager'";
I got 100100100 for kg_pa_lager

But if I do this:
$sql = "SELECT kg_pa_lager FROM dynamit WHERE valgt_lager = '$valgt_lager'
AND varenr = '$varenr'";
I got NULL.

Look at varenr = EDY22X180 in the select where and that it is in the table
under varenr.
But why is kg_pa_lager NULL?

This is strange to me but I guess you know why?
Thanks for your advice.

Karl

I got the solution. I had forget to write "K" at end of the serial number.
Now it is OK.
Karl
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.