Webmaster Forum / PHP / Database Access / October 2007

I don't get it, when i use the code below I get a "Query empty", however
when I enter the myql statement in phpmyadmin i get the result i want...
what am i doing worng?
$msyql = "SELECT DATE_FORMAT(d_date, '%M %e, %Y') as date FROM `pages`

First off what I'm trying to do is export my mysql database to a file on my
server, preferably with an option of emailing it in compressed format. I've
tried quite a few mysql database backup programs, all of which work on a
small test database but all fail when trying to export an ...

I have converted a xml-file to mysql with Navicat but the problem with the
xml-file was that the end of line code wasn't changed before I used Navaicat
so I had to look for it manually and change it in there but in Firebug I
still saw this code \r\n.

I'm a newbie to sql, and i'm having problems importing tables that i have
exported from another databases.
The problem is that i cannot export the db dump, instead i just the chance
to export table by table through the hosting control pannel.

First off sorry if this is a long posting but I need to give all the facts
in the hope to get an answer. 2 Years ago I did a site for a client to track
online orders and run reports. One of the main reports is now going so slow
it's of no use to anybody.

I need to find out whos birthdays land today. The DOB is stored in a
standard Unix timestamp. I'm trying to use the following but it throws up a
syntax error.
SELECT numberx FROM member WHERE date('d m',dob)=date('d m',time())

I have an admin page where auth'd users upload a csv file for
insertion of email addresses into a unique field in a mySQL DB.
Using "INSERT IGNORE" how do I track the occurence of an ignore?
I'd like to print a message saying something like "X email addresses

I hope someone can help me with this... :)
I am again moving a site to another server and I am again amazed how low the
script limitations are (upload file size), how cr***y the consoles are and
how unnerving the whole process is. It has taken me 3 hours just to move

I've got a few different tables that track video game consoles people
use in their profile. The tables are below. I'm trying to do two
counts/sorts and display them properly.
(1) sort the fields by country

I have a problem - I need to select fields from two tables, where
field form table1 contains text + table2.id + text.
I have table reservations which has clients field. clients contains
client's id (taken from table2) with client's options. It's syntax is