dweb

thanks for fu It just doesn't do anything, no errors, just dead, but i'll try your code above Question, do I do the following document.form.form_product_box_array2.value = fieldObj.value; or do I use document.form.form_product_box_array2.value = elm; thanks

Thanks, I tried that and ended up with function do_something() { var elm = document.getElementById('fieldx').value; elm.replace("0",""); elm.replace(",,",""); document.form.fieldx.value = elm; } but that didn't seem to work, any idea why? thanks

hey all i have a html form and my input field looks like; <input id="fieldx" value="1,0,23,0,99"> the value changes each time, but that gives you an example As you'll see, I have 0's in the input field Inside a function, what i want to do is run the following var elm = document.getElementById('fieldx').value; then strip any 0's from that input field, and output the new value using document.form.fieldx.value = stripped_zeros; so the output would look like <input id="fieldx" value="1,23,99"> can anyone help? thanks

hi all i have a input field on my webpage that looks like <input name="people" id="people" value="1,4,6,8,10,23"> and I want to run a javascript so when my link, such as <a href='javascript:remove_comma(3)'>click</a> is clicked, it would remove the 3rd comma separated value, leaving me with <input name="people" id="people" value="1,4,8,10,23"> but i might also do <a href='javascript:remove_comma(1)'>click</a> <a href='javascript:remove_comma(5)'>click</a> can anyone help? thanks

Awesome thanks

Someone said it was faster to do it in the Query than in code, but i'll take your advice, thanks

Sorry, my mistake I don't want to just show the ones in the last hour i want to set the value 'OlderThanAnHour' to 0 if the record was added in the last 3 mins, and 1 if the record was added later than 3 mins ago Is that possible by altering my Query a little?

Hi everyone I have this Query SELECT *, IF(HOUR(TIMEDIFF(NOW(), datetime)) >= 1, 1, 0) AS OlderThanAnHour FROM people_and_staff Which works great, and shows me all the records in the last hour How can I alter this to show me records in the last 3 minutes? Thank you

Hi I have the following Query, but it can sometimes take over 2 minutes to return data How would you suggest I improve the Query and which fields should I look at indexing in the database? Thanks SELECT user.id, user.name, user.email, user.myid , (SELECT COUNT(*) as Num FROM stuff s WHERE s.userid = user.id) AS apps , (SELECT COUNT(*) as Num FROM stuff s WHERE s.userid = user.id AND s.gone > 0) AS gone_total , (SELECT COUNT(*) as Num FROM stuff s WHERE s.userid = user.id AND s.action = 3) AS exist_total , (SELECT COUNT(*) as Num FROM `customers` WHERE `userid` = user.id) AS customer_total FROM users user LEFT JOIN items i ON i.id = user.my_id

thank you, works great

Hi I have the following query; SELECT m.name,m.gender,m.dob, (SELECT FLOOR( DATEDIFF( 'date('Y-m-d')',m.dob ) / 365.25 )) AS age FROM members m which gets David Male 1990-08-17 22 John Male 1978-02-15 35 and that all works ok what i want to do, is extend the query to grab rows when the member is between a set age but when i do WHERE age BETWEEN 30 AND 40 i get Unknown column 'age' in 'where clause' any idea why? thanks

Yes, it all works fine, it's just that it -200 crops in the wrong direction

Hi Jazzman1 The type is int(5) and the record saves as "-200" My PHP image processing code looks like; $position = $rowdata['image_position']; $src = imagecreatefromjpeg('images/saved_photo.jpg'); $dest = imagecreatetruecolor(500, 800); imagecopy($dest, $src, 0, 0, 0, $position, 500, 800); imagejpeg($dest,'images/copped_photo.jpg'); imagedestroy($dest); imagedestroy($src); The value $rowdata['image_position'] is the css top position that was saved (ie: -200) thanks

Hi I have a website that has a jQuery image dragger script, which lets you move an image up and down a fixed 500x800 area, the code ends up looking like; <div style="width:500px; height:800px; overflow:hidden"> <div style="position: relative; top: -200px"><img width="500" src="images/test_image.jpg"></div> </div> This all works ok, and what i'm doing is then saving the css "top" value in my database. In the example above, i'm saving -200 in the database. I'm saving it because i might want to go back and adjust the image position later on So my problem is, when I come to processing the image, I want to use imagecopy(); to crop the image to the positioned sized but when I pass my -200 value from the database imagecopy(images/NEW_image.jpg, images/test_image.jpg, 0, 0, 0, -200, 500, 800); it seems to crop the wrong way how can I get PHP to correct that value so it crops correctly? thanks

cool, thanks

Thanks, i changed the table a bit and indexed the column `name` in the `users` table seems to have made it much faster I have quite a few inserts, updates and deleted from the `users` table, what do I need to do to update the index each time, or is this automatically done for me? Do i have to add another query to each insert, update and delete? thank you

