Roybut

Hi All, (EDIT: Amazingly, I clicked on another thread to give myself a break from coding and i found half the answer immediately. Thanks Pritaeaus [url]http://www.daniweb.com/forums/post1478160.html#post1478160[/url]. However, when validation is not passed I still get the messed up page so if anyone can help, I'd be most grateful.) (EDIT 2: …

Hi, I have this view: [CODE]DROP VIEW digits; CREATE VIEW digits AS ( SELECT TO_NUMBER(SUBSTR(rounded_cost, 1, INSTR(rounded_cost, '.' -1))) left_digits, TO_NUMBER(SUBSTR(rounded_cost, INSTR(rounded_cost, '.' + 1, LENGTH(rounded_cost)))) right_digits FROM roundcost );[/CODE] It allows me to create it but the values stored are apparently not valid numbers. When I try select * …

Hi All, Could anyone suggest us how to check the Time in the Database when an Order get injected into the Oracle data base as of now i am able to see only the date , but inorder to know the time when i got generated can anyone help me? …

Hi, I have a table which I want to update thus: If d_date is has a value and b_date is 30 or more then set d_date as the min value already in d_date. I know that the WHERE EXISTS clause is wrong but I don't know how to make this …

Hi, I need to validate user input to ensure it is alphabet characters only. I know there must be a simple solution but evertything I have tried has either partially failed or totally failed. At the moment, I have this: [CODE]until [ $(echo "$myVar" | grep -v '[^a-zA-Z]') ] do …

Hi, I need to populate a drop down box with size and colour values from my db. I have got it working but it just seems to be too clunky. I'm going to be marked on it and so would like to know where I'm going wrong. What I do …

Hi, I need to retrieve the max and min values of the price field in my db. I have a item table and a category table. I am using $_GET['category'] to get the category name and then I need to retrieve the min and maxvalues only for the items in …

Hi, I'm not sure if this shpould be in PHP or here so apologies if I'm in the wrong place. I'm trying to encrypt a password and insert it into my database along with other data. Everything works when I remove the md5 password encryption. It doesn't work when I …

Hi, I'm not very good at PHP so sorry if this is stupid but I have a database with a table called item. I want to retrieve certain items based on specific criteria so I have written this function: [CODE]function get_item ($item_no, $supp_id, $cat) { global $connection; if ($item_no && …

Hi, I am extracting a set of categories from a database and want them to disply in lines of three. They are each in their own div. I need them to look like this: div1 div2 div3 div4 div5 div6 The code is PHP but I need to know how …

Hi, I've searched this and other forums and found what are clearly the right answers for some people but not for me. I have a database with an item table. Item has a field called image that stores a path to an image. Here is an actual example of a …

Hi, I'm trying to create a database that stores shoes. Each shoe must have more than one size so I have created a table "mens_boot_test" with a field "size". In the size field I have an integer which holds the delimited values 1,2,3,4,5,6,7,8,9. I'm then trying to retrieve these values …