Narendra

I need a sql query to sort the results from a sql table. The structure is like Table name : categories catid parentid catname level ----------------------------------------------------------- 1 0 services 1 2 1 printing 2 3 1 cabling 2 4 0 Products 1 5 4 cables 2 6 4 switches 2 7 1 lubricating 2 Now I want to sort the above results grouped by parentid including parent category and then by catname in alphabetical order. Can some one suggest me the best way to do this using sql query.

Why don't you add this function to your contact for to validate the email? function is_email( $email, $check_dns = false ) { // Test for the minimum length the email can be if ( strlen( $email ) < 3 ) { return false; } // Test for an @ character after the first position if ( strpos( $email, '@', 1 ) === false ) { return false; } // Split out the local and domain parts list( $local, $domain ) = explode( '@', $email, 2 ); // LOCAL PART // Test for invalid characters if ( !preg_match( '/^[a-zA-Z0-9!#$%&\'*+\/=?^_`{|}~\.-]+$/', $local ) ) { return false; } // DOMAIN PART // Test for sequences of periods if ( preg_match( '/\.{2,}/', $domain ) ) { return false; } // Test for leading and trailing periods and whitespace if ( trim( $domain, " \t\n\r\0\x0B." ) !== $domain ) { return false; } // Split the domain into subs $subs = explode( '.', $domain ); // Assume the domain will have at least two subs if ( 2 > count( $subs ) ) { return false; } // Loop through each sub foreach ( $subs as $sub ) { // Test for leading and trailing hyphens and whitespace if ( trim( $sub, " \t\n\r\0\x0B-" ) !== $sub ) { return false; } // Test for invalid characters if ( !preg_match('/^[a-z0-9-]+$/i', $sub ) ) { return false; } } // DNS // Check the domain has a valid MX and A resource record if ( $check_dns && function_exists( 'checkdnsrr' ) && !( checkdnsrr( $domain . '.', 'MX' ) || checkdnsrr( $domain . '.', 'A' ) ) ) { return false; } // Congratulations your email made it! return true; } Now use if(!is_email($email)){ echo "Invalid Email"; }

I want a readymade script which can add selected description to the spam database. It must also check if a specific content is spam, based on the spam entries added previously to the database. Is there any such script that will do my job. Or I want a script that can link to akismet service to check the spam. Any one have this kind of script? Please paste the links in this post.