urtrivedi

http://www.w3schools.com/php/php_mysql_connect.asp

You should keep only one variable lik SESS_LEVEL user that everywhere, do not user separate variables. after header function always write exit, to avoid further execution of page header("xy.php"); exit;

select ad.EmployeeID, ad.Surname, ad.Givenname, ad.Company, ad.Office , BD.EmployeeID, bd.Company, bd.Office, bd.First, bd.Last from ad inner join bd on ad.employeeid =bd.employeeid where (ad.surname<>bd.last or ad.givenname<>bd.first or ad.company<>bd.company or ad.office<>bd.office)

because when u pass "click" variable in fucntion, it overrides global "click". so do it without function variable.

1 One Organisation may have many Contacts; 2 Some Contacts have no Organisation. these 2 are conflicting needs, you need to decide first on this which is preferrable for you and by the way what u mean by contacts, its just address or anything else

As far as I know (my attempt failed in past) I think on network drive, you can not host apache server. So if you have some space in your physical harddrive, there you can assing folder for hosting. Install Apache Install PHp Install Mysql All msi setups available, for windows …

i will not use php ever, I will use mysql stuff to add time and date insert into table1 (col1,col2,today_date,today_datetime) values ('col1value','col2value',current_date(),current_timestamp())

I hope this is what you are looking for: select t.* from trans_table t left outer join position_table p on t.trans_id=p.pos_trans_id where p.pos_trans_id is null

I will use absolute position styel for all five divs like shown below, just change top left for others #div1 { position:absolute; top:1px; left:300px; }

I guess you mean foreign key by f-key. you table structure shows u already using f-key in your cart-table. Here your user_id column in cart-table is f-key because it refers to id column of user-table. so I am not able to understand why u are confused?

You need to learn ajax request, html page sends request to server on any event with parameters, there on server you must have some script to handle such request , the script will return you some output, that you can reflect on html page, all this will not need to …

you are overwriting pervious value, keep on appending as shown below, with + before = document.divfrm.div.value+=d; document.divfrm.div.value+=sp;

cereal already told you the solution alter table staff_info add primary key('name','day'); or you can open table structure in phpmyadmin, and check on both column, then click on primary key at the boottom of table structure. So after doing this, table will not expect same day for any person. But …

1) you can creat binary column in table and store image in binary format in table itself 2) you can create column with file name/path reference only and store actual file as os file in some folder In my view Second approach is better.

how it is stored in mysql, Is it in one column one row, or all features are in separte record? If it is strored using textarea (with user manually breking line in textarea) then following trick may work, no need of \n echo nl2br($features_db);

its done on its own. when you create table when you add coulmn, information scheams is managaged by mysql server. You dont have to worry about it, you just use like the query you are using above

what is structure and relation of poeple with layer table (how layer related to people)

SELECT C.theDate, IFNULL( sum(case when DATE( CAST( H.timeentry AS DATE ) ) is null then 0 else 1 end), 0 ) AS countForDate FROM calendar AS C LEFT JOIN history AS H ON C.theDate = DATE( CAST( H.timeentry AS DATE ) ) WHERE YEAR(C.theDate) = YEAR(NOW()) AND MONTH(C.theDate) = MONTH(NOW()) …

For cc on your own you may try $mail->addCustomHeader("Cc: {$yourccmailid1},{$yourccmailid2}");

if u have timestamp column in ur table then u can order by that column in reverse order select * from post order by post_time desc

1 )conect both with lan wire 2) open tcp /ip in lan addapter seeting ip address for pc 1 192.168.1.1 255.255.255.0 192.168.1.2 ip address for pc 2 192.168.1.2 255.255.255.0 192.168.1.1 use same numbers its ready now

you must set "url" variable in your goto function, it is blank now i guess.

so many datamodel is here available, I hope u will find one for u, or u can see more then one and can make ur own using them. http://www.databaseanswers.org/data_models/index.htm

I think mod can move this thread to "Business Exchange" category. Spack you may get better response there

before running query echo its output and run in phpmyadmin or observe prepared query statment echo $result; mysql_query($result);

echo substr($txt7, 0, 200); if(strlen($txt7)>200) echo "...";

I feel daniweb is only IT forum getting new post every five minute (I assume). No other forum yet I have seen so active. People says man learn from experince, but here you can learn from others precious experience too without paying single penny. 1) I am here to update …

echo nl2br($info['content']);

put echo /table out of while loop (see line 24,25,26 they shold look like following) } echo "</table>"; mysql_close($con);

what is that 3 times asterisk sign around header function on line 100? ***

your query is fine. just check what you getting in POST array when you submit form place following code in the begining of your page after first php tag <?php echo "<pre>"; print_r($_POST); echo "</pre>"; die('stop to check post array');

txtRegistration field is not having value , before calling function, make uset that field has some value.

what is ur table structure and what is ur purpose(what u want to update with what value)? Only query is not enough to understand your problem.

html code <form method='post' action=process.aspx> <select name=agerange> <option value='0-5'>0-5</option> <option value='6-20'>6-20</option> <option value='21-80'>21-80</option> </select > <input type=submit value=submit> </form> process.aspx On pageload add this Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load //you can split agerange with hyphen and get age_from age_to in 2 array elements, …

http://nivo.dev7studios.com/

$ mysql -uusername -ppassword db_name < /fullpath/text_file.sql

what is the problem u face error, no result, invalid result or any other tell specific problem

match and verify your design here, i hope u find some clue here http://www.databaseanswers.org/data_models/libraries_and_books/index.htm

You need to learn tutorials and need to understand concept of dynamic pages. some body here can help u find bugs/errors in your code, but its not possible for anyone to help u teach whole system here in this forum. you can start with http://www.w3schools.com/php/php_mysql_intro.asp

I put group by in query and put conidtion outside of while to show "no-record" <?php include 'db.php'; $term = $_POST['EAN']; $term = TRIM($term); $sql = mysql_query("SELECT Name, Brand, EAN, sum(orderedquantity) As SumS FROM $salesdb WHERE EAN LIKE '%$term%' group by Name, Brand, EAN Limit 0,5"); $i=-1; while ($row = …

post complete code

line 11 must have double equal to, comparison, u put only 1 if($row['field4'] ='') make it if($row['field4'] =='')

you need to subscirbe to service provided by vendor like verisign, they will issue certificate for your webserver, to make commnuction to your website as secure communication.

ON keyword is missing in your code select persons.firstname,orders.cost from persons inner join orders on persons.p_id=orders.p_id where (cost between 0 and 150)

see line 64 to 68, i m updating it in our code while ( $row = mysql_fetch_array( $result ) ) { if($row['bankID']==$_POST['bankID']) $selectbank=" selected "; else $selectbank=""; ?> <option value="<?php echo $row['bankID']; ?>" <?php echo $selectbank;?> ><?php echo $row['bank']; ?></option> <?php }

you can keep status flag in table in mysql with each image. say active inactive and when u display gallery in php, just put where status='active' so it will display only active images. so i suggest not to delete images physically

try to do that in asp code may be in logout.asp (if it exists) or where where u destryoing session, there u put following line <% Response.Redirect("front.htm") %>

VALUES ((1, 'Port there is extra ( after values remove one from it

http://phpsense.com/2007/php-pagination-script/ try this class, its simplest pagination class i have seen so far.

if you want to display one by one in sequece like 1,2,3 then i will suggest you to find next intitially pass 0 as id $id=0;//this must be not part of fetch script, it may be passed in post or get now search next maximum active id from pass id …