10,938 Topics
 | |
| | I am following a course on lynda.com First I had XAMPP, but I had some problems with it, and when the guy who was explaining everything used WAMP, I thought it was easier to just uninstall XAMPP and install WAMP. So i did that, but the XAMPP installer said it …  |
| | Hey all, Can any when tell me how to loop and put if-conditions in sql query? as I am new in SQL i am a bit confused about this please help me i have very short time. Thanks in Advance |
 | Hi Forum, I'm currently working on a project where I create a form in Javascript/HTMl(easy). By form, i mean an actual form where it shall contain combo boxes, drop-down lists, buttons etc. Something like a questionnaire. That's all good and simple enough. However, how can I use this questionnaire/form to …  |
| | I had a file info.php with class named xyz and functions within it, I am trying to fetch data from data base from another file show.php..but it is not working and shows "Notice: Undefined variable $info"....is there any help wht am i doing wrong... my code is.. in dblink() // …  |
| | i have a little syntax problem in php mysql, and i cant figure it out, hoping that u guys can help me out....mysql error and code are below Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right …  |
| | Hi i have problem in my login code. Firts someone fill in login informations this is checking code [CODE] // mysql connection $username=$_POST['username']; $password=md5($_POST['password']); $username = stripslashes($username); $password = stripslashes($password); $username = mysql_real_escape_string($username); $password = mysql_real_escape_string($password); $sql="SELECT * FROM users WHERE username = '$username' and password = '$password'"; $result=mysql_query($sql); $count=mysql_num_rows($result); … |
| | I have this page that you can do a search on the site. However, if I do a search that contains an apostrophe ('), it breaks and doesn't display anything although I have entries that have them. Does an easy fix exist for this problem? This is an example of … |
 | Hi All, I hope somebody can help. I would like to make 1 large query from a mysql database. Once called I want to get whatever i want from that stored array, which is where im having trouble. What i have so far is the following code, but each time … |
| | Hi, I have a MySQL DB and I am trying to set up a report page. To do so I need to be able to add the data in 6 or 7 fields into a single field for use in a summary report. How can I do that? SUM() seems … |
| | hello, [B]Please help me to create and using mysql procedures using php scripts.[/B] I searched in web for the solution but i didn't get a perfect support from anywhere . Thanks Anoop Ravi |
| | [CODE] $qrysc = "select * from `communities` where `name` like \"%$key%\" or `type` like \"%$key%\" or `about` like \"%$key%\" union all select * from `personal` where `fname` like \"%$key%\" or `lname` like \"%$key%\" or `country` like \"%$key%\" or `state` like \"%$key%\" or `city` like \"%$key%\""; $rqrysc=mysql_query($qrysc); $numqrysc=mysql_num_rows($rqrysc); [/CODE] Here communities … |
| | I have a table that contains approximately 22000 rows and I used a Boolean Full-Text Search in order to find what I`m interested in. My problem is that I created a 'dynamic search feeling' that consists of a DataGridView that it is refreshed after every TextChanged event. As you might …  |
| | Hi everyone, I had designed an application with Java as front end and mysql as back end. The client application uses both local database as well as Remote mysql server's database for login and other retrievals. I don't know how to generalize the database connectivity code?, I need to access … |
| | wat's guys? i have a java program and i want to connect it with mysql,how can i get my prob solved?or if i can view any source code that can help me. |
| | I need a script that allows users to privately message each other. How can i do this and where can i find an easy script for this? All it needs to be able to do is send messages to a username and then it would have an inbox for the … |
| | How do I advance the pointer to the next row within a while loop using mysql_fetch_array?[CODE]while ($row = mysql_fetch_array($result)) { $zip11 = $row['postnet ip']; include "postnet2.php"; //SOME MORE PROCESSING //I NEED TO ADVANCE THE POINTER HERE TO THE NEXT ROW //SOME MORE PROCESSING } [/CODE] |
| | Hi all, Sorry for the long post but i need to describe my problem properly to avoid confusion, i hope I have a table with users, and every user has a specific latitude and longitude coordinate. let say user Test_User is logged in and then he decides he wants to … |
| | Hey, We got an assignment to host a website, our members must be kept in a mySQL database. I honestly have no idea where to start. If you could just help me with the basics steps. Ill research the details myself. Here's what I've done so far. 1.I downloaded and … |
| | Hi, I am writing a MySQL script. I used a parameter file to set a user variable [CODE]set @log_file = "C:/logs/table_creation.txt";[/CODE] I used the variable in another file in the tee command as follows [CODE] set @log = concat("tee ", @log_file); prepare stmt from @log; execute stmt; [/CODE] But it … |
| | Hello All, Need help in importing CSV files into Mysql. I have tried all the methods which I can think of but im not able to import it. attach is the CSV file which Im trying to import. Below is my MYSQL table structure: mysql> show columns from test; +---------------------+----------+------+-----+---------+----------------+ … |
| | Hi people, I would love to list the table of my database: could you give me a hint to fix this problem using a PHP script ? Thank you very much begueradj |
| | Hi I have a PHP/MYSQL driven site. When a user creates a new account or updates their existing username or email address I do a quick check to make sure the requested entries are not already in use. I am concerned that in the few milliseconds between the SELECT and … |
| | <?php require_once('config.php'); $ID=$_SESSION['ID']; $UserID=$_SESSION['UserID']; $tbl_name = "tbl_users"; //To check Data Insersion $Curr_Password=$_POST['currentpassword']; //echo $Curr_Password; $new_Password=$_POST['npassword']; $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); mysql_select_db(DB_DATABASE, $link) or die( "Unable to select database"); $query="UPDATE $tbl_name SET Password = '".$new_Password."' WHERE Password='".$Curr_Password."' and id=$ID and Status=1"; echo $query; $result=mysql_query($query,$link); if(mysql_num_rows($result) ==1) //line no 38. { echo …  |
| | hi guys i want to set password to mysql database please help me out |
| | Hi, i have a fresh MySQL install, however, i cannon log in with root. All i get ir access denied for root@localhost. However, i can login without any username and password, but it does not have any useful privilegies. How can i get the root account working? Thanks |
| | Hello, I'm trying to join two tables for [CODE]www.cs75.net[/CODE]project 2 (users, history), but i read that JOIN isn't a good practice and will eventually be bad if your tables get larger. so i created new tables as the following: [url]http://pastebin.com/MBzCM1Wv[/url] used a foreign key. the question now am i on … |
| | I have a MySQL Database with several tables that have the same fields in them. I have updated the "cp_ads_welcome_msg" field of the "WP_7_OPTIONS" table with the data that I would like to update all the other tables with. This code works if wanted to update each table one at … |
 | Hey all... I have assigned a job to create back of the databases of our company, maintain it for 7 days and after 7 days delete the back... I have worked on this and make it up the following query but still confused on its authenticity. Please Check and tell … |
 | Hey everyone, As many of you know, we've been having serious database issues here on DaniWeb lately, causing the site to go down just about every single day for a few minutes. We finally got the situation resolved thanks to our database sysadmins over at Percona. While James and Cameron … |
| | Hi, I have access to files in a remote web server that I use frequently ([B]each used file is removed from the server[/B]). The problem is that the server is accessed by many clients and accessing it is sometimes very slow due to this. So I want to make a … |
The End.