Trying to make a row field searchable(state location in this case)

[Jdog]

Hi,

 

As title reads I am looking for a way to make the state field name searchable, even by way of a url

example: www.site.com/index.php?page=home&state=victoria

 

The directory script software I got has a home page with a seach box where you select your state from a drop down, hit search and then it narrows down the results and shows the number of the results next to the categories "dogs(2)", but I am trying to find a way that I can create a link directly to a page which displays the records from that state, the idea behind it is to create more links for SEO purposes.

 

If anyone could shed light on how I could do this or how I could figure out how I'd be greatly appreciative.

[Barand]

Which particular bit are you having a problem with? Show the relevant code.

[Jdog]

Thank you for responding, my problem is I'm not sure how I would target the URL to filter (by location in this case).

 

I can do www.site.com/index.php?page=home&category=1

 

And it will list all the results in category 1, i've tried location=victoria, location=2(the id of the state in the mysql database)

 

I just don't know where to look to troubleshoot if this is possible(sorry I am very new to php so my terminology isn't the best).

 

I can provide information from the mysql database if required, I just don't know what info is required.

[Jdog]

Just an update, the software providers got back to me and said for this function to be available I'll need to pay an "additional feature" fee

 

EDIT:

 

Just got an e-mail back..

 

"If you want to do it yourself, I can tell you as much as, you would need to do a MySQL query which loops through the database and pulls out results based on the listing owner, then you would need to output those results into the HTML.

 

Search for MySQL queries and how to get records out of a database with PHP.If you want to do it yourself, I can tell you as much as, you would need to do a MySQL query which loops through the database and pulls out results based on the listing owner, then you would need to output those results into the HTML.

 

Search for MySQL queries and how to get records out of a database with PHP."

 

So I guess I'll start there, so for wasting any readers time by not understanding the terminology enough to ask the right questions.

[Jessica]

Pay the fee.

[Jdog]

Thanks for the reply, they aren't getting back to me now (best customer support ever), so I'll guess I'll be looking into other options.

[Barand]

i've tried location=victoria, location=2(the id of the state in the mysql database)

 

 

Which one you use will depend on what the table you want to search contains, the name or the id. (If designed properly it should be the id).

[Jdog]

The "state" and "city" are in a LOCATION table where they have IDs, i.e. Victoria has the ID of 2, the records in the LISTINGS table have state defined by word, i.e. "Victoria".