[mysql] Forum Topics

i am trying to connect to my database which i have set up and i keep getting the same message 'could not connect'. i have a php page which sets up the database, and i recall this page with the include db.php to connect to the server. i have tried …

anybody mind teach me how to connect between tables in db??say theres table a, b and c in db .how can i make all these table connected??theres any coding??im using EasyPHP as server

Dear all site members, my hosting provider says that there are SQL queries running from my i.p address (I am renting a dedicated server, if it matters to the question) to another i.p address on their network. Basically, something on my server is connecting to a MySql database on a …

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/doreen/public_html/trunk/template/posts.php on line 19 I don't know how to fix it

hi , M facing the problem to get first 4 rows from the table . m using sql2000. i used count but it is showing total no of rows in a table . please let me know the query used to display rowcount.

I need some help suggesting an elegant way of doing something. I'm currently in the planning phase of a media management solution that comes in two parts; The administration website, and the deployment website. What I'm considering doing is, at the time a member signs up for an account, I …

How can I create a trigger to UPDATE this for me when a new record is inserted. I want to create a column called "fullthumb" where by default it has the words "http://example.com/thumbs/" and add the words in "thumb" column. In syntax: [code]UPDATE files SET fullthumb = CONCAT('http://example.com/thumbs/', thumb);[/code] I …

Hey everybody, I'm new to mysql, but I'm developing a real estate website, mostly for condos. I'm setting up the database and want to make sure it's sufficiently designed so that customers can search the database for the type of place they want. Specifically, if someone wants to search for …

i have created an image upload page in my web site which stores the images on the server using php. i now need to get the images to display on a different page. here is the code i have used to set a variable to the file directory // the …

How to create a trigger to UPDATE this for me when a new record is inserted. I want to create a column called "fullthumb" where by default it has the words "http://example.com/thumbs/" and add the words in "thumb" column. UPDATE files SET fullthumb = CONCAT('http://example.com/thumbs/', thumb);

Ok I got a new multimedia search engine that im hoping to launch pretty soon. ([URL="http://im1musicc.cs-webhost.com/search/"]temporary link here[/URL]) I all ready got the number of mp3 downloads counter set up there using flat files, but I didnt do that. It was all ready done when I got the script. Now …

[code=mysql] $result = mysql_query("SELECT * FROM cycles WHERE Upper(brand) LIKE '%$brandC%' AND type LIKE '%$typeC%'"); [/code] Above code is not working, pls help.

Attached to this thread is the DB schema I've come up with. I'm trying to do an outer join to join the exercises to the submissions regardless if there's a related record in the submissions table. Trouble is when a user logs in I want to execute this query and …

This has become a horror, a horror I tell you. I am not a techie. I am not a developer. I do not want to be a developer. I am trying to set up a pro bono program for a non-profit law office that serves the poor. Every time I …

Is it possible to make a column on my database that automatically copy another column on the same table string together with another url? for example on my database "ewelby_k5" I want to create a new column called (fullthumb) on table "files" where "fullthumb" stores "http://k5live.com/thumbs/ + column "thumb" " …

mysql4.X is installed on my system.while i tried to install Phpbb forums in my personal computer it is giving the following error: Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\Apache Group\Apache2\htdocs\phpBB2\db\mysql4.php on line 48 Warning: mysql_error(): supplied argument is not …

hi all, i just want to know whether it is useful to alter the 50% threshold scheme that mysql uses by default ,is it beneficial in any way regarding serach(either by increasing or decreasing its value)or is it good to use default value of 50% only. which is better (altering …

I am relatively new to mysql. I am updating a site for a customer, and I'm using mysql 5 w/ phpMyAdmin. I was supplied an .sql (echeck.sql) script to build the database for this site. I create a database named "echeck" in phpMyAdmin, and once created go to the import …

I had my site working which require mysql database... so now im trying to host that site here at home... my site comes up but now on the top of the main site 3 errors come up... Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'milatcom_clipsha'@'localhost' (using password: YES) in /www/www.mysitesname.com/include/adodb/drivers/adodb-mysql.inc.php …

Hello Everyone i need help connecting my site to a database.. Either MySQL or PHP Which Is better.

I used both Myisam and InnoDB. We have something like 500k update, 500k and 500k insert/delete/replace per hour. Many full scan because of updation.Both give me some problem either dead lock occurs or too many connection rise. Also insert/delete/replace operation takes long time. If i used innodb then dead lock …

I am emailing a field from a MySQL DB table. The field type is text. Basically, it is an accept email. How can I make it so the email sent is capable of emailing HTML to make the message more attractive? I have already tried to insert < html > …

I want to build a web application with MySQL database. When more users will visit my site, more database queries will be initiated and the response time will increase. - Is there a limitation for the number of users who can query MySQL? - What are the ways to handle …

hi i want to know how to fetch data by giving more than two condition...please tell me wat should i use eg i have a query [ICODE]SELECT * from post_resume WHERE ind_type='IT'and career='Engineering' order by tdate DESC[/ICODE] i want to check based on another condition also... [ICODE]select association from employer …

[code=mysql] $query = "INSERT INTO users (first_name, last_name, email, password, registration_date) VALUES ('$fn', '$ln', '$e', SHA('$p'), NOW() )"; [/code] What is the NOW() used for. Is it compulsory?

Hi everyone, I was trying to setup MySql with Cygwin so that i can create and work on databases using my Windows OS. After gruesome hours of googling, I am still confused as to how to do that. I first downloaded the installer for MySql on windows. I also downloaded …

Say you have 3 tables A (Key, a) B (Key, b) C (Key, c) How would you select say 10 from A ordered by a, from 50 from B ordered by b, from 100 from C ordered by c? All the keys represents the same thing. Thanks!

I have a need for a program better than Query Analyzer, I use Enterprise Manager on a daily basis for work purposes and have given the Query Analyzer program to our head person in charge of the front-end of the software, but they are now having a growing need to …

I am trying to insert a row into a table into a MySQL DB 5.0 table. One of the VALUES that I am inserting just so happens to be HTML code. When I execute the INSERT in MySQL Query Browser it tells me "You have an error in your SQL …

Well n not a mysql expert so i need help with this sql file here r d contents of it. Quote:[code] CREATE TABLE `admin` ( `id` int(11) NOT NULL auto_increment, `username` varchar(255), `password` varchar(255), `webmaster_email` varchar(255), `lastlogin` int(11), PRIMARY KEY (`id`) )"; "insert into admin set username='$admin_login',password='$admin_pass',web master_email='$admin_email'"; CREATE TABLE …