CodeBackspace

mysql check for duplicate data

select parentid,childid from groups group by childid,parentid having count(*) > 1

this check for parentid,childid field for duplicate value

Add new user to subversion debian

add svnuser1 to group subversion on debian

addgroup svnuser1 subversion
htpasswd /etc/apache2/dav_svn.passwd svnuser1

Facebook Lite = Faster facebook

Cuba la facebook lite . Minimal content. Loading lagi laju .

http://lite.facebook.com/

Css Reset

im using eric Mayer css reset reloaded

html, body, div, span, applet, object, iframe,
h1, h2, h3, h4, h5, h6, p, blockquote, pre,
a, abbr, acronym, address, big, cite, code,
del, dfn, em, font, img, ins, kbd, q, s, samp,
small, strike, strong, sub, sup, tt, var,
dl, dt, dd, ol, ul, li,
fieldset, form, label, legend,
table, caption, tbody, tfoot, thead, tr, th, td {
	margin: 0;
	padding: 0;
	border: 0;
	outline: 0;
	font-weight: inherit;
	font-style: inherit;
	font-size: 100%;
	font-family: inherit;
	vertical-align: baseline;
}
/* remember to define focus styles! */
:focus {
	outline: 0;
}
body {
	line-height: 1;
	color: black;
	background: white;
}
ol, ul {
	list-style: none;
}
/* tables still need 'cellspacing="0"' in the markup */
table {
	border-collapse: separate;
	border-spacing: 0;
}
caption, th, td {
	text-align: left;
	font-weight: normal;
}
blockquote:before, blockquote:after,
q:before, q:after {
	content: "";
}
blockquote, q {
	quotes: "" "";
}

click
here for the post on eric mayer website

Change file owner in debian

 chown -R ownerName:groupname file_name

-R for recursive

How To Use Record Set in Dreamweaver?

Untuk mat Shuk. Jangan la slalu guna menatang nie. Tak bagus untuk kesihatan 100% not recomemded. Tapi nah amik ko nak sgt tau.

1. Mula2 set dulu connection . Tp make sure suma benda kat dlm panel database nie da tick ok.. kalo tak tak ble

2. Set Connection ke database letak nama, username, password dan select database

3. bila nie suma da set then gi second panel Binding. Binding nie guna untuk define query.So kalo macam aku nak select name dr table detail and sort asc aku buat macam nie. then aku bg nama dia recordset1.

4. Macam mana nak guna.? nanti akan kuar field yg da di select tuh.. so drag drop jer mana2 tempat ko nak dia appear. Tp akan kuar satu jer result. Tak akan kuar semua.

5. So camana nak kuar kan semua. Pergi ke server behavior. Select benda yg nak di repeat. Cth . aku Select {Recordset1.name} tekan tanda + tuh. Select repeat region.  Ble specify brapa kali nak repeat atau repeat jer all.

6. Untuk lain2 function .. be creative atau carik sendiri.. aku tau .  aku tak guna menatang nie.. mess up.