Webmaster Forum / PHP / Database Access / December 2006

I know PHP but need to learn CakePHP right away.  Where's the best
documentation?
Looking for a consultant to help via phone, email or chat.
p h p b a b y 3 AT a o l DOT c o m

I have use DW making a PHP site and has set a multiple selection
field..But I don't know how to write the SQL statement to database like
<select name="support[]" size="3" multiple="multiple"  id="support">
             <option value="1">Apple</option>

.
The UK charity I periodically give IT support to has a database with a
client table which currently contains some 600 records but will soon
contain over 10,000.

I'm examining someone else's code and can't seem to find an answer on
the Internet regarding a parameter he's using
@useraccount["membership"].  What is the @ symbol for?

I was wondering if it is possible to load the values of a ENUM out of
antoher table.
Example:
Table 1

if ((isset($_POST["insert"])) && ($_POST["insert"] == "form_insert"))
{
  $query=mysql_query("INSERT INTO dates (userInfo,regDate) values(
'$userInfo','$date' )");

I am noob, stuck here. I took this frag from the docs:
    <?php
    $link = mysql_connect('localhost', 'clb', 'secret');
    if (!$link) {

I'd like to write a simple select query. In a particular 1000-row db I
have one column (field) where many of the rows (records) have the same
entry. I'd like to write a query that returns all the different entries
in that column, but each one only once.

I have a MySql database in which I have 2  columns of which I want to
make a list of all the distinct values from both columns. The 2nd
column can be empty if the first one is filled in ; if the 1st column
is filled in, then the 2nd column is by default also empty.Also the

I am doing a compound lookup by deriving person_id values for a query
from various tables by selecting arrays of person_id values that meet
my criteria from those tables.  I am ending up with a query whose logic
would be something like:

I have phpmyadmin installed and I can access it and the databases.
I don't see an "Import" function.
I do see "Export".
What am I missing?

I have a domain, call it www.domain.com.  I have a mysql database that
I created that I would like to add records to using an html form.
1.  where do I put the php script that takes the fields of the form,
and adds it to the database? The fields (firstname, lastname, etc) are

I'm totally new to PHP and MySQL. I'm using a quick start guide to make
a little blog. I get:
"You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use

How to update multiple values ?
e.g.
UPDATE user SET  name='$name' WHERE id='$id' "
This will update just one field.

How to upload picture to local ( or remote ) mysql table field ?
Photos are under 1 MB and i need to put them into db and then pull them out
for displaying.
Thank you !