The detail page will be used to display all the info on a specific establishment, so my detailRS1 Recordset is the actual detail recordset and not the images recordset. Not sure if it makes sense? Let me paste the code here: $maxRows_DetailRS1 = 10; $pageNum_DetailRS1 = 0; if (isset($_GET['pageNum_DetailRS1'])) {   $pageNum_DetailRS1 = $_GET['pageNum_DetailRS1']; } $startRow_DetailRS1 = $pageNum_DetailRS1 * $maxRows_DetailRS1; $colname_DetailRS1 = "-1"; if (isset($_GET['recordID'])) {   $colname_DetailRS1 = $_GET['recordID']; } mysql_select_db($database_test, $test); $query_DetailRS1 = sprintf("SELECT * FROM name WHERE id = %s", GetSQLValueString($colname_DetailRS1, "int")); $query_limit_DetailRS1 = sprintf("%s LIMIT %d, %d", $query_DetailRS1, $startRow_DetailRS1, $maxRows_DetailRS1); $DetailRS1 = mysql_query($query_limit_DetailRS1, $test) or die(mysql_error()); $row_DetailRS1 = mysql_fetch_assoc($DetailRS1); if (isset($_GET['totalRows_DetailRS1'])) {   $totalRows_DetailRS1 = $_GET['totalRows_DetailRS1']; } else {   $all_DetailRS1 = mysql_query($query_DetailRS1);   $totalRows_DetailRS1 = mysql_num_rows($all_DetailRS1); } $totalPages_DetailRS1 = ceil($totalRows_DetailRS1/$maxRows_DetailRS1)-1; mysql_select_db($database_test, $test); $query_Recordset1 = "SELECT * FROM images"; $Recordset1 = mysql_query($query_Recordset1, $test) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); ?> //head //body <div id="content">   <img src="Images/heading_index.png" alt="Search, Browse and find &lt;b&gt;Accommodation in South Africa&lt;b&gt;" width="735" height="33" hspace="80" vspace="10" />   <p><?php if ($row_Recordset1['usrID'] = $row_DetailRS1['id']) { ?>   <img src="<?php echo $row_Recordset1['path']; ?>" /> <?php } ?></p>   <table border="1" align="center">   <tr>     <td>id</td>     <td><?php echo $row_DetailRS1['id']; ?></td>   </tr>   <tr>     <td>name</td>     <td><?php echo $row_DetailRS1['name']; ?></td>   </tr>   <tr>     <td>province</td>     <td><?php echo $row_DetailRS1['province']; ?></td>   </tr>   <tr>     <td>city</td>     <td><?php echo $row_DetailRS1['city']; ?></td>   </tr>   <tr>     <td>type</td>     <td><?php echo $row_DetailRS1['type']; ?></td>   </tr>   <tr>     <td>price</td>     <td><?php echo $row_DetailRS1['price']; ?></td>   </tr>   <tr>     <td>website</td>     <td><?php echo $row_DetailRS1['website']; ?></td>   </tr>   <tr>     <td>email</td>     <td><?php echo $row_DetailRS1['email']; ?></td>   </tr>   <tr>     <td>fax</td>     <td><?php echo $row_DetailRS1['fax']; ?></td>   </tr>   <tr>     <td>landline</td>     <td><?php echo $row_DetailRS1['landline']; ?></td>   </tr>   <tr>     <td>cell</td>     <td><?php echo $row_DetailRS1['cell']; ?></td>   </tr>   <tr>     <td>contact_name</td>     <td><?php echo $row_DetailRS1['contact_name']; ?></td>   </tr>   <tr>     <td>caontact_surname</td>     <td><?php echo $row_DetailRS1['caontact_surname']; ?></td>   </tr>   <tr>     <td>profile_pic</td>     <td><?php echo $row_DetailRS1['profile_pic']; ?></td>   </tr>   <tr>     <td>username</td>     <td><?php echo $row_DetailRS1['username']; ?></td>   </tr>   <tr>     <td>password</td>     <td><?php echo $row_DetailRS1['password']; ?></td>   </tr> </table>   master </div> Hope you can make more sense of what I am trying to do. Not sure how to explain it. This is only a test page but all the basic information is there ... View more

