[SOLVED] 2 Files, URL and Variable problem!

[erme]

Thought this was best suited as a new topic rather then a string of multiple questions in a topic that the title wasn't now true to.

 

I have 2 files, index.php and locations.php.

 

In index.php I have

$extrapart = (isset($_GET['county'][0]))?"WHERE County='".mysql_real_escape_string($_GET['county'])."'":"";

 

and in locations.php

$query = "SELECT * FROM locations $extrapart";
$result = mysql_query($query);

 

In order for what I am wanting, I have my URL like this

/index.php?county=devon

 

however because this is being called in index.php, I can't use $extrapart in locations.php. Is there a way locations.php can read this?

[DEVILofDARKNESS]

you can store it in a session, or in a cookie

[erme]

Know of any good tutorials on this?

[Batosi]

<?php
$_SESSION['extrapart'] = (isset($_GET['county'][0]))?"WHERE County='".mysql_real_escape_string($_GET['county'])."'":"";

$query = "SELECT * FROM locations $_SESSSION[extrapart]";
?>

[erme]

<?php
$_SESSION['extrapart'] = (isset($_GET['county'][0]))?"WHERE County='".mysql_real_escape_string($_GET['county'])."'":"";

$query = "SELECT * FROM locations $_SESSSION[extrapart]";
?>

 

Dosen't seem to work 

[DEVILofDARKNESS]

ofcourse,

it should be:

$query = "SELECT * FROM locations $_SESSION['extrapart']";

 

and if that doesn't work:

$extrapart = $_SESSION['extrapart'];
$query = "SELECT * FROM locations $extrapart";

 

BTW don't forget to include as first line above the html in your php:

session_start();

 

And I think something is wrong with your query:

SELECT * FROM locations $extrapart

what should the variable extrapart contain?

[erme]

$extrapart = (isset($_GET['county'][0]))?"WHERE County='".mysql_real_escape_string($_GET['county'])."'":"";

 

so it will be something like ?county=devon

[mikesta707]

in index.php

$extrapart = (isset($_GET['county'][0]))?"WHERE County='".mysql_real_escape_string($_GET['county'])."'":"";

$_SESSION['extra'] = $extrapart;//or just set the session var to the above

 

then in your locations page either use the session var or set the variable to the session var's value.

 

also, I don't know if you want to select everything from your database if the county isn't set, but currently your script will only select entries of a certain county if it's set, and everything from the table if the county isn't set. you may want to change this if this isn't desired

 

[erme]

then in your locations page either use the session var or set the variable to the session var's value.

 

Sorry I don't understand

[mikesta707]

...

 

in

$query = "SELECT * FROM locations $extrapart";
$result = mysql_query($query);

 

instead of extrapart variable, use the session variable (in my code's case, $_SESSION['extra']) or set the $extrapart variable to $_SESSION['extra']

[erme]

So it will be

 

$query = "SELECT * FROM locations $extra";
$result = mysql_query($query);

[erme]

Whata star!!! Thanks .. it works!