10,946 Topics
 | |
| | [B][I]please [/I][/B]I need to learn how can I [B]synchronize[/B] between tow [B]MySQL databases [/B]. thanks for everything. mostafa . |
 | Hey Underneith is my code, im having a problem where as when i click the delete button it does what i need it to do (delete a thead) however it also delete the 'title' fields from every other entry in my database ?? this is substantually weird can anyone help …  |
 | I need help deleting a row from a mysql database using a drop down menu form. i want to be able to just select the category i want to delete and then hit the delete button. For some reason I can not get this to work. I'm also fairly new …  |
| | Hi everyone! Unexpected situation. Is there a setting in MySQL that permits a record to be output to the requesting page even though one of the two value pairs is incorrect? And if so, can it be changed? Here's the problem: I have attached a querystring to a URL. It … |
| | Hi everyone. I am totally new in MySQL and I am wondering if you could guide me. I am to make a simple company database (name, salary, age, etc) using three programs: DevC++, Glade 2 and Xampp, wherein a user could add, serach, delete entries. I can't seem to find … |
| | I've got this site that I've been working on that functions very similar to Digg/Reddit. Users submit headlines and the rest of the community either upvotes or downvotes them. Right now I'm just setting a cookie every time a user votes on a story, but this only lasts for awhile, …  |
| | As I have previously mentioned in another thread mysql and php are new concepts to me and currently I am having many problems. My question is a recommended setup. Can you please tell me about your current setup for working with mysql and php. I have read several things that … |
| | i'm trying to display the data from one particular table. everything seem to run fine. but not the data from the table. Please advise, anyone. Codes is as below: [code=php] <?php include ("login.php"); $query = "select * from news"; $result = mysql_query($query); if(!$result) { die("could not query the database: <br>" … |
| | Hi ALL, The project we're working on is a document retrieval system. Two kinds of Features for each document in a repository are extracted as described in table-1 and table-2. Table1 DocID Word LocationName PersonName Freq 1 Book N N 9 1 Study N N 3 2 Work N N … |
| | Hello ALL, I am new to MySQl. I am using MySQL ver 5.1.28 I have got two questions. (1) Can I make a user-defined function return a tabular result.(say, a list of person name) (2) Can I call the function in a select statement, like [CODE] SELECT * FROM Employee_List … |
| | The situation is the following I used phpmyadmin 2.11.5 on localhost when creating databases, but I have phpmyadmin 2.11.6 installed on my hosting account. I am planning to upload databases to hosting really soon and I have some questions about uploading databases to hosting. Can phpmyadmin version difference cause any … |
| | would anybody please point out what is wrong with the "order table" .. i spent hours and can't figure it out why this simple table won't work. i appreciate it. [code] CREATE TABLE customer( cid INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT, fn VARCHAR(10), ln VARCHAR(10), phone VARCHAR(15)); CREATE TABLE address( … |
| | Yes, I know this is a common one, but I've inserted images in a database and can't for the life of me get them to display. And before anyone suggests I shouldn't do it, they are only small pictures and a maximum of four. I am currently using two pages … |
| | hai i have a page where i there is a single drop down box after the user finishes his selection the content of the selection should be returned on the same page to tell the user what he has selected........ |
| | i was trying out how to configure manually postgreSQL and mySQL database servers into Apache with php as a module. luckily i was successful in configuring those things. however, to have better management on mySQL databases in tried to install and configure phpMyAdmin. but i always encounter error (attached image … |
| | Ok - so I have what should be a simple pull into an array for display in a form - however, I am getting this error: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in ...Database.php5 on line 30 Basically, the function is built in Database.php5 [code=php]function … |
| | Hello. I've been banging my head against the wall with this problem and am lost as to how to work it. I have two tables headlines comments The primary key of the [B]headlines[/B] table is HID, and this value is placed by hidden field into the form to submit comments. … |
| | I just created a sql database through my host server. I also created a user with a pass word for that. How do I link that to my dreamweaver site? Thanks for any help. |
 | hi guys, i have problems regarding PHP. I cant connect the php page with mysql database. I have installed everything as far as I know. i have changed the conifiguration files. but still i cant access the database via the pages! im creating a recruitment site(job search) and people should … |
| | Someone please enlighten me. I am just beginning to experiment with mysql and php on websites. I just took over a new site that had an exsisting sql file. I need to add a new table to the database and can not figure out how. If I just open the … |
| | Here's the situation - Im making a website for a game server in which a user can make 1 account. and in 1 account he can make 3 characters. We maintain two tables one for accounts and one for characters. The three characters which can be made is recognized by … |
| | Hi all, i am looking for a way to connect to a Remote MySQL server through HTTP using VB.NET. Actually my application has no direct access to internet. The application connects to a proxy server which is blocking access to database server. The proxy server only allows web requests. How … |
| | this is my login function: [CODE] function doLogin($username, $password) { include ("global.php"); $conn = mysql_connect($DB_HOST, $DB_USER, $DB_PASS); if (!$conn) { return 2; } mysql_select_db($dbnames[$DATABASE_MAPLESTORY]); $result = mysql_query("SELECT * FROM `accounts` WHERE `name` = '" . $username . "'"); if (mysql_num_rows($result) < 1) { mysql_close($conn); return 1; } $row = mysql_fetch_array($result); … |
 | Hello, I am trying to do an export from a table within a mysql database into a csv file where my parameters are a start date and end date...but I am experiencing a few problems... [U]Background:[/U] I have 2 files; testGCR.php and gcrFunction.php. testGCR.php has my form where the user … |
| | Hi Everyone, Is it possible for a table in MySQL to be updated on a regular basis from an Oracle database? |
| | I had written a algorithm, that gets executed daily. it does the following. Make use of 4 auxillary tables , A,B,C,D. Reads from the other database tables, using few rates and updates or populates ranks and order in A,B,C, D. Once this is done, it enters a fixed iteration loop. … |
| | hi, I got a daily task script that does the job as below: #1. Calculate score for one time, count and rank using 4 auxillary empty tables, using data from few other main tables. #2. Now, i start iterating 5 times to get my score for each user stabilised based … |
| | I use to use all for loops for looping through database data sets and just started using while loops with mysql_fetch_ type functions and for some reason, the second mysql_fetch loop in the file never seems to fire but does when I switch the second one to a for loop. … |
| | I've already installed apache server, php and mysql and they are working. I can't configure php and mysql to work together. When I run the test, I receive the message: "Fatal error: Call to undefined function mysql_connect() in C:\apache\htdocs\mysql_test.php on line 9". What can I do? |
| | Hey Guys, Thanks for taking the time to read this, I have the following, rather complicated queries that I am trying to join, and I've spent the past two days attempting to do so, but had no luck so far so any help would be very much appreciated. I have … |
| | Hi I have a database running on MSSQL server 2005. Now I want to move all my data in MySQL server 5. I am familiar with MySQL and PhpMyAdmin. Please help me what is the best way to do this. Thanks |
| | Hi, I'm not sure if this is the right place for the question but it is related to databases, i think. I have been developing a site on a win server 2003 box using MySQL 5 and PHP 5. While I have been developing it the client wanted the site … |
| | |
| | Hi all, I'm an absolute newbie on the site, first ever post! I have been scratching my head for a while now so hopefully one of you DB pro's will be ableto help me :) I have a friend that has asked me to design a database for his small …  |
| | Helllo! I'm working on a user information tracker that will allow users to write data to their profile through it's web interface and with a Java Application for wireless devices. My the issue is the Java app, how do I let public applications access a mySQL database securely? I can't … |
| | OK this is driving me mad and it needs to be done for a deadline. It is just a simple query to update a few database fields. Here's the PHP for it. [code=php] $sql5 = "UPDATE videos SET title='$new_video_title' WHERE artist_id='$i' "; $query5 = mysql_query($sql5) or die( mysql_error() ); $sql6 … |
| | hi all, I have been trying to convert my phpnuke setup over to mysqli.I am running it as mysql at the moment on apache 2.2.9, php 5.2.6 and mysql 5.0.51b.I have attached the unmodified file as i have been playing for a week and have got no closer. is it … |
| | hai ! im into a project where ive got to display the table in the form of a datagrid....im in a look out for a really gud one ....pls help.... |
| | hi, iam new mysql with vb.net , i am install mysql in my machine 3 more user have to access the mysql database , my question is that , i need to install mysql in all the client machine? looking forward ur suggestions kannan |
| | I have a form in jsp and if someone enters special character (like single quote ') in text field (ex L'orel) and submit, it gives a error. I know this is a special character conflict, but how can I override special characters by submitting a form through JAVA. Is there … |
| | hai when the no of columns is 10 rows to be more than 2000 ....which type of insert is best?? INSERT INTO example (name, age) VALUES('Timmy Mellowman', '23' ); or INSERT INTO example (name, age) VALUES('Timmy Mellowman', '23' ),('jimmy','16' ),(' johnn', '19' ); |
| | |
| | Hey everyone, I want to use mysql to list all of the makes of vehicles and I want the user to be able to click a make and the years that make were made pop up. Is there a way to do this using PHP? I've got the makes to … |
| | Please i need someone who can help me Display Date from Mysql which is in format YYYY/MM/DD to DD/MM/YYYY the code below sends data to mysql but when i`m displaying date it comes in YYYY/MM/DD. [code] <?php include"config.php"; $comment=$_POST['comment']; $news_id=$_POST['news_id']; $name=$_POST['name']; //$rece_user=$_POST['rece_user']; $query="INSERT INTO newscomment (name,news_id,time,comment,date) VALUES('$name','$news_id',CURTIME(),'$comment',CURDATE())"; $result=mysql_query($query); if($result){ //echo"<i><b><font … |
| | Hi, I am trying to query a terms database with multiple text boxes. The user has a choice of how many text boxes they want (i have this part done), they would put one term into each text box. The would have the option of checking a check box for … |
| | Hi all, I have a question about mysql_real_escape_string. Is it just used for login scripts or is it also used for inserting data to a database. My problem is this: [CODE] $connection = mysql_connect("*****", "*****", "*****"); $database_select = mysql_select_db("*****", $connection); $firstname = $_POST['firstname']; $lastname = $_POST['lastname']; $firstname = stripslashes($firstname); $firstname … |
| | Hi, I have a problem. I would like to, from a text form, filter out what the user wants to see. I have a mysql database with info on every order placed. Each row is a new order. All users has their own ID. I would like the users to … |
| | In my Database(mysql) i have 100 members registered,Now there is page i want to display only ten members, but after each page refresh i want other ten members to display at the very same place Meaning replacing the current shown members. Any one with the idea on how i can … |
| | i know this maybe to easy for you, this is what i need to accomplish: 2 list menus 1.- Manufacturer (Honda, Kawa, Susuki) 2.- Model (cr250, cr125,etc..) each manufacturer has their own models 3.- Year(1999.1998,etc..) So i would like to have the first list menu listing the manufacturers options and … |
| | Hi guys, How can i store multiple image paths in one single MySQL field, help please Thank you OCBPHOTO |
The End.