not pulling data from "name" field

[rfigley]

This weird. I have this smame setup on another database and it's working fine. However on this one, it's pulling data from all fields but the name field.

Here's the page:
http://pnanetwork.com/tamarac_lunch_members.php

Here's the code below is being used:

Any idea what the problem is? I've verified the correct spelling for 'name' and case sensitivity in the database, and all match.

include('dbconnect.php');


$query = ("select * from tbl_members where chapter='Coral Springs - Tamarac' AND unit='Lunch'");
//$query = ("select * from tbl_members where chapter='Coral Springs' AND unit='Lunch' order by name");
$result = mysql_query($query) or die("Query fail");


if (mysql_num_rows($result) == 0)
{

} else
{

  echo "<CENTER>";

  echo "<table border=1>";

  while($row = mysql_fetch_array($result))
    {
        //echo "<table><tr><td>";
        //echo "<table border=1>";

    echo "<tr><td> " . "&nbsp" .  $row['name'] . "&nbsp" . "</td><td> " . "&nbsp" . $row['category'] ."&nbsp" . "</td><td> " . "&nbsp" .  $row['business_name'] . "&nbsp" . "</td><td> " . "&nbsp" . $row['phone'] . "&nbsp" . "</td><td> " . "&nbsp" .  $row['email'] . "&nbsp" . "</td></tr>";
    //echo "<td> " . $row['name'] . " ,</td><td> " . $row['category'] ." </td><td> " . $row['phone'] . "<br>\n";
    //echo "</font>";

}
echo "</table>";

 }




?>

[mtimdog]

Well, check to make sure the field is called name, and check the db to make sure that those fields have a name.

[rfigley]

yes, name fields match exactly.
here is an exerpt from the database:

00001 Arthur Drujak Coral Springs Breakfast member Accounting Arthur M Drujak CPA 954-485-4448

00002 Brigitte Baroukh Coral Springs Breakfast Advertising - Magazine City Smart 305-604-8600 [e-mail]

00004 Scott Brook Esq Coral Springs Breakfast Attorney - Workers Compensation Scott J Brook PA

[mtimdog]

None of those fields are on the page you linked to. Can you use your sql query in phpmyadmin and post the results. I'm trying to see if it's a php by you or mysql issue. Like I said before, those records may not have a name.

[rfigley]

Same database, different query. Here is from the link I provided.

00059 Barbara Mintz Coral Springs - Tamarac Lunch Acupuncture Peach Blossom 954-344-7846 [e-mail]

00060 Charles Sternfield Coral Springs - Tamarac Lunch Accounting Charles Sternfield, CPA 954-227-1040 [e-mail]

00061 Dr Mendel Brookner Coral Springs - Tamarac Lunch Chiropractic Self

[mtimdog]

Is that the sql query from your page?

try print_r($row) and see what it says

[rfigley]

This is the query that select the data from the table:

$query = ("select * from tbl_members where chapter='Coral Springs - Tamarac' AND unit='Lunch'"); 

This is the code that prints the information in the table:

{ 

  echo "<CENTER>"; 

  echo "<table border=1>"; 

  while($row = mysql_fetch_array($result)) 
    { 
        //echo "<table><tr><td>"; 
        //echo "<table border=1>"; 

    echo "<tr><td> " . "&nbsp" .  $row['name'] . "&nbsp" . "</td><td> " . "&nbsp" . $row['category'] ."&nbsp" . "</td><td> " . "&nbsp" .  $row['business_name'] . "&nbsp" . "</td><td> " . "&nbsp" . $row['phone'] . "&nbsp" . "</td><td> " . "&nbsp" .  $row['email'] . "&nbsp" . "</td></tr>"; 
    //echo "<td> " . $row['name'] . " ,</td><td> " . $row['category'] ." </td><td> " . $row['phone'] . "<br>\n"; 
    //echo "</font>"; 

} 
echo "</table>"; 

 }

[mtimdog]

What I meant was, is your 2nd last post from the query on your page. Also, I'm interested in seeing what print_r($row) does inside of your while loop.

[TTT]

first column is is and 2nd is name?

if so try:
echo "<tr><td> " . "&nbsp" . $row['name']

=>

echo "<tr><td> " . "&nbsp" . $row[1]

or try:
while($row = mysql_fetch_array($result))
=>
while($row = mysql_fetch_assoc($result))