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 any page</option> <?php $sql10 = "SELECT Id,Title FROM abc"; $val=$row['PageId']?:''; $rs = mysql_query($sql10) or die(mysql_error()); while($row = mysql_fetch_array($rs)){ $selected = ($val == $row['Id'] ? 'selected="selected"' : ''); echo '<option value ="' . $row['Id'] . '" '. $selected .'>' . $row['Title'] . '</option>'; } mysql_free_result($rs); ?> </select> </td> i am insert …

Member Avatar
Member Avatar
+0 forum 6

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
Member Avatar
+0 forum 2

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 not want the entire page reloading everything the users hits submit. Main issue: I cannot figure out how to reset/set the session variable when a user clicks submit then push that session variable to the next page for processing and return that page results back into my div. Mainpage.php <?php …

Member Avatar
Member Avatar
+0 forum 7

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` = replace(`field`,'price',''); can somebody help please? Thanks in advance

Member Avatar
Member Avatar
+0 forum 1

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 is my update-profile.php <form id="form" method="post" action="update-profile-action.php" enctype="multipart/form-data"> <label for="Fname">First Name:</label> <input type="text" id="Fname" class="text" value="<?php echo $firstname; ?>" name="Fname" /> <br /><br /> <label for="Lname">Last Name:</label> <input type="text" id="Lname" class="text" value="<?php echo $lastname; ?>" name="Lname" /><br /> <br /> <?php if ($_SESSION["type"]=="T") { ?> <label>Profile Image:</label> <input type="file" name="image" …

Member Avatar
Member Avatar
+0 forum 3

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 week, only for the month... UPDATE trans_earnings SET status = 'P' WHERE status = 'E' AND YEARWEEK(earned_date, 0) < YEARWEEK(NOW(), 0) AND abbrev = 'ABC' This would be used in a script that is run once each month, so it would basically effect all records from the previous month. Any …

Member Avatar
Member Avatar
+0 forum 1

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, and my form currently shows all the current times in the different support areas that we have and that all seems to be working fine. The second part runs a function which creates labels at runtime based on how many teams are set up and populates the label.text property with …

Member Avatar
Member Avatar
+0 forum 51

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; //GridView1.DataSource = dc.GetTable<bio>(); GridView1.DataBind(); } public void whereQuery() { DataClassesDataContext dc = new DataClassesDataContext(); var q = from a in dc.GetTable<bio>() where a.name == TextBox3.Text select a; GridView1.DataSource = q; GridView1.DataBind(); } protected void Button2_Click(object sender, EventArgs e) { whereQuery(); } protected void Button1_Click(object sender, EventArgs e) { showgridview(); } …

Member Avatar
Member Avatar
+0 forum 1

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 = DateTime.Today.ToString("yyyy/MM/dd") & " " & "18:15:00" Sqlstr = " UPDATE dbo.VAC_LineStatus " Sqlstr = " SET SET Status = @Status " Sqlstr = " WHERE (Line IN " Sqlstr = " (SELECT VAC_JSINFO.LINE " Sqlstr = " FROM dbo.VAC_LineStatus INNER JOIN " Sqlstr = " VAC_JSINFO ON dbo.VAC_LineStatus.Line = …

Member Avatar
Member Avatar
+0 forum 3

The End.