arcanine

Script error:MySQL said: Incorrect arguments to AGAINST with query: SELECT *, GROUP_CONCAT(`Key`,':',`Value` SEPARATOR ',') AS Tags FROM `gettomypc_groups` g LEFT OUTER JOIN ( SELECT * FROM `gettomypc_group_membership_users` WHERE IsDesignatedContact ) ug USING(`GID`) LEFT OUTER JOIN `gettomypc_users` u USING (`UID`) RIGHT JOIN `gettomypc_group_tags` gt USING (`GID`) RIGHT JOIN `gettomypc_tags` t USING (`TID`) RIGHT JOIN `gettomypc_tag_keys` tk USING (`KID`) GROUP BY `GID` HAVING MATCH (g.Name,Tags,g.SalesNotes,g.ContactInfo,u.FirstName,u.Surname,u.Organisation,u.Address1,u.Address2,u.Address3,u.Postcode,u.Telephone,u.Email,u.MobilePhone) AGAINST ('Abbey Medical Group' IN BOOLEAN MODE) ORDER BY `Name` ASC Has anyone got any ideas on this one? Is there anything wrong in the syntax that's obvious?

I have a string with images that I want to extract from "http://ecx.images-amazon.com/images/I/random filename here .jpg " is the general format within the string, how can I get the full url and push them into an array?

hello there I wanted to know if it's possible to take a rss feed such as: http://www.amazon.com/rss/tag/dvd/new and implement it into a coverflow like set up, on my own website: http://www.jacksasylum.eu/ContentFlow/index.php and what do I need to use/learn to achieve this? I don't have that much experience interpreting xml files or sorting them into different divisions etc

I would recommend using javascript if that helps, here is a snippet of code I've been using $(document).ready(function(){ // Reset Font Size var originalFontSize = $('div').css('font-size'); $(".resetFont").click(function(){ $('div').css('font-size', originalFontSize); }); // Incrementa Font Size $(".increaseFont").click(function(){ var currentFontSize = $('div').css('font-size'); var currentFontSizeNum = parseFloat(currentFontSize, 10); var newFontSize = currentFontSizeNum*1.2; $('div').css('font-size', newFontSize); return false; }); // Decrementa Font Size $(".decreaseFont").click(function(){ var currentFontSize = $('div').css('font-size'); var currentFontSizeNum = parseFloat(currentFontSize, 10); var newFontSize = currentFontSizeNum*0.8; $('div').css('font-size', newFontSize); return false; }); }); to change font size, just link that up to the correct classes and it works, some sort of modification of this might help you

