arrays and mySQL querys

[Stephen Preston]

I can't get an $array[key] to be used as a select query on a mySQL database.

I have a 'parts list' which displays on a page (works fine) and is a form.
At the end of each row is a input type='text' (quantity) cell with a default
0

The quantity can be altered.
At the bottom of the table (form) is a submit to basket Button

echo "<form action='basket. php' method='POST'>\ n";
while ($row = mysql_fetch_arr ay($result))
extract($row);
echo "<tr>\n
<td WIDTH=10% align='middle'> <FONT SIZE=-1 face=Arial>$ite m</td>\n
<td WIDTH=25%><FONT SIZE=-1 face=Arial>&nbs p;$partNo</td>\n
<td WIDTH=50%><FONT SIZE=-1 face=Arial>&nbs p;$description</td>\n";
echo "<td WIDTH=5% align='center'> \n";
echo "<td WIDTH=10%> <input type='text' name='basket[$id]' value='0'
size='2'></td>\n";
echo "</tr>\n";
<tr>
<input type='submit' value='Add to basket'></form></td>\n";
</tr>

The table z350 contains columns headed

id (unique identifier numerical)
item
partNo
description

When some values have been entered in the quantity I submit.

*************** *************** *************

The 'basket' page displays. I have used the

echo "<pre>";
print_r ($_POST['basket']);
echo "</pre>";

To display the contents of the posted array.
It is shown below how it prints out. The Key refers to a line entry (id) in
the database.
The right hand entry is a quantity input by the user on the previous page.

Array
(
[63] => 5
[64] => 0
[65] => 6
[66] => 25
[67] => 0
)

The basket page needs to pull these requsted rows (id) from the database.

I have tried various combinations of MySQL queries but can't seem to get the
data into a $query.
$query = "SELECT * FROM z350 WHERE id=\"{$basket[id]}\"";
$result = mysql_query($qu ery)
or die ("Couldn't execute query.");

I beleive the state of play with the above is that the key is not being
looked at, its the value.
So how do I make the key into the values that will be used in the SQL query.

Ultimately my desire is to keep the Array in a session which will keep the
keys and as the users adds the 'id' and
the value (quantity ordered), but on request to view the basket the Key will
be used to get the partNo and description to display.
in a table (I feel confident I can do that part).

Thanks in antcipation

Stephen

[Steve]

I can't get an $array[key] to be used as a select query on a mySQL database. The basket page needs to pull these requsted rows (id) from the database. I have tried various combinations of MySQL queries but can't seem to get the
data into a $query.
$query = "SELECT * FROM z350 WHERE id=\"{$basket[id]}\"";
$result = mysql_query($qu ery)
or die ("Couldn't execute query.");

The form is fine, your array $basket is fine, the problem is your use
of $basket in the SQL statement. In the context of this statement what
does {$basket[id]} mean? Not what you think it means...

Depending on your requirements you can either fetch all the rows at
once or process each row individually.

All at once:

$query = 'SELECT * FROM z350 WHERE id IN ( ' . join( ',', $basket )
.. ')';
// process...

One at a time:

foreach( $basket AS $id )
{
$query = "SELECT * FROM z350 WHERE id = $id";
// process...
}

---
Steve

[Justin Koivisto]

Stephen Preston wrote:

I can't get an $array[key] to be used as a select query on a mySQL database.
<sni
To display the contents of the posted array.
It is shown below how it prints out. The Key refers to a line entry (id) in
the database.
The right hand entry is a quantity input by the user on the previous page.

Array
(
[63] => 5
[64] => 0
[65] => 6
[66] => 25
[67] => 0
)

The basket page needs to pull these requsted rows (id) from the database.

I have tried various combinations of MySQL queries but can't seem to get the
data into a $query.
$query = "SELECT * FROM z350 WHERE id=\"{$basket[id]}\"";
$result = mysql_query($qu ery)
or die ("Couldn't execute query.");

I beleive the state of play with the above is that the key is not being
looked at, its the value.
So how do I make the key into the values that will be used in the SQL query.

foreach($basket as $id=>$val){
$query = "SELECT * FROM z350 WHERE id='{$id}'";
...
}

HTH

--
Justin Koivisto, ZCE - ju****@koivi.co m
http://koivi.com

[Stephen Preston]

Thanks very much for that guys. I'd never have worked that out easily.
This is my first foray into any form of programming and started a few months
ago with PHP and MySQL for dummies, it was a good easy start, but even with
a few library books open on PHP and MySQL I have struggled with this (array)
interaction between php and mySQL.

Did you learn by just reading books or did you go on a course or study on
the net?

Is there any easy reference ie a book that gives an explaination (giving
hypothetical situations) of problems/queries and the code in laymans terms
for the php/mysql interaction.
I find the php and mysql reference assumes I know more of the basics, so
they are quite a hard read.

Thanks once again.
"Steve" <go********@nas tysoft.com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .

I can't get an $array[key] to be used as a select query on a mySQL
database.

The basket page needs to pull these requsted rows (id) from the database.

I have tried various combinations of MySQL queries but can't seem to get
the
data into a $query.
$query = "SELECT * FROM z350 WHERE id=\"{$basket[id]}\"";
$result = mysql_query($qu ery)
or die ("Couldn't execute query.");

The form is fine, your array $basket is fine, the problem is your use
of $basket in the SQL statement. In the context of this statement what
does {$basket[id]} mean? Not what you think it means...

Depending on your requirements you can either fetch all the rows at
once or process each row individually.

All at once:

$query = 'SELECT * FROM z350 WHERE id IN ( ' . join( ',', $basket )
. ')';
// process...

One at a time:

foreach( $basket AS $id )
{
$query = "SELECT * FROM z350 WHERE id = $id";
// process...
}

---
Steve