1,257 Posted Topics
Re: MYFORM is anyway child of document so it is allowing, I think problem occurs when there are more than one form. | |
Re: you must take out friend request code out of if condition that is [CODE]if(isset($_GET["accept"])) {[/CODE] [CODE]//START OF SHOW FRIEND REQUESTS $query = mysql_query("SELECT * FROM friend_requests WHERE recipient = '" . $_SESSION["logged"] . "'"); if(mysql_num_rows($query) > 0) { while($row = mysql_fetch_array($query)) { $_query = mysql_query("SELECT * FROM members WHERE id … | |
Re: post both files here configuration.php and index.php | |
Re: you may find solution at [url]http://www.daniweb.com/web-development/php/threads/361569/1544967#post1544967[/url] | |
Re: are u able to work with mysql usin phpmyadmin, there i think you can look into privileges, where you can specify which host,user can connect and what he can access. | |
Re: [CODE]insert into dbname.destination_table_name (dest_col1,dest_col2,dest_col3) select source_col1,source_col2,source_col3 from dbname.source_table_name where some_colname='some condition'[/CODE] | |
Re: put need to put deleimiter between sql commands like semicolon or any other. [CODE]DROP PROCEDURE IF EXISTS sp_Insert_Address;[/CODE] if you are runing this commands in phpmyadmin, then you can use another command terminator like @@ so you code will look like [CODE]DROP PROCEDURE IF EXISTS sp_Insert_Address @@ CREATE PROCEDURE sp_Insert_Address … | |
Re: I will suggest you unaurthodox method if student id is not important for you. I assume that student id is autonumber 1) first notice the maximum student id in your table. Here I assume it is 19 2) now insert distinct name in same table from same table using following … | |
Re: [CODE]<?php $str = " Hello world hello World this is hello world "; $arr=str_word_count(strtoupper($str),1); echo "<pre>"; foreach($arr as $value) { $finalarr[$value]++; } echo print_r($finalarr); echo "</pre>"; ?>[/CODE] | |
Re: line number 69 in process_form2.php [CODE]$header = "From: $name \n";[/CODE] I think they will not allow any name. you must write some email id that you have registered with them. so you code must look like [CODE]$header = "From: registered_with_bluehost@domain.com \n";[/CODE] | |
Re: if you have written sql query somewhere than format date or time to text, so when you datatype is text it will not append anything like :00. | |
Re: I think parameter place in mysql and mysqli is interchanged. so you need to modify everywhere only adding 'i' is not sufficient. ![]() | |
Dear moderator, We do have so many thread tabs like all thread new stories product reviews code snippets tutorial upvoted solved unanswered I always felt one more in the list is required. Like if user who started thread was last to reply on that thread and that thread is still … | |
Re: [CODE] $result = mysql_query( "SELECT page_name FROM ms_content" ) or die(mysql_error()); $num_rows = mysql_num_rows($result); $mainmenu=""; while ($get_info = mysql_fetch_row($result)) { $mainmenu .= ".:"; $mainmenu .= $get_info[0]; $mainmenu .= "</br>"; } [/CODE] | |
Re: add second and third line shown below at line number 14 [CODE]show_user_info($username); $conn=mysql_connect("localhost","username","password"); mysql_select_db("dbname",$conn); $q1="select timestamp from users where username='$username'"; $r1=mysql_query($q1);[/CODE] | |
Re: while inserting you can do like [CODE]INSERT INTO `data` (`test`, `test1`, `test2`, `total`) VALUES(20, 20, 20, 20+20+20);[/CODE] after inserting you must run update query like [CODE]update data set total=test+test1+test2 where total=0[/CODE] | |
Re: Do not create tables for categories. 2 is enough Do you have actually 76 kind of pizzas with distinct type and price? if yes then i think you can not compact it anymore. One complex design I can suggest, it is self referencing (though it may not solve your problem) … | |
Re: what you have given is your requirement, but how you want it to work, 1) do you want single php form where you enter age and census year and you get period of year of born 2) or you have some large data in excel, csv and you want to … ![]() | |
Re: For learning basic queries, microsoft access is good software. There you can drag columns and apply functions, and you can see sql query generating on its own. | |
Re: How mysql server will know what to select out of multiple choices, 1134 1125 What is criteria of selection. what is the version of mssql | |
Re: before executing query you echo it for example. copy that query result from browser and run in phpmyadmin, is it running there [code] $query="update ir312 SET R3_21 = $tot WHERE irdnumber=$irdnumber "; echo $query; mysql_query($query) [/code] several reason for query failure. 1) On linux mysql table name are case sensitive … | |
Re: add one more closing ) before { at line 41 [CODE]if(!empty($_POST['pass1']) ) {[/CODE] | |
Re: you can also search help on mssql_field_name() in your case it could be sqlsrv_field_name() | |
Re: I used to convert things in upper case while comparing strings in oracle [CODE]select * from test where upper(ID_PRIVILEGES) = upper('Admin');[/CODE] You may also follow this link [url]http://geekzspot.blogspot.com/2010/01/case-insensitive-oracle-database.html[/url] | |
Re: where is checkcode() source code? Post complete code and what exact problem your facing? How would somebody know, that what is not working in your case? | |
Re: say your form in menu is [code] Entry |____new Master [/code] Here your menu newmaster will open a form for example, We assue that name of ENTRY menu item is, ENT AND name of new master menu item is NEWMST so collectiveley we can say that new master menu item … ![]() | |
Re: you must pass database name also $conn=oci_connect("sysdba", "hammad90", $databasename); | |
Re: function is running fine here I think you have problem with [CODE] <input type="checkbox" name="chk1" onclick='checkCheckBoxes()' />check for Birth year only[/CODE] or if you have chrome, then open tool> java script console, there you will able to see error. | |
Re: [code] SELECT col1,col2,col3 FROM (SELECT col1, col2, col3, ROW_NUMBER() OVER (ORDER BY col1) myrow_srno FROM tablename) WHERE myrwo_srno BETWEEN 51 and 100; [/code] | |
Re: [CODE]<html> <head> <script lang='javascript'> function setcode() { // alert( ); document.form1.code.value = document.form1.list1.value+'-'+document.form1.list2.value+'-'+(document.form1.list2.selectedIndex+1); } </script> </head> <body> <form action="" method="get" name="form1" > <select name="list1" onchange=setcode()> <option value="MUM">MUM</option> <option value="DEL">DEL</option> <option value="BAN">KOL</option> <option value="HYD">HYD</option> </select> <select name="list2" onchange=setcode()> <option value="MUM">MUM</option> <option value="DEL">DEL</option> <option value="BAN">KOL</option> <option value="HYD">HYD</option> </select> <input name="code" type="text" /> … ![]() | |
Re: Have you checked if somebody paste the number then what happens? | |
Re: You question is not clear, If you do not want name to change in update, then you may ignore writing column name in update query. [CODE] insert="insert into table (col1, col2, col3,filename) values ('1','2','3','myfile')"; update="update table set col2='2', col3='3' where col1='1'";[/CODE] | |
Re: [CODE]<div id=firstdrop > <select > <option value=1> one</option> <option value=2> two</option> <option value=3> three</option> <option value=4> four</option> </select> </div> <div id=seconddrop> </div> <script language=javascript> document.getElementById("firstsecond").innerHTML=document.getElementById("firstdrop").innerHTML; </script>[/CODE] | |
| |
Re: make only two changes as shown below [code] <?php . . . . while ($row = mysql_fetch_assoc($extract) || $totala<10) { $totala++; . . . . ?> [/code] | |
Re: [url]http://translate.google.co.in/?hl=en&tab=wT[/url] [url]http://www.google.co.in/url?source=transpromo&rs=rssf&q=http://translate.google.com/toolkit%3Fhl%3Den[/url] | |
Re: you may try [CODE]wardrobe.php?key=hash&value=HASHTAG or wardrobe.php?key=friend&value=FRIENDNAME[/CODE] your code file may look like [CODE]<? header("Content-Type: image/png"); $value = strtolower($_GET['value']); if( strtolower($_GET['value'])=='hash') $filepath = "wardrobe/$value"; else if( strtolower($_GET['value'])=='friend') $filepath = "wardrobe/md5($value)"; else exit; $errorpath = "wardrobe/cb5e100e5a9a3e7f6d1fd97512215282"; if (is_readable($filepath)) { readfile($filepath); } else { readfile($errorpath); } ?>[/CODE] | |
Re: using return statement at the end of function [CODE] function Email() { $the_name = $_SESSION[$this->GetLoginSessionVar()]; $profil_query="SELECT * FROM $this->tablename WHERE username='$the_name'"; $resultate_profil=mysql_query($profil_query); $resultat=mysql_fetch_array($resultate_profil); $mail = $resultat['email']; return $mail; } $revalue=Email(); echo $retvalue; [/code] | |
Re: In page a.asp you can keep one hidden form element, that will be passed to b.asp on submitting form. IN setvalue fuction you can set value for that field before submitting the form. [CODE]<script lang='javascript'> function setvalue() { document.getElementById('myfield ').value='newvalue'; document.frm.submit(); } </script> <form name=frm action=b.asp method=post> <input type=text name=txt1> … | |
Re: [CODE]<html> <head> <script lang='javascript'> var isNumeric = /^(\d*)(\.?)(\d*)$/; function checknum() { if (!isNumeric.test(document.frm.txt1.value)) { alert( 'Not a valid number'); return false; } else { alert( 'Number Accepted'); return false; } } </script> </head> <body> <form name=frm id=frm action='#' method=post> <input type=text name=txt1 id=txt1> <input type=button name=btn1 id=btn1 value=check onclick='javascript:checknum()'> </form> … | |
Re: [CODE]SELECT CONVERT(VARCHAR(10), GETDATE(), 120) AS [YYYY-MM-DD][/CODE] For details refer following link [url]http://www.sql-server-helper.com/tips/date-formats.aspx[/url] | |
Re: first select whether your table has null rows or not. run following queries one by one. [code] SELECT name, grade, age FROM education WHERE (grade IS NULL ) SELECT name, grade, age FROM education WHERE ( name is null ) SELECT name, grade, age FROM education WHERE (age is null) … | |
| |
Re: Login to phpmyadmin (with working login info). Server:localhost, privileges. add user and host. Do this carefully. | |
Re: It is good to develop tools for generating forms. It is essential for self growth. But those who do not have time to do all this, they should use ready to use tools. For managing mysql table data operation, I use free version of php datagrid428 (support is stopped for … ![]() | |
Re: I think you can use mysql function. If you need help kindly post details about records, your input, expected output etc | |
Re: where is rest html code | |
Re: I think you have bunked your class in your college when your professor was teaching you variables. No condition required at all, remove all if condition and keep following link in first page. [code] Response.Redirect("Search Page.aspx?Category=" & Category.SelectedItem.Value & "&Product=" & ProductList.SelectedItem.Value ) [/code] Now in second page, same way … | |
Re: I am not sure about the best solution. This happened to mean for person address directory. I had to go for manual correction. Though I developed a tool in php, which list thing is alphabetic order, If I found more than two rows I used to delete all rows but … | |
Re: USE SINGLE QUOTE AROUND SRC attribute [CODE]out.println("File has been uploaded successfully"); out.println("<html>"); out.println("<body>"); out.println("<table><tr><td width='210'></td><td> <img border=2 src='image/"+itemName.toString().trim()+"' width=800 height=600></td></tr></table>"); out.println("</body>"); out.println("</html>");[/CODE] |
The End.