Search found 14 matches

by DonthDragon
Wed Jun 23, 2010 9:09 am
Forum: Databases
Topic: search query
Replies: 13
Views: 2774

Re: search query

I think I got it.
I just replaced the "between" with "<=".

thanks for all you help. Really appreciate it.

Donovan
by DonthDragon
Wed Jun 23, 2010 1:21 am
Forum: Databases
Topic: search query
Replies: 13
Views: 2774

Re: search query

Thanks for the help. My problem though is that I wont know what amount the user will put in the input field. Could be any random number. This is my search form : <form action="search_results.php" method="post"> <fieldset> <legend>Search for a venue</legend> <label for="area&...
by DonthDragon
Tue Jun 22, 2010 3:16 am
Forum: Databases
Topic: search query
Replies: 13
Views: 2774

Re: search query

Thanks. I had a feeling the "between" was wrong. Just looking at the link you gave me, I see there is something that might work. Its the : "<=" (Less than or equal operator) How can I add that into my query, so that it looks for all "venues" that can hold the same amoun...
by DonthDragon
Mon Jun 21, 2010 11:22 am
Forum: Databases
Topic: search query
Replies: 13
Views: 2774

Re: search query

my form goes to a "results.php" page. This handles the search : <?php $area = $_POST['area']; $category = $_POST['category']; $max_guests = $_POST['max_guests']; $db = mysql_connect(localhost,'root','****') or die("could not connect"); mysql_select_db('****') or die( "Unable...
by DonthDragon
Fri Jun 18, 2010 3:52 am
Forum: Databases
Topic: search query
Replies: 13
Views: 2774

Re: search query

please can someone help me out on this.
My knowledge of mysql is quite limited

Thanks
Donovan
by DonthDragon
Tue Jun 15, 2010 5:59 am
Forum: Databases
Topic: search query
Replies: 13
Views: 2774

Re: search query

Thanks for your responses. I still seem to be a bit stuck here though. What will happen : The user will put in any random number for the field "maximum number of guests". I want the search to find all venues that can hold the amount of guests that the user puts in. How would i construct my...
by DonthDragon
Tue Jun 15, 2010 12:52 am
Forum: Databases
Topic: search query
Replies: 13
Views: 2774

Re: search query

Thats sounds like exactly what i need.
Thank you very much!
by DonthDragon
Mon Jun 14, 2010 4:02 am
Forum: Databases
Topic: search query
Replies: 13
Views: 2774

search query

Hi. I would like to do a search on my website. I seem to be stuck with one small thing though. My website contains conference venues that can each seat a certain amount of delegates. I have a form which states on one of the field inputs : "maximum amount of people". The user will put in eg...
by DonthDragon
Sat Jun 05, 2010 3:30 am
Forum: Databases
Topic: Database creation query
Replies: 2
Views: 1074

Re: Database creation query

Thanks for your response.

That does pretty much sound like what I need.
I have been doing some research and think a "left-join" might be the right approach to get the tables to relate to each other.
Am I on the right track?
by DonthDragon
Fri Jun 04, 2010 3:33 pm
Forum: Databases
Topic: Database creation query
Replies: 2
Views: 1074

Database creation query

Hi. I am fairly new to mysql database design, so am not sure about the best route to take on my next project. I am creating a website that accommodates the following categories : 1. Conference venues 2. Wedding venues Both conference and wedding venues will have accommodation facilities. I would lik...
by DonthDragon
Tue Feb 09, 2010 1:56 am
Forum: PHP - Code
Topic: php pagination
Replies: 7
Views: 373

Re: php pagination

Hi. Just want to say that I have finally sorted the problem out (along with some new grey hairs).

Thanks to everyone who helped me. Really appreciate it.

cheers. Have a brilliant week.
Donovan
by DonthDragon
Wed Jan 13, 2010 3:55 am
Forum: PHP - Code
Topic: php pagination
Replies: 7
Views: 373

Re: php pagination

ok. I have tried to implement the code, but still cant seem to get it right. Please can you have a look at my updated code.   <?php require_once('Connections/propProfile.php'); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.d...
by DonthDragon
Mon Jan 11, 2010 5:18 am
Forum: PHP - Code
Topic: php pagination
Replies: 7
Views: 373

Re: php pagination

Thank you for getting back to me. I apologise if I sound uneducated on this issue (because I probably am), Im actually doing a property website and need results to show from a search query. Below is my exact code :   <div id="house">             <h2>Search results</h2>                 <?ph...
by DonthDragon
Sun Jan 10, 2010 4:11 am
Forum: PHP - Code
Topic: php pagination
Replies: 7
Views: 373

php pagination

Hi. I am pretty new to php and am struggling to get a php pagination going. I found a script to help me out, but I cant understand how I can call items from a database and the put it into an array. Below is a snippet of the code   //create an array of names in alphabetic order. A database call could...