Recent content by WebmasterA

I think I know what you mean. Each time you create a new widget you assign the new_id to it and you have old_id of the previous widget that is associated with the new widget. Is that correct?

If I understand the question correctly than the answer is: select w.widget, w.widget_id, v.new_id, v.old_id from widgets w, versions v where w.widget_id = 712 and w.widget_id = v.old_id order by w.widget;

Thank for the reply. I may work but I have like 10000 records. I just found an answer. I tried it and it works. DELETE FROM `my_posts` WHERE `post_id`=2 LIMIT 1; Good luck to everyone who has same problem. I found like 5 similar posts on this board but no similar and simple answer. - Webmaster

Hello, I have a problem. I have a table with identical row information. I need to delete duplicates. For exaple I have a table my_posts with data: post_id post 1 first post 2 second post 2 second post 3 third post I need it to be: post_id post 1...

It works like a charm. Thanks a lot guys. Sorry azzazzello I misread your first message a little bit. Thanks again guys. - Andrey

Thanks for reply. I am not sure what maxdate suppose to be. If you are proposing to try: select a.topic_id, a.topic_header, max(messsages.message_date) from topics a left outer join messages(a.topic_id=messages.topic_id) group by a.topic_id <==== missed line order by max(messages.message_date)...

Hello, I have a sort question. I have two table: topics and messages for those topics. Each topic can have multiple messages. I need to select the topic name and the last message posted. topics table topic_id (int) topic_header (varchar 100) topic_text (text) messages table mesage_id (int)...

Hello, I am looking for a code example that does header trailer in Javascript. Meaning when my page is very long and I need to scroll down I need a particular banner/header to be visible all the time. For example if the table data is too long I need to be able to see table heading no matter how...

Coderifous, Thank you very much. I just tried it and it works perferctly. Thanks everyone else who responded.

Thanks for replies guys. I am at home now and will test it tomorrow. Mike I have looked at the docs before posting it, but I managed to make it work for every case, but not for all at the same time. :(

Thanks for reply Mike. As it is shown in examples above I need to find out if number 5 is the in the string. But I need to make sure number 5 is the stand alone number and not part of any other number like 15, 51 or 151. 5,12,121,17 - yes there is 5 12,121,17,5 - yes there is 5...

Hello, I have a pretty simple pattern matching question. I need to match a number in a string. For example I need to see if the number 5 is in the following stringsL 5,12,121,17 - yes 12,121,17,5 - yes 12,121,5,17 - yes 12,121,15,17 - no 12,121,51,17 - no 12,121,151,17...

Thanks for info guys. I have a small form with radio buttons that have to be there (data is stored as value of the radio field). I cannot do any calculations serverside. Whatever I do has to be done in javascript. I am not trying to hide the numbers from experienced programmers and hackers...

Thank you for response. Why would not encryption work? I have seen it done with third party software so I assume that there is a way to do it with perl. All the data is in the database as it is, but the problem is that the results are calculated by javascript depending on what clients chose -...

Hello everyone. I was trying to search this forum for an answer to the question I have and I was not able to do so. Therefore I am asking this question. I need to encrypt my HTML output so other people cannot see the output data because it consist sensitive data (numbers used for caculation.)...