urtrivedi

I think keep structure of delievery as it is. You may add one column in delivery that is order_id_reference. while creating delivery note you can show list of order and could be selected, which will copy all details of customerid, address and all that. You may also bring items and …

What you want to use, myql query , php code or combination of both?

Your university told you how to write php code, but they might have not told you how to configure your database and webserver. Now here at your workplace, I think there is no role of php. Microsoft will surely give you some option to import excel data directly to you …

where is the code, post it here, I think you need to wrap your value attribute of button with quotes [CODE]<input type=button name=btn1 id=btn1 value="<?php echo $sizes; ?>" >[/CODE]

I am assuming your method is POST, otherwise you may change it to GET [CODE] <select name="prop_type" onchange="display(this,'Private Apartments','Landed Property', 'Hdb Flat', 'Commercial', 'Hudc Apartments');"> <option >Please Select</option> <option value="Private Apartments" <?php echo ($_POST['prop_type']=="Private Apartments")?"selected":"";?>>Private Apartments</option> <option value="Landed Property" <?php echo ($_POST['prop_type']=="Landed Property")?"selected":"";?>>Landed Property</option> <option value="Hdb Flat" <?php echo ($_POST['prop_type']=="Hdb …

I think you do not need php , you can simply do it in mysql query itself [code] SELECT * from table_name where date_add(submit_date ,interval 21 day ) <= current_date [/code]

Even if you use another process reg page you can still send the entered data back to main form in case of error. If you want to send data to same form, you may use cookies to overcome resend issues. Ajax can work in any way, one page or two …

[url]http://devzone.zend.com/node/view/id/651[/url]

no such facility is there in html. You may user jquery-ui, datepicker, its easy to use

problem is in dbfucntions.php, post it here

Here you can see I have executed query only once, and shortened for loop. [CODE]$operator=""; $condition=""; for( $i = 0; $i < count($words); ++$i ){ $condition.=$operator." CONCAT(FirstName, ' ',LastName) LIKE CONVERT(_utf8 '%".$words[$i]."%' USING latin1) COLLATE latin1_swedish_ci"; $operator=" OR "; } $sql = "SELECT *,CONCAT(FirstName, ' ',LastName) as fullname FROM `ajax_demo_table` …

[CODE]$chkdt = "Wed Jun 15 2011 00:00:00 GMT 0530 (India Standard Time)"; $chkdtarr=explode("GMT",$chkdt); $newdt= strtotime($chkdtarr[0]); echo $newdt; echo "<br>".date("m/d/Y",$newdt);[/CODE]

having relationship is good thing to do in database, but it is not mandatory at all. You will not see much pk to pk relation (1 to 1). Generally you will find (pk-fk) kind of relation much in database.

upload sql script with definition and data of ajax_demo_table

post your php code of index.php file

post structure of ex_cat, and ex_tax or try with ` around word group, because group is reserved word [CODE] $sql="INSERT INTO ex_cat (username,exp_id,used_category,`group`,type) SELECT ex_tax.username,ex_tax.exp_id,ex_tax.category,ex_tax.`group`,ex_tax.type FROM ex_tax WHERE ex_tax.username='$uname' AND ex_tax.exp_id='$exp_id' AND ex_tax.used='1'";[/CODE]

not need to write COLUMN AND QUOTE [code] $insertQuery = "ALTER TABLE atable ADD $example INT"; [/code]

[CODE]<?php $arr1 = array('1','2','3','4','5','6','7','158','12'); $arr2 = array('2','5','4','8','12','6','7','154','124','131'); echo "<pre>"; $insert =array_diff($arr2,$arr1); $update =array_intersect($arr2,$arr1); //print_r($update); foreach($update as $key) { echo $key." update <br>"; } echo "<br><br>"; foreach($insert as $key) { echo $key." insert<br>"; } echo "</pre>"; ?>[/CODE]

search in google for JQUERY-UI, then see examples of AUTOCOMPLETE

if you have phpmyadmin then , get output your query using echo, then copy that query to phpmyadmin, and run. see what error you are getting there. [code] . . . $query="SELECT symSymbol,................. LIMIT 10"; echo $query; $result = @$db->query($query); . . . . [/code]

Better way to view your array is following, after setting your array, write following 3 lines at the end of your code. [CODE] echo "<pre>"; print_r($_SESSION['cart']); echo "</pre>"; [/code]

First of all make your link proper, use common get parameter for all a to z links, Here i m using alpha get variable. [code] printf ('<a href = "%s?result.php?alpha=%s">%s</a> ', $PHP_SELF,chr($i) , chr($i)); [/code] Then in your result.php you query must look like [code] $query="select * from tablename where …

Also add on more key that is autonumber say transaction ID. To avoid duplication make combination of three columns as unique (cardnumber,libraryid,chekcoutdate) checkout([U]trans_id[/U],cardNumber,libraryID, checkoutDate, checkinDate, dueDate)

[code] $string= nl2br($string); [/code]

your directory must look like following [code] webroot |__________molham |________Connections | |_________bdata.php |________edary.php [/code] OR set proper path in line require_once(Connections/bdata.php), so that php can locate bdata.php linux apache is case sensitive , so check the file spelling case in your diretories.

[code] myquery="INSERT INTO PR_REC(pr_no,item1,price1,qty1,item2,price2,qty2,item3,price3,qty3,item4,price4,qty4,item5,price5,qty5,item6,price6,qty6,item7,price7,qty7,item8,price8,qty8,item9,price9,qty9,item10,price10,qty10,Pur_reason,pr_date,Status) VALUES ('" & Me.txtprno.Text.TRIM & "','" & Me.txtitm1.Text.TRIM & "','" & Me.txtprc1.Text.TRIM & "', '" & Me.txtqty1.Text.TRIM & "','" & Me.txtitm2.Text.TRIM & "', '" & Me.txtprc2.Text.TRIM & "','" & Me.txtqty5.Text.TRIM & "','" & Me.txtitm3.Text.TRIM & "','" & Me.txtprc3.Text.TRIM & " ','" & Me.txtqty9.Text.TRIM & "','" & …

write first two lines shown below in code part, in the begining of your code and then try to run your page. Also echo your query before inserting, copy that from browser, run that prepared query in your second database directly using phpmyadmin (or any other tool). Then check whether …

You have 2 records for same (1) pk_product_id in image table. INSERT INTO `image` VALUES ('1', '83d8f803-8c4c-11e0-a22a-0ef39922def5', '1');INSERT INTO `image` VALUES ('2', '10aae9f7-8c4f-11e0-a22a-0ef39922def5', '1');

I think you have already including include ('require/dbUtil.inc'); in mysqli.inc, try to comment it.

select * from mytable order by abs(mydate-sysdate)

Following is the nice post by almostbob (member of this site). I hope this will help you. [url]http://www.daniweb.com/business-exchange/website-reviews/threads/366283/1571019#post1571019[/url]

I think you are looking for this. [CODE]<?php $firstday="Tuesday"; $secondday="Saturday"; $today=date("l"); $nextdate1=strtotime("next $firstday"); $nextdate2=strtotime("next $secondday"); if ($today==$firstday || $today==$secondday) { echo "Today: ".date("m-d-Y")."<br>"; } if ($nextdate1<$nextdate2) { echo "Next: ".date("m-d-Y l",$nextdate1)."<br>"; echo "Next: ".date("m-d-Y l",$nextdate2)."<br>"; } else { echo "Next: ".date("m-d-Y l",$nextdate2)."<br>"; echo "Next: ".date("m-d-Y l",$nextdate1)."<br>"; } ?>[/CODE]

[code] <?php //replace line 19 echo $comma."[\"$imagefolder/$imagefilename\", \"$imageurl\", \"_new\"]" ; //add new line 20 $comma=", "; ?> [/code]

1) You should not use there queries. Integrate there inputs in one query using OR operator. (you may also give one more dropdown with three text boxes that is AND, OR) 2) Same way to display you should not use three loops, just one is enough 3) for going to …

what is your server scripting language. php, perl-cgi, asp.net, java or any other.

I think its not possible with normal simple coding, It is somewhat complicated issue, which requires complex javascript code. Why do you need such thing?

you must learn something about curl

try to fetch thing only once in php array, and then use that array to intialise report and chart parameters

FROM LINE NUMBER 228 above, remove single quote from the end [code] $googleads='http://www.google.com/' [/code] type as [code] $googleads='http://www.google.com/ [/code]

Since few days I am not able to post reply or send personal message. This is not happening always, but Happens frequently. For e.g. following is the thread I am not able to reply from any browser, any computer. [url]http://www.daniweb.com/web-development/php/threads/365669/1568120#post1568120[/url] It shows time out. This is happening since 2 months. …

[url]www.w3schools.com[/url] for any web related begining

post table structure with sample data and then post expected output,

this is not possible. When your page is rendered to client browser, It will execute php code first at server side and produce html source code for browser. When php execution is over then page is in ready state. NOw javascript/html takes up the job. To execute php query, you …

[code] select * from invoice where document_no in ( select max(document_no) from invoice where document_date in (select max(document_date) from invoice) ) [/code]

[CODE] select TABLE_NAME, NUM_ROWS from all_tables where owner='SCHEMANAME' ORDER BY num_rows DESC [/CODE]

I think on second verision of your code line no 13,25,26 is having un wanted paranthesis. Your effort is in right direction, but I think you need to do proper code indentation as I did below [code] while($row = mysql_fetch_array($result)) { $src = ''; switch( $row['speed'] ) { case 'fast': …

set id for DIV not for FORM, as i did in following code [code] <form > <div id="he"> <input name="regPictures1" type="file" size="12"/> <br/> <input type="button" id="btnAdd" value="More" onclick="newUpload();" /> </div> </form> [/code]

[code] . . . <input id=barcode type=text> . . [/code] in your function you can write [code] . . . function getBarCode(ItemCode,VendCode,Cat) { . . . . . . . var barcodeval = Item+Mcode+Category; document.getElementById("barcode").value=barcodeval; . . . } . . [/code]

Make sure you make column of your table PK or unique, so when u insert any duplicate number, query will fail. [code] do { $no=rand(300,1000); $insert="insert into table(column)values ($no)"; $query=mysql_query($insert); if($query)// { $found=true; } else { $found=false; } }while(!found); [/code] Kindly check mysql syntax, My code may have syntax error;

storing multi values in single field cell is not normalised way of storing data. YOu must keep table with columns (eventid,user). Another doubt you are fetching event id using date. Now if there are two events on same date, then Which event is to be considered.