Jump to content

renesis

Members
  • Posts

    3
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

renesis's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Hi everybody! I was wondering how I could manage to make backups of my database daily. I obviously need a free tool. I have tried MySQL Administrator which seems to have all the functions that I need but the problem is that it runs in MySQL 4.0>. I use 3.23 and I don't want to upgrade. Is there any other tool for doing that? Please note that I needa tool that can take backups using scheduling (for instance it will run every day at 24.00). Many thanks!
  2. Thanks for the reply. When I try the first one, I get an error: You have an error in your SQL syntax near ' '', '', '', '')' When I try the second one I do not get eny errors but an empty entry is created (no value in "orders" table).
  3. Hi all. I'm new to this forum and hope to find the solution to my problem. What my problem is... I have created a web site in php-mysql-apache. It deals with online product orders. Assume there are 2 tables, "products" and "orders". Assume that a customer selects some products and pressing "checkout" button the list of the selected products appears. I need to capture the product details and insert them to the "orders" table but it fails. I use the following code: <?php mysql_connect("$host","$user","$pass"); mysql_select_db("$database"); mysql_query("insert into orders values (now(), '', '', '', item_code='$code_no', '', '', '', '')") or die(mysql_error()); ?> I explain: now() is the date today. item_code is the column in "orders" table and "code_no" is the column in "products" table. I use "" because at the moment I'm not interested in these columns. What I get from this code in the "orders" table is the correct date in the "order_date" column and a "1" in the "item_code" column. How did this "1" come from? Any obvious mistakes? Any proposal? Many thanks in advance.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.