vijay

Hi..SELECT * FROM tbl_name ORDER BY RAND( ) LIMIT 5 from the above qry u will have any random 5 records from the specified table name..I think suppose this thing you want.. isn't it..?Regards,Vijay

Hi..yes you can do for thatyou have to common connection code @ one file "connect.php"and that file you have to require_once @ where ever you want..I mean suppose this you want to say..am i right..?Regards,Vijay

Hi...No that would not be work even if with tthe persistan link also with mysql_pconnect();If you found the other way then tell me...you can do the following (probably that u know..): <?phpsession_start();$link=mysql_connect("localhost","root","");$sel_db=mysql_select_db("db_name");$qry="SELECT * FROM table WHERE language = 'english' ORDER BY id DESC LIMIT 12";$result=mysql_query($qry,$link);echo 'This is all of our members<br /><br />';while($row = mysql_fetch_array($result)){ echo $row['username']; echo '<br />';}?> Regards,Vijay

Hi..u can do that by following..ob_start();include('s.php');ob_clean();tell this file as t.php..but with this you can not apply css in ur pagebut may I know why u r doing silly thing.. am not getting..Regards,Vijay

Hi..see the following code..you will get the things what to do..you have to do same over there.. function func1($param){ return func2($param*10);}function func2($param){ return $param*30;}$param=10;$ret_val=func1($param);echo "return Value: ".$ret_val."</br>"; Regards,Vijay

Hi.. It would be working fine if that file containg css.. but you must enter css name over there as a standards..Regards,Vijay

Hi.. May I have full table structure of those both tables.. I have also try like this: category: cat_a,cat directory: bname,btel SELECT c.cat, concat(d.bname,' ',d.btel) FROM `cat` AS `c` inner join directory as `d` on c.id = d.cat_id order by cat asc Suppose this will help u..Regards,Vijay

Hi.. Is there any chat script or demo based on only AJAX and JAVASCRIPT..? IN php... No use of database.. have got and made but not too good enough and simultaneous.. Thanks in advance..Regards,Vijay

Hi..yes u r right..Regards,Vijay

hi.. which version of mysql r u using..? subqry support available in >= mysql 4.1 version Regards,Vijay

Hi,yes Its possible if both's directory page's session var are samebut you have to check that this things not have any side effects..Regards,Vijay

Hi,try to ammend this line echo "<meta http-equiv=\"Refresh\" content=\"0\" URL=\"profile.php\"/><center>redirect</center>";othewise check the is it redirecting on 'profile.php'if yes then check the content of 'profile.php'or its still remain in 'login.php'try to debug the code line by line and check where ur control goes.. suppose this will help you..Regards,Vijay

Hi.. I dont know whether there i any other way except refresh the page.. with the help of AJAX you can do this at regular interval you have to call that file which will give us "last modified time" of that file.. Regards, Vijay

Hi use the following qry:Table: cat - id, cat Table: product - id,cat_id,product_nameSELECT * FROM `cat` WHERE id NOT IN ( SELECT DISTINCT ( cat_id ) FROM product )Regards,Vijay

Hi..Use the following code... and modify according ur req.. <?phprequire_once("functions.php");//_pr(gd_info());//$size = getimagesize("./image/Blue hills.jpg");//_pr($size,1);$uid=uniqid();$random_str=substr($uid,-6);header("Content-type: image/png");$im = @imagecreate(50, 30) or die("Cannot Initialize new GD image stream");$w = imagecolorallocate($im, 255, 255, 255);$red = imagecolorallocate($im, 255, 0, 0);$background_color = imagecolorallocate($im, 255, 255, 255);$text_color = imagecolorallocate($im, 233, 14, 91);$black = imagecolorallocate($im, 0, 0, 0);// prints a black "P" in the top left corner//imagechar($im, 1, 0, 0, $random_str, $text_color);imagestring($im, 5, 5, 5, $random_str, $text_color);imagepng($im);imagedestroy($im);?> Regards,Vijay