Hello there I currently have a website with a general layout, I was going to include the content using iframes to call the content with my buttons to control the frame, however my javascript (used to change the text size for accessibility reasons) cannot access content within a frame (The accessibility feature will increase my marks by 5 points for this assignment I was wondering if there is any sort of alternative, I was looking at using php includes but my navigation buttons need control of the "content window" I can't just include all my files at once

it was zero in the end had a bit of trouble with it but got there in the end for those interested finished code was: <?php $result = mysql_query("SELECT `id`,`name` FROM linkvideos_category"); $num_rows = mysql_num_rows($result); while($row = mysql_fetch_assoc($result)){ $num_rows--; if ($num_rows != 0 ){ echo' <a class="categorylink" href="'.$web_path.'video_listing.php?category='.$row['id'].'">'.$row['name'].'</a> <br /> <img src="'.$pro_path.'/images/box_middle_line.jpg" />'; } else { echo' <a class="categorylink" href="'.$web_path.'video_listing.php?category='.$row['id'].'">'.$row['name'].'</a>'; }} ?> Thanks a lot for your help guys

I was modifying the wrong table haha thanks I wouldn't have looked otherwise, okay I've taken a shot at what you said but please keep in mind I'm not a php coder by a long stretch <?php $result = mysql_query("SELECT `id`,`name` FROM linkvideos_category"); $num_rows = mysql_num_rows($result); while($row = mysql_fetch_assoc($result)){ if ($num_rows != 0 ){ $num_rows--; echo' <a class="categorylink" href="'.$web_path.'video_listing.php?category='.$row['id'].'">'.$row['name'].'</a> <br /> <img src="'.$pro_path.'/images/box_middle_line.jpg" />} '; else { echo' <a class="categorylink" href="'.$web_path.'video_listing.php?category='.$row['id'].'">'.$row['name'].'</a>} '; } ?> I think it says if $num_rows isn't 0 (so isn't on the last iteration) then output as normal else output without the image

Hello there I've got two questions that I hope you can help me with firstly as you can see here I've got a loop which makes a list of links out of the id field and name fields of my database <?php $result = mysql_query("SELECT `id`,`name` FROM linkvideos_category"); while($row = mysql_fetch_assoc($result)){ echo' <a class="categorylink" href="'.$web_path.'video_listing.php?category='.$row['id'].'">'.$row['name'].'</a> <br /> <img src="'.$pro_path.'/images/box_middle_line.jpg" /> '; } ?> Now I want the loop on the last iteration not to output that image and I'm not sure how & lastly I input a new name and id into my database but its not being reflected in my code, is there any reason why it wouldn't be updating and appending my new item to this list when I run the website? Thanks for your time, arcanine. ps what does that $result string do exactly? I've modified the code from a tutorial I found

excellent my list is ordered thanks I'll be sure to have a look through the code and try understand the witchcraft behind it

hmm yeah I was just thinking that can you help me construct the new array (I'm still relatively new to php) we've got the imgfile string reading all the files so we need to feed those values into our new array so $imgfile = array (); sort($imgfile); Would work? I don't know if php will automatically fill my array with the strings also I guess I would need to convert the array back to strings to echo it out properly?

Okay he is my script that I've cobbled together, it used to work fine in till I changed server it's purpose it to read a directory (in this case /img) decide if images are in that folder and then output the file names in xml format now this worked fine in till I moved server when the xml file started displaying the image names non alphabetically (I can't have this happening I need my images in order, I have a lot of them and to rename them all would be impractical) this is where I need your help have a look through the code and help me re-write my code so that it outputs image file names alphabetically again <?php //define the xml standard header("Content-type: text/xml"); echo "<?xml version='1.0' encoding='ISO-8859-1'?>"; //this section calculates the image names in the directory $imgdir = 'img/'; // the directory, where your images are stored $allowed_types = array('png','jpg','jpeg','gif'); // list of filetypes you want to show $dimg = opendir($imgdir); echo "\n<gallery> <image>\n"; while($imgfile = readdir($dimg)) { if(in_array(strtolower(substr($imgfile,-3)),$allowed_types)) { echo ' <url>img/' . $imgfile . "</url>\n"; } } echo ' </image> </gallery>'; ?>

Thanks a lot just what I needed I'll be sure to bookmark this forum in google bookmarks Final script just in case anyone wanted something similar <?php //define the xml standard header("Content-type: text/xml"); echo "<?xml version='1.0' encoding='ISO-8859-1'?>"; //this section calculates the image names in the directory $imgdir = 'img/'; // the directory, where your images are stored $allowed_types = array('png','jpg','jpeg','gif'); // list of filetypes you want to show $dimg = opendir($imgdir); $url = 'http://' . $_SERVER['HTTP_HOST'] . '/' . $imgdir; echo "\n<gallery> <image>\n"; while($imgfile = readdir($dimg)) { if(in_array(strtolower(substr($imgfile,-3)),$allowed_types)) { echo ' <url>' . $imgfile . "</url>\n"; } } echo ' </image> </gallery>'; ?>

oh right, thank you for all this by the way the corrected script is at http://dinogod.adrianhosting.com/smf/coverflow/test.php I get XML Parsing Error: no element found Location: http://dinogod.adrianhosting.com/smf/coverflow/test.php Line Number 6, Column 10: looking at the source the output is <?xml version='1.0' encoding='ISO-8859-1'?><gallery> <image> <url>http://dinogod.adrianhosting.com/img/11.jpg</url> <url>http://dinogod.adrianhosting.com/img/12.jpg</url> </image> <gallery> which to me looks right, can I ignore that xml error and start trying to call the xml file to my flex project? or is it not valid yet?

I imagine I don't if I'm not seeing anything I don't know how to find out whether error_reporting is on or off as I've mentioned I don't know php :-\ your error does mention line 21 though which is echo ' <url>' $url . $imgfile . "</url>\n"; does anything look wrong there?

Thanks for your help but the script generates nothing not even in the source code :S I've uploaded your script to http://dinogod.adrianhosting.com/smf/coverflow/test.php so you can see for yourself I'm really confused as to why it won't echo anything :S