I think I got it.
I just replaced the "between" with "<=".
thanks for all you help. Really appreciate it.
Donovan
Search found 14 matches
- Wed Jun 23, 2010 9:09 am
- Forum: Databases
- Topic: search query
- Replies: 13
- Views: 2774
- 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&...
- 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...
- 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...
- 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
My knowledge of mysql is quite limited
Thanks
Donovan
- 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...
- 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!
Thank you very much!
- 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...
- 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?
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?
- 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...
- 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
Thanks to everyone who helped me. Really appreciate it.
cheers. Have a brilliant week.
Donovan
- 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...
- 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...
- 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...