delete across multiple tables problem

I'm trying to help a friend with this. When I run this everything is fine SELECT * from clicks, urls WHERE clicks.url=urls.url AND urls.description IS NULL The clicks table has 31 instances of url that match 5 instances of url in the urls table. When I run the following I get a syntax error DEL

MySQL - PHP - Banner ad click through tracker

Does anyone here have a PHP script that will store banner ad click throughs in a MySQL database? If not, is anyone here interested in doing this project? Thanks Craig ><> [EMAIL PROTECTED] - Before posting, please check: h

MySQL counter for HIGH traffic site

I'm needing counter for site that receives 80 to 120 hits a minute at peak load. Many I have tried cause excessive server load and need to be deactivated or they lose data and return to zero without warning. All tried so far have been written in Perl writing to a file. Anyone here know of a count

MySQL - check for existing data

I have a db table that receives weather data several times a day via a php script and cron job. Sometimes the data is duplicated for a certain time window. 11:50 44 degree 11:50 44 degree 11:40 45 degree 11:30 46 degree 11:20 46 degree 11:10 45 degree I do not want the du

data from service into MySQL

I'm retrieving data from a data service. This is the ENTIRE source code of the URL they let me receive: RHAT 6.82 3/4/2002 3:59pm 0.32 6.59 6.99 6.53 932400 How can I insert the data values into fields in MySQL ? Thanks Craig ><> [EMAIL PROTECTED] -

mysql php - while loops

The following lists 12 items from a fruits table. $results = mysql_query("SELECT ID, date, appleprice, orangeprice, pearprice FROM fruits"); while ($data = mysql_fetch_array($results)) { ?> - - - <> [EMAIL PROTECTED] - Befo

RE: MySQL php - assigning date variables

SQL statement are: > What is proper way to define a variable to include all dates newer than > 1995-01-01? > $query = "???" select * from table where date > '1995-01-01' > What is proper way to define a variable to include all dates older than > 1995-01-01? > $query = "???" select * from table

MySQL php - assigning date variables

$query = "" mysql_query("SELECT * FROM table WHERE date LIKE '%". $query ."%'"); // returns all items in database $query = "2001-01-01" mysql_query("SELECT * FROM table WHERE date LIKE '%". $query ."%'"); // returns all rows that have 2001-01-01 as the date What is proper way to define a varia

Paul DuBois - Thank You

for the EXCELLENT index in your MySQL book. I developed several questions this morning and was able to find answers to all easily using the index in your book. Much appreciated. Craig ><> [EMAIL PROTECTED] - Before posting, pl

MySQL Load Data Infile

I have a table that has following fields id (auto increment) date appleprice orangeprice pearprice When I try to LOAD DATA INFILE with this file using comma as field delimiter and newline as end of row "2000-01-04","281.08","5.27","430.05" "2000-01-05","280.06","5.14","421.98" "2000-01-06","279

Connect question

Below is two scripts. The first one connects fine. The second gives the following error. Parse error: parse error in /usr/www/users/abc/connect.php on line 1 What is the problem with the second script? Thanks in advance - Craig #1 - Works --- Our List of J

MS Excel to MySQL upload macro?

I have data I create daily in MS Excel. I need to insert this data into MySQL data base on my web server every night. Does anyone here have a VB technique to upload to MySQL from Excel via a macro? Thanks Craig ><> [EMAIL PROTECTED]