Network_ninja

Pardon me... Is it ok for you if you can give me some example on how you do it? tnx

hi everyone I have a question... does creating a connection to mysql takes time depeding on the database size? Lets say that in my entire project I will be connection to 4 databases so I created a config.php which looks like this: $hostname = "localhost"; $username = "root"; $pword = ""; $con1 = @mysql_connect($hostname,$username,$pword,true); @mysql_selectdb("databasename1",$con1); $con2 = @mysql_connect($hostname,$username,$pword,true); @mysql_selectdb("databasename2",$con2); $con3 = @mysql_connect($hostname,$username,$pword,true); @mysql_selectdb("databasename3",$con3); $con4 = @mysql_connect($hostname,$username,$pword,true); @mysql_selectdb("databasename4",$con4); so, this file is included in every pages, I put this on the top. Basically every page request it will open 4 connection and the script will only use 2 connection and another page will only 1 and so on..... this style is very convenient as for I am not creating a connection in every page.. But my concern is will it effect the performance of my system? Tnx in advance.....

I will try working on the indexes because the tables already have 3 indexes that are used by other queries... How many indexes can I create in a table? the table has 42 fields.. Sorry but I don't understand this question.. Why are you querying on parts of a column? Do you mean this part: right(depbank,1) = 'D' and right(checkstatus,2) = '-R' The queries and tables are created by the previous developers, what I am doing right now is trying to optimize the performance of the system... Tnx bro.....

In connection with the previous post, here is my query: Query1: select depbank,left(unitspaid,3) as unitspaid, sum(checkamtfx) as checkamtfx from pdc where statusdate = '2009-09-04' and right(depbank,1) = 'D' and right(checkstatus,2) = '-R' group by left(unitspaid,3),depbank Query2: insert into `cashpos3` (mbtcho)SELECT distinct depbank from pdc where statusdate = '2009-09-04' and right(depbank,1) = 'D' and right(checkstatus,2) = '-R' and not isnull(depbank) and depbank <> '' Query3: SELECT * FROM pdc WHERE depbank='MBTCHO' AND checktype <> 'ADV' AND batch ='2009-09-07' AND (NOT ISNULL(checkno) AND checkno<>'') AND RIGHT(checkstatus,2)<>'-H' order by checktype,pullorder Pls. see attach file for the accompanying EXPLAIN.... note: Query2 is an insert select type query, I obtain the EXPLAIN by removing the INSERT INTO and replacing it by EXPLAIN. [attachment deleted by admin]

In the slow query logs I can see something like this, what does it means? # Query_time: 16 Lock_time: 0 Rows_sent: 2 Rows_examined: 870923 # Query_time: 14 Lock_time: 0 Rows_sent: 0 Rows_examined: 870920 # Query_time: 15 Lock_time: 0 Rows_sent: 94 Rows_examined: 871013 - And we can also see that there are a lots of SELECT *, SELECT distinct in our queries will modify this one can help the performance? - And also we find out that the VB systems are not closing the connection after script execution, does also closing the connection will help increase the performance? - And does running OPTIMIZE table will also help increase the performance And also currently we are now modifying some of our queries... I will be back soon after we reconstruct our heavy queries.... Thanks for all your help guys.....

sorry.... but can u tell me what other information do you want to know? tnx

Tnx for the help guys....

can you share your code and I will try to look over it... tnx

hey guys... Sorry if i am posting this one in the wrong forum. We just have a problem in our company.. All our systems are loading so slow that takes about a minute or so and many are complaining about it: We have about 4 systems created in VB6 and about 4 systems created in PHP We use Mysql Database and the version is 4.1.10 We only use 1 machine, our database and codes resides in there: For the VB system : System 1: maximum of 200 user at a time, about 4GB database in size System 2: maximum of 20 user at a time, about 6GB database in size System 3: maximum of 10 user at a time, about 5GB database in size System 4: maximum of 15 user at a time, about 4GB database in size For the PHP System: System 1: maximum of 200 user at a time, about 8GB database in size System 2: maximum of 200 user at a time, about 2GB database in size System 3: maximum of 200 user at a time, about 1GB database in size System 4: maximum of 200 user at a time, about 3GB database in size Base from the info above guys what do you think is the reason why our systems are loading very slow.... Is it because our database is going bigger and bigger? or because of the number of user? We do have a proper index in our table and we also use LIMIT in our queries.... Tnx everyone...

