11,093 Topics
 | |
| | 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 … |
| | Hi. I'm programming an e-commerce/online store using servlets and a MySQL database, and I'm having some problems with the db right now. Hope somebody here smarter than me can give me a hand. There are two kinds of users, both having their own table in the db: customers and admins. … |
| | Is using php with MS SQL server over MySQL a good practise? Ive been using MySQL for quite sometime and what I like about it is that it is free. Are there any advantages of using MS SQL server over MySQL? Or any challenges. |
| | I downloaded the php. MySQL and the apache but, I am facing a problem in which the code is being displayed and not the web page. There must be a configuration problem. Any help would be much appreciated. |
| | Hey there =) Im struggling to save a file to my MySQL database. I managed to save a image to the database with this code [CODE] SqlConnection con = new SqlConnection(Properties.Settings.Default.NorthWestConnectionString); SqlDataAdapter da = new SqlDataAdapter("Select * From MyImages", con); SqlCommandBuilder MyCB = new SqlCommandBuilder(da); DataSet ds = new DataSet("MyImages"); … |
| | hi i know there is a lib for mysql in c++, but i can't seem to install it properly! someone has a place i can find a tutorial for mysql for: Windows XP, Codeblocks. thx for helping. Checklist for Fast Responses: 1: Search before you post. Does what you're looking …  |
| | I;m trying to move a database created with WAMP from one computer to another. I've exported it as a .sql file and imported it by creating a new database and then importing into it. The problem I'm facing with this approach is that none of the data in the tables … |
| | I have code where I am pulling data from my database and it needs to be separated by commas except the last value (that part works) so I can take those values and input into another SQL query. Here is the working code: [CODE]$biz_id = $row_businesses['id']; $query_related = sprintf("SELECT * … |
| | Hello Friends, I am working in JME. Now, I have situation in which, I suppose to connect with Database which has been used with PHP. So, How can I access to Mysql? As usual same as to connect mysql with JDBC? Is Mysql and Mysql in WAMP Server different? Please … |
| | i can't finde my.ini or my.cnf i installed XAMPP and it can't start mysql and the error is: because of port 80 and 3306 and i look up with netstat i don't find any program use these 2 ports and my firwall is off what can i do to start … |
| | I'm having trouble with a MySQL INSERT query. I've used this exact code in many places, and even in different pages on the same web server. I feel like I've tried every variation of INSERT query with no luck. Here are a couple that I've tried so far: [CODE] $name … |
 | how does one search mysql where one fields has multiple entries. example: in my db i have two fields in table, one field is the type field: id | Garment | Type 1 | Satin Shirt | "Chemical Clean" 2 | Silk Shirt | "Dry Clean", "Chemical Clean" When i … |
 | Query Runs in mysql but gives an error when I run in PHP here is the query [CODE]select p.pid as pid, s.sid as sid, s.status as staus, p.name as name, p.mobile as mobile, p.email as email, c.name as course from students as s, prospects as p, courses as c, batch … |
| | I'm not sure where to begin on this... I have a survey engine that supports 7 types of questions and really an unlimited number of entries per question (yes/no being one exception). So, I have 7 tables and each table correspondes to one answer type so I have: response_bool (true/false … |
| | Hey there =) i have 2 tables with a relationship between them. a Primary key in the one table, and a secondary key referencing the primary key, in the second table. Now usually when i want to display data in my db i INNERJOIN the two tables, so i can …  |
| | Hi I'm not an asp .net developer although I have done web development with php and mysql, I'm more of a software developer for desktop and mobile devices. So this is my first big project with ASP .NET. I have a question with the ASPNETDB database, understand that the database … |
| | I have the php which can import the csv files into mysql. But how to avoid the wrong data replace the data database. What is the code in php for checking before insert into the database? Thanks! |
| | Hello to all,m kawal had rcecntly started my carrier in php so requests to help me in my projects.... I wana know how to generate a password by the admin panel itself..for ex.If if m running a company and handling admin panel,how can i generate a password to a new … |
| | I don't know how to enquiry the "informationtype" which are message and email? How to rewrite the below code? [CODE] $information = mysql_query("SELECT * FROM table WHERE informationtype='message'"); $row = mysql_fetch_assoc($information); $result=($row['informationno']); [/CODE]  |
| | I'm trying to run this code but there is error message: PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource [code] <?php if (mysql_connect('localhost','root','') && mysql_select_db('guestbook')) { //echo 'connected today'; $time= time(); $errors= array(); if (isset($_POST['guestbook_name'], $_POST['guestbook_email'], $_POST['guestbook_message'])) { $guestbook_name = mysql_real_escape_string(htmlentities($_POST['guestbook_name'])); $guestbook_email = mysql_real_escape_string(htmlentities($_POST['guestbook_email'])); $guestbook_message = … |
| | I'm going a little crazy here trying to figure this out. Any help would be greatly appreciated. MySQL version: 5.0 I'm trying to make a very ugly php page used to basic queries. I have a similar page working that creates new records in the specified table, so I know … |
| | I have problem in code for IF statement. Im looking in a mysql table if there is a field (fld_comleted) that has record with "NO" in it. If there is a record that has "NO" in it it has to do something (send email to client) if there is no … |
 | Hi, I wrote a qyery: [CODE] SELECT introtext FROM jos_content JOIN jos_sections ON jos_content.sectionid = jos_sections.id WHERE jos_sections.title = 'Redaktores zodis' ORDER BY publish_up, DESC; [/CODE] If I don't use ORDER BY then it works. But with it it throws error: Query : select introtext from jos_content join jos_sections on … |
| | Hello to all,m kawal had rcecntly started my carrier in php so requests to help me in my projects....thanks  |
| | Hello Friends, I am working in JME. Now, I have situation in which, I suppose to connect with Database which has been used with PHP. So, How can I access to Mysql? As usual same as to connect mysql with JDBC? Is Mysql and Mysql in WAMP Server different? Please … |
| | i have designed a windows forms which has a textbox in it,in that textbox i will enter path and on click of button i will bind that data to database(mysql) and i am done with it.but if the entered path contains ''(escape character) it will be ignored while binding for … |
| | Hello all. The Java Date and time classes are difficult. I think I have to use java.sql.Date which is a sub class of Date but is not a date unless the time is normalized to zero. so I've heard. I would like to work with my studentDOB first by collecting … |
| | Hello, I have the following situation which I can seem to resolve. When I do an "ALTER TABLE" in mysql (v5.5) it hangs in with "waiting for metadata lock". Here is how I got there: - i have an xml which i want to import into a table; i use … |
| | Hello Guys, I'm having the biggest headache over this issue. I have a system that I designed which uses a standard php login script to a MySQL database. The system has account registration etc. For the past 5 months I've tested multiple accounts and logged in with one primary account … |
| | Hello! I am interested how can I find the connection string in order to be able to connect to MySQL Server 5.1.50 using OleDbConnection(C#). I used this auto generated string (after adding new data source in Visual Studio): [QUOTE]erver=localhost;User Id=MyID;password=MyPassword;database=MyDatabase[/QUOTE] but I always get the same annoying error saying: [quote]An … |
The End.