as far as i know, i only have the ability to do select queries, but i could try i also know very little about indexing as not done it before

thanks, I will try inner joins

Hi Psycho I tried your query idea and it still took 90 seconds I can't index the columns as I dont have direct database access

Hi I have a 5 database tables that i'm tying together, each table has about 50,000 records. The query i'm using is SELECT u.id, u.name, u.age, p.name, p.code, a.time, a.kin, b.lime, g.happen, (SELECT COUNT(*) FROM `log` WHERE `logid` = u.id) AS tot FROM users u LEFT JOIN products p ON p.id = u.prodid LEFT JOIN ages a ON a.id = u.ageid LEFT JOIN book b ON b.id = u.bookid LEFT JOIN group g ON g.id = u.groupid WHERE u.name != 'admin' ORDER BY u.id DESC LIMIT 10,40 works great but for some reason it's taking around 100 seconds to return data. but if I remove ORDER BY u.id DESC then the query takes around 5 seconds I've read in some groups that to speed up, I should do the ORDER after the query, by doing SELECT * FROM ( SELECT u.id, u.name, u.age, p.name, p.code, a.time, a.kin, b.lime, g.happen, (SELECT COUNT(*) FROM `log` WHERE `logid` = u.id) AS tot FROM users u LEFT JOIN products p ON p.id = u.prodid LEFT JOIN ages a ON a.id = u.ageid LEFT JOIN book b ON b.id = u.bookid LEFT JOIN group g ON g.id = u.groupid WHERE u.name != 'admin' ) ORDER BY u.id DESC LIMIT 10,40 But that doesn't seem to work Can anyone help or suggest an alternative Thank you

Hi I really could do with someone's help, i've tried a ton of things and nothing seems to work. I have a HTML page which contains a 200px by 500px div Behind that div, I have an image, which can be dragged around, resized and i've put a rotate tool in too. Once the user is happy, they click a button and using javascript I store the following in the database Width = the new width Height = the new height Left = how far left the image was dragged (ie: -100) Top = how far from the top the image was dragged (ie: 20) Angle = the rotation in degrees Image = url of image (ie: ../images/photos/abcd.jpg) The "top" and "left" can be positive values (ie: 300) or negative values (ie: -100) I have stored those values as vars (ie: $var_rotate_value), what I want to do, is using GD library, replicate what the user did and save a copy of the image that was positioned inside the div, cropping everything around the outside of the div I've tried so many things and nothing is working for me It either shows the wrong size, or it doesn't rotate correctly, or the position is way off I have attached an image to try and show you what im trying to do The code i'm using and hacking around is; $filename = '../images/photos/abcd.jpg'; $nfile = $var_photo_url_value; $degrees = $var_rotate_value; $source = imagecreatefromjpeg($filename); $rotate = imagerotate($source, $degrees, 0); imagejpeg($rotate, $nfile, 100); imagedestroy($rotate); $div_area_width = 200; $div_area_height = 500; list($width, $height) = getimagesize($filename); $from_left = $var_left_value; $from_top = $var_top_value; $new_width = $var_width_value; $new_height = $var_height_value; $image_p = imagecreatetruecolor($div_area_width, $div_area_height); $image = imagecreatefromjpeg($nfile); imagecopyresampled($image_p, $image, 0, 0, $from_left, $from_top, $new_width, $new_height, $width, $height); imagejpeg($image_p, $nfile, 100); imagedestroy($image_p); Can someone help please? ta

i can't do that as its a php script that runs in the background, so i need to do a php calculation to achieve it

hi i'm having big problems trying to figure something out, so wondering if someone can help. I have two numbers, as $width = 800; $height = 1000; these numbers are not always the same value, so they can look like $width = 700; $height = 450; and i want to reduce both numbers, keeping their ratio but i want to reduce both the values, until either one meets their min value allowed $width_max_val = 200; $height_min_val = 400; So if the values were $width = 410; $height = 750; $width_max_val = 200; $height_min_val = 400; then the outputted values would be 219 400 can anyone help? thanks

thanks very much

Hi everyone I have a QUERY to get a product based on a ID, and I am trying to make a next and previous button. I'm using the following query SELECT p.id, p.name, prev.id AS prevID, prev.name AS prevNAME, next.id AS nextID, next.name AS nextNAME FROM products p LEFT JOIN products prev ON prev.id < p.id LEFT JOIN products next ON next.id > p.id WHERE p.type = 1 AND p.del = 1 AND p.id = '".$currentID."' AND prev.type = 1 AND prev.del = 1 AND next.type = 1 AND next.del = 1 ORDER BY prev.id DESC,next.id ASC LIMIT 1 which gives me the current product, the next product name and ID and the previous product name and ID It works ok, the problem is when you reach the last row, or first row, it won't return anything, I think because of the part AND prev.type = 1 AND prev.del = 1 AND next.type = 1 AND next.del = 1 Is there a better way to do this and a way which will work Thanks