Webmaster Forum / PHP / Database Access / July 2005

I have two tables:
table A
Id. | id_result | value
1   |          1|      10

Hello Thanks for taking the time to look at this post.
What im trying to do
i have a table called
user with 4 fields id username jdate ref

Hello
Could somebody help me to resolve this problem?
I have a fist php script where I make a query on table.
In this script I display the selected query (table) by

i have a form with 5 fields. and my problem is that if user put 2 or more
same variables my script finds in db only 1 and i need to search all
variables in db even if they r same.
<http>

I have:
Table: articles
--------------
articleid

As questions about mysql seem to be generally accepted (see the answer which
I got in the other thread)
I am asking the following question.
I get this Warning:

Error: 1062 SQLSTATE: 23000 (ER_DUP_ENTRY)
Message: Duplicate entry '%s' for key %d
I get this message when I try to add a new line in the same table in the
same database (Mysql)

I am running fedora core 3 with mysql and apache 2 and php ver 4.3.9
All the applications seem to be working fine. When I run the test.php
containing
phpinfo() it post the information showing apache and mysql.

The following code grabs the url of a file location on the net from a db
on my server for a file download.
// connection to grab url of the file
mysql_select_db($database_local, $local);

Is mysql on topic in this NG?

I run a PHP/MySql point of sale system on RH9 server. The system backs up
via FTP at night to a remote server but I would like a more imeadiate
solution that can be switched over in case of failure (I will obviously
still keep doing the off site backups).

Is it possible to union more than two sql statements (I want to perform
a query on the union of 4 tables)?

<?php
print "<font face=\"Trebuchet MS\">";
$oldpwd = $_POST['stara'];
$newpwd1 = $_POST['nova1'];

I have 2 tables TABLE1 , TABLE2 with same structure.
TABLE1 one has ID 1-100000
TABLE2  has ID 100001-200000
How can I SELECT over both tables.