Hi..try with this: suppose this will help u.. with help of php and js <?php/* Created: 12/21/2006daysinfuture2.php -> original code by TDavid @ tdscripts.com License: Creative Commons 2.5 AttributionDesscription: Enter in days in the future and find out the date*/$timezonelist = array('Africa/Abidjan','Africa/Accra','Africa/Addis_Ababa','Africa/Algiers','Africa/Asmera','Africa/Bamako','Africa/Bangui','Africa/Banjul','Africa/Bissau','Africa/Blantyre','Africa/Brazzaville','Africa/Bujumbura','Africa/Cairo','Africa/Casablanca','Africa/Ceuta','Africa/Conakry','Africa/Dakar','Africa/Dar_es_Salaam','Africa/Djibouti','Africa/Douala','Africa/El_Aaiun','Africa/Freetown','Africa/Gaborone','Africa/Hara','Africa/Johannesburg','Africa/Kampala','Africa/Khartoum','Africa/Kigali','Africa/Kinshasa','Africa/Lagos','Africa/Libreville','Africa/Lome','Africa/Luanda','Africa/Lubumbashi','Africa/Lusaka','Africa/Malabo','Africa/Maputo','Africa/Maseru','Africa/Mbabane','Africa/Mogadishu','Africa/Monrovia','Africa/Nairobi','Africa/Ndjamena','Africa/Niamey','Africa/Nouakchott','Africa/Ouagadougou','Africa/Porto-Novo','Africa/Sao_Tome','Africa/Timbuktu','Africa/Tripoli','Africa/Tunis','Africa/Windhoek','America/Adak','America/Anchorage','America/Anguilla','America/Antigua','America/Araguaina','America/Aruba','America/Asuncion','America/Barbados','America/Belem','America/Belize','America/Bogota','America/Boise','America/Buenos_Aires','America/Cancun','America/Caracas','America/Catamarca','America/Cayenne','America/Cayman','America/Chicago','America/Chihuahua','America/Cordoba','America/Costa_Rica','America/Cuiaba','America/Curacao','America/Dawson','America/Dawson_Creek','America/Denver','America/Detroit','America/Dominica','America/Edmonton','America/El_Salvador','America/Ensenada','America/Fortaleza','America/Glace_Bay','America/Godthab','America/Goose_Bay','America/Grand_Turk','America/Grenada','America/Guadeloupe','America/Guatemala','America/Guayaquil','America/Guyana','America/Halifax','America/Havana','America/Indiana/Knox','America/Indiana/Marengo','America/Indiana/Vevay','America/Indianapolis','America/Inuvik','America/Iqaluit','America/Jamaica','America/Jujuy','America/Juneau','America/La_Paz','America/Lima','America/Los_Angeles','America/Louisville','America/Maceio','America/Managua','America/Manaus','America/Martinique','America/Mazatlan','America/Mendoza','America/Menominee','America/Mexico_City','America/Miquelon','America/Montevideo','America/Montreal','America/Montserrat','America/Nassau','America/New_York','America/Nipigon','America/Nome','America/Noronha','America/Panama','America/Pangnirtung','America/Paramaribo','America/Phoenix','America/Port-au-Prince','America/Port_of_Spain','America/Porto_Acre','America/Porto_Velho','America/Puerto_Rico','America/Rainy_River','America/Rankin_Inlet','America/Regina','America/Rosario','America/Santiago','America/Santo_Domingo','America/Sao_Paulo','America/Scoresbysund','America/Shiprock','America/St_Johns','America/St_Kitts','America/St_Lucia','America/St_Thomas','America/St_Vincent','America/Swift_Current','America/Tegucigalpa','America/Thule','America/Thunder_Bay','America/Tijuana','America/Tortola','America/Vancouver','America/Whitehorse','America/Winnipeg','America/Yakutat','America/Yellowknife','Antarctica/Casey','Antarctica/Davis','Antarctica/DumontDUrville','Antarctica/Mawson','Antarctica/McMurdo','Antarctica/Palmer','Antarctica/South_Pole','Arctic/Longyearbyen','Asia/Aden','Asia/Almaty','Asia/Amman','Asia/Anadyr','Asia/Aqtau','Asia/Aqtobe','Asia/Ashkhabad','Asia/Baghdad','Asia/Bahrain','Asia/Baku','Asia/Bangkok','Asia/Beirut','Asia/Bishkek','Asia/Brunei','Asia/Calcutta','Asia/Chungking','Asia/Colombo','Asia/Dacca','Asia/Damascus','Asia/Dubai','Asia/Dushanbe','Asia/Gaza','Asia/Harbin','Asia/Hong_Kong','Asia/Irkutsk','Asia/Jakarta','Asia/Jayapura','Asia/Jerusalem','Asia/Kabul','Asia/Kamchatka','Asia/Karachi','Asia/Kashgar','Asia/Katmandu','Asia/Krasnoyarsk','Asia/Kuala_Lumpur','Asia/Kuching','Asia/Kuwait','Asia/Macao','Asia/Magadan','Asia/Manila','Asia/Muscat','Asia/Nicosia','Asia/Novosibirsk','Asia/Omsk','Asia/Phnom_Penh','Asia/Pyongyang','Asia/Qatar','Asia/Rangoon','Asia/Riyadh','Asia/Saigon','Asia/Samarkand','Asia/Seoul','Asia/Shanghai','Asia/Singapore','Asia/Taipei','Asia/Tashkent','Asia/Tbilisi','Asia/Tehran','Asia/Thimbu','Asia/Tokyo','Asia/Ujung_Pandang','Asia/Ulan_Bator','Asia/Urumqi','Asia/Vientiane','Asia/Vladivostok','Asia/Yakutsk','Asia/Yekaterinburg','Asia/Yerevan','Atlantic/Azores','Atlantic/Bermuda','Atlantic/Canary','Atlantic/Cape_Verde','Atlantic/Faeroe','Atlantic/Jan_Mayen','Atlantic/Madeira','Atlantic/Reykjavik','Atlantic/South_Georgia','Atlantic/St_Helena','Atlantic/Stanley','Australia/Adelaide','Australia/Brisbane','Australia/Broken_Hill','Australia/Darwin','Australia/Hobart','Australia/Lindeman','Australia/Lord_Howe','Australia/Melbourne','Australia/Perth','Australia/Sydney','Europe/Amsterdam','Europe/Andorra','Europe/Athens','Europe/Belfast','Europe/Belgrade','Europe/Berlin','Europe/Bratislava','Europe/Brussels','Europe/Bucharest','Europe/Budapest','Europe/Chisinau','Europe/Copenhagen','Europe/Dublin','Europe/Gibraltar','Europe/Helsinki','Europe/Istanbul','Europe/Kaliningrad','Europe/Kiev','Europe/Lisbon','Europe/Ljubljana','Europe/London','Europe/Luxembourg','Europe/Madrid','Europe/Malta','Europe/Minsk','Europe/Monaco','Europe/Moscow','Europe/Oslo','Europe/Paris','Europe/Prague','Europe/Riga','Europe/Rome','Europe/Samara','Europe/San_Marino','Europe/Sarajevo','Europe/Simferopol','Europe/Skopje','Europe/Sofia','Europe/Stockholm','Europe/Tallinn','Europe/Tirane','Europe/Vaduz','Europe/Vatican','Europe/Vienna','Europe/Vilnius','Europe/Warsaw','Europe/Zagreb','Europe/Zurich','Indian/Antananarivo','Indian/Chagos','Indian/Christmas','Indian/Cocos','Indian/Comoro','Indian/Kerguelen','Indian/Mahe','Indian/Maldives','Indian/Mauritius','Indian/Mayotte','Indian/Reunion','Pacific/Apia','Pacific/Auckland','Pacific/Chatham','Pacific/Easter','Pacific/Efate','Pacific/Enderbury','Pacific/Fakaofo','Pacific/Fiji','Pacific/Funafuti','Pacific/Galapagos','Pacific/Gambier','Pacific/Guadalcanal','Pacific/Guam','Pacific/Honolulu','Pacific/Johnston','Pacific/Kiritimati','Pacific/Kosrae','Pacific/Kwajalein','Pacific/Majuro','Pacific/Marquesas','Pacific/Midway','Pacific/Nauru','Pacific/Niue','Pacific/Norfolk','Pacific/Noumea','Pacific/Pago_Pago','Pacific/Palau','Pacific/Pitcairn','Pacific/Ponape','Pacific/Port_Moresby','Pacific/Rarotonga','Pacific/Saipan','Pacific/Tahiti','Pacific/Tarawa','Pacific/Tongatapu','Pacific/Truk','Pacific/Wake','Pacific/Wallis','Pacific/Yap');$sizetz = count($timezonelist);$fdays = (int)$_POST['d'];$ftz = (int)$_POST['tz'];// 10,000 days maxif($fdays <0 || $fdays >10000) {$fdays = 7; // week from now is default}if($ftz > $sizetz || $ftz < 0) {$ftz = 107; // default timezone PST}// Time Zone set EXAMPLE // putenv("TZ=America/Los_Angeles");putenv("TZ=$timezonelist[$ftz]");$today = time();$future_tense = strtotime("+$fdays days", $today);print "Now: " . date("l M d, Y H:i:s", $today) . " <i>$timezonelist[$ftz]</i><br /><font color=\"green\"><b>+ $fdays days =</b></font> <b>" . date("l M d, Y H:i:s", $future_tense) . '</b>';?><form method="POST" action="">Number of days in the future? <input type="text" size="3" name="d" value="<?php echo($fdays);?>"> Timezone? (pending) <select name="tz"><option SELECTED value="107">USA - Pacific (GMT -8)</option><option value="70">USA - Midwest (GMT -6)</option><option value="122">USA - Eastern (GMT -5)</option><?phpfor($y=0;$y<$sizetz;$y++) { print("<option value=\"$y\">$timezonelist[$y]</option>\n");}?></select> <input type="submit" value="See future date"></form> Regards,Vijay

