Write Forums

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');
}?>

No comments posted yet

145 26 Tweet

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
Calculating a rating by adding number of points and dividing by number of items 
I have a site that users can post links to files to download. They can rate these files on a 1-5 sca
Preventing blank or already entered values  
Im trying to learn how to place a read file line by line and prevent duplicate entries and also BLAN
JSON SORT WITH PHP 
I have two products that I want to sort by say "Id:17, value: xxx" using php
The page w
values in array being escaped 
I would like to submit some values  - back to the same form for checking before processing...
ctype() validation - allowing illegal characters 
Hello,
I use ctype() to filter and validate a user form.  However, I am trying to allow certain c
Comparing Values 
Hi
I'm reading data from a database and this seems to work OK.

Each system has an associat