Jump to content

jeger003

Members
  • Posts

    260
  • Joined

  • Last visited

Contact Methods

  • Website URL
    http://semesterold.com

Profile Information

  • Gender
    Not Telling

jeger003's Achievements

Regular Member

Regular Member (3/5)

0

Reputation

  1. does anyone know another way without using outside softwares or browser plugins? can this be done within the page it self with php, javascript, or any other language?
  2. i have seen plugins but I dont want to do that. i want to be able to load the page with fields already filled then I just have to fill the other ones. Could i load the javascript form in a iframe and send the data from the page to the iframe?
  3. Hello, I submit info to a javascript on another website. I want to be able to autofill the fields so i dont have to type everything. Is it possible to send form fields through the url? if not is it possible to take the form and create a page on my own server and submit to them from my site? Just trying to see what my options are. I dont want to use any softwares or anything.
  4. All my urls have something like this after except for the homepage. #.UTyO5hzviSo Im trying to figure out why its doing this. I turned off many of the plugins but it still appears. anyone seen this before?
  5. I am using InnoDB tables and i have been getting multiple table locks. The tables get 6-7 update and insert queries per second as well as 4-5 select COUNT(*) of all rows per second for live data. could this activity cause tables to lock?
  6. Table Locks makes no sense to me. I read through the mysql doc but its been no help. I have multiple tables locking and other queries time out because of it. From my understanding: MySQL locks a table on any transaction whether its doing SELECT,UPDATE,INSERT etc. MySQL will not release the lock until either the connection has disconnected or it has completed the transaction. if thats the case then when is a row locked? How can I prevent table locks? my server does 90% UPDATE INSERT 10% SELECT, JOINS etc please dumb it down for me.
  7. db ftd_store is being replicated and rdb is not. It seems to be sending the query to the SLAVE and that db does not exist on the SLAVE.
  8. Thanks! what about this issue? I get this error when I run a query: Error 'Table 'rdb.rest' doesn't exist' on query. Default database: 'ftd_store'. Query:... when I run this: INSERT INTO ftd_store.sdnt(dom,art,ttl,ttl_count,last_updated) SELECT * FROM ( SELECT dom,art,ttl,COUNT(OKey) AS ttlCount, NOW() FROM rdb.rest WHERE dom = dom_val GROUP BY art,ttl ORDER BY dom,ttlCount DESC LIMIT 200 ) aliasResults ON DUPLICATE KEY UPDATE ttl_count = ttlCount, last_updated = NOW();
  9. still messing around with this and it doesnt seem to be my queries.
  10. well does it slow anything down to have a constant connection open? thats my main reason of closing it off. Also I have an event that runs once a day to update the MASTER. So in the entire day the MASTER has activity only once!
  11. hello, I don't like the fact that there is a connection open 24/7 from slave to master. I want to specify a time of the day to open a connection and test whether there are any updates. Is this possible?
  12. here it is again. <script> $(document).ready(function() { $("#domains").children('option:gt(0)').hide(); $("#bts").change(function() { $("#domains").children('option').hide(); $("#domains").children("." + $(this).val() + "").show() }) }) </script> <form action="#" method="get"> <select name="bts" id="bts"> <option></option> <?php //mysql_close(); $query = mysql_query("SELECT DISTINCT bt_name, sd,id FROM db.s WHERE bt_name != 'optimus' ORDER BY id"); while($botname = mysql_fetch_array($query)) { echo '<option value="'.$botname['id'].'">'.$botname['bt_name'].'</option>'; } ?> </select> <select name="domains" id="domains"> <option></option> <?php //mysql_close(); $query = mysql_query("SELECT DISTINCT bt_name, sd,id FROM db.s WHERE bt_name != 'optimus' ORDER BY id"); while($botname = mysql_fetch_array($query)) { echo '<option value="'.$botname['sd'].'" class="'.$botname['id'].'">'.$botname['sd'].'</option>'; } ?> </select> <input type="submit" name="go"/> </form>
  13. I have this: http://jsfiddle.net/Mxkfr/2/ after adding my mysql query to the drop down it stops working after the 20th record in the first drop down. meaning it wont show up the record of the second drop down It's exactly the 20th. the drop down has 150 records. http://pastebin.com/G8UJei6A I put my code on jsfiddle and pastebin because I don't like it coming up on google.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.