dweb

Thanks everyone, managed to finally get it working Barand, tried your code also and works a charm, thank you

I am able to change it, so if you think there's a better script to use to do this, then i'd be happy to change it

Thanks very much, it kinda works, but for some reason if I replace $department = 'Admin'; with $department = 'Call the Admin or HR department'; Then rather than printing the names, it just returns that entire variable Any idea why? Thanks

Thanks, i'll do that. Could you supply a simple example of how I could use foreach() to tackle this issue? Thank you

Hi every body I have a multidimensional array that looks like $staff = array( array("David", 31 , 'HR'), array("Julie", 29 , 'Direct Sales'), array("John", 32 , 'Admin'), array("Shawn", 30 , 'Direct Support'), array("Vicki", 41 , 'HR') ); As you can see, it stores [persons name],[extension number],[department], in total I have about 30 rows on that array I then have several PHP pages, an example looks like; $page_text = 'If you need to contact Direct Sales or Admin, please call us'; echo $page_text; What I need to do is look at that var $page_text and check if any of the rows in the multidimensional array match any keywords, and then display them. So for example, with $page_text = 'If you need to contact HR or Admin, please call us"; It would output the following text David on ext 31 Vicki on ext 41 John on ext 32 If possible, I also wanted to make the extension number (ie: 41) a direct http link to their blog, which is /blog/staff/{EXT]/read/ so it might look like David on <a href="/blog/staff/31/read/">ext 31</a> Vicki on <a href="/blog/staff/41/read/">ext 41</a> John on <a href="/blog/staff/32/read/">ext 32</a> Can anyone help Thanks

for some reason it returns every record, do you know why that might be?

Actually it seems to have an issue running and stops certain rows from being loaded, i'll try a few other things

thanks everyone, jcbones, your example seemed to be the quickest, but thanks everyone for all the help

Hi I have the following code $result = mysql_query("SELECT * FROM products"); while($row = mysql_fetch_array($result)) { echo $row['name']; } and the following DB table id,type,name 1,1,Mouse 2,1,Printer 3,1,Keyboard 4,2,Laptop 5,2,Desktop 6,2,Tablet 7,2,Mp3 As you can see, the columns are `ID`, `Type` and `Name` and at the moment it comes back like Mouse Printer Keyboard Laptop Desktop Tablet Mp3 My database also has lots of other products in it, that is just a snippet At the moment it returns all the products, but what I want to do is limit it to that it only returns 2 rows from each type (2nd column), so it would look like Mouse Printer Laptop Desktop Can anyone help? I've tried LIMIT but cannot see how to do this thanks

Wicked, that seemed to cure all the problems, thanks man

