Query failed with error: Unknown column 'bernard' in 'where clause'

Expand|Select|Wrap|Line Numbers

 <?php

session_start();

ob_start();

$host="localhost";

$user="bernard";

$pass="bernard";

$dbase="myproj";

mysql_connect($host,$user,$pass);

mysql_select_db($dbase) or die("Failed to connect".mysql_error());
 
$limit=$_SESSION['user'];
 
$sql = "SELECT * from user where user = '$limit'";

$sql2 = mysql_query($sql);
 
while($res = mysql_fetch_array($sql2))

{
 
$fname=$res['fname'];

$add=$res['add'];

$country=$res['country'];

$mm=$res['mm'];

$dd=$res['dd'];

$yy=$res['yy'];

$date=$res['today'];

}
 
?>

<html>

<head><title>•• POST A QUESTION & FOLLOW - Bernardo Cunanan ••</title></head>

<body vlink="black" alink="black" link="black" background="bg.jpg">

<font face=Arial size=3>

<center>

<table border=0>

    <tr>

    <td colspan=3><img src="logo.png"></td>

    </tr>

    <tr>

    <td colspan=3> 

        <link href="style.css" rel="stylesheet" type="text/css" />   

               <div id="navigation">

        <ul>

                <li><a href="home.php">HOME</a></li>

                <li><a href="about-sign.php">ABOUT</a></li>

                <li><a href="post-sign.php">POST</a></li>

            <li><a href="members-sign.php">MEMBERS</a></li>

                <li><a href="logout.php">LOG-OUT</a></li>

        <li><a href="contact-sign.php">CONTACT US</a></li>
 
        </ul>

    </div>  </td>

    </tr>

    <tr>

    <td background="body.png" height=491 width=883>

        <center>

        <table>

        <tr>

        <td width=200 align=left><center><font color=#696969><img src="pic.jpg" border=4><br>

        <a href="">(change avatar)</a></font></center></td>

        <td width=400><font face=Arial size=4><ul>

        <li>Name: <?php echo $fname; ?></li>

        <li>Birthday: <?php echo $mm; ?>&nbsp;<?php echo $dd; ?>&nbsp;<?php echo $yy; ?></li>

        <li>Address: <?php echo $add; ?>, <?php echo $country; ?></li>

        <li>Member Since: <?php echo $date; ?></li>

        <ul>

        </td>

        <td valign=top width=150 align=right>

         <a href=""><font face=Arial size=4>Edit Profile</font></a>

        </td>

        </tr>

        <tr>

        <td>

        <form>

        <center>

        <a href="new-post.php"><BUTTON name="submit" type="submit" size=5 style=width:150px>

                <font face=Arial size=4>New Post</font></BUTTON></a><br>

                <BUTTON name="reset" type="reset" style=width:150px>

            <font face=Arial size=4>Edit Post</font></BUTTON><br>

        <BUTTON name="reset" type="reset" style=width:150px>

            <font face=Arial size=4>Delete Post</font></BUTTON>

        </center>

        </form>

        </td>

        <td><font face=Arial size=5><i>YOUR POST(s):</i></font>

        <ul><font face=Arial size=4>
 
        <?php
 
        $querydisplay = "SELECT * from post where user=$limit";

        $result1 = mysql_query($querydisplay) or die("Query failed with error: ".mysql_error());
 
        while($topic=mysql_fetch_array($result1))

        {
 
        echo "<li>";

        echo "<a href=post-view.php>". $topic['topicname']. "</a></li>";
 
        }
 
        ?>    

        </font>

        </ul>

        </td>

        </tr>

        <tr>

        <td colspan=2 valign=bottom align=left height=50><font face=Arial size=4>Other Information: I am techie critic, I love hot trivias about I.T.</td>

        </tr>

        </table>

        </center>

    </td>

    </tr>

<table>

Copyright 2010<br>

<a href="">College of Information and Communications Technology<br>

Holy Angel University, Angeles City</a>

</center>

</font>

</body>

</html>

Oct 7 '10 #1

Subscribe Post Reply

4250

code green

1,726

Expert 1GB

String values need wrapping in quotes

Oct 7 '10 #2

Similar topics

REQ: MySQL Query Syntax Error

by: Jonas Gorauskas | last post by:

I am having this one problem on an app I am writing where it shows the following error on some error trapping that I did: Query failed: Error Number: 1064 Description: You have an error in...

MySQL Database

PostgreSQL query failed: ERROR: pg_atoi: zero-length string

by: shreedhar | last post by:

If I try to delete a record from my table which is giving following error Warning: PostgreSQL query failed: ERROR: pg_atoi: zero-length string in /xxx/database.inc on line 73 What might be...

PostgreSQL Database

"Interesting" query planning for timestamp ranges in where clause?

by: Zygo Blaxell | last post by:

I have a table with a few million rows of temperature data keyed by timestamp. I want to group these rows by timestamp intervals (e.g. every 32 seconds), compute aggregate functions on the...

PostgreSQL Database

MySql Error 'Unknown Column' from PHP variable

by: Larry in Honolulu | last post by:

I'm getting an error message that makes no sense to me. I have a table with a field named 'testkey' for a list of "keys" in the form of ABC10102. I have a php variable holding a specific key...

PHP

MS SQL 2005: Where clause and optimizer

by: boa sema | last post by:

Way back when, and at least in version 7 IIRC, the query optimizer gave up when the where clause in a statement contained more than 4 search conditions. Does anyone know if such a limitation...

Microsoft SQL Server

Error: Database query failed: Unknown column 'subj' in 'where clause'

by: benicio | last post by:

Database query failed: Unknown column 'subj' in 'where clause' What does this error mean and how should it be fix?

MySQL Database

Error Unknown column 'quotation' in 'field list'

by: nomad | last post by:

Hello everyone: I new to PHP and I'm reading a book on PHP Bibles 2nd edition. It has to deal with a user-rating system. There are 4 scripts to it. I'm getting an error Unknown column...

PHP

how to get maximum value of multiple columns with where clause?

by: omar999 | last post by:

i can a max value of a single column with where clause like this select MAX(Price_Band_1) AS HighestPrice from UK_Specials where ID IN (1,3,5,7,9,10,13,15,17,19,21,23,25,27,29,31,33,35,37) ...

Microsoft SQL Server

y do i get this error? Unknown column 'imagePath' in 'field list'

by: luke noob | last post by:

This acually happends to all fields, i have made sure that i have connected to the right database name, if i post my query (SELECT id, imagePath, titleOfTutorial, descriptionOfTutorial, tutorialBy...

PHP

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing