10,940 Topics
 | |
| | 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 … |
| | 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 … |
 | 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 … |
The End.