[mysql] Forum Topics

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

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 …

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 …

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 .

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 …

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.

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 …

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 …

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 …

i'm trying to write a query that list each team, team member, and their captain. Can someone please help me