jazzman1

You have a problem with the first table - filters. To optimize this query we need to know a little about the structure of that table and the current indexes. Give us your results, please! mysql> DESCRIBE filters; mysql> SHOW INDEX FROM filters;

No, you wrong.

Try, <?php /*-------------------------------*/ /* Template Name: Contact Page /*-------------------------------*/ get_header();?> <div class="blog"> <?php if(get_option('breadcrumbs') == 'yes') { ?> <div class="blog-info"> <?php the_breadcrumb();?> </div> <?php if(get_option('breadcrumbs_search') != 'no') { get_template_part('search_form'); } } ?> <div id="main"> <?php if(have_posts()) { while(have_posts()) { the_post();?> <div id="post-<?php the_ID();?>"> <div class="contact-item"> <?php if(has_post_thumbnail()) { the_post_thumbnail();?> <img src="<?php echo get_template_directory_uri();?>/images/image_shadow_680.png" style="margin-top: -6px" class="semi_trans" /> <?php } ?> <div style="clear:both"></div> <div class="post-title" style="margin-bottom: 30px<?php if(has_post_thumbnail()) { ?>;padding-top: 10px<?php } ?>"> <?php the_title(); ?> </div> <div style="clear:both"></div> <div class="post-content"> <?php the_content();?> </div> <?php if(get_option('google_map') != '') { ?> <div class="google-map"> <?php echo stripslashes(get_option('google_map'));?> </div> <?php } //If the form is submitted if(isset($_POST['submittedPage'])) { get_template_part('includes/submit-page'); } if(isset($emailSent) && $emailSent == true) { ?> <p class="thanks"><?php if(get_option('thankyou_message') != "") { echo get_option("thankyou_message"); } else { ?><strong>Thanks!</strong> Your message has been sent.<?php } ?></p> <?php } else { if(isset($captchaError)) { ?> <p class="error">There was an error submitting the form.<p> <?php } if(get_option('contact_form_title') != '') { ?> <h3><?php echo get_option('contact_form_title');?></h3> <?php } ?> <a name="#reload"></a> <form action="<?php the_permalink();?>" id="contactFormPage" method="post"> <label class="textfield_label" for="contactNamePage">Name: *</label> <p> <input type="text" name="contactNamePage" id="contactNamePage" value="<?php if(isset($_POST['contactNamePage'])) { echo $_POST['contactNamePage']; } ?>" class="page_requiredField textfield<?php $nameError = isset($nameError) ? $nameError : '';if($nameError != '') { echo ' inputError'; } ?>" size="22" tabindex="5" /> </p> <label class="textfield_label" for="emailPage">Email: *</label> <p> <input type="text" name="emailPage" id="emailPage" value="<?php if(isset($_POST['emailPage'])) { echo $_POST['emailPage']; } ?>" class="page_requiredField page_email textfield<?php $emailError = isset($emailError) ? $emailError : '';if($emailError != '') { echo ' inputError'; } ?>" size="22" tabindex="6" /> </p> <label class="textfield_label" for="subjectPage">Subject:</label> <p> <input type="text" name="subjectPage" id="subjectPage" value="<?php if(isset($_POST['subjectPage'])) { echo $_POST['subjectPage']; } ?>" size="22" tabindex="6" /> </p> <label class="textfield_label" for="commentsPage">Message: *</label> <p> <textarea name="commentsPage" id="commentsPage" rows="10" cols="36" tabindex="7" class="page_requiredField textarea<?php $commentError = isset($commentError) ? $commentError : '';if($commentError != '') { echo ' inputError';} ?>"><?php if(isset($_POST['commentsPage'])) { if(function_exists('stripslashes')) { echo stripslashes($_POST['commentsPage']); } else { echo $_POST['commentsPage']; } } ?></textarea> </p> <p class="screenReader"> <label for="checking" class="screenReader">If you want to submit this form, do not enter anything in this field</label><input type="text" name="checking" id="checking" class="screenReader" value="<?php if(isset($_POST['checking'])) { echo $_POST['checking']; } ?>" /> </p> <p class="loadingImgWidgetFt"></p> <p> <input type="checkbox" name="option" value="copy"<?php if(isset($_POST['option'])) { echo(' checked'); } ?> /> <label for="option" class="auto_copy">E-mail a copy of this message to your own address</label> </p> <?php if(get_option('contact_captcha') == 1) { ?> <?php if(get_option('template_style') == 'dark') { $captch_bg = 'black'; } else { $captch_bg = 'white'; } ?> <div id="mc"> <label>Please draw the shape in the box to submit the form: <sup><a onclick="window.location.reload()" href="#reload" title="Click for a new shape" id="refreshCaptcha">New shape</a><sup></label><br /><br /> <canvas id="mc-canvas" style="background-color: <?php echo $captch_bg;?>"></canvas> </div> <?php } ?> <input name="submittedPage" <?php if(get_option('contact_captcha') == 1) { ?>disabled="disabled" autocomplete="false" <?php } ?>id="submittedPage" class="page_button" tabindex="8" value="<?php if(get_option('button_text') == "") { echo "Send Message"; } else { echo get_option('button_text'); } ?>" type="submit" /> <input id="submitUrlPage" type="hidden" name="submitUrlPage" value="<?php echo get_template_directory_uri() . '/includes/submit-page.php'; ?>" /> <input id="emailAddressPage" type="hidden" name="emailAddressPage" value="<?php if(get_option('recipient_email') == "") { bloginfo('admin_email'); } else { echo get_option('recipient_email'); } ?>" /> <input id="textMessage" type="hidden" name="textMessage" value="<?php if(get_option('subject_message') == "") { echo "Message From Website Contact Form"; } else { echo get_option('subject_message'); } ?>" /> </form> <?php if(get_option('contact_captcha') == 1) { if(get_option('third_color')) { $third_color = get_option('third_color');if(get_option('template_style') == 'dark') { $captch_stroke = 'dark'; } else { $captch_stroke = 'light'; } } else { if(get_option('template_style') == 'dark') { $third_color = "aaff00";$captch_stroke = 'dark'; } else { $third_color = "6f6f6f";$captch_stroke = 'light'; } } <script src="<?php echo get_template_directory_uri();?>/scripts/motionCaptcha/motionCaptcha_<?php echo $captch_stroke;?>.js"></script> <script type="text/javascript"> jQuery(document).ready(function(jQuery) { jQuery('#contactFormPage').motionCaptcha({ action: '#submitUrlPage', canvasFont: '11px Verdana', canvasTextColor: '#<?php echo $third_color;?>', shapes: ['triangle', 'x', 'rectangle', 'circle', 'check', 'caret', 'zigzag', 'arrow', 'leftbracket', 'rightbracket', 'v', 'delete', 'star', 'pigtail'] }); }); </script> <?php } } ?> </div><!-- contact-item end--> </div><!-- post end --> <?php } } ?> <div style="clear:both"></div> </div><!-- main end --> <?php get_sidebar();?> </div><!-- blog end --> <?php get_footer();?>

Hm.... there is no error message, but still nothing happened. I'll continue digging up, maybe the problem now is from a remote one. Thanks guys.

Christian, forget about php. This is only a bash script dumping the file from a mms remote server. It's going to be something like this: mplayer -dumpstream -dumpfile 2012.11.18 -Sunday- (00-00).wmv mms://vod.bgtelevizia.com/vod/onlineBTV-HQ/[bTV] 2012.11.18 -Sunday- (00-00).wmv

Can you give me a simple example reference to the script above? Thank you buddy

I know that Pika, but the syntax error still appears. Ops, new error appears: ERROR: Error parsing option on the command line: -Sunday-

Hey friends, I'm trying to run a video file from mms (microsoft media server) into a linux terminal , but I've got a syntax bash error. How to escape parenthesis and maybe encoding empty spaces? Example : mplayer mms://vod.bgtelevizia.com/vod/onlineBTV-HQ/[bTV] 2012.11.18 -Sunday- (00-00).wmv ERROR: bash: syntax error near unexpected token `(' Example 2 works without any problems: mplayer mms://v3.bgtelevizia.com/onlinebtv?token=4d377bcabbec99de204f68b5dbbba2fd Thank you in advance!

Phone them !

Try, 0 */2 * * * /usr/local/bin/php -f $HOME/minecraft-backups/mcbackup.php > $HOME/minecraft-backups/backup.log 2>&1 Learn about more a cron job schedule from here - http://en.wikipedia.org/wiki/Cron

Ha-ha-ha, Pika I suspected the same like you, oped up this site, so start searching "range" and found nothing -> http://msdn.microsoft.com/en-us/library/aa238507%28v=sql.80%29.aspx After your post I saw that I was looking reserved words in MSSQL @BenardZMEDIA, do you know that phpmyadmin is a not database? Your title is wrong.

B/s your database is a case sensitive and Barand's used (t2.id = X.table2id), t2.id must be t2.ID. My query is also wrong, it should be something like this SELECT title FROM tabel2 WHERE ID NOT IN ( SELECT table2id FROM tabel3 WHERE table1id = 1 )

No, you wrong. For userID 1, you should retrieve the titles - Apples and Oranges. For userID 2 - All titles For userID 3 - Oranges and Grapes My solution is simple, SELECT title FROM tabel2 WHERE id NOT IN ( SELECT table2Id FROM tabel3 WHERE tabel1id = 1 )

So, your problem is obvious!

You can use a cron ob to send the php scrips like a demon. In the same way I've sent about 2000 mails to my subscribers in 30 min delay.. Do you need to give you an example about this ?

Wow..... I'm just a stupid man. Thank you Psycho Thanks everyone for your help. Solved!

But, it's alredy a dimensional array. If I'm using the code like below, see the result: $query = 'SELECT * FROM users'; $result = mysql_query($query); while ($row = mysql_fetch_assoc($result)) { $menu_array[$row['id']] = array($row['email']=>$row['name']); } function partition( $list, $p ) { $listlen = count( $list); $partlen = floor( $listlen / $p ); $partrem = $listlen % $p; $partition = array(); $mark = 0; for ($px = 0; $px < $p; $px++) { $incr = ($px < $partrem) ? $partlen + 1 : $partlen; $partition[$px]= array_slice($list, $mark, $incr); $mark += $incr; } return $partition; } echo '<pre>'.print_r( partition( $menu_array, 5 ), 1).'</pre>'; Results: Array ( [0] => Array ( [0] => Array ( [jazzman_1@gmail.com] => jazzman ) [1] => Array ( [slippers@gmail.com] => slippers ) [2] => Array ( [tuparov@gmail.com] => tuparov ) ) [1] => Array ( [0] => Array ( [jazzman_2@gmail.com] => jazzman ) [1] => Array ( [jazzman_3@gmail.com] => jazzman ) [2] => Array ( [jazzman_3@gmail.com] => jazzman ) ) [2] => Array ( [0] => Array ( [jazzman_4@gmail.com] => jazzman ) [1] => Array ( [jazzman_5@gmail.com] => jazzman ) [2] => Array ( [jazzman_6@gmail.com] => jazzman ) ) [3] => Array ( [0] => Array ( [jazzman_7@gmail.com] => jazzman ) [1] => Array ( [jazzman_8@gmail.com] => jazzman ) [2] => Array ( [jazzman_9@gmail.com] => jazzman ) ) [4] => Array ( [0] => Array ( [jazzman_10@gmail.com] => jazzman ) [1] => Array ( [jazzman_9@gmail.com] => jazzman ) ) )

Hi friends, assuming that I currently have an array like this, Array ( [0] => Array ( [jazzman_1@gmail.com] => jazzman ) [1] => Array ( [slippers@gmail.com] => slippers ) [2] => Array ( [jazz@gmail.com] => jazz ) [3] => Array ( [jazzman_2@gmail.com] => jazzman ) [4] => Array ( [jazzman_3@gmail.com] => jazzman ) [5] => Array ( [jazzman_4@gmail.com] => jazzman ) [6] => Array ( [jazzman_5@gmail.com] => jazzman ) [7] => Array ( [jazzman_6@gmail.com] => jazzman ) [8] => Array ( [jazzman_7@gmail.com] => jazzman ) [9] => Array ( [jazzman_8@gmail.com] => jazzman ) [10] => Array ( [jazzman_9@gmail.com] => jazzman ) [11] => Array ( [jazzman_10@gmail.com] => jazzman ) [12] => Array ( [jazzman_11@gmail.com] => jazzman ) [13] => Array ( [jazzman_12@gmail.com] => jazzman ) ) What is the best way resorting it and the final result I wanna be exactly like this: Array ( [0] => Array ( [jazzman_1@gmail.com] => jazzman [slippers@gmail.com] => slippers [jazz@gmail.com] => jazz ) [1] => Array ( [jazzman_2@gmail.com] => jazzman [jazzman_3@gmail.com] => jazzman [jazzman_4@gmail.com] => jazzman ) [2] => Array ( [jazzman_5@gmail.com] => jazzman [jazzman_6@gmail.com] => jazzman [jazzman_7@gmail.com] => jazzman ) [3] => Array ( [jazzman_8@gmail.com] => jazzman [jazzman_9@gmail.com] => jazzman [jazzman_10@gmail.com] => jazzman ) [4] => Array ( [jazzman_11@gmail.com] => jazzman [jazzman_12@gmail.com] => jazzman ) ) Thank you in advance! jazz.

You are missing the last brace of the mysql_query function. EDIT: Andy123, sorry for my post

Could you echoing out your $query before to send it to the database and post out the result, please. I suspect that you have a syntax error(s). Also, instead of die('Could not execute INSERT query') use die(mysql_error()).

What kind of transport do you use? Can you show us the script?

Show us other fields from the form and explain in clear English what do you want to do with this...

Yep, the code could be something like that, $numbers = array_map('intval',explode(',', trim($searchText))); foreach ($numbers as &$number) { if (is_int($number) && strlen($number) == 4) { echo "$number is ok"; } else { echo "$number is not a 4 digit number"; } }

For example, $result = mysql_query("Select * from student where rollno = '$rnum'") or die(myslq_error());

I've made 40 registrations last night, so if someone has a interest, he/she could send me a PM. jazz