1,257 Posted Topics
 | Re: MySQL query help Still I am not able to understand your problem. what kind of menu tool you are going to use. |
| | ON LINE 90 check variable names properly if (($[COLOR="Red"]R[/COLOR]status == ON) && ($[COLOR="Red"]R[/COLOR]vinc == R1) && ($[COLOR="Red"]R[/COLOR]month >= $current_month) && ($[COLOR="Red"]R[/COLOR]year == $current_year)) on line 80 you must keep break under some condition. otherwise it will go out of loop after one record |
| | you must submit the form, action page will be your second page, where you want to display text. Here (second page) you can access fields by using GET or POST array. |
| | [QUOTE]startdate is more than today'sdate and enddate is less than today'sdate [/QUOTE] Above sentence is unlikely to happen, any way query is as follows 1 [CODE]select * from tablename where current_date<start_date and enddate<current_date[/CODE] 2 if end date is null [CODE]select * from tablename where current_date<start_date and enddate is null[/CODE]  |
| | what is the problem? what is structure of the array and table? Anybody can not guess problem from what you have posted. |
| | I am not sure but try with lang attribute [CODE]echo '<script lang="javascript">alert("Your project has timed out. Contact your project Manager")</script>';[/CODE] |
| | Dear friends I need free vertical tree menu as shown in the link (green one) [url]http://dhtml-menu.com/menu/dhtml-floating-menu-sample.html[/url] I have heard something related to FISH, fishmenu or starfish menu, I am not sure. I have seen some fish named menu, but now I am not able to find that link or forgot … |
| | You can keep access level column in user master table. Whenever user login save his/her acces level in session variable and which ever page you want to secure check condition at the beginning of the page. also you can hide/show buttons and links according to access level saved in a … |
| | I assume that you have defined your primary key or unique key for you table. If yes then you can use following single query. search more "on duplicate key mysql" [CODE]insert into tablename(col1,col2, col3) values('1','2','3') on duplicate key update set col2='22', col3='33' [/CODE] |
| | Re: basic download 1) oracle express edition 10g. its oracle server 2) (optional) then download oracle sqldeveloper, its interface to work on your database, otherwise you may work with sql prompt to query your database. search something about oracle tutorials on google. If you want to learn basic sql then you may …  |
| | YOU need to run update query in mysql to update emails [CODE]update listing set email='title@test.domain.com' where email='suppliers@test.domain.com'[/CODE] Be carefull before using following query. it will set title to title without spaces in all records, so better you add new column say title_wo_space, then use following query [CODE]update listing set title_wo_space=replace(title,' … |
| | |
| | [CODE]<input type=file name=fl[] id=fl[]><br> <input type=file name=fl[] id=fl[]><br> <input type=file name=fl[] id=fl[]><br> <input type=file name=fl[] id=fl[]><br> <input type=file name=fl[] id=fl[]>[/CODE] in php file you will get array of uploaded files. fl[0], fl[1], fl[2] like that |
| | on what basis you chose following record for RMA 123|11|2011-03-01|3 |
| | Re: COUNT() Function [CODE]select last_name, count(*) total from user_master group by last_name having count(*) = 1[/CODE] This query will find last_name that occurs only once in the table. so you must use [COLOR="Green"]having [/COLOR] with aggregate functions.  |
| | Make that column unique in database, when you try to insert duplicate email it will give you error. So handle that error and give message to user. |
| | do no submit form to php before validating with javascript. look at the following code carefully. [CODE] <html><head> <script language="javascript"> function validate() { if (document.finfo.testabc.value=='') { alert('enter some value'); return false;// this will not allow form to submit } return true; } </script> </head><body> <table> <tr> <td> <form id="finfo" name="finfo" … |
| | Re: Table Row onBlur I think instead of giving update button in all rows. keep one update button at bottom. Let user change everything across the rows and then let him press update button only once. If you attempt to update table on so many events, it will impose extra load on your server.  |
| | Re: NVL-NULL usually nvl is used with arithmetic operation (atleast I use for that), when you are not sure that column will contain null or not. If you add two values where one of them is null, it will return null result even if second one is valid number. assuming one row … |
| | do not count, use max function [CODE]select ifnull(max(id),0)+1 as maxid from tablename[/CODE] |
| | If you are already having date type (reshipdate) then why are u converting it. starting away insert it. any way try to use 1) change yy to yyyy and change / to - or 2) str_to_date function |
| | Your textarea and your button must be inside form. you should also set action page for the form, where you will actually insert comment in your table. |
 | [CODE]$_GET['message'][/CODE] this variable is empty. check the spelling in the previous page from where your current page is called. |
| | SYNTAX [CODE]select substring(COLNAME, 1, CHARINDEX('/',COLNAME, CHARINDEX('/',COLNAME)+1)) FROM TABLENAME [/CODE] EXAMPLE [CODE]select substring('TVM/345/2000,TVM/01/00,TSR/42/01', 1,CHARINDEX('/','TVM/345/2000,TVM/01/00,TSR/42/01',CHARINDEX('/','TVM/345/2000,TVM/01/00,TSR/42/01')+1))[/CODE] |
| | change this line 19 from [CODE]if(isset($_POST['submitted']))[/CODE] to [CODE]if(isset($_POST['submit']))[/CODE] because you are giving name submit to the submit-button and not submitted. |
| | Re: Mini RObot You are talking about cron job (linux) and schedule job (windows). You create your php page to do so, google for cron job settings. you can schedule that php script to run whenever and however you want you want. |
| | |
 | [CODE]$arr[2]=150; $arr[231]=163; $arr[235]=1121;[/CODE] |
| | Where is your effort? Post here, what ever you did so far. |
| | I think ftp is better. Share ftp userid password with him. Because even if you find such tool, to change single page, he need to download whole site. |
| | I have tried doing in one query, but Not able to do it in your case, I was able to succced in other cases long back ago. So as almostbob suggested I am posting part query code which is mysql php combination (uncompiled). You may try this [CODE] <?PHP $query="select … |
 | what are values of, num1 and num2. Your second loop will never execute. eveyting depends on num1 and num2 |
 | Look at the link, it is something readymade. Check whether it is useful in your case or not. [url]http://coppermine-gallery.net/[/url] |
| | [QUOTE]I have tried this sattement but it doesnot work SELECT accountname, NULL AS debit, credit FROM revenue UNION SELECT accountname, debit, NULL FROM expense [/QUOTE] This statement is fine. You should get the result. what error you are getting? |
| | Its not inserting data where it is null. You must say. Updating columns where it is null. first of you must know which rows you want to update. I mean what is the condition. sample 1 (to update status of all null columns) [CODE]update tablename set status='Single' where status is … |
| | Insertion is the problem or you are not able to display things in expected way??? [QUOTE] each time i insert a new recipe in creates a new completley seperate table and i want all the recipes that belong to "some recipe website" to apear in the same table of the … |
| | You must add one transaction id column. say Fsample (ESN varchar(10), [COLOR="Red"]transId int[/COLOR], optn_type int, auditdate datetime) depening only on query may generate misleading report, if some data is missing. In above case if data is missing, then it will show null instead of closest date. |
| | You have explained this problem in very well manner. I have added one more column adj, check are you getting what is expected. Here I have used ifnull function [CODE] . . . , d.change as DIFF , ((sum(CASE WHEN (".$ht." AND ".$hw.")OR(".$at." AND ".$aw.") THEN 3 ELSE 0 END) … |
 | one option is to use jquery-ui datepicker. google for jquery-ui, IF you want to insert in any other format in mysql then, write your insert query as follows. You may use str_to_date format [code] $query="insert into tablename value(col1,datecol) values ('{$_POST['col1']}',str_to_date('{$_POST['datecol']}','%m/%d/%Y')) "; [/code] |
| | You are using parameter CommandBehavior.SchemaOnly, so I think its not a problem in performance. |
| | Re: php editor/IDE phpdesigner personal edition is free and at least it indicates you syntax errors. Just 2 mb on download [url]http://www.download.com/PHP%20Designer%202007%20-%20Personal/3000-10248_4-10575026.html?part=dl-6263317&subj=dl&tag=button[/url]  |
 | echo your array structure. before everything and check is it as expected [CODE]<?php echo "<pre>"; print_r($array); echo "<pre>"; if(is_array($array)){ . . . ?>[/CODE]  |
| | in the begining of your code, you check the post values and see whether you are getting expected variables, and their values or not [code] <?php echo "<pre>"; print_r($_POST); echo "</pre>"; $connect=mysql_connect("localhost","root",""); . . . [/code]  |
 | first change name of checkbox to number[] (i have done that change only). this action will send checkbox array to processing page. [CODE]<?php /*connect to and select database*/ $num_rows = mysql_num_rows($result); $i = 0; while ($i < $num_rows) { $row = mysql_fetch_array($result); $num = $row['id']; ?> <form action="delete.php" method="post"> ... … |
| | [CODE] var total=no+no1+no2; html += 'a.one + a.arr[0] + a.two = ' + total + '<br/>'; document.getElementById('content').innerHTML = html; [/CODE] |
| | |
| | use function mysql_fetch_assoc() to get array with column name as key instead of index |
| | |
 | Re: query issue [CODE]SELECT p.property_id, p.property_type, u.user_id, u.name, u.subscription_id from properties p inner join user u on p.user_id=u.user_id where p.property_type='home' order by u.subscription_id [/CODE] |
| | Re: Moving a File [CODE]move_uploaded_file($_FILES['fileelement']['tmp_name'],'../uploadedfiles/newfile.ext');[/CODE] |
The End.