$query_Recordset1 = "SELECT * FROM images"; This the query you are talking about? ... View more

<?php if ($row_Recordset1['usrID'] = $row_DetailRS1['id']) { ?>   <img src="<?php echo $row_Recordset1['path']; ?>" /> <?php } ?> It works if I use the above so I'm on the right track I believe. Only problem still is that it displays an image with userID 9 even though I'm on a user with id10. What is missing from this function to let only the images where the id matches that of the userID display? ... View more

Thanks for the good luck David. I took your advice and went back to the drawing board. I decided to try my first strategy again from scratch where I store the image path in a different database table and then link that image to a user with the userID. I was just wondering if it could work if I put a small if function on my details page to display a users' images like this: <?php if ($row_Recordset1['usrID'] = $row_DetailRS1['id'])   echo "<img src="$row_Recordset1['path']"/>"; ?> That's the exact code I tried and it gave me an error like this: Parse error: syntax error, unexpected T_VARIABLE, expecting ',' or ';' in C:\public_html\TravelTo\detail.php on line 135 Of the 3 lines of code I provided above the second line is line 135, and I don't really understand what the problem is since I put the ';' there. I'm obviously missing something crucial. Can you please tell me what I'm doing wrong and if a function like that will work at all? I'm not joining the 2 tables like I did before and was hoping to achieve the results I wanted just by adding a function like that to display all the images in the table where the userID matches that of the user's id in the details table. P.S I had a look at your website and your books. Which one of your books would you recommend to a complete novice like myself? Regards ... View more

I have decided on another approach so this thread probably no longer qualifies as I will only use one table. I will explain anyway. I put together a small function that will create a unique directory for each user's images, then a function with some php and javascript that calls the folder and displays all the images in that users' image directory. I store the path to the images directory in the table along with all the other details. That way there are no issues with duplicate results etc. and only one entry for each establishment to work with, much much easier. Thanks for all the help anyway David. I appreciate it a lot. ... View more

So in that case I will have to create a page for each establishment manually? I just had a look at my facebook profile to try and learn something from this. My url for my facebook profile looks like this: http://www.facebook.com/profile.php?id=762039663 While my images URL look like this: http://www.facebook.com/profile.php?id=762039663&v=photos I don't want to copy facebook's methods, but that only proves that there is a simpler way to do this. Do you maybe have any idea how I can do that? Sorry I'm not very clued up with these things as you have probably noticed. lol. But I appreciate your help and patience very much. Thanks ... View more

I understand what you mean, yes. I am building a website with a travel directory. A guest-house for example should be able to upload images of his establishment to my website. When a client does a search for guest houses, a list of guest houses will appear. That will be the master page. When you click on an establishment name, you go to his "profile" which is the detail page. It is there I want to display the images, not next to the name on the master page. I have no problem with uploading and handling one image per establishment. I am trying to figure out how I can manage all those images for an establishments' "image gallery". How does all these social websites handle all the images? Like on facebook your images are linked to your profile. When I click on your profile on facebook, all the images you have uploaded are available to view. So obviously all your images are linked to your facebook user ID in some way. I want to achieve something like that. I can't find anything on google or anywhere else for that matter. Hope this makes better sense? ... View more

Yeah you're right of course. It does work, to some extent. Now I get results like this: ID Name 1  Ben 1  2  John 3  Sarah I successfully removes the duplicate names but the record is still there, only the name doesn't show. Isn't there an easier way to do this? I still want to store the images like I do, but without the hassle I'm having now. Right now my recordset query looks like this: SELECT details.id, details.name FROM details LEFT JOIN images ON images.usrID = details.id Is there a way that I can just display the images for a user without joining the tables and sitting with this problem? ... View more

