warhead2020

problem solved!

<level 1> <level 2> <level 3-1> text 1 </level 3-1> <level 3-2> This 1 </level 3-2> </level 2> <level 2> <level 3-1> text 1 </level 3-1> <level 3-2> This 2 </level 3-2> </level 2> <level 2> <level 3-1> text 1 </level 3-1> <level 3-2> This 3 </level 3-2> </level 2> </level 1> Hi, can someone help ni..how can i retrieve text node form 'level 3-2'?? My return data should be THIS 1,THIS 2,THIS 3. Thanks in advance.

Hi, I am new to jquery. Only juz started to learn about 3 weeks ago. So i can say im a BEGINNER. Got 1 simple question. what is the different between '$.blabla' and '$().blabla'. Dollar sign ..and the other one...dollar sign+ bracket. Thanks in advance.

Hi, I have this problem. Can someone help me,how to convert number of days(eg: 5000 days) into the format XX Years, XX Month, XX Days... thanks in advance.

Hi, I have this problem. I want to get the difference between two dates(eg: 1997-09-09 And Curdates()), how to get the output to be in XX Years, XX Months, XX days?.. Hope someone can help me on this problem. Thanks in advance.

Hi, i have one simple question regarding Inner Join. SELECT column_name(s) FROM table_name1 INNER JOIN table_name2 ON table_name1.column_name=table_name2.column_name If i change this code to this code SELECT column_name(s) FROM table_name1 INNER JOIN table_name2 ON table_name2.column_name=table_name1.column_name will the output still the same or different? Thank in advance.

Actually, it's quite illogical to store a number as anything but a number. But still u can insert number into varchar column right? I jus want to know is there any effect to performance/size etc? Maybe your DB size will be bigger or anything?? just curious...

Logically there is no problem to insert number into varchar right? But i need to know what happen if we insert number into varchar with 100 or more in size.

Hi, Im quite new to mysql/DB. I have simple question. Lets say I want to create one column 'Number'. Yeah i know, the data type should be int/double. But if i declare it as 'Varchar(100)', is there any effect in term of performance/speed etc etc etc? I know to some ppl it is simple but for me its quite important. Thanx in advance.

problem solved. My own mistake...

