mrjameer

hi, i want to convert the bmp or gif image to jpg.how i can.any of your help will be surely appreciated.any links or tutorials help is great advantage to me thanks mrjameer

Hi, i have mysql 5.0.37 on my pc.now i want to download postgresql and test some php scripts with it on localhost.is it ok.if i installed postgresql,the mysql will still remains as it is? can i use both at a time. thanks mrjameer

hi can any body tell me what is the encrytion technique used for the password which is stored in user table and mysql database when we login to phpmyadmin thanks mrjameer

hi i have to give some more clear idea CREATE TABLE `category` ( `cat_id` int(2) NOT NULL auto_increment, `category` varchar(25) NOT NULL, PRIMARY KEY (`cat_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ; -- -- Dumping data for table `category` -- INSERT INTO `category` VALUES (1, 'Fruits'); INSERT INTO `category` VALUES (10, 'cars'); CREATE TABLE `subcategory` ( `subcat_id` int(3) NOT NULL auto_increment, `cat_id` int(2) NOT NULL default '0', `subcategory` varchar(25) NOT NULL default '', UNIQUE KEY `subcat_id` (`subcat_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ; -- -- Dumping data for table `subcategory` -- INSERT INTO `subcategory` VALUES (30, 1, 'heavyfruits'); INSERT INTO `subcategory` VALUES (23, 1, 'bbb'); INSERT INTO `subcategory` VALUES (22, 10, 'aaa'); INSERT INTO `subcategory` VALUES (29, 1, 'middlefruits'); INSERT INTO `subcategory` VALUES (26, 1, 'fruits'); INSERT INTO `subcategory` VALUES (28, 1, 'lightfruits'); CREATE TABLE `subsubcategory` ( `cat_id` int( NOT NULL default '0', `subcat_id` int( NOT NULL default '0', `subsubcat_id` int(11) NOT NULL auto_increment, `subcat2` varchar(15) NOT NULL default '', PRIMARY KEY (`subsubcat_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ; -- -- Dumping data for table `subsubcategory` -- INSERT INTO `subsubcategory` VALUES (1, 28, 47, 'light2'); INSERT INTO `subsubcategory` VALUES (1, 28, 46, 'light1'); INSERT INTO `subsubcategory` VALUES (1, 30, 45, 'heavy2'); INSERT INTO `subsubcategory` VALUES (1, 30, 44, 'heavy1'); INSERT INTO `subsubcategory` VALUES (1, 26, 42, 'oranges'); INSERT INTO `subsubcategory` VALUES (10, 22, 41, 'hi'); INSERT INTO `subsubcategory` VALUES (1, 23, 40, 'apple'); INSERT INTO `subsubcategory` VALUES (1, 29, 49, 'middle1'); INSERT INTO `subsubcategory` VALUES (1, 28, 48, 'light3'); <?php include 'config.php'; $sql = "SELECT * FROM subsubcategory C INNER JOIN subcategory S ON C.subcat_id=S.subcat_id ORDER BY S.subcat_id"; while($row = mysql_fetch_array($result)){ if($lastState != $row['subsubcat_id']) print "{$row['subcategory']} "; print "<font color=#FFFFFF>{$row['subcat2']}</font> "; $lastState = $row['subcat_id']; } ?> i want to display just cat_id='1' data and all subcats and subsubcats of it output aaa hi bbb apple fruits oranges lightfruits light2 lightfruits light3 lightfruits light1 middlefruits middle1 heavyfruits heavy2 heavyfruits heavy1 thanks mrjameer

hi i have to give some more clear idea CREATE TABLE `category` ( `cat_id` int(2) NOT NULL auto_increment, `category` varchar(25) NOT NULL, PRIMARY KEY (`cat_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ; -- -- Dumping data for table `category` -- INSERT INTO `category` VALUES (1, 'Fruits'); INSERT INTO `category` VALUES (10, 'cars'); CREATE TABLE `subcategory` ( `subcat_id` int(3) NOT NULL auto_increment, `cat_id` int(2) NOT NULL default '0', `subcategory` varchar(25) NOT NULL default '', UNIQUE KEY `subcat_id` (`subcat_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ; -- -- Dumping data for table `subcategory` -- INSERT INTO `subcategory` VALUES (30, 1, 'heavyfruits'); INSERT INTO `subcategory` VALUES (23, 1, 'bbb'); INSERT INTO `subcategory` VALUES (22, 10, 'aaa'); INSERT INTO `subcategory` VALUES (29, 1, 'middlefruits'); INSERT INTO `subcategory` VALUES (26, 1, 'fruits'); INSERT INTO `subcategory` VALUES (28, 1, 'lightfruits'); CREATE TABLE `subsubcategory` ( `cat_id` int( NOT NULL default '0', `subcat_id` int( NOT NULL default '0', `subsubcat_id` int(11) NOT NULL auto_increment, `subcat2` varchar(15) NOT NULL default '', PRIMARY KEY (`subsubcat_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ; -- -- Dumping data for table `subsubcategory` -- INSERT INTO `subsubcategory` VALUES (1, 28, 47, 'light2'); INSERT INTO `subsubcategory` VALUES (1, 28, 46, 'light1'); INSERT INTO `subsubcategory` VALUES (1, 30, 45, 'heavy2'); INSERT INTO `subsubcategory` VALUES (1, 30, 44, 'heavy1'); INSERT INTO `subsubcategory` VALUES (1, 26, 42, 'oranges'); INSERT INTO `subsubcategory` VALUES (10, 22, 41, 'hi'); INSERT INTO `subsubcategory` VALUES (1, 23, 40, 'apple'); INSERT INTO `subsubcategory` VALUES (1, 29, 49, 'middle1'); INSERT INTO `subsubcategory` VALUES (1, 28, 48, 'light3'); <?php include 'config.php'; $sql = "SELECT * FROM subsubcategory C INNER JOIN subcategory S ON C.subcat_id=S.subcat_id ORDER BY S.subcat_id"; while($row = mysql_fetch_array($result)){ if($lastState != $row['subsubcat_id']) print "{$row['subcategory']}<br />"; print "<font color=#FFFFFF>{$row['subcat2']}</font><br />"; $lastState = $row['subcat_id']; } i want to display just cat_id='1' data and all subcats and subsubcats of it [u]output[/u] aaa hi bbb apple fruits oranges lightfruits light2 lightfruits light3 lightfruits light1 middlefruits middle1 heavyfruits heavy2 heavyfruits heavy1 thanks mrjameer

hi now it is displaying the state names and city names but state name are repeating.i just want to print in the way that first print the state name and all the citys under it like that.i have to add one where condition also so that it display the particular coutry states and citys only thanks again best regards mrjameer

hi it is just displaying the city names but not state names regards mrjameer

hi rhodesa thanks for your reply sorry here i have a small adjustment state_id,state_name 1---ca 2---ba 3---da second table name is citys fields are cityid,state_id,city_name 1--1---texas 2--1---newyork 3--2--losangles 4--2--perth 5--2--sydney 6--3--washington

hi, i have 2 mysql tables first table name is states fields are state_id,state_name 1---ca 2---ba 3---da second table name is citys fields are id,state_name,city_name 1--ca---texas 2--ca---newyork 3--ba--losangles 4--ba--perth 5--ba--sydney 6--da--washington what i want to do is i want to fetch data from 2 mysql tables and display as state_name1 cityname1 cityname2 state_name2 cityname1 cityname2 cityname3 like that.just i need the sql query to fetch and display the data in the above format.any of your help will be surely appreciated thanks mrjameer

hi, i have a web site name called www.welcome.com i want to break or explode the site name and store in 3 different variables as follows . $variable1=www; $variable2=welcome; $variable3=com; how i can achieve this.any of your help will be surely appreciated. thanks mrjameer

hi BlueSkyIS your logic worked.it is displaying the results what i want.thanks but when i use like operator it does not display anything. any how thanks for all replys thanks mrjameer

hi i have a mysql table.it has 2 fields 1.register_number 2.registered_date values 333333----2007/08/21 245678----2007/06/30 123123----2007/09/20 123222----2007/09/21 125553----2007/09/22 i have select box on a page and it's option values from january-december. when i select the month from select box and press submit button,it should fetch those records that are registered in that particular month. i just need the sql query logic to fetch the records of that particular month. any of your help will be surely appreciated thanks mrjameer

hi, i want to play some audio and video files(separately) randomly.any tutorials or links or any help will be surely appreciated.i search in google.but i dont get any useful links.. thanks mrjameer

hi, i want some info about how i can put the bbc news,cnn news on my page.is there any opensource rss feed system,so that i can get the news and store it in mysql db and display the news.any of your help will be surely appreciated. i searched over google.find some but complex,i need simple news system. thanks mrjameer

hi, sorry,now i filtered some code. <script language="Javascript"> function EgCheck() { var eg_array = document.getElementsByName("eg_array[]"); for (var i=0; i< eg_array.length; i++) { eg_array[i].checked = true; } } function writecombo($array_name, $name, $selected = "", $start = 0, $add_text = "", $add_text2 = "") { $length = count ($array_name); if (($array_name == "") || ($length == 0)){ echo "<select name=\"$name\"></select>\n"; }else{ echo "<select name=\"$name\" $add_text $add_text2>\n"; while (list($key, $val) = @each($array_name)) { if( !is_array($val) ){ $select_name = $val; $i = $key; echo " <option value=\"$i\""; if ($i == $selected){ echo " selected"; } echo ">$select_name</option>\n"; } } echo "</select>\n"; } } </script> <? if ($_POST['RenewDate']){ $renewIt=mysql_query("update admin set last_login='".time()."'"); if ($renewIt){ echo "<meta http-equiv='Refresh' Content=0;URL='imgman.php'>"; } } $eg_max=10; $limit = $eg_max; ?> <script> function gotocluster(s){ var d = s.options[s.selectedIndex].value self.location.href=d; } </script> <? if (!$start_m){ $starttime = time(); $start_y = date("Y",$starttime); $start_d = date("d",$starttime); $start_m = date("m",$starttime); } if (!$end_m){ $endtime = time(); $end_y = date("Y",$endtime); $end_d = date("d",$endtime); $end_m = date("m",$endtime); } ?> <form method="POST"> <table width="85%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr valign="top"> <td><p>welcome</p></td> <td nowrap> <!-- add writecombo date here --> <? WriteCombo($month_values, "start_m",$start_m);?> / <? WriteCombo($day_values, "start_d",$start_d);?> / <input name="start_y" type="text" size="4" maxlength="4" value="<?=$start_y?>"> -Åáì- <? WriteCombo($month_values, "end_m",$end_m);?> / <? WriteCombo($day_values, "end_d",$end_d);?> / <input name="end_y" type="text" size="4" maxlength="4" value="<?=$end_y?>"> </td> <td align="right"><input type="submit" name="report" value=" view "></form> <form method="post" action="?eg=mod"><input type="submit" name="eg_mod" value="latest"></form></td> </tr> </table> <!--</form>--> <table width="85%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td> <form method="POST"> <input type='hidden' name='start_m' value='<?=$start_m?>'> <input type='hidden' name='start_d' value='<?=$start_d?>'> <input type='hidden' name='start_y' value='<?=$start_y?>'> <input type='hidden' name='end_m' value='<?=$end_m?>'> <input type='hidden' name='end_d' value='<?=$end_d?>'> <input type='hidden' name='end_y' value='<?=$end_y?>'> <? if($_POST['report'] || $_GET['report']){ $stime = mktime(0,0,0,$start_m,$start_d,$start_y); $etime = mktime(23,59,59,$end_m,$end_d,$end_y); if($byip){ $sql = "SELECT * FROM images WHERE ipaddress='$byip'"; }else if($byuid){ $sql = "SELECT * FROM images WHERE user='$byuid'"; }else{ $sql = "SELECT * FROM images WHERE date >= $stime AND date <= $etime"; } $qr1 = mysql_query($sql); echo "total: ".mysql_num_rows($qr1)."<br>"; if($byip){ $purl = "imgman.php?report=1&byip=".$byip; }else{ $purl = "imgman.php?report=1&start_m=".$start_m."&start_d=".$start_d."&start_y=".$start_y."&end_m=".$end_m."&end_d=".$end_d."&end_y=".$end_y; } $rowcount = mysql_num_rows($qr1); $pagecount = ceil($rowcount / $limit); print "<table width=100%><td>images: " . ($pageno+1) ."</td><td align=right> <select onChange=\"gotocluster(this)\">\n <option>ÇÎÊÑ ÇáÕÝÍÉ</option>"; for($x=0; $x<$pagecount; $x++){ $p = $x + 1; $l = $x * $limit + 1; $u = $l + $limit - 1; if($u>$rowcount) $u=$rowcount; print "<option value='".$purl."&pageno=".$x."'>ÇáÕÝÍÉ $p ($l - $u)</option>\n"; } print "</select></td></table></form>"; echo "<form method='post' action='eg_del.php'> <input type='submit' value='delete'><br/><br/><a href='javascript:EgCheck();'>check</a> <table width='100%' border='1' cellspacing='4'><tr>"; $l = $pageno * $limit; $u = $l + $limit-1; $count = -1; $i = 1; $eg_count=1; $domCount = 0; while( $a = mysql_fetch_object($qr1) ){ $eg_time = date("Y/m/j h:i:s",$a->date); $count++; $row = ($count % 2)+1; if ($limit && $count < $l ) continue; if($limit && $count > $u) continue; $filen = $siteurl."/".str_replace('./', '', $att_path)."/".$a->filename; $filen = str_replace('http://','%%',$filen); $filen = str_replace('//','/',$filen); $filen = str_replace('%%','http://',$filen); //$thname = $a->thumb; $eg_explode = explode(".",$a->filename); $eg_ex = $eg_explode[1]; if(strtolower($eg_ex) == "jpg" || strtolower($eg_ex) == "gif" || strtolower($eg_ex) == "png" || strtolower($eg_ex) == "jpeg"){ echo "<td align='center'>"; echo "<a href='$filen' target='_new'><img src='$filen' height=100 width=100 border=0></a><br>"; //$FName = $thname; //echo "<a href='$filen' target='_new'><img src='$filen' width=100 height=100 border=0></a><br>"; } else { echo "no image found<br>"; } if($a->user){ list($username) = mysql_fetch_array( mysql_query("SELECT username FROM users WHERE uid='".$a->user."'") ); echo " <b>ÇáãÇáß:</b> <a href='imgman.php?byuid=".$a->user."&report=1'>".$username."</a><br>"; } echo "<a href='imgman.php?byip=".$a->ipaddress."&report=1'>".$a->ipaddress."</a><br/>"; echo $eg_time."<br/>"; echo "<input type='checkbox' name='eg_array[]' value='$a->id' class='arr'>"; echo "</td>"; if ($eg_count == $eg_in_row){ echo "</tr><tr>"; $eg_count=0; } $eg_count++; } echo "</table></form>"; print "<table width=100%><td>images: " . ($pageno+1) ."</td><td align=right> <select onChange=\"gotocluster(this)\">\n <option>select</option>"; for($x=0; $x<$pagecount; $x++){ $p = $x + 1; $l = $x * $limit + 1; $u = $l + $limit - 1; if($u>$rowcount) $u=$rowcount; print "<option value='".$purl."&pageno=".$x."'>ÇáÕÝÍÉ $p ($l - $u)</option>\n"; } print "</select></td></table>"; }elseif($_GET['eg'] == "mod"){ $eg_sqlmod=mysql_query("select last_login from admin") or die (mysql_error()); $sqlmod=mysql_fetch_array($eg_sqlmod); // Paging ----------------------- if(!(isset($page))) { $page=1; } else { $page=$_GET['page']; } // Max_Per_Page $max=$eg_max; // from page to page $from=($max*$page)-$max; $paging=mysql_query("select id from images where date>='$sqlmod[last_login]'"); $nums=mysql_num_rows($paging); $pages=ceil($nums/$max); // -------------------------------- $sql="select * from images where date>='$sqlmod[last_login]' limit $from,$max"; $qr1 = mysql_query($sql); echo "<input type='submit' name='RenewDate' value='ÊÌÏíÏ ÊÇÑíÎ ÂÎÑ ÒíÇÑÉ'>"; //</form>"; echo "<form method='post' name='myf' action='eg_del.php'> <input type='submit' value='del'><br/><br/> <a href='javascript:EgCheck();'>ÊÍÏíÏ Çáßá</a> <table width='100%' border='1' cellspacing='4'><tr>"; $l = $pageno * $limit; $u = $l + $limit-1; $count = -1; $i = 1; $eg_count=1; $eg_a=0; $domCount = 0; while( $a = mysql_fetch_object($qr1) ){ $eg_time = date("Y/m/j h:i:s",$a->date); $count++; $row = ($count % 2)+1; if ($limit && $count < $l ) continue; if($limit && $count > $u) continue; $filen = $siteurl."/".str_replace('./', '', $att_path)."/".$a->filename; $filen = str_replace('http://','%%',$filen); $filen = str_replace('//','/',$filen); $filen = str_replace('%%','http://',$filen); //$thname = $a->thumb; $eg_explode = explode(".",$a->filename); $eg_ex = $eg_explode[1]; if(strtolower($eg_ex) == "jpg" || strtolower($eg_ex) == "gif" || strtolower($eg_ex) == "png" || strtolower($eg_ex) == "jpeg"){ // $FName = $thname; echo "<td align='center'>"; echo "<a href='$filen' target='_new'><img src='$filen' width=100 height=100 border=0></a><br>"; } else { echo "<td align='center'>"; echo "no image found<br>"; } /* echo "<td align='center'>"; echo "<a href='$filen' target='_new'><img src='../$filen' border=0></a><br>"; echo "<td align='center'>"; echo "<a href='$filen' target='_new'><img src='../$filen' border=0></a><br>";*/ if($a->user){ list($username) = mysql_fetch_array( mysql_query("SELECT username FROM users WHERE uid='".$a->user."'") ); echo " <b>ÇáãÇáß:</b> <a href='imgman.php?byuid=".$a->user."&report=1'>".$username."</a><br>"; } echo "<a href='imgman.php?byip=".$a->ipaddress."&report=1'>".$a->ipaddress."</a><br>"; echo $eg_time."<br/>"; echo "<input type='checkbox' name='eg_array[]' value='$a->id' class='arr'>"; echo "</td>"; if ($eg_count == $eg_in_row){ echo "</tr><tr>"; $eg_count=0; } $eg_count++; $eg_a++; } echo "</tr></table></form> <center>"; } // paging ---------------------------------------------------- for($i=1;$i<=$pages;$i++) { if($page==$i) { echo"[$i]"; } else { echo "<a href=".$PHP_SELF."?eg=mod&page=$i>[$i]</a> "; } } // ------------------------------------------------------------ ?> <!-- </form>--> </td> </tr> </table> <? include("siteadmin/footer.php"); ?>