Hi David, thanks for your help. From what I understand of the suggestion you made for suppressing the display of duplicate results, this will only suppress the display of duplicate images? Forgive me if I'm wrong, could you then please explain the function to me in more detail? Let me try to lay out what I'm trying to achieve: I am trying to make a master/detail page set. On the master page, the results are shown as I have mentioned, duplicated if there is more than one image per name stored in the images table. That is also the reason I am trying to join these two tables, so that when the ID carries over to the detail page, the userID from the images table will  display the images uploaded by that user. The detail table will have data like this: ID Name 1  Ben 2  John 3  Sarah The images table like this: ID userID imgPath 1  1         /Images/image1 2  1         /Images/image2 3  3         /Images/image3 So on the master page the results from the detail table will be displayed. I will link to the detail page from the name and unique id will be carried over to the detail page by the ID. On the detail page, if the userID matches that of the ID from the detail table, all the images with that user's ID must be displayed. The problem is that on the master page, if user ID 1 (Ben) has uploaded 2 images, the results on the master page will look like this: ID Name 1  Ben 1  Ben 3  Sarah I want it to display every record only once like: ID Name 1  Ben 3  Sarah Even though Ben has 2 images. I have a hard time explaining myself so hope this makes sense to you? Please let me know if you need anything else? Regards ... View more

If you join tables with a one-to-many relationship, then you are going to get duplicated results from the user table. So there is no way to get only one result per user? Sorry about not making sense. I'm not sure how to put it or exactly what information you will need, but let me give it a shot: I have two tables- 1.Details and 2.images The details table is self-explanatory. A user can log in and  upload images to his gallery with the filename/path stored in the database - in the images table. The images table has 3 columns, picID, userID and filepath. The user ID is the ID of the user that uploaded the images so all the images with his user ID is all the images he uploaded and I want to display all those images accordingly with each user's ID. When a client does a search, I get more than one result per user at this time, because there is more than one image per user. What I want to do, is to create a recordset where all the fields are present, including image data, but without displaying every record twice because there is more than one image linked to that user. I don't want any one specific image, I want all the images available for that user. I have created a recordset joining the 2 tables like this. eg: SELECT details.id, details.name, images.`path` FROM details, images WHERE images.usrID = details.id; Something like that. SELECT DISTINCT won't work obviously since every row is different because of the image path. Hope this makes better sense. Please let me know if there is something specific you need. If there is a better way to do this that you know of, please let me know. ... View more

Hi, So sorry I couldn't get back to you sooner. My internet was down due to cable theft. WTF right? Only one place where that could happen. Welcome to South Africa. But thanks a lot for your  help  on the matter. I appreciate it a lot. Hope you have a great day. Regards ... View more

It makes a lot of sense. Only I don't know how it's implemented. That's what I'm doing here trying to learn. Your help to me is priceless. You don't have to write me a script, although a quick example would be nice. I am figuring this out bit by bit and making progress. I don't just want to copy someone's work and use it without knowing what's actually happening "behind the scenes". So please can you explain as you go (in human language. LOL.) that would be great if it doesn't cause too much trouble. If possible also explain what's happening in the first script? I understand most of it, but maybe someone else comes along in a few days then this could help him *wink wink* Thanks iPHP ... View more

Sorry bregent,didn't refresh my page before posting so didn't see your message coming in. Yes I do already have a column to store the subscription length but as I said it's in text format. To minimize/eliminate complicated coding, I want to "pre-calculate" the expiration date so it gets inserted into my table already as the date my query should use to check if the subscription is near expiry. There should be a way to do this but I am unaware of anything and if there is a better way please can you help me out by letting me know what it is? ... View more