I modified your code a little bit. You can try out this one.. So I also do believe that you have a correct HTML form to accept the inputs... Here is the code: <?php $db = mysql_connect("localhost", "Miguel", "MPSMFJ")or die(mysql_error()); $basedados = "OCFDO2011" ; mysql_select_db($basedados, $db)or die(mysql_error()); $passi = $_POST['password'] ; $equipa = $_POST['Comprador'] ; $querypc = "SELECT Password FROM Password WHERE IDEquipa = '$equipa'" ; $passc2 = mysql_query($querypc, $db)or die(mysql_error()); while($as = mysql_fetch_array($passc2)) { // you can ommit the while statement if you only have to fetch 1 record, You can also do it this way $passc = $as['Password'] ; // $as = mysql_fetch_array($passc2); } // $passc = $as['Password']; But it's still your preference if you do it that way if($passi != $passc) { $Estado = "Transferência Cancelada: Password Incorrecta" ; } else { $Jogador = $_POST['jogador'] ; $querycj = "SELECT IDEquipa FROM Jogadores WHERE IDJogador = '$Jogador'" ; $clubejog = mysql_query($querycj, $db)or die(mysql_error()); while($ford = mysql_fetch_array($clubejog)) { $cjogador = $ford['Equipa'] ; } if($cjogador == "ZZZ") { $qvalorj = "SELECT Preco FROM Val_Jog WHERE Valor = (SELECT Valor FROM Jogadores WHERE IDJogador = '$Jogador')" ; $valorj = mysql_query($qvalorj, $db)or die(mysql_error()); while($ab = mysql_fetch_array($valorj)) { $vjogador = $ab['Preco'] ; } $vprop = $_POST['valor'] ; if($vprop == $vjogador) { $querync = "UPDATE Jogadores SET IDEquipa = $equipa WHERE IDJogador = '$Jogador'" ; $novoclube = mysql_query($querync, $db)or die(mysql_error()); $queryif = "INSERT INTO Mov_Fin (IDEquipa, Montante, Descricao) VALUES ($Equipa, '-$vprop', 'compra jogador $Jogador')" ; $insfin = mysql_query($queryif, $db)or die(mysql_error()); $Estado = "Transferência bem sucedida..." ; } else { $estado = "Transferência Cancelada: O valor da proposta não é aceitável..." ; } } else { $queryip = "INSERT INTO Propostas (IDEquipa, Jogador, Valor, Tipo) VALUES ($Equipa, $Jogador, $vprop, 'Compra')" ; $insprop = mysql_query($queryip, $db)or die(mysql_error()); $queryup = "UPDATE Propostas SET Vendedor = (SELECT Equipa FROM Jogadores WHERE IDJogador = '$Jogador'"); $updprop = mysql_query($queryup, $db)or die(mysql_error()); } } echo $Estado; ?>

why? is it bad to rename a table? what if we really need to change the name of it?

Tnx bro... I am planing to mke my tablenames as variable so that in the future if we need to rename the table we will not be editing a lot of code....

simply because you use the name "Date" in your fieldname..... You cannot use that for fieldname because it's a reserve word. You can see the complete reserve words here: http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html

hey guys.... Just have a question Is it advantageous or will do good if i make my tablename as a variable? For example: $table1 = "first_table"; $table2 = "second_table"; Query: $query = @mysql_query("SELECT * FROM $table1 "); or does it still good practice if I write my queries like this: $query = @mysql_query("SELECT * FROM first_table"); tnx everyone....

This is my new code. But still not working well. INSERT INTO table2 (code,description) SELECT code,description FROM table1 ON DUPLICATE KEY UPDATE description=(SELECT description FROM table1) by the way I am using the field code to check if it exist in the other table... not the tranid which is my primary and is auto-increment field.. tnx....

Is it possible to do a single query that update or insert a record? For example I have to tables... table1 table2 tranid code description tranid code description 1 001 zero zero one 1 001 one zero zero 2 002 zero zero two 2 002 two zero zero 3 003 zero zero three 3 003 three zero zero 4 004 zero zero four 5 005 zero zero five my question is i have to update the record in table2. If the code in table1 already exist in table2 update the description. If the code in table1 does not exist in table2 insert the record. so after the query table2 will look sumting lyk dis: table2 tranid code description 1 001 zero zero one 2 002 zero zero two 3 003 zero zero three 4 004 zero zero four 5 005 zero zero five This is my current code that is not working: SELECT * FROM `table1` if((SELECT COUNT(tranid) FROM table2 WHERE table2.code=table.code) == 0,(INSERT INTO table2 VALUES('',table1.code,table2.code) ),(UPDATE table2 SET table2.description=table.1description WHERE table2.code=table1.code) )

waiting for your reply guys?

Guys? I have EasyPHP installed on my pc running in windows, my computer has a static ip address which is 192.168.100.92 i want that my system would be accessible with other pc connected with the network for example 192.168.100.44. I tried typing in the browser http://192.168.100.92/system1/index.php it says that unable to connect.. What should I do so that my system with be accessible to others.... tnx.....

tnx to the very quick reply.... so i would go to the code number 2. even if the difference in time is very slight.... tnx tnx tnx.....

guys? which do you think among this two codes execute faster. Code 1: <?php $query = @mysql_query("SELECT fld1,fld2,fld3 FROM tablename"); while($row = @mysql_fetch_array($query)) { echo $row['fld1']."<br>"; echo $row['fld2']."<br>"; echo $row['fld3']; } ?> Code 2: <?php $query = @mysql_query("SELECT fld1,fld2 FROM tablename"); while($row = @mysql_fetch_array($query)) { echo $row['fld1']."<br>"; echo $row['fld2'] * 1.12; } ?> How do i also get the difference in their execution time? Tnx....

Hi everyone... I decided to use Mysql Stored Procs but i don't find a complete tutorial on how this things work. But I already started creating one: Here is my simple SP: ; CREATE PROCEDURE GetAllProducts() Select * FROM products ; Question 1: Whenever I use this piece of code CALL GetAllProducts(); it will give me an ERROR 1312: PROCEDURE stored_procs. GetAllProducts can't return a result set in the given context Question 2: How do i display the created stored procs again.. so that I can review the code or modify the code. By the way I am using Mysql Control Center as my UI. Tnx in advance.

Yep. Currently it will display 5 thank you message. If you only want to display the message once remove it inside the mail function and have it echo outside the while loop.

Sory dude i miss out something pls. Change the first part of the mail function from mail($recepients_friend to mail($emails[$n]

I can't see any problem with your code if your current url looks like this: http://sitename/pagename.php?kurdish_id=value

You can do it like this: <form action="tellafriend.php" method="POST"> <fieldset> <input name="privateleaguename" type="hidden" value="<?php echo $row['privateleaguename']; ?>"> <input name="privateleaguepasscode" type="hidden" value="<?php echo $row['privateleaguepasscode']; ?>"> <legend>Invite a friend</legend><br /> Your name<br /> <input type="text" name="your_name" value="Your name" /><br /><br /> Friends email 1<br /> <input type="text" name="friend_email[]" value="Your friends email" /><br /><br /> Friends email 2<br /> <input type="text" name="friend_email[]" value="Your friends email" /><br /><br /> Friends email 3<br /> <input type="text" name="friend_email[]" value="Your friends email" /><br /><br /> Friends email 4<br /> <input type="text" name="friend_email[]" value="Your friends email" /><br /><br /> Friends email 5<br /> <input type="text" name="friend_email[]" value="Your friends email" /><br /><br /> <input type="Submit" value="Tell a friend" name="Submit" /> </fieldset> </form> <?php if (isset($_POST['Submit'])) { // This will check to see if the form has been submitted $senders_name = $_POST['your_name']; // The person who is submitting the form $privateleaguename = $_POST['privateleaguename']; $privateleaguepasscode = $_POST['privateleaguepasscode']; // The forms recipient $n = 0; $emails = $_POST['friend_email']; while($n < count($emails)) { mail($recipient_friend,"Invitation to join Private League from $senders_name", "Dear $emails[$n],\n\nYour friend $senders_name has created a private league and thought you would be interested in joining.\n\nPlease follow the link to register for FREE. Then enter the details below in the 'Join a Private League' section of your account page.\n\nPrivate League Name: $privateleaguename\nPrivate League Passcode: $privateleaguepasscode\n\nThank You"); $n++; } if (isset($_POST['your_name'])) { $n = 0; while($n < count($emails)) { echo "<br>Your friend at $emails[$n] has been contacted <br><br>Thank you $senders_name"; $n++; } }} ?><?php if (isset($_POST['Submit'])) { // This will check to see if the form has been submitted $senders_name = $_POST['your_name']; // The person who is submitting the form $privateleaguename = $_POST['privateleaguename']; $privateleaguepasscode = $_POST['privateleaguepasscode']; // The forms recipient $n = 0; $emails = $_POST['friend_email']; while($n < count($emails)) { mail($recipient_friend,"Invitation to join Private League from $senders_name", "Dear $emails[$n],\n\nYour friend $senders_name has created a private league and thought you would be interested in joining.\n\nPlease follow the link to register for FREE. Then enter the details below in the 'Join a Private League' section of your account page.\n\nPrivate League Name: $privateleaguename\nPrivate League Passcode: $privateleaguepasscode\n\nThank You"); $n++; } if (isset($_POST['your_name'])) { $n = 0; while($n < count($emails)) { echo "<br>Your friend at $emails[$n] has been contacted <br><br>Thank you $senders_name"; $n++; } }} ?>