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