www.webdeveloper.com
Results 1 to 2 of 2

Thread: Unknown column '' in 'where clause' No problem. We won't show you that ad again. Why

  1. #1
    Join Date
    Jun 2011
    Location
    California
    Posts
    383

    Unknown column '' in 'where clause' No problem. We won't show you that ad again. Why

    know the column npi exists so I'm not sure why i'm getting this error; I've read a few other threads on here but nothing is working for me. In my where clause, i've tried backticks and single quotes but no avail. Any help would be greatly appreciated. Thank you.


    PHP Code:
     <?php
        
    include('config.php');
        if (isset(
    $_GET['insurance_id']) ) {
        
    $insurance_id = (string) $_GET['insurance_id'];
        if (isset(
    $_POST['submitted'])) {
        foreach(
    $_POST AS $key => $value) { $_POST[$key] = mysql_real_escape_string($value); }
        
    $sql = ("UPDATE `doctor_data` SET `dr_first_name` = '{$_POST['dr_first_name']}', `dr_last_name` = '{$_POST['dr_last_name']}' where npi='$npi'");

        
    mysql_query($sql) or die(mysql_error());
        echo (
    mysql_affected_rows()) ? "Edited Record.<br />" "Nothing changed. <br />";
        echo 
    "<a href='index.php?id=28&insurance_id=($REQUEST:insurance_id)'>Back To List</a>";
        }
        
    $row mysql_fetch_array mysql_query("SELECT * from `doctor_data`"));
        
    ?>

        <form action='' method='POST'>
        <p><b>Doctor:</b><br /><input type='text' name='dr_first_name' value='<?= stripslashes($row['dr_first_name']) ?>' /> <input type='text' name='dr_last_name' value='<?= stripslashes($row['dr_last_name']) ?>' />
        <p><input class="btn btn-success" type='submit' value='Update Record' /><input type='hidden' value='1' name='submitted' />
        </form>
        <? ?>

    Additionally, the data is being saved on the form after it's being posted but not into the database and upon pushing the post button I receive the error message posted in the title.





    -- phpMyAdmin SQL Dump
    -- version 3.4.11.1
    -- http://www.phpmyadmin.net
    --
    -- Host: localhost
    -- Generation Time: Feb 15, 2013 at 05:50 PM
    -- Server version: 5.5.23
    -- PHP Version: 5.2.17

    SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
    SET time_zone = "+00:00";


    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;

    --
    -- Database: `anag_demo`
    --

    -- --------------------------------------------------------

    --
    -- Table structure for table `doctor_data`
    --

    CREATE TABLE `doctor_data` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `npi` int(11) DEFAULT NULL,
    `dr_first_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `dr_last_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `npi` (`npi`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=17 ;

    /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

  2. #2
    Join Date
    Feb 2011
    Posts
    231
    Hi,
    The 'npi' column is integer, so, the value must be passed without quotes.
    Also, the $npi variable is not defined.
    Anyway, try this query:
    Code:
     $sql = ("UPDATE `doctor_data` SET `dr_first_name` = '". $_POST['dr_first_name'] ."', `dr_last_name` = '". $_POST['dr_last_name'] ."' where npi=$npi");

Thread Information

Users Browsing this Thread

There are currently 2 users browsing this thread. (0 members and 2 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles