Acute

There are two tables - posts and comments: create table posts ( id integer not null primary key auto_increment, body text not null ); create table comments ( id integer not null primary key auto_increment, body text not null, post_id integer not null references posts(id) ); Now I want to …

I want to make a brochure similar to this one: [url]http://www.awf.ae/al_rowaad_advocates_brochure.html[/url] I'm web developer but new in brochures, so what technologies are used in it? 1) What to use to make the actual brochure? (See, it is just like a simple magazine) 2) Which flash technology is used? Where to …

How to create a transparent png or gif file? on photoshop? if yes, can you explain how? I create 1x1 transparent png/gif file and put it on the box background with y and x repeat, right? is this the idea of transparent backgrounds? Thnx in advance

For each of the step (even that specific as what editors and other software to use) included into building an application (for me mostly - web (php-mysql-html-javascript)) I really need tips on how to improve them so I could start working really really fast and be able to generate all …

Hi,I put many tiny forms on one of my pages, all have the same action to return to this page when submitted <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> but how can I know which one was submitted? I used this line all this time when I had only 1 form …

Hi every1, I have a recursive function for building dynamic menu, and it gives me this error: "Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 261900 bytes)" Any ideas?

Do you know how to store multi-level menus in db and build them into html lists using php? thnx p.s.: i googled and could not find what i need

Hello there, I'm selecting only one column, so if I have 20 rows in result, how to merge all these rows into [U]one row[/U] where all the rows will be [U]comma separated[/U]? Thnx in advance

Hi, I need to create a sql query that will return the sum of the total number of records in the t1 and t2 tables. Any ideas how to do it? Thnx in advance

Following code: [CODE=php] <?php $test_array = array(); $test_array['string_index'] = "data in string index"; $test_array[] = "data in index 0"; $test_array[] = "data in index 1"; $test_array[] = "data in index 2"; foreach($test_array as $key => $val) { if($key != 'string_index') { echo $val."<br>"; } } ?> [/CODE] gives result: data …

Hi, [B]I need to remember the time when user closes the window[/B] and later when he/she comes back, site will highlight latest news that happened when user was offline. So far the best solution I have found is jquery.unload (since I use jquery): it sends some data to php script …

I have a column "etype" which stores enum('r', 'p'). So with each selection I want to extend the row number until the number of etype->'p' will reach some number, for instance 10. If I use LIMIT 10, the total number of rows will be 10, but there is no guarantee …

How to store both cyrillic and latin in MySQL and is there anything special that I should know to display cyrillic with PHP? (conversions etc.) Thnx in advance

Hi there, in twitter and facebook when some of your friends/follows makes new post, your page gets updated via ajax. any ideas how it is implemented? i need the best concept/idea, not the code :] thnx in advance

When we send ajax request to some php file via post, we get the variables in php file from $_POST['varName'], and then send response as a text or html or JSON or whatever with echo or print. So, what if a lot of such ajax requests come simultaneously? what server …

Hi everybody, I have a js(using jQuery lib) file where all events and following actions(functions) are written. For one of such events there is a function that prepends one more similar element from which prepending was called: $("[COLOR="Red"][B]#id1[/B][/COLOR]").click(function(){ $(...).before("<div [B][COLOR="Red"]id='id1'[/COLOR][/B]></div>"); }); so that when I will click to just prepended …

How to send [COLOR="Red"][U]ANY[/U][/COLOR] text via jquery ajax method to php script? When text entered in textarea is html entity, php $_POST[]/$_GET[] sees it as empty string. Here is the code: [CODE=html] <head> <script type="text/javascript" src="/Engine/js/jquery-1.4.4.min.js"></script> <script type="text/javascript"> $(document).ready(function(){ $("button").click(function(){ $.ajax({ type: "GET", url: "get.php", data: "ta=" + $("#ta").val(), success: …

When I insert "&lt;b&gt;dog&lt;/b&gt;" into database using php, it inserts empty string. WHY??? How to fix it? thnx in advance

I have a <textarea> and <button>. When button is pressed the text entered in textarea will be displayed inside of <p></p>. So I want: when I enter for instance "1<br>2<br>3" in textarea and press button, exactly the same text is displayed in <p> i.e. "1<br>2<br>3" is displayed instead of 1 …

Hi everyone, I have a jquery script that prepends a <div> tag on button click. Additionaly in this script there are some jquery effects(like slideDown) applicable to <div> tags that were before(and for them effects work fine) and also to <div> which was prepended. However, after new <div> is prepended …

Hello everyone, I made a layout using float:left and it's ok until the browser window is resized. When window is resized everything messes up, how to fix it??? how to make it independent from window size? I mean whatever the window size is, layout keep it's positions. Here is what …

Hi everyone, I'm building a microblogging system like twitter and I need help in optimizing the database structure. I have tables "user_info", "posts" and "friends". Each time when user logs in, lets say user X, all latest posts of friends of X should be displayed. So it means that when …

In facebook or twitter time of post is changing every minute on every post. Any idea how to make it?

Hi everyone, can anyone explain me why following code [U]alerts[/U] me nothing: [CODE=javascript] var text = $.ajax({ type: "POST", url: "registration.php", data: "email=" + elementValue }).responseText; alert(text); [/CODE] but when I add option "async: false": [CODE=javascript] var text = $.ajax({ type: "POST", async: false, url: "registration.php", data: "email=" + elementValue …

Hello every1, i'm building a site that requires logging in before accessing other pages(like facebook or any mail system). At first(in index) i create an object of my sessions class, say $session. The constructor of sessions class calls session_start() php function. $session checks if user logged in or not(maybe he …

Hi everyone, i need your help) i have some elements with same id, say: <div id="myid">Data1</div> <div id="myid">Data2</div> I want to get innerHtml when one of them is clicked, how can i determine which one exactly was clicked? JQuery: $("#myid").click(function(){ //how to get the .html and other properties of clicked …

Hi, in Gmail (I've noticed it in other services too..)after you log in, progress bar appears. What does it do? Uploads all the JS(containing ajax) files into client's machine? or what?:) Thnx!

Hello everyone, i'm writing my own forum, and now my database has a [U]table for categories[/U], [U]a table for forums[/U] (each forum belongs to only one category), [U]a table for members[/U], [U]a table for threads[/U] (each thread belongs to only one forum, and each thread has only on member as …

Hi everybody, i have a web site without login system, and i want to integrate a good login system into it. Plz, suggest me a good tutorial about it?

Hi everybody, Is it possible to give a property default value without using constructor?