displaying values horizontally

BEFOR

I've used do while's to display values on the page for repeat regions.

But generally, how do you display query results not top to bottom but rather continuously left to right seperated by spaces as in a paragraph?

DoctorWho

YOu could make it into a table with table headers.

You could simple do this as well.

<? echo "$yourDBdata1 $yourDBdata2 $yourDBdata3"; ?>

I think that's what your asking.

skdzines

have you tried something like this?

$sql = "SELECT * FROM tableName";
$result = mysql_query($sql);

if($result){
   while($data = mysql_fetch_array($result)){
       echo "".$data['fieldName1']."&nbsp;&nbsp;".$data['fieldName2']."&nbsp;&nbsp;".$data['fieldName3']."&nbsp;&nbsp;".$data['fieldName4']."";
   }
}

BEFOR

skdzines,

will the "if" exclude the first returned result?

-please note that each returned results has a different number of values being returned.
- this is being used for displaying the cities for each state page a user happens to be on.
- there could be 50 to 100 or a couple hundred results being returned.
- are you two saying I would have to manually place a couple hundred echoes? then whatever shows, shows? Is this the best way? Rather than go with a seperately named echo for ea. result -- is there a way to list these dynamically, as a do while does vertically?

These cities within a single field/column. I'm joining on another column. Is 'fieldName1' dynamically generated -- that is, does it reference an actual table column?

skdzines

all the if statement is doing is checking to make sure that there is some value inside the variable $result. If there is then display the results. The 'fieldName1' is the fieldName or data column name in the database you want to display and is stored in the array $data[]. So the answer is yes. It references the actual table column name.

I don't know exactly how you have your database set up, but basically what you would want to do is continue adding as many $data['fieldName'] to your one echo statement for each column in the database. How many columns do you have in your database? If you have 50 columns in your db, you would add 50 $data['fieldName'] to your echo statement, each one referencing the appropriate colum name. If that $data['fieldName'] contains a value, it will print to the screen, if not, you will just get a blank space.

However in my example, it will print two   characters regardless if there is any data in the $data['fieldName'] or not, meaning if you have five consecutive $data['fieldName'] empty in the array, you will get 10   to print to the screen which you probably don't want. In this case you could do an if statement for each returned result something like this.

$sql = "SELECT * FROM tableName"; 
$result = mysql_query($sql); 

if($result){ 
   while($data = mysql_fetch_array($result)){ 
      if($data['fieldName1'] != ""){
         echo "".$data['fieldName1']."&nbsp;&nbsp";
      }
      if($data['fieldName2'] != ""){
         echo "".$data['fieldName2']."&nbsp;&nbsp";
      }
      if($data['fieldName3'] != ""){
         echo "".$data['fieldName3']."&nbsp;&nbsp";
      }
      if($data['fieldName4'] != ""){
         echo "".$data['fieldName4']."&nbsp;&nbsp";
      }

// and so on for every column in your db
   } 
}

Hope this helps

By the way I noticed you are from Lebanon OH, I'm from Columbus, OH. Just thought I'd mention that.

BEFOR

Hey, nice to hear from a neighbor.

About the table column, there is only only one column in the table, that contains these 'cities' It's named 'City'

If the fieldName1 references a column on the table, does fieldName2 reference another column on the database table. Sorry, don't completely follow. Could this be 'City1' 'City2' 'City3', etc?

These cities are associated on the table by another column (actually by county).

What I need to do is go down the row values with this. In the 'City' column.

Don't have the SELECT yet, I'm designing this portion of the site. Could make it now if its needed.

skdzines

So you only have one table with one column named "City"? And another table with a column called County? Or do you have one table with both County and City columns? Could you show me exactly how many tables and columns you have in your database and how you plan on joining them? This will help me understand more clearly of what you are trying to do.

BEFOR

table name:

'commercial'
CommID | City | State | County | CountyFIPS

SELECT DISTINCT City, State
FROM commercial
WHERE StateCode='colname'
ORDER BY City

///filtering by Get variable.

I'll mainly use to echo a list of cities on each state page. Or on each city page listed. StateCode will be filtered by Get_Vars

May also do by CountyFIPS = 'colname' // dynamically listing all the cities in a county. Or use this for all as soon as I determine that there are no counties that cross any state borders.

skdzines

Sorry to take so long to get back to you.

From your query statement you have posted, you can't search the database on the field 'StateCode' because it doesn't exist in your table. You say you are going to filter by the Get var, so I assume that 'colname' is going to be passed in from another page like so:
http://www.mypage.com/somepage.php?colname=someData and then you will get it by doing this:

$colname = $_GET['colname'];

So if you want to search by CountyFIPS then your query would look something like this.

$sql = "SELECT DISTINCT City, State FROM commercial WHERE CountyFIPS ='".$colname."' 
ORDER BY City";
$result = mysql_query($result);

if($result){
   while($data = mysql_fetch_array($result)){
       echo "ID: ".$data['CommID'].", City: ".$data['City'].", State: ".$data['State'].",  County: ".$data['County'].", County FIPS: ".$data['CountyFIPS']."";
   }
}

I'm still not quite sure what you are wanting but I think I'm close. Hope this helps.

Also, here is a little info on the DISTINCT query. http://www.databasejournal.com/features/postgresql/article.php/3437821