kvdd

"SELECT *" e.g. select [I]everything[/I] is [B]always[/B] a bad idea. To speed up, select only the things you want/need. WOW! I look again at your query and cannot believe my eyes :D because you select everything (*) from [B]two[/B] tables! Things you need to do: 1) Select what you want: …

Nobody have experiences with this?

Seems like a debugging issue, have you tried a (JavaScript) debugger? With a debugger you can easily step through the code, and see which variables are filled with what values, and when they change. See it as a slowmotion running your webpage, while you can inspect every value if it …

I am working on a site that must drag and drop items, I use scriptaculous 1.8.2, effects, dragdrop.js. See the picture of the website: [url]http://http://www.freeimagehosting.net/uploads/a5e185062a.jpg[/url] or [url]http://img11.imageshack.us/img11/4913/myplansite.jpg[/url] [I](each number 1..8 is an drag and a dropable)[/I] But now I am lost, I kan drag, i can drop and invoke the …

I have a Client and a server application, very simple code and it is working. But with the client, I can send one time a message, do I want another, it does not appear at the server. No response, nothing. Here is my code: Client: [CODE=pascal] procedure TForm1.FormCreate(Sender: TObject); begin …

Hello people, I want that when I mouse over a checkbox, that it is checked. I have now the following code: [CODE=javascript] <script language=javascript> function checkit(myform, name) { var xx = document.myform.name; xx.checked = true; } </script> <form name=myform27> <input type=checkbox name=mycheck onMouseOver="checkit(myform27,mycheck)" value="1"> Checking </form> [/CODE] But this does …

Hello, I am a bit a loser with JavaScript, but I found the following code to auto scroll a multiple select box to the last selected item. [CODE]Function autoscroll() { var lst = From1.Listbox1 if ((lst.multiple==true) && (lst.length>0)) { if (lst[lst.length-1].selected==true) { lst[lst.length-1].selected=true; return; } else { lst[lst.length-1].selected=true; lst[lst.length-1].selected=false; } …

Hello, I have a main div, with two divs in it: - Main div ---- div title ---- div content And now I want to center the content div and title div in the main div, and its really anoying because nothing that i've found on internet is going to …

hello, I try the following query: [code=mysql] SELECT IF TIME(hour_end) > '21:00:00' THEN timediff(time(hour_end),'21:00') AS diff ENDIF FROM `hours` [/code] Why whould this not work? Any help would be appreciated.

I am following some exercises in Delphi in a Nutshell from Ray Lischner. Very easy to follow and readable. He was explaining how units are working the following code: [code=pascal] program Units1_1; uses UnitA; {$AppType Console} begin WriteLn('Units 1_1 main program'); end. unit UnitA; interface uses UnitB; implementation initialisation WriteLn('UnitA …

Hello, I try with the following query to calculate the working time of employees: [code=mysql] SELECT TIME_FORMAT( ADDTIME( TIMEDIFF(TIMEDIFF(hour_end, hour_begin),(hour_pause)), TIMEDIFF(TIMEDIFF(hour_end_o, hour_begin_o),(hour_pause_o)) ) ,'%H:%i' ) AS total FROM hour [/code] This works correct, if the pause is filled, if no pause is given, no total is displayed (NULL). How can …

Whats wrong with this query? [code=mysql] TIME_FORMAT( DATE_ADD ( TIMEDIFF(TIMEDIFF(u.hour_end, u.hour_begin),(u.hour_pauze)), TIMEDIFF(TIMEDIFF(u.hour_end_o, u.hour_begin_o),(u.hour_pauze_o)) ) ,'%H:%i') AS total, [/code] I get the error: [QUOTE]#1305 - FUNCTION system.DATE_ADD does not exist [/QUOTE] BTW: I am using version 5.0.51a.

Hello, I am trying to add a total of some items in a while. My while produces list with names and with times that that person has worked. Like this: [code] John 8:00 John 5:00 John 6:00 <<here the total of john>> Lars 9:00 Lars 4:00 <<here the total of …

I think you know how to retrieve data from the database. So I only post the code you are asking: [code=php] <?php // Put here the database connection $qOptions1 = mysql_query("SELECT * FROM Options1"); foreach (mysql_fetch_row($qOptions1) as $val){ $aOptions1[] = $val; // generate the array for you with the options …

The warning tells you the following: "Your query is *nuts*." This is what you should do: $result=mysql_query("select * from job where jobtite='".$jtitle."'");

Maybe google for: wamp server tutorial? [url]http://subliminalconfusion.net/?page_id=109[/url]

Hello all, What I want is to divide a string in timeformat, lets say 27:30. How can I do that? Eventually I can use SQL for it, because the string comes from the database. Thanks before!

Hallo everyone, Im new to this forum, but not new to PHP, I do a lot programming in it, but sometimes I have to [B]less[/B] knowledge to solve the problems I get. The title is not very explained what my problem is, so mods, edit it if you want. [B]The …

The advice I give: hang out at php.net To find the first dot (.): [url]http://nl2.php.net/manual/en/function.stristr.php[/url] [url]http://nl2.php.net/manual/en/function.stripos.php[/url] And so on, I think you must not ask for a whole script here.

Use first this to print your query: [code=php] print_r($sql); [/code] Add this before you run the query in your code e.g. before: mysql_query($sql) or die (mysql_error()); And post that printed query here

I think, the fourth is a header, and maybe you stated it wrong. Try to send without headers: [code=php] mail("[email protected]","My subject",My Bodytext); [/code] And post here the result

[offtopic] I see you use several shashes in one line of code: [code=php] echo "<td width=\"75\" align=\"center\"><input type=\"checkbox\" name=\"toApprove[]\" id=\"approve\" value=\"approve\" />"; [/code] Why not do it this way? [code=php] echo '<td width="75" align="center"><input type="checkbox" name="toApprove[]" id="approve" value="approve" />'; [/code] Note the difference: the ' and the " [/offtopic] Ontopic: …

Look at this thread: [url]http://www.daniweb.com/forums/thread39857.html[/url]