itazev
-
Posts
26 -
Joined
-
Last visited
Never
Everything posted by itazev
-
Still not working. But thanks for your time. Anybody!? Please!!
-
Hey everyone! How do I get the values stored in an array using $_POST? In the HTML form there is a multiselect listbox but when I do $my_var = $_POST['multiselect_listbox']; it will return only the last selected element. Thanks for your help!
-
Hey everyone! I tried to google it but I could not find how to get a text of a listbox/combobox element. Besides I tried getDataProperty("text") but does not worked. I appreciate your help!
-
Wonderful! Thank you so much!
-
Hey everyone! I'm trying to sum values to existing values on the table. Lets suppose that I have an int field called "items" then I want to sum / add more 3 (+3) to the existing value. Is there a way to do that on the MySQL itself or I have to query and sum in php and then store back the sum results? I appreciate your help!
-
Hey everyone! I have these 2 tables and I am trying to design it in a way that when a product is deleted from the catalog it also get its entry removed from the installation table. The situation is: each installation has its own products list on it. but what if a product is no longer available? the installations having that product should remove it from the list. Appreciate any help! create table products ( id int unsigned auto_increment not null primary key, description varchar(64), price float(5,2) unsigned )type=InnoDB; create table inst_products (FOREIGN KEY (inst_id) references installation(inst_id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (descID) references products(id) ON DELETE NO ACTION, inst_id int unsigned not null, unints smallint unsigned, descID int unsigned not null )type=InnoDB;
-
hmmm interesting functions! I never heard of! Seems to solve my broblem! I'll test them! Thank you genericnumber1
-
Hey everyone! I'm trying to figure out how to build a function to REPLACE non-standard chars in a HTML string such as É É Ê Ê Í Í Ó Ó Ô Ô something like function AnsiChars($htm_string){ ... return <<html with special char codes replaced>> } http://www.php.net/chr The problem is how do I get the char number to replace it try pressing ALT+0199 in your keyboard and you get what i mean. I appreciate any help!
-
Hey everybody! I'm trying to build up a query to find a client by its telephone number. In this case I use tel LIKE '%55%' to find phone number containing '55' on it. The problem is that it results clients that even have a phone number registered. Probably it is due to some JOIN instruction missing. I don't know exactly. clients and contacts are referenced by primary/foreign key in InnoDB SELECT clients.id, clients.name, contacts.tel, contacts.tel2 FROM clients, contacts WHERE tel LIKE '%55%' GROUP BY name; Thank you for helping!
-
really! Pentium 4 1gb ram i think it may be related to the fact that it access the array in another window but Thank you!
-
Hey everyone! I am coding javascript with arrays in a way that a pop up window controls the array items on the parent window it works but gets slower to add an item to the array as it get more and more items on it. I mean 10 items on the array will bother the user pop up window manipulating the parent's array: window.opener.ArrUn[ index ] = document.list.un.value; window.opener.ArrDescID[ index ] = selectedID; window.opener.ArrDesc[ index ] = selectedText; window.opener.display(1); on IE it seems to be slightly faster the FF appreciate any help!
-
solution: http://www.perlscriptsjavascripts.com/tutorials/javascript/window.html#07213446
-
hey everyone! I'm looking for a way to open a pop up window (<a href ..> click) to list products in a combo or list box. What I do not know how to do is - link up <a href ..> to open a pop up window - return the selected choice from the <selected> option it is about 1000 products. I appreciate any help!
-
There is just a problem: the current_field variable never apperas on the POST or GET string. Something like processform.php?field=aaaa?field=bbbb?field=cccc?field=dddd <script language="javascript" type="text/javascript> var current_field = 3; function addfield() { current_field ++; document.getElementById("extra_field").innerHTML += "<input type=\"text\" name=\"field\"" + current_field + " /><br />"; } </script> appreciate your time!
-
Cheers mate! worked very well!!! I wonder how on earth did you discover that!!? I mean, i could never guess it document.getElementById("extra_field").innerHTML xenophobia, do you recommend any javascript tutorial?
-
Hey ya! I am looking for a way to put on the page body text boxes (<input type="text">) as many as the user clicks the button "add field". I tried document.write() function but it erases all the page content and then add the field. sketch: <form ... > <input type="text" name="field1"><br> <input type="text" name="field2"><br> <input type="text" name="field3"><br> . . . <!-- and so on --> <input type="button" value="Add field"><br> </form> I appreciate any help
-
Cheers mate! worked very fine!!! Thank you bubblegum!
-
Hey ya! Well, i got a table of clients with a field client_id which i set as autonumber. The problem comes up when a new client is stored in the database: after the record is stored in the table (save.php) i want to redirect the user to the page form layout which will display all just stored information, but to do so i need to know what is that client_id number just stored once it is autonumber. so i can do a "select ... from ... where client_id=???" query Can you give a hand please? Thank you!
-
Hi there! I recently migrated from ms-access to php/mysql ("a small step for the men, a huge step for the humanity" ) and now I'm facing an issue on tables relationship . I don't know too much of sql language, so I googled and searched in on books for mysql relationships InnoDB. I found some slight explanations. In a few words, how can I set up a relationship between two tables whether (lets say...) table clients - clientID - client_name table products - clientID - product_name In this case i'd like to link clientID from clients to clientID on products and on deleting a client, its products will be deleted automatically, also a product entry must have an associated entry on clients. I was thinking about a database modeling software but i want to learn the sql statements. I appreciate your help!
-
Thank you all indeed! All answers helped a lot! I think I'll really get the point when i starting making use of arrays. But i got the concept, that is important. Cheers!
-
Hey guys! I often have seem these ( => , -> ) operators through php samples on the net but I do not know what they really do and i tried a search but they are so 'small' that it never give the results for them. particulary i note the use of => on foreachs. what does these operators do actually? cheers!
-
worked! cheers mates!!
-
Hey ya! I searched for leading zeroes php function all the way and I found that it can be done in date functions. but what if I want to list a non-date query from mysql? lets say I have field CODE_NUMBER and it stores 5, 128, 96, 5879 ... is there a function (?) that i can use to make them appear in the html with leading zeroes like: 0005 , 0128 , 0096 , 5879 thank you
-
thank you buddy! it worked
-
Hey there! I started with mysql a few days ago and now I don't know how to insert data in a DATE filed type mysql> insert into employee values (NULL, 'Jeferson', date('15/02/2003'), 'Accoun tant', '500.25', '1', '42'); All the values are stored normally except when I try to store it with the date. (I tried a search but i get more confused yet) Thank you for any information!