Please help - should be a simple fix.. driving me nuts

Posted on 16th Feb 2014 07:03 pm by admin

Everything seemed to be working fine. I have a table, it alphabetically lists a bunch of cities and relivant city data.

However, I found out that the city is showing up only one time when I have can have more than one rows with that City name.. I.e. - I should have 15 rows that are all "Jacksonville" but I am only seeing one. I guess my code is eliminating what it thinks are duplicates?

Here is my code (I renamed field names for communication purposes)



$dbhandle = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");

$selected = mysql_select_db("companies",$dbhandle)
or die("Could not select companies");

$query = mysql_query("SELECT* FROM companies GROUP BY City");
while ($row = @mysql_fetch_array($query))


{

$variable1=$row["Email"];
$variable2=$row["WEB"];



echo "<tr bgcolor="#dddddd"><td><center>";
echo $row["City"];
echo ($variable2 != '') ? "<a href="$variable2"></br> Website</a>" : '';
echo ($variable1 != '') ? "<a href="mailto:$variable1">Email</a>" : '';
echo ltrim($row[""], '0');
}?>

Your Answer:

Login to answer

Other forums

Table trouble
i have been reading the forum for a few weeks and decided to join. i like the format and the advice

Comparing two dates
Hi Guys
I have two dates I want to compare. Below is my current implementation. The problem with

Simple email form - Newbie
Hello all,

First time poster!

I've been asked to create a simple HTML form that submit

Hom to make one url to open together with another url
I have a chat, which i want to be opened, as soon as the users login to the site. As it is now, when

string to currency format
Hi guys...

Actually I chunk out some data from txtfile and one of the data contains amount va

how to read and write into a word document using php...?
hi,
I need,reading and writting into a word document using php.




Thank u inadva

using file_get_contents??
okay how would i create a script using file_get_contents() in php have it grab search pages 1-20 and

Web Application Recipe
Hi Guys!

I am working with the Web Application recipes. I am currently working on the sen

Need help/w Page: 1,2,3,4 function!
So I have this code im working on where it's ment to display seperate pages having 20 logs each
I

Count on multidimensional array
Hi, i got an array as below:

Array
(
=> Array
(