Can I maybe add a function into the radio button values that would set the expiry date to 3/6/12 months after current timestamp based on selection? I can't find anything on google about this or maybe I'm not using correct search terms but maybe someone knows? I don't know if this is possible? But instead of normal text saying 3 Months when someone clicks on the 3 months option radio button, can't I do something that will set the 3 Months to CURRENT_TIMESTAMP + 3 Months so it gets added as DATE datatype into expiry_date column? In my code the value that gets inserted looks like: GetSQLValueString($_POST['book_period'], "date") Is there maybe an if statement to use? Something like if  selected value = 6 months then CURRENT_TIMESTAMP + 6months? I have tried some but couldn't get it to work. ... View more

Can I maybe add a function into the radio button values that would set the expiry date to 3/6/12 months after current timestamp based on selection? I can't find anything on google about this or maybe I'm not using correct search terms but maybe someone knows? I don't know if this is possible? But instead of normal text saying 3 Months when someone clicks on the 3 months option radio button, can't I do something that will set the 3 Months to CURRENT_TIMESTAMP + 3 Months so it gets added as DATE datatype into expiry_date column? ... View more

Hi bregent, thanks I understand that, but how do I actually do it? In which datatype format should my column for application period be and the also the value? I am using a simple form to submit the data, the value for the radio buttons are 3 Months, 6 Months, 12 Months. But in what format should that value be to go with what datatype? Something like DATE datatype maybe? Then what should the values be for the radio buttons instead of just a varchar 3 Months or 6 Months or whatever? thanks ... View more

Feels like I'm not making sense even to myself. Sorry about that. What I wanted to say was that I need a column for the expiration date, so in the form the user uses to subscribe, they have 3 options with simple radio buttons. 3 months, 6 months or 12 months. I already have a column for the current timestamp that the user subscribed where the default value is set to 'CURRENT_TIMESTAMP' so when a user selects an option from the three radio buttons, I need the table to automatically add an expiration date based on the option selected like it adds the current timestamp. For date_subscribed the default value is 'CURRENT_TIMESTAMP' so what should I do to add 3/6/12 months based on the selection? Hope I make sense this time ... View more

Maybe I should ask how do I set an expiration date? I didn't think of that when I said "all necessary information". I have a column with CURRENT_TIMESTAMP option for when user subscribes. But obviously if I want to use WHERE expiration_date < NOW() I have to have a column that sets an expiration date based on the option the user selected (3 months, 6 months, 12 months). I have a column that uses the value of the subscription period but in varchar. I'm baffled. Please can you explain to me how to do this if I add a column expiration_date? ... View more

What syntax would I use if I want to change WHERE expiration_date < NOW() to WHERE expiration_date < (one month/one week prior)? ... View more

I'm testing it right away. Will let you know what happens. Thanks a lot!!! ... View more

Thanks for the quick reply. I have no idea how to structure such a query. Do you maybe have a link or something to a site that can teach me to do that? Meantime I will keep searching and post here if I find something. ... View more

Thanks Lon ... View more

Yeah, thanks. You set me thinking with your wildcard and I realised I only had one parameter running. Stupid of me. Will make sure next time before I waste my own or anyone elses' time again bby posting obvious questions. Anyway, thanks. ... View more

I'm not very sure that I understand correctly what exactly you need. I am trying (without success) to create a search page that searches multiple columns at the same time. In one of my unsuccessful attempts I stumbled upon a Dreamweaver function that could help you (that is if I understand you correctly). your search form action should redirect the user to the result page on submit. On the results page, go to your bindings tab and double click on your recordset to bring up the recordset properties box. To create the database filter for the search, complete the fields in the Filter area as follows: • For the first Filter field, select the database column you want to search. • For the second Filter field, select how to filter your results: Contains, Begins With, Ends With, or Numeric Comparisons. • For the third Filter field, select Form Variable if your form uses the POST method, or URL Parameter if it uses the GET method. • For the fourth Filter field, enter the name of the search field from the search page. Hope this helps. Let me know. Reandré ... View more

Anyone? ... View more

