11,093 Topics
 | |
| | The [B][URL="http://www.onlinesynchronization.com/mysql_synchronization.html"]Synchronization [/URL][/B]Manager enables one to set up data synchronization scenarios from one MaxDB to one or several MaxDB servers. The Synchronization Manager uses the standardized XML-RPC to enable asynchronous data transfer. An easy-to-use GUI is also included to simplify the definition of the synchronization scenarios. The new tool also … |
 | [B][U]Question:[/U][/B] [COLOR="Red"]How to pull info from MySQL to populate title tag?[/COLOR] [U][B]Current code:[/B][/U] Include/common.inc.php <title><? echo PAGE_TITLE; ?></title> ________________________________________ Individual pages <? include("include/common.inc.php"); define ("PAGE_TITLE", "Blablablablablabla"); ETC ECT ETC ETC ... ________________________________________ I want to customize further the PAGE_TITLE in the file details.php ([url]www.mysite.com/details.php?listid=[/url]... ) to reflect information taken from …  |
 | I am trying to query a table where at least three conditions have to be met and then the outcome stored in an array and printed into a table. I tried with the code, but I am having problems setting the conditional query and would be happy with an assistance … |
| | Hey, I have installed Mysql and launched it from command line using cd Mysql/bin/mysql. I want to now how to give user credentials as soon as it opens. Also, is there any default username by which it opens. I ask this because, without logging in I'm able to run all … |
| | i'm using vb.net 2005 express + mysql connector to connect to mysql database. i want to save image into mysql database. so i've created a table with img field as longblob. to save the image, first i convert it into byte() and then insert into the table. the problem is … |
| | I am creating a website to load images by registered members. I created a database for registration details and thats working fine (still few errors). But now my issue is to upload images into database. i tried different ways still i am unable even to load data into database. Anyone … |
| | Code: [CODE]<?php define( "DATABASE_SERVER", "blah" ); define( "DATABASE_USERNAME", "blah" ); define( "DATABASE_PASSWORD", "blah" ); define( "DATABASE_NAME", "blah" ); //connect to the database $mysql = mysql_connect(DATABASE_SERVER, DATABASE_USERNAME, DATABASE_PASSWORD) or die(mysql_error()); mysql_select_db( DATABASE_NAME ); $sql = 'SELECT * FROM `users`'; $result = mysql_query($sql) or die ('Error: '.mysql_error ()); while($row = mysql_fetch_array($result)) { …  |
| | We are trying to implement MySQL clustering on our E-commerce database, but presently the tables are MyISAM based and some of the tables have full text search index on. In the wake of Clustering environment, one of the requirements is moving to InnoDB. However, that would pose the problem of … |
| | Hi guys I am building a website which allows people to advertise their property online for free. I allow people to upload up to 5 images to my database. I store the name of the file in the database and the image itself is stored elsewhere on the server. I … |
| | hi i have problem when sorting file path like c:\test in mysql varchar field it retrieve like c:test what is my problem? what can i do to correct that i am using vb.net so please help me |
| | hai ive got two tables company table serial_no smallint(5) unsigned NO PRI NULL auto_increment industry varchar(255) company_name varchar(255) person table serial_no int(25) company_name varchar(255) contact_person varchar(255) i want to insert the serial no in COMPANY to PERSON i used the following code [code=sql]INSERT INTO person(serial_no,company_name) SELECT company.`serial_no`,person.`company_name` FROM company,person WHERE …  |
| | i have a simple question which is that if MySQL database and PHP are installed on the same system do i require a secure connection or can i just place the connection code in a php file and call it as needed. Thanks Studio  |
| | Hi, Is a stored procedure faster or a normal inline query in a web application? I use mysql but i guess answer must be same for all databases. Maybe not! Also, how do i test speed of the query in php page and in mysql client application? Thanks |
 | If anyone can answer [URL="http://www.programmingforums.org/thread16958.html"]my question on PFO [/URL]I'd apprecaite an answer. I don't want to repeat it here because it is somewhat lengthy. |
| | Hi all! I'm trying to write a "last login" message in my login script. The plan is to store dates in the database with UTC_TIMESTAMP and then show them back to the user with CONVERT_TZ, using each user's specified timezone (they have set that on registration). However here lies the … |
| | This one is worth two gold stars. I am working out of Cristian Darie's PHP and MySQL Ecommerce 2nd edition book and am woefully stuck on chapter 6. For some reason, on the main page load (i.e., index pulling in products_list.tpl) I am getting a repeating option dropdown and all …  |
| | Hi, This is my SQL exercise questions. I got it from my friend. Honestly, I am starting to learn SQL language. Now I am using MS SQL 2003. When I've tried to answer the question, there are much error in my answer. So, could you plz try to answer the … |
| | Hello everyone, I'm having trouble populating a dropdown box with mysql data. I have a table with columns makeid, yearstart, yearend and makename. Sample data would be 1, 1936, 1941, American Bantam. I want the dropdown to list the years a certain brand of car was offered. For instance, a … |
| | Hi, I would like to know how I can send the changed data over a period of time to another database on a different server. If this is possible without replication... Must be the same tables in the two databases? Thank you so much |
| | [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 |
The End.