Hi I have the following jQuery code $(document).ready(function() { function slider(panel) { jQuery("#"+panel).animate({ top: '-=30' }, 400); } setTimeout(slider('panel1'), 400); setTimeout(slider('panel2'), 800); setTimeout(slider('panel3'), 1200); } But it seems to run straight away and the inital delay doesn't seem to happen, and it also only seems to only animate "panel1" and ignores "panel2" and "panel3" Any idea why this might be happening? Thanks

Thanks for that, that seemed to work grea

Nope, the script to authenticate is on our server, they said to return a JSON so that once logged in, content can be viewed

Hi I wonder if someone can help. I'm setting up a login page and have been told by the development team that I need to build a HTML login screen to run on their system and then call a PHP script on my server for authentication, of which sessions will then be created (to show certain content on their system). I'm not done any authentication this way before, can anyone show me a simple script, which demo's how this would work? I've had a look around, but could only find complex examples Thanks very much

Hi everyone I wonder if you can help me. Excuse me if this is in the wrong section, but it's kind of a mixed question. My dad runs an online shop and I am taking care of the website (while he deals with orders), currently i'm trying to enhance it with a simple product search We received our latest database of products in an excel file, in total there are around 300,000 rows of data in the excel file, attached to this post is an image showing you how the data is presented to us, we're expecting another database soon, which will have around 600,000 rows, and maybe another 400,000 next year. What I need to do is get the data into a MySQL database and then write a small PHP page to which displays drop downs for Company Type Range and then list products associated to the selected options, along with the description (and a few extra fields ie: price, color). I may need help with the PHP script, but will post that in another tread once I have managed to deal with this issue. I guess i'll need to import all this data into separate tables (company, type, range, products) so to make sure it's not slow at getting data, as I said, we have 300,000 rows of data and we're getting another 600,000 rows later, I guess with almost 1 million records it would be to much to hold in one table, especially if we get the 400,000 next year. my problem is, that i'm stuck with how to get all this data from the excel file into the a MySQL database with relevant ID numbers linking data. We have asked the company that supplies the data, but they can only supply it in an excel file and we're at a bit of a panic point at the moment. can anyone help? thank you

Hi everyone I'm trying to get a file upload progress bar working, which uses APC and Query to check the size of the file during upload, but for some reason when uploading the file, the only values returned are coming back as 0 But it does upload the file ok, but the upload bar sits as 0 the whole time Attached is a screenshot of firebug showing the responses as 0 The following code makes up the 2 files used, sorry for posting long code, but I know people will ask to see it There is also a css file if anyone needs to see that Any help would be great as it's driving me mad trying to find a solution ====================== upload.php <?php //get unique id $up_id = uniqid(); ?> <?php //process the forms and upload the files if ($_POST) { //specify folder for file upload $folder = "uploads/"; //specify redirect URL $redirect = "upload.php?success"; //upload the file move_uploaded_file($_FILES["file"]["tmp_name"], "$folder" . $_FILES["file"]["name"]); //do whatever else needs to be done (insert information into database, etc...) //redirect user header('Location: '.$redirect); die; } ?> <!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"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Upload your file</title> <!--Progress Bar and iframe Styling--> <link href="style_progress.css" rel="stylesheet" type="text/css" /> <!--Get jQuery--> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.0/jquery.js" type="text/javascript"></script> <!--display bar only if file is chosen--> <script> $(document).ready(function() { // //show the progress bar only if a file field was clicked var show_bar = 0; $('input[type="file"]').click(function(){ show_bar = 1; }); //show iframe on form submit $("#form1").submit(function(){ if (show_bar === 1) { $('#upload_frame').show(); function set () { $('#upload_frame').attr('src','upload_frame.php?up_id=<?php echo $up_id; ?>'); } setTimeout(set); } }); // }); </script> </head> <body> <h1>Upload your file </h1> <div> <?php if (isset($_GET['success'])) { ?> <span class="notice">Your file has been uploaded.</span> <?php } ?> <form action="" method="post" enctype="multipart/form-data" name="form1" id="form1"> Name<br /> <input name="name" type="text" id="name"/> <br /> <br /> Your email address <br /> <input name="email" type="text" id="email" size="35" /> <br /> <br /> Choose a file to upload<br /> <!--APC hidden field--> <input type="hidden" name="APC_UPLOAD_PROGRESS" id="progress_key" value="<?php echo $up_id; ?>"/> <!----> <input name="file" type="file" id="file" size="30"/> <!--Include the iframe--> <br /> <iframe id="upload_frame" name="upload_frame" frameborder="0" border="0" src="" scrolling="no" scrollbar="no" > </iframe> <br /> <!----> <input name="Submit" type="submit" id="submit" value="Submit" /> </form> </div> </body> </html> ====================== upload_frame.php <?php $url = basename($_SERVER['SCRIPT_FILENAME']); //Get file upload progress information. if(isset($_GET['progress_key'])) { $status = apc_fetch('upload_'.$_GET['progress_key']); echo $status['current']/$status['total']*100; die; } ?> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.0/jquery.js" type="text/javascript"></script> <link href="style_progress.css" rel="stylesheet" type="text/css" /> <script> $(document).ready(function() { // setInterval(function() { $.get("<?php echo $url; ?>?progress_key=<?php echo $_GET['up_id']; ?>&randval="+ Math.random(), { //get request to the current URL (upload_frame.php) which calls the code at the top of the page. It checks the file's progress based on the file id "progress_key=" and returns the value with the function below: }, function(data) //return information back from jQuery's get request { $('#progress_container').fadeIn(100); //fade in progress bar $('#progress_bar').width(data +"%"); //set width of progress bar based on the $status value (set at the top of this page) $('#progress_completed').html(parseInt(data) +"%"); //display the % completed within the progress bar } )},500); //Interval is set at 500 milliseconds (the progress bar will refresh every .5 seconds) }); </script> <body style="margin:0px"> <!--Progress bar divs--> <div id="progress_container"> <div id="progress_bar"> <div id="progress_completed"></div> </div> </div> <!----> </body>

Someone suggested starting the code off with SELECT Concat(If(isnull(p2.id),"",Concat("/",p2.id)),"/",p1.id) AS `generated path` and then ending it with ORDER BY `generated path` so it generated something like /1 /1/3 /1/4 /2 /2/5 /6 but would this be the best and fastest way as it seems to work?

Hi It gives me root_name sub_name Apple iPad Apple iPod HP Mouse HP Printer the problem is that it ignores any record which doesn't have a "child", for example I have "Dell" as a main category, and it excludes it. I also wanted to have all results in one column with the parent at the top and child underneath with a type column indicating if it's a child(1) or parent (0), such as root_name type Apple 0 iPad 1 iPod 1 HP 0 Mouse 1 Printer 1 DELL 0 unless I can tweak the query to look like root_name sub_name Apple NULL NULL iPad NULL iPod HP NULL NULL Mouse NULL Printer DELL NULL which I guess would do the same trick my table is going to be huge, around 800,000 records, so i'm trying to make it as quick as possible, so any suggestions would be great

Someone suggested I use Recursive CTE but has not explained this very well, any suggestions on if I should and if so, how I can use Recursive CTE to get my result

Hi everyone I'm trying to sort out this SQL code so that is displays as I need it. The table I have looks like; id name parent 1 HP 0 2 APPLE 0 3 Printer 1 4 Mouse 1 5 iPod 2 6 iPad 2 and I need to output the QUERY as id value sub_item parent 2 Apple 0 0 6 iPad 1 2 5 iPod 1 2 1 HP 0 0 4 Mouse 1 1 3 Printer 1 1 So it basically displays the sub items under the main items The code I am using is select root.name as root_name , sub.name as sub_name from comments as root left outer join comments as sub on sub.parent = root.id where root.parent = 0 AND sub.parent != 0 order by root_name , sub_name but I can't seem to get it to work as my example shows any ideas??

Just a quick question; In the example Pikachu2000 gave, the following code was used $query = "UPDATE `users` SET `nickname` = '$nickname' WHERE `id` = {$_SESSION['s_uid']}"; what's the advantage of using brackets {$_SESSION['s_uid']} instead of using $query = "UPDATE `users` SET `nickname` = '$nickname' WHERE `id` = '".$_SESSION['s_uid']."'"; just wondering thanks

finally managed to get it to work, re-wrote whole page and works good now thanks for everyones help

I promise that i've tried every single persons comment without any luck, and i've also spend a long time looking at other posts and forums, but nothing seems to work if you have any other ideas, i'll be interested to try other things to try and solve it thanks

Hi everyone I've read and tried all your ideas and none work, it seems impossible to fix My only option is to turn off errors Thanks for all your help anyway

yes sorry I copied the error from another page by mistake, then corrected my post with the correct error