7,368 Topics
 | |
| | I've constructed a photo gallery with a dynamic CMS backend that allows the content providers to upload, delete, etc images. All images are stored as reformated jpeg files (processed by the GDLib on upload) and the relevant metadata is stored in a table called `gallery`. References are made by an …  |
| | I have two tables: tb1: Name Email Location ----------------------------------- user1 email1 address1 user2 email2 address2 user3 email3 address3 ----------------------------------- tb2: Group Email ----------------------------------- group1 email1,email2 group2 email4 group3 email5,email6 ----------------------------------- Now I want to join these two tables, to display the usernames who are listed in table 2, with keyword …  |
| | [b]PREFACE:[/b] My name is Al and I'm a loving moron who locked himself out of MySql. Alright, Let's rock. I don't exactly remember changing my password, but since I was in the Terminal using commands like [b]-u password[/b], I think I might have done it on accident. So... I need …  |
| | |
| | I am building an online music video library where u can strean the media to ur browser mobile phne and pda devices. I am using PHP for the middle HTML for the front end and MYsql for the backend. I want to have database with the music files residing on … |
| | I am creating a database and would like to create a unique primary key that is randomly generated. Does MySQL have any feature that will do this? I don't want to use an auto-increment, because when I have a page like "whatever.php?id=xxx", I don't want a user to be able … |
| | Hi all, Ok, first I'll let you know that I am very new to databases and scripting languages, so my questions are very elementary. I have read a book on the SQL language as well as a book on PHP basics, but I have no idea where to get started. … |
| | Hi, I am with a web host using mysql 4.0 and phpmyadmin 2.5.5 p\1 I am trying to get my html user form on my website to insert into mysql database. I keep getting: Error! Could not select the database: Access denied for user: 'match.match.com@10.80.0.%' to database 'mydb' Can you … |
| | [code] CREATE TABLE my_feature ( pk_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, member_id INT(8) UNSIGNED NOT NULL, time_added DATETIME NOT NULL, personal_questions BOOL NULL, hits INTEGER UNSIGNED NULL, PRIMARY KEY (pk_id)); [/code] When I put this into the MySQL Query Browser I get this error: You have an error in your … |
| | Hi, While I'm not entirely new with SQL, I am not by any means highly knowledgable. I'm attempting to write a SQL statement to do the following, and having no luck: Assumptions: There is only one table, with several fields of metadata including the following. 1 field (integer) that indicates … |
| | My MySQL query_cache_size is currently set to 50M and even at that setting I am getting a decent amount of qcache_lowmem_prunes. Queries are being removed from the cache to make room for new ones. My question is whether the queries being removed are based on time elapsed since they were … |
| | I am using MySQL 4 and trying to cache my queries per this tutorial: [url="http://dev.mysql.com/doc/refman/4.1/en/query-cache-configuration.html"]http://dev.mysql.com/doc/refman/4.1/en/query-cache-configuration.html[/url] Right now, my query_cache_size is set to 0. I would like to set both the query_cache_size and query_cache_limit parameters. However, I'm receiving the following error message: [code]mysql > ERROR 1227: Access denied. You need the … |
| | I am writing from the ground up a feature for this one company in Georgia while I am in school. It is running on mysql, but I have encountered a problem (actually a few problems, which led to this problem). I use auto increment for the unique identifiers for each … |
| | Hi I am so Desperate! I use a server internic.ca which host my website and offers me MySQL with phpMyAdmin 2.5.5-p\1 I seem to be able to make the table fine beyond that I cannot understand… How do I use this phpMyAdmin 2.5.5-p\1 I am trying to setup a Membership … |
| | I'm looking for a way to compare 2 lists of keywords and return the number of matches. I'm currently working with PHP and MySQL, but I'm not sure how to go about this task. Any suggestions are appreciated. Thanks, J_ |
| | Hello, I have this query: SELECT players.id AS id, players.name AS name, players.surname AS surname, players.email AS email, calendar.start AS beginning, calendar.end AS finnish, calendar.name AS title, calendar.event AS description, calendar.id AS eventid FROM `calendar` , `attendance` , `players` WHERE (attendance.present = "yes" AND calendar.start BETWEEN "1141060879" AND "1141665679" AND … |
| | I'm running a query through XML from the local database which uses PHPMyAdmin to a remote one which uses MSSQL. Unfortunately I have no way of checking syntax against MSSQL so all I know is that this works in PHPMyAdmin. So the query gets as far as running, but is … |
| | Linux newbie any way ... MySql 5 installed eaisly on my Mandrake 10.1 box but the Gui admin tool MrSql-Administrator 1.1 will not. Is it my ineptness? Thans in advance :( |
| | [COLOR=SeaGreen]Hi guys, i hope u can help me solve this prob of mine. Im currently werking on this project and somehow im unable to insert this data into my database eventhough the data was being retrieved. Can anione help :sad: [/COLOR] <% option explicit %> <% response.buffer = true %> … |
| | |
| | I'm creating my first web application in PHP/MySQL, however, when I go to view the database contents, the data has been stored in the wrong columns. I've gone through my insertion code with a fine toothcomb and can see no errors which might cause this. I will post the code … |
| | [b]Configuring PHP with MySQL[/b] [B]Intro[/B] To use PHP with MySQL, of course you need to install MySQL server on you system first. On my local system, I have MySQL server installed in \mysql directory. If you need help on installing MySQL on your system, please read "Herong's Notes on SQL". … |
| | hi i am extremly a newbie and i have a doubt. i have wamp server installed, if i create the mysql database on my system using phpmyadmin how can i upload that database to the remote server ?, what type (wht type of file extention) of database files that i … |
| | Hi to all, I would like to build a registration module and this registrastion module has the following requirements. It is mainly divided in to four parts. [B] 1.General Info 2.Personal Details 3.Searchable details 4.Owned products[/B] The first two are compulsory and the later two are opted from a group … |
| | I've created a web page in .php which receives it's content from a MySQL database, it is all working nicely and looking good except that a field which I have called Ed_Main is now about 65kb and now does not display all the text stored in it. I'm using PHPMyadmin … |
| | hey guys, i need to setup a database server, and as of now , i do not have any knowledge about MySQL, PHP, and things realted ...although i have a fair knowledge of how things work, i have used Access for my earlier databases, i want to have adress book(forms) …  |
| | Hiya all ive decided to do my final year project designing an online music video library that will allow multiple access by many users to the same files that will be highly available, with facilities to access the video library by pc, pda and mobile phones. how would i integrate … |
| | I would like to know how I can backup Mysql tables from hosting server to my local pc? I don't want to use phpMyAdmin, is there some simple commands to do that(I use PHP)? and how to restore it back to hosting server? I assume it will use csv file. … |
| | i'm a newbie in MySQL. i want to know if i want to update MYSQL, can i check that is it have any user at that time, provide me the solution. if i get there is the user how i block the traffic and wait for the user finish their … |
| | whats wrong with this code? i'm really confused! when i use INSERT code insted of UPDATE in my file, every thing is ok. but when i use UPDATE,it doesn't work!! UPDATE: [CODE]$query = "UPDATE $tblname SET title='$title', desc='$desc', body='$body', time='$time', faday='$faday', famonth='$famonth', fayear='$fayear', fu_show='$fu_show', fu_day='$fu_day', fu_month='$fu_month', fu_year='$fu_year', wshow='$wshow', dshow='$dshow' WHERE … |
The End.