I have a question regarding the information you gave me. I am able to create the master/detail relationship between the datasets and everything. I also managed to get the Master container into the <select> form with spry:repeatchildren function. I can also get the detail container into <select> form but unable to display necessary information based on selection in master collumn. i.e Select province but cities doesn't repopulate. My guess is I'm missing some sort of JavaScript. i'm vouching for the onChange function in the first dropdown. But I have no clue about how JavaScript operates. Please can you have a quick look and let me know what's wrong and if you have any suggestions I will appreciate it very much. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xmlns:spry="http://ns.adobe.com/spry"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <script src="SpryAssets/xpath.js" type="text/javascript"></script> <script src="SpryAssets/SpryData.js" type="text/javascript"></script> <link href="SpryAssets/SpryMasterDetail.css" rel="stylesheet" type="text/css" /> <script type="text/javascript"> <!-- var ds1 = new Spry.Data.XMLDataSet("data/provinces/provinces.xml", "provinces/province"); var ds2 = new Spry.Data.XMLDataSet("data/provinces/{ds1::url}", "province/cities/city"); //--> </script> </head> <body> <div class="MasterDetail">   <span spry:region="ds1" id="provinceSelector">           <select spry:repeatchildren="ds1" name="provinceSelect" onchange="document.forms[0].citySelect.disabled = true; ds1.setCurrentRowNumber(this.selectedIndex);">                <option spry:if="{ds_RowNumber} == {ds_CurrentRowNumber}" value="{name}" selected="selected">{name}</option>                <option spry:if="{ds_RowNumber} != {ds_CurrentRowNumber}" value="{name}">{name}</option>           </select>      </span>   <span spry:region="ds2" id="citySelector">           <select spry:repeatchildren="ds2" id="citySelect" name="citySelect">                <option spry:if="{ds_RowNumber} == {ds_CurrentRowNumber}" value="{name}" selected="selected">{name}</option>                <option spry:if="{ds_RowNumber} != {ds_CurrentRowNumber}" value="{name}">{name}</option>           </select>      </span>   <br style="clear:both" /> </div> </body> </html> Also- is there a way to make the <option selected> option "Select from list"? When I try that, the message also repeats Thanks in advance, Reandré ... View more

Hi, I put together another PHP form to mail processing script. <?php $est_name = $_POST['est_name']; $province = $_POST['province']; $near_city = $_POST['near_city']; $accomm_type = $_POST['accomm_type']; $norm_price_range = $_POST['norm_price_range']; $first_name = $_POST['first_name']; $surname = $_POST['surname']; $website = $_POST['website']; $email = $_POST['email']; $landline = $_POST['landline']; $cell = $_POST['cell']; $discount_from = $_POST['discount_from']; $discount_to = $_POST['discount_to']; $book_period = $_POST['book_period']; $to = '.....'; //Recipient email $subject = '.....'; //Email subject $message =     "Establishment Name: $est_name\n" .  //Message body     "Province: $province\n" .     "Nearest City/Town: $near_city\n" .     "Accommodation Type: $accomm_type\n" .     "Normal Price Range: $norm_price_range\n" .     "First Name: $first_name\n" .     "Surname: $surname\n" .     "Website Address: $website\n" .     "Email Address: $email\n" .     "Tel: Landline: $landline\n" .     "Tel: Cell: $cell\n" .     "Discount Offered: $discount_from% to $discount_to%\n" .     "Period Applying For: $book_period\n" ;       if ( preg_match( "/[\r\n]/", $first_name ) || preg_match( "/[\r\n]/", $email ) ) {      die ("We encountered an error sending your mail"); }       mail($to, $subject, $message, 'From:' . $email); if(!empty($message)&&!empty($email)) {      header("Location:.....");  //Redirect Page      exit;      print "Your mail was sent successfully"; } else {print "We encountered an error sending your mail"; } ?> Much much more user friendly and I added the security function, tested it and it works. Hope this helps better than the first one I posted. I'm still learning but making progress fast. Reandré ... View more