This prevents anyone else from using the tables while you have them locked. It can also be used to execute a group of statements as a unit.
LOCK TABLES inventory WRITE
SELECT quantity FROM inventory WHERE item=”abc”
UPDATE inventory SET quantity=’123′ WHERE item=”abc”
UNLOCK TABLES
We use WRITE lock here because we need to modify the inventory table. If you [...]
Archive for August, 2009
Lock and Unlock Tables
Thursday, August 27th 2009 Tags: execute group of mysql statement, group mysql statement, lock multiple table, lock mysql table, lock table, mysql execute statements, mysql table lock, unlock multiple table, unlock mysql table, unlock table
PHP - How To Write To Text File
Wednesday, August 5th 2009 Tags: how to write to file, php file handle, php open file, php write data to file, php write file, php write text file, writing file in php
The fwrite function is used to write data to a text file. This function has two parameters. The first parameter is the file handle and second one is the string of data to be written.
To be written, the file must be opened first using the fopen function.
fopen(filename, mode)
The mode parameter specifies the type of access [...]
Remove Underline For A Url Text
Tuesday, August 4th 2009 Tags: link text underline remove, remove link text underline, remove url underline, text decoration, url decoration, url text decoration, url underline, url without underline
How to remove the underline for a url text which is there by default? Actually this is easy but for some people this is quite distressing. You can do that using CSS:
<a style=”text-decoration: none;” href=”#”>link text</a>
Okay! Hope this solve your problem!
- The Acrobat Reader Speed Launcher
- Remove Infoweb.net
- Display Text in MS Word Vertically
- Remove the Clear History Button in Windows XP
- MySql Error 1036 Table is Read Only
- Call to Undefined Function curl_init
- Hang When Installing Novell Netware 5
- Create Favicon for Your Website
- How To Add Or Subtract Hours From Datetime Expression
- Remove Mybrowserbar From My Browser
- samir patel in Merge Table Cells Using Javascript
- ankara hali y?k… in Call to Undefined Function curl_ini…
- SuperJet in Remove Mybrowserbar From My Browser…
- The Love in Remove Mybrowserbar From My Browser…
- ???? in Remove Mybrowserbar From My Browser…
- satyajeet in Merge Table Cells Using Javascript
- How come PR alw… in Remove Acronym or Abbr Underline In…
- Shermie in Get The Last Record from a Table
- martin in Getting The Domain Name Out Of A UR…
- rbc303 in Fireworks: Make Rounded Corner Edge…
- Fireworks: Make Rounded Corner Edges Image (4)
- Remove Mybrowserbar From My Browser (3)
- Naked Scuba Diving (2)
- Merge Table Cells Using Javascript (2)
- Check User Input Is Numeric or Character String (1)
- MySQL - Copy An Existing Table To A New Table (1)
- Getting The Domain Name Out Of A URL (1)
- Get The Last Record from a Table (1)
- Remove Acronym or Abbr Underline In Mozilla Firefox (1)
- Call to Undefined Function curl_init (1)
- Fireworks: Make Rounded Corner Edges Image
- Javascript - Get URL Parameters
- Merge Table Cells Using Javascript
- Get Domain Name From URL Using Javascript
- Javascript: Open new window containing php page
- Check User Input Is Numeric or Character String
- Remove Mybrowserbar From My Browser
- PHP - IP To Numeric Value
- PHP Create Zip file
- Exporting Data To TextFile
- convert ip to number convert ip to numeric value copy table to a new table copy table using mysql dll error dll file dll file corrupt dll not found domain name domain name from url Export Data fireworks horizontal line effect get domain from url get url parameters golfer social network import data javascript alert javascript alert method javascript dialogue box javascript get url parameter javascript load php page javascript open new window javascript open php page javascript pops up javascript prompt javascript tabbed page location href merge table cells Motion Trail Text mysql copy table mysql ip to number PC Router php compress file php create zip file php error PHP fatal error php ip to number php session how to php uploaded file rounded corner edges image url domain url domain name WinXP auto logon WinXP File Sharing zip using php