Some SQL results missing from SELECT query

[Gregg]

I wrote a query and have it executing properly, but when the results are being displayed I receive the following values and all of the rest are blank (even though data exists and I believe that it is queried correctly)
These fields appear

Company
First_Name
Last_Name
Address1
Address2
City
State

While all of the other result sets are blank. I have tried everything I can think of .

Thank you for the help.

Greg

echo "<Table border=2>";

echo "<tr><th>Company</th><th>First_Name</th><th>Last_Name</th><th>Address1</th><th>Address2</th><th>City</th><th>State</th><th>ZipCode1</th><th>ZipCode2</th><th>Area</th><th>Local</th><th>Number</th><th></th><th>Ext</th><th>HC</th><th>HN</th><th>HU</th><th>Email</th><th>Web</tr></th>";

while ($row = mysql_fetch_array($sql_result)) {
$Company = $row["Company"];
$First_Name = $row["First_Name"];
$Last_Name = $row["Last_Name"];
$Address1 = $row["Address1"];
$Address2 = $row["Address2"];
$City = $row["City"];
$State = $row["State"];
$Zip_code = $row["ZipCode1"];
$Zip_Code2 = $row["ZipCode2"];
$WPareacode = $row["Area"];
$WPlocal = $row["Local"];
$WPunique = $row["Number"];
$Extension = $row["Ext"];
$HPareacode = $row["HC"];
$HPlocal = $row["HN"];
$HPunique = $row["HU"];
$Email_Address = $row["Email"];
$Webaddress = $row["Web"];

echo "<tr><td>$Company</td><td>$First_Name</td><td>$Last_Name</td><td>$Address1</td><td>$Address2</td><td>$City</td><td>$State</td><td>$Zip_code</td><td>$Zip_Code2</td><td>$WPareacode</td><td>$WPlocal</td><td>$WPunique</td><td>$Extension</td><td>$HPareacode</td><td>$HPlocal</td><td>$HPunique</td><td>$Email_Address<td align=right>$Webaddress</td></tr>";

}

---

Thanks

Greg

[LordShryku]

I dont see anything wrong with your echo's. Try posting the query. And have you tried the query through command line and gotten back the desired results?

[Gregg]

$sql = "SELECT * FROM ggalvin1.Phonebook WHERE $textinput = ('$values')";

I have not attempted to use the through command. How would I go about using it.

Thanks

Greg

[LordShryku]

Well first thing I see is the single quotes around your variable. Some DB's won't work at all like that. And the parens might be in the way too. You should be able to login to mysql at the command line, or in phpMyadmin. I assume you have something that you execute your SQL in besides php right?

Try using:

$sql = "SELECT * FROM ggalvin1.Phonebook WHERE $textinput = '$values'";

[Gregg]

Thanks but the SQL query does not change anything. Same results.

Thanks

Greg

[ultraslacker]

How exactly have you tried to debug this?

You should know if the query returns all the required data.

Debugging steps -

• Echo the query and execute it directly on mysql client.
• Get rid of the '*' and list the attributes.

[LordShryku]

I dont use MySQL, but another thing I do during debugging, after I've verified the query work through command line SQL is to echo the whole array to the page. Just to see if the information is getting to the array.

Sorry I couldn't be of more assistance...

[Gregg]

Thanks for all of the help. I have solved the problem by examining every variable carefully and realizing that I had some errors in my code.

Thanks