wemustdesign

Hi, I have a database that contains the following tables: - State - Town - Zip Code I have a searchbox, when a users submits I want to search all 3 tables for a match. What is the best way of doing this?

Thats on the same lines as I was thinking about doing it, I didn't want to jump in though. Thanks for the reply

You need to wrap them in a div #tabsWrapper{ width:1000px; margin:0 auto; } you may also want to add a width for the .tab class

Its going to be a little bit like a estate agent/ real estate website, so the shortlist will hold as many as they add really. To save the shortlist they have created they will have to register but they can initially use the system while they are browsing the webiste for the first time.

I am creating a 'add to shortlist' feature where users can add items to be viewed later. I don't want the user to have to register to use this feature. What would be the best way to store these items; in a database, cookie or in a session (and maybe save to a database if they register)? It is basically going to work similar to a shopping cart just without the checkout stage and prices

form.php (just a normal form) functions.js $(".submitLocation").click(function() { var name = $("#name").val(); var dataString = 'name=' + name; $.ajax({ type: "POST", url: "updateDatabase.php", data: dataString, success: function(){ $('.success').fadeIn(200).show(); } }); updateDatabase.php this is just a simple php file which inserts the data sent Basically what I want is to add a 'step 2' of the form. This is where the user can add photos to the listing. To do this I need to get the 'name' that the user submitted in form.php.

My whole webiste is based around Google Maps and is loaded full of JS so if they do not have JS turned on they will only get a noscript error message

I have created a form, basically this is the data flow - Form.php Passes the data to - Functions.js This validates the data etc If valid passes the data to - updateDatabase.php Adds the values from the form to the database Now I want to display the data on the original form page (form.php). I have tried the get 'Functions.js' to pass the data back to 'form.php' but can't get it working. Can anyone reccomend a way to do this or can point me in the direction of a related tutorial?

I have a category table to categorise all of my subjects. This way they can output (when I get it working) in a category structure and will be used for other things as well. Animals (Cat) Tiger (Subject) Birds Lion Buildings (Cat) Castles (Subject) Church

Hi, Thanks for the reply, yes I am going to code this in PHP. I know you can order by 2 columns but how would this work is what I am wandering? So if I 'ORDER BY name ' for the categories how do I then output all of the subjects under that category before the mysql outputs the next category? This is the part I cannot get my head round?

What I don't understand is the order by bit, how would I output 'Animals' cat and then all of the animals from a different table and then 'Buildings' cat and all the buildings from another table. How would I create this kind of order?

Hi, I have two tables and I am wanting to output them all on a page but I would like to do this by sorting them by cat name so would look like: Animals Tigers Dogs Buildings Castles This is how I have my tables set up: tbl: subject id name cat 1 Tigers 1 tbl: cat id name 1 Animals any ideas are much appreciated

Solved: Changed WHERE to HAVING

I know I do not have a distance column, I am using the calculation as distance AS distance FROM `location` WHERE distance <

Hi, I am using this query to list the closest distances to a certain lat/ lon $qry = "SELECT *,(((acos(sin(($lat*pi()/180)) * sin((`lat`*pi()/180))+cos(($lat*pi()/180)) * cos((`lat`*pi()/180)) * cos((($lon- `lon`)*pi()/180))))*180/pi())*60*1.1515) AS distance FROM `location` WHERE distance <= 10"; I am getting an error: Unknown column 'distance' in 'where clause' Can anybody see what the error is?