urtrivedi

SELECT * FROM tableA WHERE (b= 'y' or (b<>'y' and a='x') or (a<>'x' and b<>'y' and a = '' AND b = '') )

there are some username in playerwepons which does not exist in your users table, so it is not allowing you to add constraint. If you want to add contraint, you have to delete that usernames from weapon table which does not exists in your users table, or add that usernames …

For such case I have created education master table edu_id, edu_desc, edu_order, 1, SSC, 1 2, hsc,2 3, PHD, 3 I will create on more table user_eductaion userid, edu_id (ref to above), marks, percent,year When you insert userid in your usertable at same time you can insert all multiple records …

call exec multile times

what are you trying to do, and what exactly the error you are getting.

same query works here fine

what is the problem? whats happening? or what not happening?

1) User can do coding in any langauage or only one? 2) you want to compile code online?

You are depending on the data entered in text area. This is poor design. If any how you solve your current problem, big unsolvable problems are waiting for you in future

submit your code then we may able to help you.

Its nothing but request/response game. If you note in case of flight. In the brouwser, in his/her pc, user chose flight, class, date of travel, then u press submit Now that submitted parameters are send to page on the server so server use this parameters to query database that how …

In your code above I have changed line number 36. I have commented 80-86 lines. <table width="750" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td> <?php include "../../db.php"; ?> <?php error_reporting(0); //Rows $imgRow = '<tr>'; $idRow = '<tr>'; $nn=10; //Number of items, we split this later $s=mysql_query("SELECT * FROM `products`"); $c=mysql_num_rows($s); if($c%$nn==0){ …

1) semicolor at the end is not needed or $tquery="SELECT questions.id,questions.date,questions.title,users.user_name,subjects.subject FROM questions INNER JOIN users ON questions.student_id=users.id INNER JOIN topics ON questions.topic_id=topics.id INNER JOIN subjects ON topics.subject_id=subjects.id WHERE subjects.id=".$_SESSION['sub1']." OR subjects.id=".$_SESSION['sub2'].";"; echo $tquery; 2) a you can echo query before mysql_query, b run script in browser, c you will …

1) you must have one primary key in records table 2) that primary key must be referred in upload table 3) on upload page you can check (count) number of files uploaded for id , it its 2, then do not allow more uploads, if its less then 2 than …

what error does it return (may be you can see error number also) Here query runs perfectly

Following way you can refer third record (index=2). echo "Third person: ".$data[2]['FirstName']." ".$data[2]['LastName']."-".$data[2]['Amount'];

Usually in you computer if firewall is installed. You have to allow http port to other users in network. Like in windows you can manage firewall from control panel.

you can use javascript timer functions http://www.w3schools.com/js/js_timing.asp

reading books practising exampels given in books read whole book with practise and start small assinment projects

is it php script? is it single file script or multiple files? can u post script code here?

it is not going in the following if condition if ( (!empty($_REQUEST['id']) && !empty($_REQUEST['mode'])) && $_REQUEST['mode'] == "delete")

change line 37 to following, <form method="post" action="<?php echo $_SERVER['PHP_SELF']?>">

very strange

You are missing ON keyword after inner join subjects SELECT questions.id,questions.date,questions.title,users.user_name,subjects.subject FROM questions INNER JOIN topics ON questions.topic_id=topics.id INNER JOIN subjects **ON** topics.subject_id=subjects.id INNER JOIN users ON subjects.id=users.sub1 OR subjects.id=users.sub2 WHERE users.id=8;

http://en.wikipedia.org/wiki/Asp.net

1 )Your site is in joomla/wordpress/drupal or custom? 2) Are you owner or programmer?

THERE is differenct between parameter passing in mysql and mysqli. Link is passed later in mysql and passed as first parameter in mysqli. so refer manual of mysql and replace parameter position where applicable

submit full code

to access another server mysql data, you need to have permission to do so in mysql. If you know administrator you can ask him to allow access to the server.

line 63 change it as following we make quantity 0 if use keep it blank if(trim(=$_REQUEST["es_quantity"])=='') $es_quantity="0"; else $es_quantity=$_REQUEST["es_quantity"]; 112-116 comment 4 lines /* if ( !is_numeric($es_quantity) || ($es_quantity < 0) ) { $errs[$errcnt]="$Quantity_must_be_non_zero_positive_integer"; $errcnt++; } */ replace 709 to 715 by following code if(frm.es_quantity.value!='') { if( isNaN(frm.es_quantity.value) || frm.es_quantity.value<0) …

Usually I have faced 2 issues with file upload. 1) web user may not having permission to write on the folder you chosed for update 2) if user file size is bigger then limit configured on the server then it will not upload check admin setting and directory permission in …

