18,960 Topics
Hello everyone, Now this is my first time posting a question, if I do end up making it too general please let me know. OK, now, I am in the process of programming a small program capable of accessing a sql database. That is no problem. Now, I have decided …
Hello, i'm having 2 tables one is CLG and other is STUD. in CLG(columns CID-autoincrement and CName) and in STUD( three columns are ID-autoincrement,Name and CID) > im using this code to store the records into tables [CODE]$sql="INSERT INTO clg (Cname) VALUES ('$_POST[cname]')"; $id=mysql_insert_id(); $sl="INSERT INTO stud (name,CID) VALUES ('$_POST[name]',".$id.")";[/CODE] …
I would like to know how to put a commenting box into my website I am not that much php expert but I need to know how to do it, I would appreciate if u wont just post a source but explain where to put it. I would also like …
Please can you help. I have been trying create a form to insert some data into a database. (I am coding with PHP and MYSQL). When I put any data into the field called enter treatments completed the database gets updated with the treatments_completed column containing a 0 and then …
I have a table in a database named "tblstudentnumber" it has the following columns: stud_id stud_fname stud_lname stud_address stud_age stud_course i need to have a data report using data environment that can sort all students with the age(a user input) of let say "16". i have a form, it has …
I am trying to put the results of my query into a table on my webpage that i have made however, i am having problems as it prints some of the code out onto the webpage & doesn't display the table. [code]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html …
[CODE] $result = mysql_query("SELECT * FROM Users") or die("could not select ".mysql_error()); if (!$result) { echo 'Could not run query: ' . mysql_error(); } $rows = mysql_num_rows($result) or die("no rows" . mysql_error()); if ($rows > 0) { $row = mysql_fetch_assoc($result); while ($row = mysql_fetch_assoc($result)) { print_r($row); }[/CODE] Every time I …
Hi everyone, I am getting a error when using Xampp with mod_python addon and another python script Here is what I am trying to do, (I checked that the mysql server and apache server are running and refreshed. Also the config files was done correctly.) 1. First entered a string …
When a user logs in, the user is directed to a page called accountsummary.php. I have sessions enabled. I can successfully echo the inputed username, and echo the ENTIRE column of firstname and lastname for the entire table. The problem is that I do not want to echo the entire …
i am using a GridBagLayout and it works fine when i take my coordinates to place an asterisk on the frame but if i try to extract the coordinates from an sql table then it just displays one single asterisk and which would be in the center.. and if i …
I’ve been fighting this for a few days now. I’ve found some wonderful tutorials that get REALLY close to what I’m doing, but I guess I’m too dumb to figure the last step out. I understand it in theory but I’m hoping someone can help me complete this project. What …
Hey guys. Can anybody tell me what is wrong with this line of SQL? I keep getting a syntax error message. Here is the line: [CODE]prepStat = connection.prepareStatement("INSERT INTO WeatherHistory (Date, Location, Overview, Temperature, WindDirection, WindSpeed, Pressure) VALUES ('"+date+"','"+location+"','"+temp+"','"+windDir+"','"+windSpd+"','"+pressure+"')");[/CODE] All the field names and variables exist correctly, so I really …
I've LAN in my office . We work on local server there but.... is it possible for me to access localhost from my home situated far away from office? Plz help me?????????
Hi experts: I created a departments table and populated value as follows SELECT department_id , name,description FROM[COLOR="Red"] departments[/COLOR] ...the table has Trading department Food department Toy departments However, I don't know how to create a dropdown in the frontend like this format: ( Mouse over or click "Departments" navigation menu …
I am accessing the mysql DB via TOAD and I am getting the below error "MySQL Database error - select command denied to user for table 'proc'" When I click on the Procedures I dont see the list of SP's and see this error. When I execute the below script, …
I need a way to practice using PHP and MySQL. But I have the following limitations: 1. My ISP requires me to change my URLs if I upgrade to its service which provides PHP and MySQL. 2. If I change my URLs, all of the resumes I already sent out …
[CODE]//only completed successfully if($cs =='yes') { $sql = "select * from past_participant where completion LIKE '%$cs%'"; $result = mysql_query($sql); $num_rows= mysql_num_rows($result); } else if($cs =='no') { $sql = "select * from course_participant FULL JOIN past_participant ON completion LIKE '%$cs%'"; $result = mysql_query($sql); //$num_rows= mysql_num_rows($result); }else if($cs =='current') { $sql = …
[B]SHA1 my password fields all at once by running a query, I need to know how to write the query[/B] What I want to do is update all password fields in my database to be SHA1 Can anyone help me to run a query to update all fields as I …
Hi all, I have a file download counter on my website, [URL="http://www.madtogger.co.uk/page/software"]here[/URL], that I am playing around with. The files are stored in a folder on my server and their filenames are used to populate a mysql database. What I would dearly like is for the filename without it's extension …
ok so i have to tables and i want to have a query that selects all from "table a" and "table be" where "a certain variable"="$x".. how do i select all from 2 tables at once?
Hi, I had a problem when display the total amt from sql to textbox ------------------------------ create table get(Currentdate varchar(200),Expenses varchar(200),Amount decimal(38,2))-this a table ------------------------------ asp.net codings -------------------------- mycomm.CommandText = "SELECT sum(Amount) from get" dr = mycomm.ExecuteReader While dr.Read() TextBox6.Text = dr.GetDecimal(2) End While dr.Close() -------------------------------------------------------------- Error: Index was outside the …
Hey guys, this is probably a really simple question for you experts so I hope you can help..! Basically I have three separate html fields for the user's date of birth: "year" "month" and "date" All I'm trying to do is to take these three from the form and insert …
hi all,,, i am storing word document in mysql db. i have to email those word document form mysql database how to do it?
What I would like to do is search a MySQL table for anywhere from one to 12 seprate fields, depending on what is submitted from a search form(has 12 different things that a user can search -- its an "AND" search only) What I am unsure of is how to …
When I insert a new event into the table, I serialize almost all the data except a few fields I needed to keep separate. Here is what my serialization looks like in the database: The field this data is stored in is called host_array: [CODE] a:16:{s:5:"sport";s:8:"football";s:14:"tournamentname";s:21:"Grid Iron Challenge 2";s:11:"sanctioning";s:7:"Testing";s:4:"age1";s:2:"15";s:4:"age2";s:2:"16";s:4:"cost";s:3:"450";s:5:"sdate";s:10:"2010-03-05";s:5:"edate";s:10:"2010-03-10";s:5:"tcity";s:5:"Wayne";s:6:"tstate";s:2:"MI";s:5:"games";s:1:"5";s:13:"teamsaccepted";s:2:"15";s:16:"pslteamsaccepted";s:1:"5";s:6:"hotels";s:6:"Hotels";s:7:"details";s:7:"Details";s:6:"button";s:8:"Continue";} [/CODE] …
hi, i had a post in php re display a countdown for policy, it got side tracked to inserting the date properly into mysql database. that is now resolved. what i have is a database setup like this, and if anyone could tell me if this is wrong design before …
i was current developing a software and i like to use odbc in conecting to my database but im having trouble of what version of mySql ODBC connection is compatible with windows 7 or is their any compatibility issue with this software...
Hey, I currently have a dataGridView which displays information from my SQL database. I have a button that I use to update/add into the SQL database - for example a user ammends a field in the dataGridView this automatically updates the database. I now want to implement a button that …
Very simple code, I even echo the variables to make sure they are comming through: [PHP]<? include 'config.php'; $recordid = $_POST['recordid']; $im=$_POST['im']; $bm=$_POST['bm']; $peachtree=$_POST['peachtree']; $canapprove=$_POST['canapprove']; $cancomment=$_POST['cancomment']; $canclose=$_POST['canclose']; $administrator=$_POST['administrator']; echo $im; echo $bm; echo $peachtree; echo $canapprove; echo $cancommnet; echo $canclose; echo $administrator; echo "<p>"; $result = mysql_query("UPDATE employees SET im='$im', …
Hello all i am new to sql, iam having a requirement where i need to have a distinct value from the result lets say example, contacts table id name --- -------- 1 john 2 jason 3 mark address table id address conid -- ------ ----- 1 newlane1 1 2 newlane2 …
Hello to all, I want to know the difference between SQL and MySQL. Also, please post links if anyone have links related to this question.
Hi, I have a PHP application that stores sales transactions into database tables, etc - and we have decided to use this as an online service - which makes it great for the client. They aren't computer literate and their computers mysteriously die and disappear. Having off-site data and no …
I was searching around but I could not find it: I'd like a tool(free or paid) that is able to manage multiple MySql servers from the same GUI. I know about a few thick-client apps that do this, but I need one that you can use it from internet(forget about …
Hello, I've DOB field in my database with date datatype. Bt when I enter 1 March 1980 from front end it stores 29 Feb 1980 in database. Can anyone help me? Thanx a lot in advance.
Hey Guys I'm gonna start on a eleave system for a business soon and I was wondering which language should I use to write it in ? Can someone give a few suggestions as I'll be using MySQL database and Apache but server side script is not yet decided. Personally …
Hello everyone. I have a php webpage, where there are textforms, dropdown lists and stuff. There is Activity field in the database. Whatever activities that i do on the webpage, like modifying the text in the textbox, or changing a value for a dropdown list, these need to be automatically …
mysql trigger if new row inserted into that tabe... php need to popup that values in php... can u please advise me...
Hi I have a query which i run to give me the monthly amount of money that needs to get loaded to our consultants cards. Our system has changed and I need to get the same data but differently The query needs to join three tables consultants,voucher,gift_cards. The only difficulty …
I have written a program to insert the values into datbase and a field named SNO which should be auto incremented whenever an insert happens. I have aready created a table but did not set SNO as increment!! Kindly help to set this constraint in SQL !! Query: Alter table …
is there any to export data from mysql to excelsheet through PHP.. Thanks in advance..!! :D
Hi guys, I've put together a little app which users can use to book off days. I have a button made which reads [B]"Book of this day for every week of the year". [/B] Basically what I want it to do is: 1. User clicks the check box [exists already] …
I have a script that generates random data into an array then uses a while loop to display the data. I have a separate script that takes a row from that array and inserts it into a MySQL database. The problem I am having, is that every time the page …
Hello Friends! :) I am working on my College Major Project. My project contains a part, where the Admin will post News (using Editor like a Blog). This News is then stored in Database. Now I want to retrieve "top 2" news and post them on Home page. I am …
I was searching around but I could not find it: I'd like a tool(free or paid) that is able to manage multiple MySql servers from the same GUI. I know about few thick-client apps that do this, but I need one that you can use it from internet. So far …
Hello' I'm using following code and getting mysqlerror Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs/..... Code is $query="SELECT ('$retfield') FROM ('$table') WHERE ('$givefield')=('$val')"; $res=mysql_query($query); if(mysql_num_rows($res) > 0){ } Upto my knowledge I'm using correct syntax bt I dnt where I'm going wrong. Can anyone help …
[CODE]//SELECT ID van ingelogde gebruiker MySqlConnection cn = cn = new MySqlConnection("server=localhost; user id=bla; password=bla; database=project; Allow User Variables=True;"); cn.Open(); string selID = "SELECT LidID FROM gebruikers WHERE Gebruikersnaam=?Gebruikersnaam;"; MySqlCommand cmd = new MySqlCommand(selID, cn); MySqlDataReader dr = default(MySqlDataReader); //Add parameters to get the username and password cmd.Parameters.Add("?Gebruikersnaam", MySqlDbType.VarChar); cmd.Parameters["?Gebruikersnaam"].Value …
Hi to all, Example: CREATE TABLE test(name varchar(20) NOT NULL DEFAULT ''); In the above query varchar is described as NOT NULL.Then why we are inserting DEFAULT value as '' (null). Thanks in advance, Prem
I am trying to connect to Mysql from Jsp in Tomcat and I am getting Java.lang.NullPointer Exception. Please provide any help as soon as possible. I have set the web.xml and the server.xml properly. My web.xml contains: [code=xml]<description>MySQL Test App</description> <resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/TestDB</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>[/code] server.xml I have …
Hi every body!, I am new to PHP and I'm developing a basic PHP CMS, now specially I'm developing the database backup & restore section of the CMS, so I've experienced one problem. I want that CMS users able to upload their database back ups to restore, they will use …
The End.