Hi, i have this problem regarding ajax dropdownlist. Here is my code. this is my ajax code function getXMLHTTP() { var xmlhttp=false; try { xmlhttp=new XMLHttpRequest(); } catch(e) { try { xmlhttp= new ActiveXObject("Microsoft.XMLHTTP"); } catch(e) { try { xmlhttp = new ActiveXObject("Msxml2.XMLHTTP"); } catch(e1) { xmlhttp=false; } } } return xmlhttp; } function getIpt(strURL) { var req = getXMLHTTP(); if (req) { req.onreadystatechange = function() { if (req.readyState == 4) { // only if "OK" if (req.status == 200) { document.getElementById('institusidiv').innerHTML=req.responseText; } else { alert("There was a problem while using XMLHTTP:\n" + req.statusText); } } } req.open("GET", strURL, true); req.send(null); } } function getKursus(strURL) { var req = getXMLHTTP(); if (req) { req.onreadystatechange = function() { if (req.readyState == 4) { // only if "OK" if (req.status == 200) { document.getElementById('kursusdiv').innerHTML=req.responseText; } else { alert("There was a problem while using XMLHTTP:\n" + req.statusText); } } } req.open("GET", strURL, true); req.send(null); } } Here is my php code (ajaxIPT.php) <?php require_once("../../class/class.mysqldb.php"); $code = intval($_REQUEST['code']); $kod_ins = $_REQUEST['kod_ins']; $con = new MysqlDB; $con->connectMysql(); if($code == 1) { $queryIpt = "select ctext from kod_ipt where kat_ipt = 1"; $resultQuery = $con->query($queryIpt); ?> <select name="INSTITUSI" id="INSTITUSI"> <option>--Choose--</option> <?php while($row=$con->fetch_array($resultQuery)) { ?> <option value="<?php echo $row['ctext']; ?>"><?php echo $row['ctext']; ?></option> <?php } ?> </select> <?php } elseif($code == 2) { $queryIpt = "select ctext from kod_ipt where kat_ipt = 2"; $resultQuery = $con->query($queryIpt); ?> <select name="INSTITUSI" id="INSTITUSI"> <option>--Choose--</option> <?php while($row=$con->fetch_array($resultQuery)) { ?> <option value="<?php echo $row['ctext']; ?>"><?php echo $row['ctext']; ?></option> <?php } ?> </select> <?php } elseif($code == 3) { ?> <input name="INSTITUSI" type="text" id="INSTITUSI" size="30" value="" /> <?php } elseif($code == 4) { ?> <input name="INSTITUSI" type="text" id="INSTITUSI" size="30" value="Test" /> <?php } ?> And this is my form <table width="100%" cellspacing="1" class="main"> <tr> <th width="25%"> <div align="left"> <strong>A</strong> </div> </th> <th align="center" width="2%"> <div align="center">:</div> </th> <td width="73%" class="bodystyle"> <select name="KOD_INSTITUSI" id="KOD_INSTITUSI" onchange="getIpt('ajaxIPT.php?code='+this.value),tukarPeringkat(this.value);"> <option value="">-Choose-</option> <?php while($row=$con->fetch_array($resultIptQuery)) { ?> <option value = "<?php echo $row['id']; ?>"><?php echo $row['cat']; ?></option> <?php } ?> </select> </td> </tr> <tr> <th> <div align="left"> <strong>B</strong> </div> </th> <th align="center"><div align="center">:</div></th> <td class="bodystyle"> <div id="institusidiv"> <select name="INSTITUSI" id="INSTITUSI" onchange=""> <option value="">-Choose-</option> </select> </div> </td> </tr> </table> this code works perfectly. When i choose KOD_INSTITUSI, the INSTITUSI dropdownlist change. The problem now is, when i post the form, the INSTITUSI IS NULL. It is like, the result in INSTITUSI dropdownlist only "virtually/temporarily"(sorry if im using wrong word ) exist there not the real object. That's y when i post the form, the INSTITUSI dropdownlist post NULL. I think maybe it is because the way i send data from ajaxIPT.php to the ajax code?? Hope someone out there can help me. Thanks in advance.

oh ok....i found the real culprit here... actually i just copy and paste tutorial from PDF...so actually there r using ‘ but when i paste it in notepad...it is actually diff character. anyway..many2 thanx from me.

YES! It works! im in BLANK MODE now..can u see what is the diff between ur code and mine... CREATE TABLE `categories` ( `id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR( 255 ) NOT NULL , `shortdesc` VARCHAR( 255 ) NOT NULL , `longdesc` TEXT NOT NULL , `status` ENUM( 'active', 'inactive' ) NOT NULL , `parentid` INT NOT NULL , PRIMARY KEY ( `id` ) ) TYPE = MYISAM ; this is urs...it works. CREATE TABLE ‘categories’ ( ‘id’ INT NOT NULL AUTO_INCREMENT , ‘name’ VARCHAR( 255 ) NOT NULL , ‘shortdesc’ VARCHAR( 255 ) NOT NULL , ‘longdesc’ TEXT NOT NULL , ‘status’ ENUM( ‘active’, ‘inactive’ ) NOT NULL , ‘parentid’ INT NOT NULL , PRIMARY KEY ( `id` ) ) TYPE = MYISAM ; this is mine.. can detect anything??

sory ..i stil cant understand it....what is the diff between mine and urs? PRIMARY KEY ( `id` )

..sory wrong quote stil error... #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''id' ) ) TYPE = MYISAM' at line 8

I tried to run this command CREATE TABLE ‘categories’ ( ‘id’ INT NOT NULL AUTO_INCREMENT , ‘name’ VARCHAR( 255 ) NOT NULL , ‘shortdesc’ VARCHAR( 255 ) NOT NULL , ‘longdesc’ TEXT NOT NULL , ‘status’ ENUM( ‘active’, ‘inactive’ ) NOT NULL , ‘parentid’ INT NOT NULL , PRIMARY KEY ( ‘id’ ) ) TYPE = MYISAM ; but i got this error #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '‘active’, ‘inactive’ ) NOT NULL , ‘parentid’ INT NOT NULL , PRIMAR' at line 6 can anyone help me? thanx in advance..

I read sumthing about dreamweaver save page as BOM marker and need to save it without it. So,how to save it as UTF-8?. Thanx in advance.

Yes..im using different code/php. But basically...in AddListMain.php, there r a lot php code so i just want to focus on that php part. I notice, even simple html page cant run the php code.

Hi, i got this problem. "Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\axis\AddListMain.php:1) in C:\xampp\htdocs\axis\AddListMain.php on line 16" I have read all recommended solutions but i still can't find the problem. Here i will paste the code and hopefully someone can spot what is the real problem. Thanks in advance. The php page. <?php if(isset($_COOKIE['user_id'])) { $userId = $_COOKIE['user_id']; } else { $userId = $_SESSION['user_id']; } if($userId=="") { header("Location: userError.php"); } ?> <!doctype html public '-//W3C//DTD HTML 4.01//EN' 'http://www.w3.org/TR/html4/strict.dtd'> <html> <head><title>site</title> <meta http-equiv="Content-Type" content="text/html; charset=ISO 8859-1" /> <link rel="stylesheet" href="assets/reset.css" type="text/css"/> <link rel="stylesheet" href="assets/style.css" type="text/css"/> <!--[if IE]><link rel="stylesheet" href="assets/styleIE.css" type="text/css"/> <![endif]--> </head> <body> <div class="wrap"> <div class="header"> <embed src="header.swf" quality="high" bgcolor="#ffffff" width="960" height="150" name="header" align="middle" allowScriptAccess="sameDomain" allowFullScreen="false" type="application/x-shockwave-flash" pluginspage="http://www.adobe.com/go/getflashplayer" /> </div> <div class="head"> <h1>Welcome to Axis Property portal, your most comprehensive real estate database made online! </h1> <form method="post" action="#"> <input id="username" type="text" value="Quick Search"/> <input id="submit" type="submit" value="search &raquo" /> </form> </div> <div class="content"> <div class="lbar"> <div class="rounded"> <img src="assets/kiri-top.jpg" class="round-top"/> <h2>LOGIN <img src="assets/bullet1.gif"/></h2> <p> <table> <form action="login.php" method="post"> <tr><td><label for="user">Username</label></td><td><input name="user" id="user" size="22" /></td></tr> <tr><td><label for="pass">Password</label></td><td><input name="pass" type="password" id="pass" size="22" /></td></tr> <tr><td></td><td><input id="cookie" style="BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; BORDER-RIGHT-WIDTH: 0px" type="checkbox" value="do" name="cookie" /><label for="cookie"><small>Remember me</small></label></td></tr> <tr> <td></td><td><input type="submit" value="Login" name="submit" /></td></tr> <td></td><td><br/><a title="Forgot password" href="http://t-led.com.my/main/v3/forgotpass.php">Forgot password?</a></small> or <a title="Forgot password" href="regVisitor.php">Register Now!<a></td></tr> </tr> </form> </table> </p> </div> <div class="noRound"> <ul> <li><a href="#">Home</a></li> <li><a href="#">Search Listing (Advance)</a></li> <li><a href="#">List a property</a></li> <li><a href="#">Advertise with us</a></li> <li><a href="#">Reseller program</a></li> <li><a href="#">FAQ</a></li> <li><a href="#">News</a></li> </ul> </div> <br/> <div class="rounded"> <img src="assets/kiri-top.jpg" class="round-top"/> <h2>NEW PROPERTY <img src="assets/bullet1.gif"/> <a href="" class="rightnew">more &raquo </a></h2> <div class="prop"> <a href="dispProp.php?propId=86"><img class="thumb" src="assets/no_photo.jpg"></a> <ul> <li class="umah">APARTMENT</li> <li class="swoosh">INVESTMENT</li> <li class="id">YONGPENG</li> <li class="rm">(S) 1 / (R) 1000000</li> <li><a href="dispProp.php?propId=86"><img src="assets/more.gif" class="more"/></li> </ul> </div> <div class="prop"> <a href="dispProp.php?propId=85"><img class="thumb" src="assets/no_photo.jpg "></a> <ul> <li class="umah">APARTMENT </li> <li class="swoosh">INVESTMENT </li> <li class="id">TELUK INTAN Perak Ridzuan </li> <li class="rm">(S) 77 / (R) 0 </li> </li><a href="dispProp.php?propId=85"><img src="assets/more.gif" class="more"/></a></li> </ul> </div> <h2>TOP 5 <img src="assets/bullet1.gif"/></h2> <ul class="top5"> <li><a href="#">Vista Damai (Kajang) | RM 1 Mil </a></li> <li><a href="#">Silicon (Mont Kiara) | RM 100 K </a></li> <li><a href="#">Public Bath (Klang) | RM 1 </a></li> <li><a href="#">KLCC (Kajang) | RM 10 Bil </a></li> <li><a href="#">Centrepoint (Kajang) | RM 1 Mil </a></li> </ul> </div> </div> <div class="main"> <!-- <img src="assets/tengah-top1.jpg" class="round-top"/> -- nih kener ubah ke dalam setiap div under div main untuk jadikan derang cornered kat bhgn atas -- --> <!-- content is here --> <div class="featured"> <img src="assets/tengah-top1.jpg" class="round-top"/> <!--- paste kat sinih unutk meng corneredkan div2 yg ader dlm div .main--> <h2><img src="assets/welcome.png"> WELCOME TO AXIS REAL PROPERTY! <img src="assets/bullet1.gif"/></h2> <p> AXIS REALTY was registered and incorporated with the Board of Valuers, Appraisers and Estate Agents in March 1988 under the Registration Number of E (3) 0050. We are one of the members of Malaysia Institute of Estate Agents (MIEA) OM289 since May 1989. </p> <img src="assets/tengah-bottom1.jpg" class="round-bottom"/> <!--ditambah untuk mengcorner kan bhgn bawah setiap div--> </div> <div class="featured"> <img src="assets/tengah-top1.jpg" class="round-top"/> <!--- paste kat sinih unutk meng corneredkan div2 yg ader dlm div .main--> <h2><img src="assets/rumah.png"> FEATURED PROPERTIES <img src="assets/bullet1.gif"/> <a href="" class="right">more &raquo </a></h2> <div class="mainFeat"><a href=""><img src="assets/featured.png" alt="kinrara mas project" class="featleft" /> <span class="hightl">KINRARA EMAS | RM 2 Mil &raquo </span> </a></div> <div class="feat1"> <div class="featThumbnails"> <div class="featu"><a href="dispProp.php?propId=86" class="featura"><img class="featThumb" src="assets/no_photo.jpg"><br/>KLANG <br/> <span class="red">RM 1 Mil</span></a></a></div> <div class="featu"><a href="dispProp.php?propId=86" class="featura"><img class="featThumb" src="assets/no_photo.jpg"><br/>Dato Keramat <br/> <span class="red"> 1 Mil</span></a></div> <div class="featu"><a href="dispProp.php?propId=86" class="featura"><img class="featThumb" src="assets/no_photo.jpg"><br/>JOHOR <br/> <span class="red"> 100K</span></a></div> </div> <div class="featThumbnails"> <div class="featu"><a href="dispProp.php?propId=86" class="featura"><img class="featThumb" src="assets/no_photo.jpg"><br/>SARAWAK <br/> <span class="red"> 380K</span></a></div> <div class="featu"><a href="dispProp.php?propId=86" class="featura"><img class="featThumb" src="assets/no_photo.jpg"><br/>PERAK DARUL RIDZUAN<br/> <span class="red"> 1 Mil</span></a></div> <div class="featu"><a href="dispProp.php?propId=86" class="featura"><img class="featThumb" src="assets/no_photo.jpg"><br/>KLANG <br/> <span class="red"> 1 Mil </span></a></div> </div> </div> <img src="assets/tengah-bottom1.jpg" class="round-bottom"/> <!--ditambah untuk mengcorner kan bhgn bawah setiap div--> </div> <br/> <div class="news"> <img src="assets/tengah-top1.jpg" class="round-top"/> <!--- paste kat sinih unutk meng corneredkan div2 yg ader dlm div .main--> <h2> <img src="assets/news.png"> LATEST NEWS <img src="assets/bullet1.gif"/> <a href="" class="right">more &raquo </a></h2> <img src="assets/newskecik.jpg" alt="kinrara mas project" class="right" /> <!--<img src="assets/newskecik.jpg" class="mainThumb"/>--> <ul> <li><a href="showNews.php?id=7">07 MAY 2009 | make</a></li> <li><a href="showNews.php?id=8">07 MAY 2009 | make2</a></li> <li><a href="showNews.php?id=9">07 MAY 2009 | asa</a></li> <li><a href="showNews.php?id=3">22 APR 2009 | qqq</a></li> <li><a href="showNews.php?id=4">22 APR 2009 | asdad</a></li> </ul> <img src="assets/tengah-bottom1.jpg" class="round-bottom"/> <!--ditambah untuk mengcorner kan bhgn bawah setiap div--> </div> <div class="tips"> <img src="assets/tengah-top1.jpg" class="round-top"/> <!--- paste kat sinih unutk meng corneredkan div2 yg ader dlm div .main--> <h2> <img src="assets/tips.png"> TIPS <img src="assets/bullet1.gif"/> <a href="" class="right">more &raquo </a></h2> <img src="assets/tipskecik.gif" alt="kinrara mas project" class="right" height="120px" /> <ul> <li><a href="showTips.php?id=2">08 MAY 2009 | tips 1</a></li> <li><a href="showTips.php?id=1">22 APR 2009 | aa</a></li> <li><a href="showTips.php?id=2">08 MAY 2009 | tips 1</a></li> <li><a href="showTips.php?id=1">22 APR 2009 | aa</a></li> <li><a href="showTips.php?id=2">08 MAY 2009 | tips 1</a></li> </ul> <img src="assets/tengah-bottom1.jpg" class="round-bottom"/> <!--ditambah untuk mengcorner kan bhgn bawah setiap div--> </div> <div class="advsearch"> <img src="assets/tengah-top1.jpg" class="round-top"/> <!--- paste kat sinih unutk meng corneredkan div2 yg ader dlm div .main--> <h2> <img src="assets/advsearch.png"> Advance Search <img src="assets/bullet1.gif"/> <a href="" class="right">more &raquo </a></h2> <img src="assets/tipskecik.gif" alt="kinrara mas project" class="right" height="120px" /> <p> Click and choose the options at the bottom to use advanced search function. Any combination is possible to filter and get better search result which suited your demand. <a href="mailto:[email protected]">Feedback </a> </p> <form>Options: <br/> <select> <option>Available For:</option> <option>2</option> <option>3</option> <option>4</option> </select> <select> <option>Type:</option> <option>Investment</option> <option>House</option> <option>Rent</option> </select> <select> <option>Price:</option> <option>2</option> <option>3</option> <option>4</option> </select> <select> <option>Zone:</option> <option>North</option> <option>West Coast</option> <option>Middle</option> </select> <br/> <!--<input name="Submit" type="Submit" value="Search Now &raquo" class="right"/>--> <a href="#" name="Submit" value="Submit"> <img src="assets/searchButt.gif"/></a> </form> <img src="assets/tengah-bottom1.jpg" class="round-bottom"/> <!--ditambah untuk mengcorner kan bhgn bawah setiap div--> </div> <!-- <img src="assets/tengah-bottom1.jpg" class="round-bottom"/> uncomment balik klu nk back to the design yg asal --> </div> <div class="rbar"> <img src="assets/kanan-top.jpg" class="round-top"/> <div class="ads"> <h2> Ads </h2> <p> <img src="assets/1.jpg"/> <img src="assets/2.jpg"/> <img src="assets/3.jpg"/> <img src="assets/4.jpg"/> <img src="assets/5.jpg"/> <img src="assets/6.jpg"/> </p> </div> <img src="assets/kanan-bawah.jpg" class="round-bottom"/> </div> </div> <div class="footer"> <p>Navigation : <a href="">Buy</a> | <a href="#">Rent</a> | <a href="">Sale</a> | <a href="">Resources</a> | <a href="">Contact Us</a> | <a href="">Term Of Use</a></p> <p>Copyright © 2000 <a href="">Axis-Realtors.com</a> All Rights Reserved</p> </div> </div> </div> </body> </html> the css file body{font-family: Century Gothic, Georgia, Times New Roman, Times, serif; font-size: 11px; color: #333333; background: #fff url(bg5.jpg);} a, a:visited{color: #ff7800; text-decoration: none;} a:hover {text-decoration: underline;} .wrap{background: url(wrapBG.png) repeat-y;width: 990px; margin: 0 auto;} .header{float: left; background: url(wrapBG.png) repeat-y;width: 990px; padding: 0px 15px;} .head {background: url(wrapheadBG.png) repeat-y;width: 990px; padding: 0px 15px; float: left;} .head h1{display: block; float: left; padding: 6px 0 8px 10px;} .head form{float: right; margin-right: 39px;} .head form{margin-top: 2px;} input {font-size: 11px; color: #80765e;} .content{floaT: left; background: url(wrapBG.png) repeat-y;width: 990px; padding: 0px 15px;} .lbar{float: left; background: #fff; margin: 12px 0 0 0;} .lbar div{margin: 0 10px; width: 200px;} .round-top {margin: 0 0 7px -10px; float: left} .round-bottom {margin-left: -10px; float: left;} .lbar .rounded h2{background: url(menuBG.jpg) repeat-x bottom; padding: 5px 10px; margin-bottom: 10px;} .lbar .rounded {background: #fff url(kiri-bott2.jpg) no-repeat bottom left; padding: 0 10px 10px 10px; margin-top: -2px;} .noRound{width: 200px; margin: 10px 10px 20px 10px; padding: 10px;} .noRound ul li {list-style: url(menuBullet1.jpg) inside; padding: 0 0 8px 0px; border-bottom: #564435 1px dotted; } .noRound a, .noRound a:visited{color: #8f8c8c;} .noRound a:hover {color: #ff7800; text-decoration: none;} div.prop {font-size: 11px; border-bottom: #B5B5B5 1px dotted; float: left; margin: -5px 10px 10px 0 ; padding: 5px 5px 10px 5px; width: 189px} .prop img.thumb{float: left; width: 100px; margin: 0 5px 0 0; border-bottom: #ffc200 3px solid;} .prop ul{padding-top: 0px; padding-left: -5px;} li.umah{list-style: url(ikon-rumahFF.jpg) inside; color:#0066FF; font-weight:bold;} li.swoosh{list-style: url(ikon-swooshFF.jpg) inside; color:#0066FF; font-weight:bold;} li.id{list-style: url(ikon-idFF.jpg) inside; color:#0066FF; font-weight:bold;} li.street{list-style: url(ikon-streetFF.gif) inside; color:#0066FF; font-weight:bold;} li.rm{list-style: url(ikon-rmFF.jpg) inside; color:#0066FF; font-weight:bold;} a img.more{float: right; width: 73px; height: 11px; margin-top: 7px; border: 0px; background: #fff;} ul.top5 li{list-style: url(bulletStar.gif) inside; padding: 5px 0;} /* .main{width: 520px; padding: 0 10px; background: #fff url(tengah-body1.jpg) repeat-y; float: left; margin: 10px 0 0 0;} */ /* .featured{float: left; width: 520px; margin-bottom: 20px;} */ /* .featured h2{background: url(menuBG.jpg) repeat-x bottom; font-size: 14px; padding-bottom: 3px; margin-top: -7px;} */ .main{width: 520px; padding: 0; float: left; margin: 10px 10px 0 10px;} .featured{float: left; width: 540px; margin-bottom: 15px; margin-left: -10px; padding:0 10px; background: #fff url(tengah-body1.jpg) repeat-y bottom left;} .featured h2{background: url(menuBG.jpg) repeat-x bottom; font-size: 14px; padding-bottom: 3px; margin-top: -7px; width: 520px;} .featleft{float: left; margin: 10px 0 0 10px; border:2px solid #FF0000;} .featured p{padding: 15px;} ul.feat{margin-left:200px;} .featured li {list-style: url(bulletStar.gif) inside; padding: 3px 0;} div.featu {width: 80px; border-bottom: #ffa200 1px dotted; float: left; margin: 5px; text-align: center; padding-bottom: 3px;} .featu a, .featu a:visited{ color: #534465 ; font-size: 10px;} .featu a:hover{text-decoration: none; color: #ffa200;} .mainFeat{width: 190px; float: left; text-align: center;} .featThumb {width: 80px;} .feat1{float: left; margin-top: 10px; margin-left: 20px; width: 300px;} .featThumbnails{margin-top: 0; margin-left: 10px; float: left;} .red {color: #00a8ff;} .green {color: #009900;} a.right{float: right; font-size: 11px; margin-top: -14px; margin-right: 3px; padding: 0;} a.rightnew{float: right; font-size: 11px; margin-top: -11px; margin-right: -3px; padding: 0;} /* .news, .tips, .details, .advsearch{width: 520px; float: left; margin: 10px 0 0 0;} */ /* .news h2, .tips h2, .details h2, .advsearch h2{background: url(menuBG.jpg) repeat-x bottom; font-size: 14px; padding-bottom: 3px; margin-top: -7px;} */ .news, .tips, .details, .advsearch{float: left; width: 540px; margin-bottom: 15px; margin-left: -10px; padding:0 10px; background: #fff url(tengah-body1.jpg) repeat-y bottom left;} .news h2, .tips h2, .details h2, .advsearch h2{background: url(menuBG.jpg) repeat-x bottom; font-size: 14px; padding-bottom: 3px; margin-top: -7px; width: 520px;} .news ul , .tips ul, .advsearch form{margin: 10px 0 0 20px;} .news li, .tips li{list-style: url(menuBullet1.jpg) inside; padding: 0 0;} .right{float: right; margin-right: 20px;}

can u please explain more?

mysql> SELECT band_number FROM BANDS WHERE bandname = 'Guitars and Tractors'; try this... SELECT band_number,bandname FROM BANDS WHERE bandname = 'Guitars and Tractors'; add one more column in the select column statement....

try this link.. http://www.phpro.org/tutorials/Introduction-to-PHP-Regex.html http://www.regular-expressions.info/php.html http://www.php.net/manual/en/ref.regex.php hope that links helps u..

SELECT band_number FROM BANDS WHERE bandname = "Metal Militia"; try this... SELECT band_number FROM BANDS WHERE bandname = 'Metal Militia' try use single quote instead of double quote

maybe im wrong in comprehending ur question. Based on ur question, y not just do like this.. SELECT * FROM TABLE WHERE COLUMN = 'TEA'

HI, is there a way to make the auto number in 4,5,6 digit? auto number always start with no 1, i want it to be 0001 or 000001 etc. Hope sumbody out there can help me. Thanx in advance.