RJP1

Thanks for the help. Does this keep the fulltext column as it is? It doesn't delete it or anything? RJP1

Hi guys, What's the best way to iterate though a table similar to this: ID | Introtext | Fulltext ... and add the fulltext data onto the end of the intro text data? Basically combining the intro and full text into one column? Can I do this in PHP? E.g. ID | Introtext | Fulltext -------------------------------------------------- 1 | <p>intro</p> | <p>main text</p> and turn that into ID | Introtext | Fulltext ----------------------------------------------------------------------- 1 | <p>intro</p><p>main text</p> | <p>main text</p> Thanks guys! RJP1

Hi guys, My host doesn't allow outbound or inbound MySQL connections, is there any way to overcome these settings so my sites can talk? Thanks, RJP1

Hi thorpe, sorry, yeah I know that. What I want to do is have the above function working as is (i.e. rotating 2 images). But when I hover over it, show a different image. I have got this far, and have managed to hide the image again on mouseout. However, re-hovering over the innerfade does not re-initiate the hover image... Any ideas of how to make this functionality correctly? Cheers, RJP1

Hi guys, I'm a bit rubbish at jquery, sometimes I can get it to do as I want, other times I can't... Can you help me find the correct place to insert an extra bit to this jquery code? The code is used to fade images and it works well. However, I'm finding it hard to figure out how to get it to pause the rotation and swap in a completely different image upon mouseover. Basically, this code will rotate 2 images, but the hover over image will be different (and a link). Can anyone point me in the correct direction please? Cheers, RJP1 <script type="text/javascript"> (function($){ $(document).ready( function(){ $('ul#<?php echo $uniqueid; ?>').innerfade({ speed: <?php echo $speed; ?>, timeout: <?php echo $timeout; ?>, type: '<?php echo $display; ?>', containerheight: '<?php echo $height; ?>px' }); }); })(jQuery); </script>

AbraCadaver, that worked a treat! Thanks a lot, really appreciated! This has helped me understand arrays a bit better! Cheers, RJP1

Hi guys, I'm trying to sort an array. The array has information about listings. ID, name, info etc. An unrelated set of data also contains the listing ID's and I have made a function to sort this array and show an new order for the ID's. I now need to sort the original array by this new ID order... This snippet shows that the original listings array can be sorted by link_id: sort($this->links, $this->link->link_id); //This works. It sorts links by link ID! In a foeach loop I have created this: $sleeps_array[] = array("ID" => $link->link_id, "Sleeps" => $sleeps); // Makes an array of arrays of a custom field with listing ID. It makes this: array ( 0 => array ( 'ID' => '9', 'Sleeps' => '2', ), 1 => array ( 'ID' => '3', 'Sleeps' => '4', ), 2 => array ( 'ID' => '6', 'Sleeps' => '6', ), ) I can then sort this array of arrays with this function: function compare_sleeps($a, $b){ return strnatcmp($a['Sleeps'], $b['Sleeps']); } # sort alphabetically by name usort($sleeps_array, 'compare_sleeps'); It then gives me a sorted array according to "Sleeps" (as in, the number of people a property can cater for). It has the correct order of ID to then output but how do I organise the original array by ID with this new array? Sounds complicated, I hope you got that! Cheers, RJP1

I'm going to be looking at this again today, I had a brief break from it. Anyone have any ideas of how I should go about this? Cheers, RJP1

This data is actually held in var_export($fields). E.g. 'Sleeps', 'value' => '2', RJP1

Ah, it wasn't cut off, just below the listings... but it doesn't show the data for this custom field (well, not obviously anyway...).

