Scip

Yeh thanks for the fast reply. Thats the direction i am probably heading. Its taken too much of my time.

Yeh IE mean internet explorer, when i view the site through internet explorer wierd borders appear around the slider on the home page. The div containing the slides overflows, i used microsoft super priview to view the site and see what was happening with the html code and it seem with internet explorer some extra div tags where being generated for some reason. this is what i mean:

I have been trying to figure this thing out for quite a while now to no avail. basically i am making this website located here: anco2.byethost2.com when you get to the site just click on the frog link, i am a noob to this :s. the slider works in firefox and internet explorer but wont work on in IE, i dont know why is it's driving me mad. Anay help is appreciated, thanks in advance.

I will now, i never really used it, to be honest i never learned how to.

OMG Thanks so much for giving me the advice on show copy. Worked like a charm. I am so happy lol

Doing as you suggested does enlarge the canvas but the images are still the same size. The new area is transparent, it took me a while to finish this design, i even feel like crying :-\.

I am currently face with this problem which is really starting to annoy me. I have a psd of a web layout i was coding to css/xhtml. I was cutting out the various images i needed for the layout with the crop tool. But like an idiot i forgot to save the original psd and use a copy. I mistakely clicked on saved when i was trying to click on save as and i undid the crop but when I finaly came to closing photoshop i forgot to save so the last save was with the cropped section. All the layers are still there but i can't return things to their original size. I can only view things through a window the size of the cropped image. What i am wondering is, is there a wall to get rid of the window, so i can work normally?

You are missing the curl brace ({}) after the if and else statements. This: if (!is_numeric($ValidPayment)) echo "<p>You did not enter a valid credit card number!</p>"; else echo "<p>Your credit cardnumber is $ValidPayment.</p>"; Should be: if (!is_numeric($ValidPayment)){ echo "<p>You did not enter a valid credit card number!</p>"; }else{ echo "<p>Your credit cardnumber is $ValidPayment.</p>"; } Thats what i think the problem is anyway.

Thanks so much for taking your time to answer, there was nothing wrong with the query as you said it was the way i was printing the results and i should have used a while loop to retrieve each row. I didn't know that lol.

Forgive but i tried using mysql_fetch array on it's own with the only parameter being $result, i also tried MYSQL_NUM AND MYSQL_ASSOC as you seen in the above post but still only the first row is returned. This is why i think there is a problem with the query. The reason why i used MYSQL_ASSOC is because i am using array_count_values to count the numbers of times something is repeated in the array and using fetch_array without any parameter caused double counting since it return both an associative and number indicies. I am very new to php(only 3 months) and programming is general, in fact mysql is the only programme apart from a little javascript i know. I really want to find a solution to this, but i might not know whats wrong or i am not explaining it clear enough.

Ok i tried something typing the dates into the query and i still get the same problem. I dont know whats wrong and i am starting to get really frustrated. It is still returning only one row when there are two rows within the specified dates. here is how it looks now. $query = "SELECT * "; /*$query .= "item1, item2, item3, item4, item5, item6, item7, item8, item9, item10 ";*/ $query .= "FROM loot "; $query .= "WHERE "; $query .= "picked_on > '2009-06-01' "; $query .= "AND picked_on < '2009-07-30'"; $result = mysql_query($query,$connection); confirm_query($result); $loot = mysql_fetch_array($result,MYSQL_ASSOC); print_r($loot); I also tried the following and still the same problem. $query = "SELECT * "; /*$query .= "item1, item2, item3, item4, item5, item6, item7, item8, item9, item10 ";*/ $query .= "FROM loot "; $query .= "WHERE "; $query .= "picked_on BETWEEN "; $query .= "'2009-06-01' AND '2009-07-30'"; $result = mysql_query($query,$connection); confirm_query($result); $loot = mysql_fetch_array($result,MYSQL_ASSOC); print_r($loot); A print_r of $loot for both of the above gives this: Array ( [id] => 1 [picked_on] => 2009-06-28 [member_name] => tom [item1] => Ebonite [item2] => Aluminite [item3] => Kobalit [item4] => Dragoturkey Peak [item5] => Bear Bone [item6] => Black Dragoss Horn [item7] => Ice Kwak Beak [item8] => Dragoturkey [item9] => Barley [item10] => Barley Sugar ) Only the first row is returned as you can see, is there something wrong with my query? thanks in advance.

Thanks for the reply but using CURDATE() doesn't seem to work either. it now looks like this. $query = "SELECT "; $query .= "item1, item2, item3, item4, item5, item6, item7, item8, item9, item10 "; $query .= "FROM loot "; $query .= "WHERE "; $query .= "picked_on < CURDATE() "; $query .= "AND picked_on > DATE_ADD(CURDATE(), INTERVAL -1 MONTH)"; $result = mysql_query($query,$connection); confirm_query($result); $loot = mysql_fetch_array($result,MYSQL_ASSOC); Now i am think if i can use a different query to get the results i want.

Hi thanks for replying, i managed to change date to picked on but i am still having the same problem. I think it has something to do with my date arithmetic. Would it have been better to use epoch format? I prefer the mysql format cause it means less time fiddling around with code converting one format to the next. the code now looks like this: $query = "SELECT "; $query .= "item1, item2, item3, item4, item5, item6, item7, item8, item9, item10 "; $query .= "FROM loot "; $query .= "WHERE "; $query .= "picked_on < NOW() "; $query .= "AND picked_on > DATE_ADD(NOW(), INTERVAL -1 MONTH)"; $result = mysql_query($query,$connection); confirm_query($result);

I am trying to query a database for range of result which fall between two dates. The table i am selecting from is set up so that there is a column called date under which the time a row is inserted into the database is recorded by the NOW() function. The date is not stored as a unix time stamp but in the mysql formate, this might be a bad decision in terms of database design on my behalf. here is the code for the query, it only returns one row of results whilst there are two and the difference in terms of dates is oneday: $query = "SELECT "; $query .= "item1, item2, item3, item4, item5, item6, item7, item8, item9, item10 "; $query .= "FROM loot "; $query .= "WHERE "; $query .= "Date < NOW() "; $query .= "AND Date > DATE_ADD(NOW(), INTERVAL -1 MONTH) "; $result = mysql_query($query,$connection); confirm_query($result); here is what the screen print of phpmyadmin looks like: thanks in advance.

managed to solve it but created another problem. :-X