1,257 Posted Topics

Member Avatar for subhra44

MYFORM is anyway child of document so it is allowing, I think problem occurs when there are more than one form.

Member Avatar for urtrivedi
0
210
Member Avatar for naru vaishnaw

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 …

Member Avatar for naru vaishnaw
0
145
Member Avatar for ElliottDuke
Member Avatar for jacob21

you may find solution at [url]http://www.daniweb.com/web-development/php/threads/361569/1544967#post1544967[/url]

Member Avatar for karthik_ppts
0
332
Member Avatar for ZER09

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.

Member Avatar for smantscheff
0
162
Member Avatar for suvisoya

[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]

Member Avatar for Pgmer
0
102
Member Avatar for Ole Raptor

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 …

Member Avatar for Ole Raptor
0
149
Member Avatar for whin_lopez

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 …

Member Avatar for BitBlt
0
190
Member Avatar for Shantanu88d

[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]

Member Avatar for edwinhermann
0
3K
Member Avatar for Rsby

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]

Member Avatar for urtrivedi
0
163
Member Avatar for karthik.net87

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.

Member Avatar for karthik.net87
0
80
Member Avatar for newbie14

I think parameter place in mysql and mysqli is interchanged. so you need to modify everywhere only adding 'i' is not sufficient.

Member Avatar for diafol
0
113
Member Avatar for urtrivedi

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 …

Member Avatar for Ancient Dragon
0
167
Member Avatar for PixelatedKarma

[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]

Member Avatar for urtrivedi
0
110
Member Avatar for gonidelux

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]

Member Avatar for IIM
0
540
Member Avatar for shyam2011

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]

Member Avatar for smantscheff
0
1K
Member Avatar for lawphotog

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) …

Member Avatar for urtrivedi
0
336
Member Avatar for paarade

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 …

Member Avatar for diafol
0
136
Member Avatar for kordellas

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.

Member Avatar for smantscheff
0
334
Member Avatar for neosonic

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

Member Avatar for neosonic
0
193
Member Avatar for pebesoft

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 …

Member Avatar for pebesoft
0
123
Member Avatar for dhruv_arora

add one more closing ) before { at line 41 [CODE]if(!empty($_POST['pass1']) ) {[/CODE]

Member Avatar for dhruv_arora
0
81
Member Avatar for mdpepper

you can also search help on mssql_field_name() in your case it could be sqlsrv_field_name()

Member Avatar for urtrivedi
0
2K
Member Avatar for divyakprabh

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]

Member Avatar for divyakprabh
0
264
Member Avatar for coleguitajuan

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?

Member Avatar for coleguitajuan
0
133
Member Avatar for Naveed_786

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 …

Member Avatar for hfx642
0
458
Member Avatar for baig772

you must pass database name also $conn=oci_connect("sysdba", "hammad90", $databasename);

Member Avatar for baig772
0
793
Member Avatar for jacob21

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.

Member Avatar for urtrivedi
0
88
Member Avatar for himmat.m4

[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]

Member Avatar for urtrivedi
0
151
Member Avatar for manu555

[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" /> …

Member Avatar for diafol
0
154
Member Avatar for avocado_juice
Member Avatar for altarek

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]

Member Avatar for nivibala
0
125
Member Avatar for divyakrishnan

[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]

Member Avatar for Airshow
0
2K
Member Avatar for divyakprabh
Member Avatar for branding4you

make only two changes as shown below [code] <?php . . . . while ($row = mysql_fetch_assoc($extract) || $totala<10) { $totala++; . . . . ?> [/code]

Member Avatar for branding4you
0
177
Member Avatar for ditty

[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]

Member Avatar for twiss
0
107
Member Avatar for shadowscape

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]

Member Avatar for shadowscape
0
143
Member Avatar for seularts

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]

Member Avatar for seularts
0
128
Member Avatar for strRusty_gal

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> …

Member Avatar for strRusty_gal
0
140
Member Avatar for f_atencia

[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> …

Member Avatar for urtrivedi
0
178
Member Avatar for solomon_13000

[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]

Member Avatar for urtrivedi
0
168
Member Avatar for strRusty_gal

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) …

Member Avatar for crishlay
0
175
Member Avatar for jacob21
Member Avatar for lsvife

Login to phpmyadmin (with working login info). Server:localhost, privileges. add user and host. Do this carefully.

Member Avatar for ko ko
0
386
Member Avatar for kolibrizas

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 …

Member Avatar for iamthwee
0
393
Member Avatar for newbie14

I think you can use mysql function. If you need help kindly post details about records, your input, expected output etc

Member Avatar for newbie14
0
479
Member Avatar for Joe34
Member Avatar for BilalAKhan

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 …

Member Avatar for khadakbist
0
147
Member Avatar for ppetree

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 …

Member Avatar for almostbob
0
147
Member Avatar for yatin.baraiya

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]

Member Avatar for Sadun89
0
131

The End.