You need to learn regular expressions http://php.net/manual/en/function.preg-match.php

You need to write javascript function, which will be called when item is selected in dropdown. That function will add value/text to DIVs

{'type':'string','label':'Analys'}, {'type':'number','label':'Test 1'}, {'type':'number','label':'Test 2'} I have changed type of 2 last rows to number from string

changed if ladder [CODE]<?php session_start(); $connection=mysql_connect("localhost","root",""); $db=mysql_select_db("bank",$connection); $username = $_POST['username']; $password = $_POST['password']; $newpassword = $_POST['newpassword']; $newpassword = md5($newpassword); $confirmnewpassword = $_POST['confirmnewpassword']; $confirmnewpassword = md5($confirmnewpassword); $result = mysql_query("SELECT password FROM users WHERE username='$username'"); if(!$result) { echo "The username you entered does not exist"; } else if(md5($password)!=mysql_result($result,0)) { echo "You entered …

At a time how many record you want to fetch?

I am not sure about how asp.net uses cookies, But in php I used cookies to solve this kind of issues. I had problem when user presses refresh button, it was inserting same record with new id. So I used cookies to track where record inserted or not.

I dont find any parse error in your code. What message you getting when you run this script. ONe thing I see in line number 10, is its not $PHP_SELF rather its $_SERVER['PHP_SELF'];

Copy above file to one another file. Now you need this file to modify according to following algorithm. [code] find users query while (all users) { htmlmessage="" while ( find all expired records for current user (as you are doing in your code for logged user only)) { create htmlmessage …

I hope inner join works in postgress, try following query select v.name as object, t.taggable_type as Type FROM views v left outer join taggings t on (v.id = t.taggable_id and t.taggable_type = 'View') where t.taggable_id is null

Try this link [http://www.orafaq.com/faq/how_does_one_get_the_time_difference_between_two_date_columns](http://www.orafaq.com/faq/how_does_one_get_the_time_difference_between_two_date_columns)

there are 2 ways, 1) conventional way, on changing selection, you can submit page to server, on server php source will fetch record by parameter passed display record on page 2) jquery/ajax You need to learn jquery/ajax on changing selection, you can pass value to server without submitting whole page …

you need to echo $image_id in link, otherwise you will not receive actually image id value. <a href=\"editimage.php?img=<?php echo $image_id ?>\">Edit</a> To check how value passed in your editimage.php, you can dump variables in the beginging <?php //editimage.php echo "<pre>"; print_r($_GET); echo "</pre>"; . . . other code ?>

SELECT view_bom_total.mat_code1, Sum(view_bom_total.net_qty) net_qty, Sum(view_mrir_esd.acpt_qty) FROM view_bom_total inner join view_mrir_esd ON view_bom_total.mat_code1=view_mrir_esd.mat_code1 GROUP BY view_bom_total.mat_code1

open link in your browser http://servername/phpmyadmin/index.php give root/pwd I assume that phpmyadmin is installed on the web root folder

I have added on line ",avg(usage2) overall_avg" Select Partno ,SUM(Case When TransMOnth='January' Then Usage2 else 0 End) As Jan ,SUM(Case When TransMOnth='February' Then Usage2 else 0 End) As Feb ,SUM(Case When TransMOnth='March' Then Usage2 else 0 End) As Mar ,SUM(Case When TransMOnth='April' Then Usage2 else 0 End) As Apr ,SUM(Case …

You can write following code in your process page <?php $wherecond=""; $sep=""; for ($i=0;$i<count($_POST['interests']);$i++) { $wherecond .= $sep." colname like '%".$_POST['interests']."%' " $sep=" or "; } $query="select * from tablename where ". $wherecond; ?>

I think you are searching following link http://www.apphp.com/php-datagrid/examples/sample_1_2_demo.php This is demo of one existing datagrid tool. they give ver 4.2.8 as free (very basic). Rest versions are paid and advanced.

ok

you may try to look at this link http://www.michaelphipps.com/how-print-pdf-php-printer