I writing a software catalog that features experts,
who a people especially skilled in a piece of
software. My db, has a software table and an
experts table.
I need to have a page that generates 2 multiple select
boxes, each on with the data from each table.
From there one will be able to choose
the Mutli select box a name as an
array. eg:
SELECT NAME=experts[] MULTIPLE SIZE=5
OPTION VALUE=key1val1/OPTION
/SELECT
then in PHP, you can access $experts as an array.
while (list ($key, $val) = each($experts)) {
print $key = $valBR\n;
}
Jason End wrote:
I writing a software
rather than an array,
and you could
remove the [] from the SELECT form element for the
software.
Please check all code, as it's off the top of my
head, and not
verified at all.
--- Jason End [EMAIL PROTECTED] wrote:
But how do I populate the array with (for e.g.) 2
fields from a mysql
I have a table that includes the ids of software
aplications and experts (apliexperts). My page is
loaded with the variable of the software id (softid),
which it uses to match the experts for that software.
But instead of returning just the expert id (expid),
to use that expid to get the full row
I'm looking for a mysql select statement that does the
following:
- Check if the value of each expert.id on the table
experts matches a value expt.id in the table
apliexpert.
- For those values where this is true check whether
the softID value for that row matches the variable
$softId.
- return
displayexpt.php?softID=$softID displays a checkbox
list of experts for a given piece of software. The
admin needs to select each user he wants to delete.
This is then posted to deleteexpt.php?softID=$softID,
which must delete users from the apliexpert table with
a statement like this:
DELETE FROM
to print it into the loop
so try first: echo $sql2br;
and you'll see that there is a mistake somewhere i
guess...
did you check hhow often he goes trhough the loop?
-Original Message-
From: Jason End [mailto:[EMAIL PROTECTED]
Sent: vrijdag 7 maart 2003 11:53
To: [EMAIL
I'm trying to interlace the results from a left-join
query with a regular select result. I have two tables:
Aplications and States (state as in: the states of
Florida and California). Each aplication in the
Aplications table contains a state_id, which matches
an id of a state in the States table.
Could someone point me to an example script using ldap
authentication but where logins are entered through a
form rather than an http pop-up challenge. I can only
find exmaples of the latter, and I'm not sure how to
keep the user logged in with the former.
thanks,
J
I have a form that includes two text areas that span
multiple rows. The first textarea (rows=2, cols=50) is
used to insert a pretty long url, while the second
(rows=5, cols=50) is used for inserting free text
(comments).
When I process the form to create the mysql insert
statement, the values
The type was already set to text.
The problem isn't at the mysql level but at the
form/php level. The insert statement that is formed
extracting the values from the form is only giving
that part of the url or comments.
Jay
--- Dan Brunner [EMAIL PROTECTED] wrote:
What is your field length???
2003 23:31:55 -0700 (PDT)
Jason End [EMAIL PROTECTED] wrote:
The type was already set to text.
The problem isn't at the mysql level but at the
form/php level. The insert statement that is
formed
extracting the values from the form is only giving
that part of the url or comments
writing in
the textar, cat_id = 1
Jay
--- Viorel Dragomir [EMAIL PROTECTED] wrote:
mysql_escape_string?
[try to print what kind of values do you receive in
post vars]
vio-
- Original Message -
From: Jason End [EMAIL PROTECTED]
To: George Patterson [EMAIL PROTECTED];
[EMAIL
= These are comments that I am writing in
the textar, cat_id = 1
Jay
--- Viorel Dragomir [EMAIL PROTECTED] wrote:
mysql_escape_string?
[try to print what kind of values do you receive in
post vars]
vio-
- Original Message -
From: Jason End [EMAIL PROTECTED]
To: George Patterson [EMAIL
14 matches
Mail list logo