19 Topics

Member Avatar for
Member Avatar for fugio

Hi all I have a script to update the value from datagridview to database I do use a button insert ToolStripButton but not working hope people to help thank ! Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load conn = New SqlConnection("") conn.Open() Dim query As …

Member Avatar for Amudhambika
0
4K
Member Avatar for rjusman90

if(isset($_GET['Id'])){ $Id=$_GET['Id']; $query = mysql_query("SELECT * FROM page WHERE ID='$Id'"); $row = mysql_fetch_array($query); $PageId=$row['PageId']; $MenuName=$row['MenuName']; $ParentMenuId=$row['ParentMenuId']; $LinkWidth=$row['LinkWidth']; $OtherUrl=$row['OtherUrl']; $Status1=$row['Status']; $OnMainMenu=$row['OnMainMenu']; $FooterMenu=$row['FooterMenu']; } ?> <form style="width:100%" action="" method="post" id="form1"> <table class="viewjob" align="center" > <tr class="tableheader"> <td align="center" colspan="4"> Update </td> </tr> <tr class="tablerow"> <td>Page Id</td> <td><select name='PageId' class="select"> <option value='0' >select …

Member Avatar for pzuurveen
0
216
Member Avatar for patk570

Hello, I found this script and have used it for my login system. http://www.wikihow.com/Discussion:Create-a-Secure-Login-Script-in-PHP-and-MySQL I have changed some variables but none the less its the same. I am trying to create a reset password script here is what i tried so far: function resetPassword(){ //Main Info $id = $_POST['id']; $email …

Member Avatar for patk570
0
314
Member Avatar for engrjd91

I have the following code,I have created a form for attemting a scheme of changing the password for the user. i have hashed my password and stored it in the database. Now in the database it looks like, "980a3a0b40df9a1". Whenever i enter the changed password in the form it throws …

Member Avatar for engrjd91
0
246
Member Avatar for kumar89hitesh

how to edit in the post in php? i m using update query but no working? can anyone suggest me any idea and please give me suitable example

Member Avatar for diafol
0
240
Member Avatar for ravi142

Hello I faced this type of Error in codeigniter. Can you suggest me any solution... *ERROR : You must use the "set" method to update an entry.* In Model Code is.. $this->db->where('user_id',$user_current_id); $this->db->update('admin_resume_expertise',$data); Thank YOu

Member Avatar for krishnanair
0
179
Member Avatar for roxanne.martos

im working on my login script and whilst testing it, it seems that the code doesnt recognise the details stored within a database im entering a valid username and password in the login form but it is not processing it somehow the system thinks its wrong. I cant find any …

Member Avatar for minitauros
0
263
Member Avatar for moone009

This is my main page where the user can choose a category from a drop down. I need that category selection to update my session variable so I can then send that variable to another php page execute a query and return the result in my div because I do …

Member Avatar for moone009
0
363
Member Avatar for fada397

below is the code which select value from the database and increase it by 2 and update the database with the new value. how do I lock or prevent multiple read and update at the same time? please help Dim query2 As String = "select * from " + usern …

0
185
Member Avatar for mpc123

Hi I need to delete words before a set of words in a field. eg delete the words before the word price in that field. I already have a query to replace a certain word but cant see how adapt it to do what I require update TABLE set `field` …

Member Avatar for diafol
0
183
Member Avatar for riahc3

Hello Sometimes I get a duplicate key which I want to ignore or discard. This is a example and has nothing to do with the actual query. I simple want to state columns/values insert into table(Time_Stamp,Time_Stamp_ms,p1) values (time,timems,'1') Where the first two are my PK. I see that insert into …

Member Avatar for riahc3
0
181
Member Avatar for adamchippy

Hey there. I'm building a project in PHP/MySQL and it is a sort of [FaceMash](http://en.wikipedia.org/wiki/History_of_Facebook#Facemash) project. I am able to call the images (with image name and points) from the database. I have managed to use the MySQL Update query in order to increase the points that each image gets …

Member Avatar for GliderPilot
0
253
Member Avatar for Riu 2009

hi everyone, i want to store an image in database not by inserting but by updating (by using UPDATE query) and hers my code... everything else is updated successfully but its not storing image..please help me to solve the problem.. im using medium blob data type to store image this …

Member Avatar for Mani_6
0
15K
Member Avatar for sweta87

i have four columns in a gridview .Every field is a template field with checkboxes.I have a button. when i check the check boxes and store it in database the checkbox value is storing. but after clicking the button the checkboxes unchecked. how to make the checkboxes checked . public …

Member Avatar for sweta87
0
826
Member Avatar for showman13

Good afternoon, I'm trying to formulate what should be a simple query that will create a result set of ALL records from a table that have a date that is in the previous month... Basically something like this one that I use that gets any records prior to the current …

Member Avatar for showman13
0
203
Member Avatar for pezza

Hi, I am new to VB.NET and am working on what is pretty much my first app. The app is based on a sql data source (created within Visual Studio) and basically is intended to show who is on-call when the app is loaded. So, i have some test data, …

Member Avatar for pezza
0
4K
Member Avatar for nileshbhanu

<?php $host = "localhost"; $user = "root"; $pass = ""; $databaseName = "foresight"; $tableName = "userinfo"; $con = mysql_connect($host,$user,$pass); $dbs = mysql_select_db($databaseName, $con); $result = mysql_query("SELECT * FROM $tableName where flag != 1"); //query $email = mysql_fetch_row($result); //fetch result mysql_close( $con ); ?> <?php $connection = mysql_connect("192.232.240.245","root","causealmedus-1608"); if (!$connection) { …

Member Avatar for veedeoo
0
2K
Member Avatar for hussain_ahmed

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.Linq.Mapping; public partial class Default3 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } public void showgridview() { DataClassesDataContext dc = new DataClassesDataContext(); var q = from a in dc.GetTable<bio>() select a; GridView1.DataSource = q; …

Member Avatar for pritaeas
0
142
Member Avatar for lulu79

I want to perform an UPDATE query but i'm getting this error: ![errorHAVING](/attachments/fetch/L2ltYWdlcy9hdHRhY2htZW50cy8zL2Vycm9ySEFWSU5HLkpQRw%3D%3D/500 "errorHAVING") This is my Sub in vb.net: Public Sub changeStatus() Dim Sqlstr As String Dim connectionString As String = "server=xxxx;uid=xxxx;pwd=xxxx;database=xxxx" Dim strtTime As String Dim endTime As String strtTime = DateTime.Today.ToString("yyyy/MM/dd") & " " & "06:15:00" endTime …

Member Avatar for lulu79
0
899

The End.