Trying to Create A Directory Structure

fireineyes

OK. Here is what I am trying to do. I am working on the tutorial at http://www.phpbuilder.com/columns/tim19990117.php3 and have gotten pretty far into it. Example of what I have done so far is at http://www.localwebadvertising.com/local/2/US/AL.
I am able to return all the cities in my database but I want to display only the cities for the state in my url (..AL here)
Ok here is 'local' php script...

<?php
$url_array=explode("/",$REQUEST_URI); $url_affil_num=$url_array[2];

$url_country=$url_array[3];

$url_state=$url_array[4];

$url_alpha_state=$url_array[5];

$url_zip=$url_array[6];

$url_content=$url_array[7];

if($url_zip) {
include('include/city.inc');
exit;
} elseif ($url_state) {
if (!$url_alpha_state) {
$url_alpha_state='a';
}
include('include/state.inc');
exit;

} ...
Here is the state.inc included script...

$sql="SELECT DISTINCT city,state FROM city";
$result=mysql_query($sql,$db);
$num = mysql_num_rows($result);
$cur = 1;
while ($num >= $cur) {
$row = mysql_fetch_array($result);
$zip= $row["zip"];
$city = $row["city"];
$state = $row["state"];
echo "$city, $state</br>";
$cur++;
}
?>

Now, I need to know this. How do I pass the state variable in the url (called $url_state in the local file) over to the state.inc include file, so that I can call on just the cities in this state?

Here is what is in my Database

affil_num | country | state | alpha_state | zip | content | city

2 US AL a 35962 Churches Crossville
2 US AL a 35971 Churches Fyffe
2 US AL a 35962 Churches Crossville
2 US GA a 00000 Churches Atlanta
2 US GA a 00001 Churches Albany

Ok. What I want is all the cities in that state to be listed in alphabetical order. Example in the case of AL...

Crossville, AL

Fyffe, AL

Can anyone help me?

bj_

If you ask smaller questions you will get more replies. Nobody wants to look at all that code. 🙂

fireineyes

ok, i have cut it down a bit. Essentially what I need to know is how to get the state variable to pass to my include script so that I can do a query in my include file to show all the cities in that state in alphabetical order.

bj_

I am not totaly sure of what you are trying to do.

If you include code it is like the page is actually coded with that code so nothing needs to be passed in on an include. i.e. The imported code has full access to the code that the page is imported to.

e.g.

<?php
// file name echo_hello.inc
echo $hello;

?>

<?php
// file named hello.php
$hello = "hello";
include( "echo_hello.inc" );

?>

When hello.php is exicuted $hello will echo.

I don't know why you would do it but you could also set a variable to global. $_GLOBAL['VARIABLE_NAME'] = VALUE;

If you need to pass the variables to another page, then in the url of the hyperlink to the page that needs the variables, you need to add ?VARIABLE_NAME=VALUE. Then you could access the information via the get super global ( $_GET['VARIABLE_NAME'] ).

fireineyes

😃
THANK YOU SO MUCH!

I got it to work. Look at http://www.localwebadvertising.com/local/2/US/GA/
and http://www.localwebadvertising.com/local/2/US/AL/ The difference is the url string being AL or GA. Before I was getting all the state cities from EVERY state. Now I have it coded to use teh variable in the include file. Here is the code I put in the state.inc files SQL statement that made all the difference....

$sql="SELECT DISTINCT city,state  FROM city WHERE state='$url_state'";

With this variable ($url_state) in the include, I can now sort out by cities!

Note -- This may not be rocket science to many out there but this was pretty tough for me. 😉 hehe