Hi..please check first @ when ur function getting over..? (end brace)and am not also getting how it will take the val of day, month and year...so for that you have to take that value first..suppose this will hint you..Regards,Vijay

Hi.. not getting ur question... that depends on our requirement..Regards,Vijay

Hi Simply use the following code for new line.. <?php if(isset($_POST['Submit'])) echo nl2br($_POST['myarea']);?> <form name="form1" id="form1" method="post" action="" enctype="multipart/form-data"> <textarea name="myarea" cols="30" rows="3" ></textarea> <input type="submit" name="Submit" value="Submit" /></form> suppose this will help you..Regards,Vijay

Hi..do one thing...<?php$_SESSION = array();unset($_SESSION);session_destroy();header(location:"login.php");exit;?>write exit..Regards,Vijay

Hi.. One suggestion: instead of text area you can go for texteditor like FCKEditor...Regards,Vijay

Hi on logoput page just try the following code$_SESSION = array();unset($_SESSION);session_destroy();header(location:"login.php");Regards,Vijay

Hi.. Thanks to both of you.. Regards,Vijay

Hi... I have form with file button in webpage. I want to do validate it. my validation criteria.. user can only browse the button and add file. user has no access to wright in text box besides browse button.. actually I have done <input type="file" name="filename" id="filename" onkeyup="this.value='';" > But this is working only for Firefox not in IE.. Thanks in advance..Regards,Vijay

Hi..use the following code.. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><title>Untitled Document</title><script type="text/javascript" language="javascript">function hideall(){ document.getElementById('menu1').style.display='none'; document.getElementById('menu2').style.display='none'; document.getElementById('menu3').style.display='none';}function showme(id){ hideall(); document.getElementById(id).style.display='';}</script></head><body><table width="70%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="33%"><a href="#" onmouseover="showme('menu1');">menu1</a></td> <td width="33%"><a href="#" onmouseover="showme('menu2');">menu2</a></td> <td width="33%"><a href="#" onmouseover="showme('menu3');">menu3</a></td> </tr> <tr> <td><div id="menu1" style="display:none"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td>menu1-Item1</td> </tr> <tr> <td>menu1-Item2</td> </tr> <tr> <td>menu1-Item3</td> </tr> </tr></table></div></td> <td><div id="menu2" style="display:none"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td>menu2-Item1</td> </tr> <tr> <td>menu2-Item2</td> </tr> <tr> <td>menu2-Item3</td> </tr> </table></div></td> <td><div id="menu3" style="display:none"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td>menu3-Item1</td> </tr> <tr> <td>menu3-Item2</td> </tr> <tr> <td>menu3-Item3</td> </tr> </table></div></td> </tr></table></body></html>