MySQL

Hello, I am looking for a way to parse out certain characters when I write a select statement to an outfile. I know how to escape the characters w/ the escaped by clause, but I need to parse off some double quotes and some backslashes. I'm cur

Hi, I am a newbie, this is my first post (please go easy). Iam at the moment trying to set up a query for someone looking for a property on an estate agents website. From a drop down menu, the user can: select an area (where they may like to live)

Hello, I have this query that worked on MySQL version 4.1.20, but when I moved to 5.0.22, the query bombs. SELECT DISTINCT id,users.user_login as username, meta_first.meta_value as firstname, meta_last.meta_value as lastname,

Hello all, I am new to mySQL, php etc as of the last few weeks and this is my first post (probably of many :))... All my files are running through the WAMP stack, which includs Apache, myQL, Php and phpMyAdmin. I have also got PEAR up and running,

I am a newbie who is creating a database using wamp. I have managed to create insert and display front-ends that each work fine for text fields. However, I would like to be able to send the contents of a plugin to mysql (as a blob) using php, or to put it

I'm working on an application that someone else wrote (using PHP and MySQL). There are LOTS of queries that make changes to different tables with joins and it's really hard to track down what's been done to the data after running the code. I've been

I have a site that I am building. I am hand coding some and using Dreamweaver 8 some. I hand coded a photo gallery with paging. On my testing server it works great. On the production server is gives me a 1045 Access Denied message. I don't get it. The

Hi all, I created a userlogin form where it will lead to either an administrator home page or user home page. In MySQL database, i create a table named "Login" where it contains the following: CREATE TABLE Login ( access_level INT NOT NULL,

I have a set of 2 drop downs. Once a selection is made in the first one, the second one popluates based on the first choice...I also have a a dynamic table on my page that works fine but shows every record from what ever recordset it is based on....here i

Looking for a simple script just work out the database connections and query/write from the table.

Hi, We are facing dependencies error when we try to install MySQL RPM's in fedora core 6. The Error message displayed is: warning:mysql-server-5.0.27-1.fc6.i386.rpm:Header v3 DSA signature:NOKEY,key Id4f2a6fd2 error:failed dependecies: perl(DB

Hi All, I've encountered a problem which i find for answers but to no avail and i hope you all can help. I've got 4 tables namely, User_Login, Admin_Login, Projects and Mapping. User_Login -user_id (PK) INTEGER NOT NULL AUTO INCREMENT -user_us

is this how you write the update trigger so the table automatically updates [code:1:6170638478]create trigger updater begin update items,sales set items.number_on_hand = items.number_on_hand - sales.number_sold where Item_id = sales.Sales_id; end[/c

Hello guys, I am in need for some one on one help with a personal project. Their is no profit or gain for me, just knowledge and usefullness for me and my close freinds for my fantasy football league. What, I want to do is create a database, so I can

<?php /* Created on: 2/9/2008 */ //the code starts here // we then will connect to the database as the user specified mysql_connect("$nil","$nil","$nil") // now if we cannot connect to the database then this me

[b:afde3b34ed]Hello.[/b:afde3b34ed] Ive just rgistered in this site, honestly its really great and helpfull, in meanwhile iam coding a php script that will enter a form post into MYSQL table predefined fields in a way of the following: Post date:

Hi, I use mysql4.0.24. Date is stored as string('15/01/2008') in mysql table.Now i want to filter the records based on the date column using <,> and between operatoes.But i am unable to do it.How can i convert the date column from string data typ

Hello - I am trying to integrate a PayPal cart into a client's website. The order of operations for the integration is: 1. Website sends client to Paypal to complete the transaction. 2. Paypal sends back transaction ID (via GET) and specified retu

Hello. I currently am working on developing an application. For reference, the related mysql tables look like this (slimmed down to applicable fields): `users` --------------------------------------- `id` int unsigned `privacy` enum('EVERYONE','FRIE

Hi I am using CENTOS 4. During the installation of MySQL Client community package, I find this problem, [b:9df5a78e44]rpm -i MySQL-client-community-5.0.45-0.rhel4.i386.rpm warning: MySQL-client-community-5.0.45-0.rhel4.i386.rpm: V3 DSA signature: NOKE