[cebuy]

With this code, I get an error. Look at http://www.localwebadvertising.com/local/2/us

Parse error: parse error, unexpected T_STRING, expecting ']' in /home/localweb/public_html/include/country.inc on line 30

PHP Code:

<?php

$db=mysql_connect ("localhost", "notable", "nopass") or die ('I cannot connect to the database.');

mysql_select_db ("notable",$db); 



$sql="SELECT DISTINCT state * FROM notable";

$result=mysql_query($sql,$db);



//Store your states in an array, $state, and count them 



$n = 0; 

while ($row = mysql_fetch_array($query_result)) { 

    $state[] = $row['state']; 

    $n++; 

} 



// sort the array 



sort ($state); 



//if you want the 3 cols, div_point is number in each column 



$div_point = floor(($n+2)/3); 





for ($i=0; $i<$div_point; $i++) {  

    echo "<tr><td>$array[$i]</td>"; 

    echo "<td>$array[$i + $div_point]</td>"; 

    echo "<td>$array[$i + $div_point * 2]</td></tr>" ; 

}





echo "I want to go to <a href=\"/local/$url_affil_num/$url_country/$state/\">$state</a> </br>";



$cur++;



?>

Line 30 is echo "<td>$array[$i + $div_point]</td>";
Any idea what I am doing wrong?

[!!! HotCGIScripts !!!]

PHP Code:

for ($i=0; $i<$div_point; $i++) {  

    echo "<tr><td>".$array[$i]."</td>"; 

    echo "<td>".$array[$i + $div_point]."</td>"; 

    echo "<td>".$array[$i + $div_point * 2]."</td></tr>" ; 

} 

will work.

[cebuy]

I got these errors when I changed it...

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/localweb/public_html/include/country.inc on line 14

Warning: sort() expects parameter 1 to be array, null given in /home/localweb/public_html/include/country.inc on line 21
I want to go to

[!!! HotCGIScripts !!!]

Yes, of course.

"SELECT DISTINCT state * FROM notable"

is invalid query. May be remove * from it.

[cebuy]

ok. here is what I am trying to do.
Here is the mysql table info (will not add as many entries)

PHP Code:

  State   |   City

+--------+ -----------------+

   AL          Crossville

   GA          Atlanta

   TN          Knoxville

   TN          Nashville

   TN          Memphis

   AL          Birmingham

   MS          Jackson  

   FL           Miami

   SC          Charleston

   CA          San Diego

   WA         Spokane 

   OR          Portland

--------+---------------------- 

I want a result output of all the states alphabetically sorted in three columns.
This would result in something like ...

PHP Code:

AL        GA        SC

CA        MS        TN

FL        OR        WA 

[phpkid]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/localweb/public_html/include/country.inc on line 14

Warning: sort() expects parameter 1 to be array, null given in /home/localweb/public_html/include/country.inc on line 21
I want to go to

Means your query failed.
Try
SELECT DISTINCT state FROM table_name

Also, always make sure whether your query executed or not.

Do it like,

$query = 'your query goes here.';

$result = @mysql_query($query) or die('Can not execute query : ' . $query . "\n" . 'MySQL Said : '. mysql_error());

So if your query fails, it will tell you the query and why it failed.

Regards,
JD

[ridwank]

THIS IS THE ALGORITHM FOR MAKING THREE COLUMN RESULT
But You could change the looping control structure
with mysql query.

<?
echo "<h3>ORIGINAL DATA </h3>";
$state=array("0","GA","SC","AL","MS","OR","FL","OR ","TN","CA");
for ($i=1;$i<count($state);$i++){
echo $state[$i]." . ";
}
sort ($state);

echo "<hr>";

echo "<h3>DISPLAYING HORISONTAL SORT </h3>";

echo "<table border=1><tr>";

for ($i=1;$i<count($state);$i++){
echo "<td><li>".$state[$i]."</td>";
if (($i % 3)==0){ echo "</tr><tr>"; }
}

echo "</tr></table>";

echo "<hr>";

echo "<h3>DISPLAYING VERTICAL SORT</h3>";

echo "<table border=1><tr><td>";

for ($i=1;$i<count($state);$i++){
echo "<li>".$state[$i]."</li>";
if (($i % 3)==0){ echo "</td><td>"; }
}

echo "</td></tr></table>";
?>

[jv2222]

This might help make your life easier when it comes to working with mySQL:

http://www.hotscripts.com/Detailed/18290.html

Cheers,
Justin

[cebuy]

THanks I will look into that.

[MGCJerry]

Originally posted by jv2222
This might help make your life easier when it comes to working with mySQL:

http://www.hotscripts.com/Detailed/18290.html

Cheers,
Justin

I'm currently using this for a larger project, and it works wonders.

No, I'm not affiliated with them I just like using it.