10,938 Topics
| |
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... actually me wish to have few differences between SQL Server 2005 & 2008, from interview point of view. As I have asked the same question most often. give me the basic difference as well as technical too. Thanks | |
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 … | |
is there any to export data from mysql to excelsheet through PHP.. Thanks in advance..!! :D | |
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 … | |
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 … | |
can somebody prove me the coding to update the database (mysql) with JSP | |
Hi people. I'd like to use MySQL in my application - would be an easy way for me to store users. But then I'd have MySQL credentials in my app, visible for everyone with a HEX editor, I'd suppose? And even though that MySQL user will have low privileges, then … | |
Hi, When I register a member using my script, why one of the column have "Resource id #14"?? Below is the code: if($do->new_user($username, $encoded_password, $email, $alertpay, $referral, $country, $c, $referral2)) {mysql_query("INSERT INTO history (username,type,time,custom1,custom2,custom3,custom4,custom5) VALUES ('{$username}','joined',unix_timestamp(),'0','0','0','0','0')"); mysql_query("UPDATE users SET balance=balance+'0.20' WHERE username='{$referral}'")or die(mysql_error()); mysql_query("UPDATE stats SET users = users + … | |
Im working on this searh field and i finally can search from the database using an entered name or national ID no, when i press the find button. But i dont know how to incorporate radio buttons to be submitted to execute a query. can someone help me . my … | |
Hello there I am a fairly new in MySQL/PHP/Javascript programming. I'm writing a web based gymnast profile management system for my final year project. Here's my problem. I have 5 MySQL InnoDB tables: [B]tests[/B], [B]testunits[/B], [B]points[/B], [B]testsgymnast[/B] and [B]gymnast[/B] I am able to retrieve a selected test which has particular … | |
Please is it possible to have two where statement in an sql query? for example: SELECT * FROM Persons WHERE FirstName='Peter' but I want another condition which will also pass the query like: SELECT * FROM Persons WHERE house='duplex' or car='Honda' Is the second query correct if not how do … | |
in a cell in mysql i have tree, car, bus, dog, apple, ocean, tire. now i'd like to query only the words beginning with the letter T. So it should echo tree and tire. this hasn't been successful; [code] <?php mysql_connect("localhost", "Master", "pword"); mysql_select_db("db"); $letter = "t"; $user =mysql_query("SELECT * … | |
Hey, I have a script that caches the output from a query, but whenever the query is run my cpu usage jumps to like 25% the query (theres about 5 different queries similar to this) is [CODE=mysql ] select n.name, ifnull(c.kills_d,0)+ifnull(s.kills_d,0)+ifnull(r.kills_d,0)+ifnull(k.kills_d,0)+ifnull(o.kills_d,0) scores, c.online_d+s.online_d+r.online_d+k.online_d+o.online_d online_d from names n left join scores_ctf … | |
how to obtain query execution time? i need for mysql query in java... does anyone know | |
Hi and I remember reading in a really old topic that somebody here was able to write a chatroom without using mysql or any other database system. Can somebody explain how this is possible with just javascript and ajax? What I want to do is to have a script that … | |
Hi, I am looking for the best solution to my situation: - I have businesses listed in a MySQL table. - Each business can bid on up to 10 keywords (different prices for different keywords). A user inputs a keyword and then I must find a way to query my … | |
Running a SQL query from the following code: [CODE] <php if(sizeof($_POST['addcandidate'])){ foreach($_POST['addcandidate'] as $id){ $name= mysql_query("SELECT LastName FROM candidate WHERE Candidate_ID= '$id'"); while($rowz= mysql_fetch_assoc($name)){ $candidatename= $rowz['LastName']; $alter= "ALTER TABLE '$votertable' ADD '$candidatename' int"; mysql_query($alter) or die(mysql_error()); } } } ?> [/CODE] I return Im getting: [COLOR="Red"]#1064 - You have an … | |
Hello! i have a mysql problem - i need to execute a query which selects field from one table and joins another table which is determined by a field value in table 1. for example, table1 contains fields ID(primary int) and someotherfield(varchar). i need to join table2 or table3 depending … | |
in mysql i have a field named S_No which i placed on auto_increment. whenever i delete the second row from the database and next time when i m trying to add another row in database its starts from the 3rd incremental value and basically i don't want it, i wana … | |
Hey there, I'm having problems importing my sql file via phpmyadmin. It keeps throwing up the following error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'id`) ); CREATE TABLE `sessions`( … |
The End.