MySql and PHP "Using WHERE in a SELECT statememt"

[Ric]

i have a basic php file that is trying to select information from a
mysql database.

echo "<br>";
include("dbConnect.inc");
$query = "SELECT * FROM client";
$result = mysql_query($query) or die("no select");
$row = mysql_fetch_array($result,MYSQL_ASSOC);
while ($row = mysql_fetch_array($result))
{
extract($row);
echo "Welcome ".$fName." ".$lName." - ".$deptID."<br>";
}

this works, but it doesnt return the first record from the table. when
i add a WHERE statement, nothing is returned. im using phpMyAdmin to
administer mysql. i can get all of the rows from the client table when
i browse from phpMyAdmin.

also, i can use PEAR database abstraction layer and it retrieves all
records and WHERE works in the select. is there a mysql or php setting
im missing?

im using mysql 4.01 and php 4.3

[Pedro]

Ric wrote:

i have a basic php file that is trying to select information from a
mysql database.

echo "<br>";
include("dbConnect.inc");
$query = "SELECT * FROM client";
$result = mysql_query($query) or die("no select");
$row = mysql_fetch_array($result,MYSQL_ASSOC); ### get the *FIRST* record into $row
while ($row = mysql_fetch_array($result)) ### get the *SECOND* (or 3rd, 4th, ...) record into $row
{
extract($row);
echo "Welcome ".$fName." ".$lName." - ".$deptID."<br>";
}

this works, but it doesnt return the first record from the table. when
i add a WHERE statement, nothing is returned.

remove the first mysql_fetch_array() and it should be ok
HTH

--
I have a spam filter working.
To mail me include "urkxvq" (with or without the quotes)
in the subject line, or your mail will be ruthlessly discarded.

[Ric]

thx. that worked. i really appreciate the help.

Pedro <he****@hotpop.com> wrote in message news:<bm************@ID-203069.news.uni-berlin.de>...

Ric wrote:

i have a basic php file that is trying to select information from a
mysql database.

echo "<br>";
include("dbConnect.inc");
$query = "SELECT * FROM client";
$result = mysql_query($query) or die("no select");
$row = mysql_fetch_array($result,MYSQL_ASSOC);

### get the *FIRST* record into $row

while ($row = mysql_fetch_array($result))

### get the *SECOND* (or 3rd, 4th, ...) record into $row

{
extract($row);
echo "Welcome ".$fName." ".$lName." - ".$deptID."<br>";
}

this works, but it doesnt return the first record from the table. when
i add a WHERE statement, nothing is returned.

remove the first mysql_fetch_array() and it should be ok
HTH