Viewing Table

nikko50

Hello there. New Sql/PHP user here. The first row of my table will not display. What am I doing wrong?? Thanks Sharon🙂)

<?
$host= "localhost";
$user= "root";
$pass= " ";
$database = "test";
$conn= mysql_connect( $host, $user)
or die("cannot connect to server");
$db= mysql_select_db($database,$conn)
or die("cannot connect to database");
$query= "SELECT * FROM employees";
$result= mysql_query($query)
or die("Cannot execute query");
$row= mysql_fetch_array($result);

while ( $row= mysql_fetch_array($result))
{ extract ($row);
print "$name $address, $city, $state $zip <br>";
}
?>

Kudose

First off, make this file called dbinfo.inc.php and upload it.

<? 
mysql_connect('localhost', 'username', 'password', 'dbname') or die(mysql_error());
?>

Then make your script just like this:

<?
//call db information
include('dbinfo.inc.php');
//query the DB
$query = "SELECT * FROM employees"; 
$result = mysql_query($query) or die(mysql_error()); 
//find out how many rows in the query
$num = mysql_num_rows($query);
//grab query array data
$row = mysql_fetch_array($result); 
//run a loop that stops when there are no rows left
for($i=0; $i<$num; $i++){ 
extract ($row); 
echo "$name $address $city , $state $zip <br>"; 
} 
?>

nikko50

Thanx for the help but it still won't retrieve the very first row of the table. Any more help will be appreciated!!

nikko50

I changed the code to this..
$query= "SELECT * FROM employees LIMIT 0,3";

and the first record in the table still will not show.
Help:🙁(((
Sharon

tekky

Sharon,

you need to remove this one line....

$result= mysql_query($query)
    or die("Cannot execute query");
$row= mysql_fetch_array($result); //this line right here is causing your problem, delete it ;)

tekky

an explanation as to why that line is causing the first row to be skipped....

you are telling it to fetch an array from the row data... the going into a loop and telling it to immediately fetch another row (losing your first row each time) and then start processing it....

anytime you want to process ALL rows of a query... something akin to this is all you need...

$query = 'SELECT * FROM example';
$result = mysql_query($query);

while($row = mysql_fetch_assoc($result))
{
  //loop through until no more rows are found, and do what you want with the data
}

nikko50

Karl you are awesome. Thanks for the explanation!!
Hugs and Kisses for you!!
Sharon

tekky

You're welcome, glad to help 🙂

dont forget to mark the thread resolved 😉