new to php and mysql and need a little help

glenn

I am try to teach myself PHP and MYSQL.

Below I have a php file I have created which when i look at it in a browser
returns a nice list of people and there addresses.

When I change the $data line from
$data = mysql_query("SELECT * FROM dir ORDER BY SURNAME") or
die(mysql_error());
to
$data = mysql_query("SELECT * FROM dir WHERE SURNAME = 'SMITH'") or
die(mysql_error());

I expected my page to show all the people who had the surname SMITH. But
instead I get nothing.

When I run the query SELECT * FROM dir WHERE SURNAME = 'SMITH';
against my mysql databse it returns the lines with SURNAME Smith.

Can anyone tell me why it doesnt work in my php file?
<html>
<head>
<title></title>
</head>
<body>


<?php

//Connect information
mysql_connect("localhost", "gaspa", "blah123") or die (mysql_error());
mysql_select_db("SBC") or die (mysql_error());

// Collects data from "dir" table
$data = mysql_query("SELECT * FROM dir ORDER BY SURNAME") or
die(mysql_error());

// puts the "dir" info into the $info array
$info = mysql_fetch_array( $data );

// Print out the contents of the entry
while($info = mysql_fetch_array( $data ))
{
Print "SURNAME:</b".$info['SURNAME'] . " ";
Print "HOME PHONE:</b".$info['HOME_PHONE'] . " ";
Print "Name:</b".$info['NAME_1'] . " ";
Print "Mob:</b".$info['PHONE_1'] . " ";
Print "Birthday:</b".$info['BIRTHDAY_1'] . " ";
Print "Name:</b".$info['NAME_2'] . " ";
Print "Mob:</b".$info['PHONE_2'] . " ";
Print "Birthday:</b".$info['BIRTHDAY_2'] . " <Br";
}
Print "</table>";

?>



</body>
</html>

Feb 24 '07 #1

Subscribe Post Reply

1101

cldmismgr

On Feb 24, 5:45 am, "glenn" <g...@bigpond.comwrote:

I am try to teach myself PHP and MYSQL.

Below I have a php file I have created which when i look at it in a browser
returns a nice list of people and there addresses.

When I change the $data line from
$data = mysql_query("SELECT * FROM dir ORDER BY SURNAME") or
die(mysql_error());
to
$data = mysql_query("SELECT * FROM dir WHERE SURNAME = 'SMITH'") or
die(mysql_error());

I expected my page to show all the people who had the surname SMITH. But
instead I get nothing.

When I run the query SELECT * FROM dir WHERE SURNAME = 'SMITH';
against my mysql databse it returns the lines with SURNAME Smith.

Can anyone tell me why it doesnt work in my php file?

<html>
<head>
<title></title>
</head>
<body>


<?php

//Connect information
mysql_connect("localhost", "gaspa", "blah123") or die (mysql_error());
mysql_select_db("SBC") or die (mysql_error());

// Collects data from "dir" table
$data = mysql_query("SELECT * FROM dir ORDER BY SURNAME") or
die(mysql_error());

// puts the "dir" info into the $info array
$info = mysql_fetch_array( $data );

// Print out the contents of the entry
while($info = mysql_fetch_array( $data ))
{
Print "SURNAME:</b".$info['SURNAME'] . " ";
Print "HOME PHONE:</b".$info['HOME_PHONE'] . " ";
Print "Name:</b".$info['NAME_1'] . " ";
Print "Mob:</b".$info['PHONE_1'] . " ";
Print "Birthday:</b".$info['BIRTHDAY_1'] . " ";
Print "Name:</b".$info['NAME_2'] . " ";
Print "Mob:</b".$info['PHONE_2'] . " ";
Print "Birthday:</b".$info['BIRTHDAY_2'] . " <Br";}

Print "</table>";

?>



</body>
</html>

take out the first mysql_fetch_array line
Craig

Feb 24 '07 #2

Similar topics

PHP/mySQL getting .csv file exported

by: Jason Reljac | last post by:

Howdy, I'm looking for a little help. I had a W2K server with Apache/PHP/mySQL installed and working. I had a specific page that ran a mySQL SELECT INTO OUTFILE and dumped the outfile into a...

PHP

New to MySQL and I'm confused!

by: w_curtis | last post by:

I'm an Access user, and I'm trying to learn MySQL and then PHP so I can make some web databases. But it just isn't clicking. I've followed some tutorials, and picked up a book, but just getting...

MySQL Database

MySQL tips that I have come across

by: Mike Chirico | last post by:

Interesting Things to Know about MySQL Mike Chirico (mchirico@users.sourceforge.net) Copyright (GPU Free Documentation License) 2004 Last Updated: Mon Jun 7 10:37:28 EDT 2004 The latest...

MySQL Database

mySQL getting .csv file exported to different server

by: Jason Reljac | last post by:

Howdy, I'm looking for a little help. I had a W2K server with Apache/PHP/mySQL installed and working. I had a specific page that ran a mySQL SELECT INTO OUTFILE and dumped the outfile into a...

MySQL Database

MySQL ODBC 3.51 driver Very Slow!

by: DJJ | last post by:

I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL tables to a Microsoft Access 2003 database. I am finding that the data from the MySQL tables takes a hell of a long time...

MySQL Database

Problems Connecting To MySQL

by: MBS | last post by:

Yeah, read the previous posts...I did that. None answer my question. I just installed PHP 5.0.4, Apache 2.0.54, and MySQL 4.1.13 a few days ago on WinXP SP2. My goal is to learn to use these...

PHP

175

Is my MySQL Gaining ?

by: Sai Hertz And Control Systems | last post by:

Dear all, Their was a huge rore about MySQL recently for something in java functions now theirs one more http://www.mysql.com/doc/en/News-5.0.x.html Does this concern anyone. What I...

PostgreSQL Database

Need info, books, articles,code, etc: Access VBA to XML to/from MySQL via HTTP

by: Cheryl Langdon | last post by:

Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to...

Microsoft Access / VBA

Newbie for PHP and MYSQL

by: Lodovikus | last post by:

Hello Everybody, glad I found you all here. I desprately want to understand PHP and MYSQL in relation to develope web sites. I'm sick and tired of build static pages. Brief reading PHP and MYSQL its...

MySQL Database

221

Uploading files into a MySQL database using PHP

by: Atli | last post by:

You may be wondering why you would want to put your files “into” the database, rather than just onto the file-system. Well, most of the time, you wouldn’t. In situations where your PHP application...

PHP

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

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

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++

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

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General