I did this: var_export($sleeps_array); var_export($this->links); For the first $sleeps_array I got: array ( 0 => '6', 1 => '4', 2 => '2', ) For the second array (the one which looks like has all the listing data - and also looks "cut off"): array ( 0 => stdClass::__set_state(array( 'link_id' => '6', Thanks for the help! RJP1

Hi guys, I'm trying to modify a Joomla listings directory component to have a sorting capability on category pages that list listings. A bit like eBay, price high to low etc. The basic code that outputs each listing is as follows... foreach ($this->links AS $link) { $fields = $this->fields[$link->link_id]; include $this->loadTemplate('sub_listingSummary.tpl.php'); } I have so far been able to get the contents of an extra field into an array within this foreach loop like this: $sleeps_array = array(); foreach ($this->links AS $link) { $fields = $this->fields[$link->link_id]; $sleeps = $fields->getFieldById(51); if(!is_null($sleeps) && $sleeps->hasValue()){ $sleeps = $sleeps->getOutput(1); $sleeps_array[] = $sleeps; } include $this->loadTemplate('sub_listingSummary.tpl.php'); } sort($sleeps_array); foreach ($sleeps_array as $key => $val) { echo "sleeps_array[" . $key . "] = " . $val . "\n"; } I've got this far but simply adding the include file to the new loop for "sleeps" does not work. I think I need to some how link the 2 arrays so that I can sort listings by the custom field... Can anyone point me in the correct direction? Thanks! RJP1

Guys, this was great! mjdamato especially, I learnt a lot from your post, thanks dearly! Really appreciated! Now to edit the style... RJP1

Hi guys, This is hard to explain... I'll try. I have a MySQL table for articles, each article is in a section (id). I can do a while loop to create a HTML table of title, section etc. How do I split the code so that I create a new HTML table per $row['sectionid']? Any ideas would be great! I can group by section and then title in the table, but i'd rather not have the section id/or name repeated in a column for every article in a particular section if you get me...? Simplified code below. Cheers, RJP1 public function listArticle() { require_once('../includes/DbConnector.php'); $connector = new DbConnector(); $result = $connector->query('SELECT * FROM article ORDER BY section, title'); echo '<h2>Articles:</h2>'; if ( $result !== false && mysql_num_rows($result) > 0 ) { echo '<table id="table"> <thead> <tr> <th scope="col">Title</th> <th scope="col">Section</th> <th scope="col" style="text-align:center;">Edit?</th> <th scope="col" style="text-align:center;">Delete?</th> </tr> </thead> <tbody>'; while ($row = $connector->fetchArray($result)){ echo '<tr><td>'.$row['title'].'</td>'; echo '<td>'.$row['section'].'</td>'; } } echo '</tbody> </table>'; return; }

Ah thanks AbraCadaver, I tried something very similar but it kept giving the year as 1969! Cheers for the speedy help, really appreciated! RJP1

Hey guys, for the life of me, I can't find the right php technique for converting a date/time number format into something useful... e.g 2010-09-16 12:09:19 to 16th September 2010 If you could point me in the correct direction, that would be great! Cheers, RJP1

Nevermind! I figured it out. Basically, I solved it earlier but didn't change the $result variable within the loop which somehow conflicts with the main $result query in the loop... Cheers anyway!

Hi guys, I've been teaching myself OOP based PHP for a CMS project. I was wondering if you could help me with a slight sticking point? I have 2 tables, one for articles, one for sections. In the articles table, each article is given a section ID (rather than the section name). When I output articles in a loop (limit of 3, to test) I can get the title, the section ID and the content. However, how do I reference the section table to get the corresponding section ID name? I've attached my code so you can see: public function display_public() { require_once('includes/DbConnector.php'); $connector = new DbConnector(); $result = $connector->query('SELECT * FROM article ORDER BY created DESC LIMIT 3'); if ( $result !== false && mysql_num_rows($result) > 0 ) { while ( $a = mysql_fetch_assoc($result) ) { $title = stripslashes($a['title']); $section = stripslashes($a['section']); $bodytext = stripslashes($a['bodytext']); #### Article variables are out put here as part of the loop #### } Thanks for the help! RJP1

Sorry, no difference. If either is true, the count should be "1"... hard to explain, sorry! RJP1

Hi Fenway, At the moment all 3 conditions must be met in order to be counted as +1. I'd like it to count +1 if all 3 are met, or if 2 conditions are met, count still = 1. Is that doable? Cheers, RJP1

I had a look at joins and it seems it's for multiple tables... the issue I have here is a single table but with a condition. Can anyone suggest a method of solving my problem? Thanks, RJP1

Thanks for the point in the right direction hamza, really appreciated. I'll have a look! Cheers, RJP1

Hi guys, I'm a bit stuck here. I've got it mostly working but can't complete my next task. Basically, I have a table where each user has 3 fields and each field has a value. eg user_id | field_id | value 1 | 1 | UK 1 | 2 | Yes 1 | 3 | 1 2 | 1 | USA 2 | 2 | Yes 2 | 3 | 4 I'm trying to count users who match a few conditions. In order to count as 1, the user must be from the country specified in my loop and have a field_id 2 = Yes and field_id = specified by the loop again. This is what I have so far - it counts just by country which is promising but I don't know how to make a conditional mysql statement where if all 3 fields (country, yes, ID) = the specified reference OR country and yes are true. It must prefer the 3 statements being true, then if the 2 are true... (in other words, if either statement is true, count = 1). Here is what I have so far: $sql = "SELECT COUNT(*) FROM `fields_values` AS tab1, `fields_values` AS tab2, `values` AS tab3, `fields_values` AS tab4 WHERE tab1.user_id = tab2.user_id AND tab2.user_id = tab3.user_id AND tab3.user_id = tab4.user_id AND (tab1.field_id = 11 AND tab1.value = '$item->website') AND (tab2.field_id = 16 AND tab2.value= 'Yes') AND (tab3.field_id = 17 AND tab3.value= '$item->id') AND (tab4.field_id = 18 AND tab4.value>='$date_first' AND tab4.value<='$date_last')"; Thanks for the help! RJP1

Hi guys, I'm stuck... I need to count users who meet certain conditions on this table: Code: user_id | field_id | value --------------------------- 1 | 1 | UK 1 | 2 | Yes 1 | 3 | 1 2 | 1 | USA 2 | 2 | No 2 | 3 | 2 As you can see, users are grouped in 3's (one row per field). How do I count users who meet these conditions? a) if country (field 1) = specified country AND field 2 = Yes ---> counted as 1 b) if country (field 1) = specified country AND field 2 = Yes AND field 3 = specified number ---> counted as 1 Output should be total of a) and b) If anyone could help me with this, that would be awesome! I need the MySQL and PHP statements... Thanks! RJP1

Hi guys, I'm a bit stuck here. I've got it mostly working but can't complete my next task. Basically, I have a table where each user has 3 fields and each field has a value. eg user_id | field_id | value 1 | 1 | UK 1 | 2 | Yes 1 | 3 | 1 2 | 1 | USA 2 | 2 | Yes 2 | 3 | 4 I'm trying to count users who match a few conditions. In order to count as 1, the user must be from the country specified in my loop and have a field_id 2 = Yes and field_id = specified by the loop again. This is what I have so far - it counts just by country which is promising but I don't know how to group the user_id's together and make a conditional mysql statement. Unless it's doable by php with a general SQL statement? $sql3 = "SELECT * FROM `jos_community_fields_values` WHERE `field_id` = '11' AND `value` = '$item->website'"; $result3 = mysql_query($sql3); $country = mysql_num_rows($result3); echo $country; Thanks for your help, really appreciated! RJP1