Webmaster Forum / PHP / Database Access / February 2007

I am trying to do a backup of my database. After I tried with phpmyadmin and
it didn't work, I did the hard way with mysqldump. Then the import works.
On the import the database did not exist.
How do I have to do the same with phpmyadmin, because it is much more

I'm trying to install a php script that uses mysql. The problem is
that the php config file asks for my database password and I don't
have one because it's not required for the database. So now I'm
getting an error that all variables in the config php must have a

I've a huge number of records in one table and must retrieve them.
Every record has a datetime field and other values (mainly numerical
fields).
My goal is to retrieve min,max,average for every month. In fact I've to

I use php / mysql for keeping and generating simple lists. I can't for
the life of me echo out a URL.
Here are my examples:
echo "<td class = \"aptbody\" width = 15%>";

I am trying to collect info from a MSSQL DB and I am not even able to
get passed the connection.  I don't get any errors I just get a blank
page when I go to the site.
PHP is working, see attached phpinfo().  Any help is appreciated.

which one is the  best for use for performance and storage -
MEDIUMBLOB or MEDIUMTEXT?
thanxs

This is for MySQL 5.0
I took over some php/mysql code and I'm trying to optimize it if
possible.
I have one select statement on an indexed varchar field that gets built

Is there really any time when I don't want to run every _POST and _GET
through mysql_real_escape_string() before I use that data in accessing
the database?
In other words, is there a good reason why I shouldn't have a function

I have an mysql table.
For particular set of rows I want to swap two of the values.
So it would be something like
update exampletable set

I'm sure this can be done but not sure of the MSQL code
I want to run an update statement on a field where it adds
X to want ever is already in the field?
e.g.

CREATE TABLE coupons (
 id int(11) NOT NULL auto_increment,
 data longtext NOT NULL,
 display_coupon varchar(10) NOT NULL default '',

    This is a newbie question.  I am using a text for learning php/mysql.
I am using PHP 5.2.x and mysql 5.
The example is that of a mysql
database of jokes.  Before we get to joins there is a

wampserver 5 not allowing mySQL_Admin to show  service control and
startup variables
I' having problem
when loging on to MySQLAdministrator

I have two lines in my script on updating a set in a table. The lines are
$query="UPDATE TelefonEmail SET Haus=$haus, Handy=$handy WHERE Nr=$nr";
$dummy=mysql_query($query);
It does not update and I cannot find out why. I have done a

I've installed wamp 5 1.6.6.
for a testserver for learning php/mysql
it appears to be running
from the icon