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

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:

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

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

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: symbolRHAT/symbol price6.82/price date3/4/2002/date time3:59pm/time change0.32/change change_percent/change_percent open6.59/open high6.99/high low6.53/low volume932400/volume How can I

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)) { ? p?=$data[date]? - ?=$data[appleprice]? - ?=$data[orangeprice]? - ?=$data[pearprice]?/p ? } How would I

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,

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 variable to

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 where

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.99,5.13,408.59

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 --- HTML HEAD TITLE

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]