Delete orders ,orders_products from orders INNER JOIN orders_products where orders.orders_id = orders_products.orders_id and orders.orders_id =24
m.ganesh@cogitsolutions.com
M/S COG IT SOLUTIONS
Delete orders ,orders_products from orders INNER JOIN orders_products where orders.orders_id = orders_products.orders_id and orders.orders_id =24
m.ganesh@cogitsolutions.com
M/S COG IT SOLUTIONS
update with replace
UPDATE wp_posts SET post_body = REPLACE(post_body, ‘needle’, ‘chocolate’);
m.ganesh@cogitsolutions.com
M/S COG IT SOLUTIONS
Check record and insert with in one query
insert int tbl (Col1,col2,col3) select col1,col2,col3 from tbl where col1=”val”
LI tag – list item
Used within the
but many WYSIWYG web page editors omit the tag which can cause problems validating the resulting HTML file. The
* li style = “list-style-type:none”
* li style = “list-style-type:disc”
* li style = “list-style-type:circle”
* li style = “list-style-type:square”
* li style = “list-style-type:decimal”
* li style = “list-style-type:upper-roman”
* li style = “list-style-type:lower-roman”
* li style = “list-style-type:upper-alpha”
* li style = “list-style-type:lower-alpha”
* li style = “list-style-image:url(../images/spot.png);”
* li style = “list-style-position:inside;”
* li style = “list-style-position:outside;”
“used style such as followes .Section1 ul
{
padding:3px;
}
.Section1 ul>li
{
padding:2px 5px 2px;
font-weight:normal;
list-style-image:url(“”images/icon_bullet.gif”");
list-style-position:inside;
}”
m.ganesh@cogitsolutions.com
M/S COG IT SOLUTIONS
While reading few posts I found that SQL_CALC_FOUND_ROWS is faster than two queries. But a very good discussion found at http://www.mysqlperformanceblog.com/2007/08/28/to-sql_calc_found_rows-or-not-to-sql_calc_found_rows/comment-page-1/#comment-661064. check this out
One member posted following on above blog which is worth to read
Please visit the mysql official documentation here http://dev.mysql.com/doc/refman/5.1/en/information-functions.html
Please have a look at FOUND_ROWS() function. They have mentioned that it is much faster to use the query with sql_calc_found_rows rather than using a query again. And I don’t find any reason not to trust them.
Error ‘8004020e’ and Error ‘80040211′ in the ASP Development
Error ‘80040211′
set up send url and smtp url
Error ‘8004020e’
from email id should be properly formatted and some times must be from same domain
sendUrl=”http://schemas.microsoft.com/cdo/configuration/sendusing”
smtpUrl=”http://schemas.microsoft.com/cdo/configuration/smtpserver”
‘ Set the mail server configuration
Set objConfig=CreateObject(“CDO.Configuration”)
objConfig.Fields.Item(sendUrl)=2′cdoSendUsingPort
objConfig.Fields.Item(smtpUrl)=”relay-hosting.secureserver.net”
objConfig.Fields.Item (“http://schemas.microsoft.com/cdo/configurationsmtpserverport”) =25
objConfig.Fields.Item (“http://schemas.microsoft.com/cdo/configurationtpauthenticate”) =1
‘objConfig.Fields.Item (“http://schemas.microsoft.com/cdo/configuration/sendusing”) =1
‘objConfig.Fields.Item (“http://schemas.microsoft.com/cdoconfiguration/smtpserver”) =”relay-hosting.secureserver.net”
objConfig.Fields.Update
‘ Create and send the mail
Set objMail=CreateObject(“CDO.Message”)
” Use the config object created above
Set objMail.Configuration=objConfig
objMail.From= “CEPHAS WebSite
objMail.To= “xxx@domain.com”
objMail.Subject=”Customer Connection Survey Form from Website”
objMail.TextBody= MsgBody ‘”body”
objMail.Send
* A standard receipt printer uses the parallel port.
* To print to the parallel-port receipt printer, you print through port PRN (exactly the same as printing from DOS prompt).
* From within PHP-GTK2, you need to first establish the connection with the printer by using
$handle = fopen(“PRN”, “w”);
* Thereafter, to print anything to the printer, you just “write” to it like the file handle: fwrite($handle, ‘text to printer’);
* There are newer receipt printer that uses USB. I believe you should be able to print to such printers through PRN too.
for more details visit http://www.kksou.com/php-gtk2/articles/interface-to-receipt-printer-in-a-point-of-sale-system.php
Another way is using PHP printer functions introduced in PHP 4 > .
You not only need php_printer.dll you need a version compiled from the same
source as the rest of your php installation. You can always find new binaries
at http://kromann.info/php4.php. These binaries are compiled from the same
snapshot, and will work together.
When html and php code mixing is required in php development, at that time writing html code as it is is faster than printing html code using echo or print function. Reason is PHP interprets and compiles each php code statement and ignore any thing writting outside php tag. Hence php echo for html is slower compared to direct writing php.
Question is how to separate php and html for readability in php development. Better solution is write down html code in separate file and include that file in php. This way readability will increase while PHP web development and also speed will be achived.