Hello Marcjon,
do this:
SELECT forumusers.*, forumuserprofiles.* from
.$godlyness['database_database']..forumusers
LEFT JOIN .$godlyness['database_database']..forumuserprofiles ON
forumusers.username = forumusersprofiles.username where order
by
so.. if you do: where
I know this issue comes up alot, I've looked through the archives
looking for a solution, but none of them are what I want. I have two
tables with share a common coloumn, username. One is the user table.
It's used to store the user's password, username, email and so on. The
other table is for the
Yeah, I think I am going to reconsider the software
box. The idea I have now is to have an Add Expert
link attached to each software entry, which will then
load a page to add experts to that piece of software.
The page could contain two select boxes, one with a
list of all experts, and one with a
But how do I populate the array with (for e.g.) 2
fields from a mysql table. Each line of the select box
needs to hold the Name and Version of the piece of
software, the results from a:
select Name, Version from software
-s-
--- Corne' Cornelius [EMAIL PROTECTED] wrote:
You have to give the
I'm not sure if anyone answered this for you, and perhaps I'm missing
something. Are you simply trying to populate a multi-select box with
MySQL data?
If so, try this:
echo form tag here...
echo SELECT NAME=\software[]\ MULTIPLE SIZE=5;
$query=select ID, Name, Version from software;
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
You have to give 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
Hello guys
I need to pass multiple choices from multiple select lists.
I have -
select name = 'listbox1' multiple
option selected value = ''Select .../option
optionAP11/option
optionAP12/AP14/option
more options listed
/select
I can choose multiple items on the list, but only the last
:
Subject: [PHP-DB] Multiple
select
10/01/2002 12:46 PM
rename your select lists with array brackets at the end
'listbox1[]'
all of your values will be passed to the next page as an array
-Original Message-
From: Wilmar Perez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 01, 2002 12:47 PM
To: php-db mailing list
Subject: [PHP-DB
Hi All
I have a situation where I need to do select on my mysql db.
Here is what I am trying to do
Select * from table_name where col1=1 and col2=1 and col3=0
But this refuses to work.
If I change the above to this.
Select * from table_name where col1=1 OR col2=1 and col3=0
What I get is
On Thursday 01 August 2002 17:06, Dave Carrera wrote:
Hi All
I have a situation where I need to do select on my mysql db.
Here is what I am trying to do
Select * from table_name where col1=1 and col2=1 and col3=0
But this refuses to work.
How does it refuse to work? Any error messages?
Hi,
I make a SELECT in a mySQL database. It returns a variable, which contains
10 values. I then need to make another SELECT in a new database where I have
to use the previous 10 values in the WHERE sentence. How can I do this?
Regards,
Morten
--
PHP Database Mailing List
IN($srch);
$result = mysql_query($query) or die(Error: .mysql_error());
-Original Message-
From: Morten Nielsen [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 22, 2002 2:28 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Multiple SELECT querys
Hi,
I make a SELECT in a mySQL database. It returns
Hi,
I've got an HTML form which allows users to select various criteria to search for in
my database (MySQL).
The problem is that I can't seem to figure out how create the SELECT statement, given
the fact that they could choose any or none of the criteria.
Does anyone know of a way to
To: [EMAIL PROTECTED]
Subject: [PHP-DB] multiple select statements
Hi,
I've got an HTML form which allows users to select various
criteria to search for in my database (MySQL).
The problem is that I can't seem to figure out how create the
SELECT statement, given the fact
Hi everyone,
This is a php and mysql question...
I've spent days trying to figure this out and can only find help on one or
the other.. not both things that I'm trying to do.
I have a table called inventory which contains the following:
manufacturer
product
price
I have a php form that has a
In HTML:
SELECT name=manufacturernames[] multiple
(note the name has PHP-like array definition)
In PHP:
for ($i=0;$isizeOf($manufacturernames);$i++) {
if ($i==0) {
$q_cond=where;
} else {
$q_cond=or;
}
$query.=$q_cond MANUFACTURER LIKE '$manufacturernames[$i]';
}
Gisele Grenier
Bogdan Stancescu wrote:
In HTML:
SELECT name=manufacturernames[] multiple
(note the name has PHP-like array definition)
In PHP:
for ($i=0;$isizeOf($manufacturernames);$i++) {
if ($i==0) {
$q_cond=where;
} else {
$q_cond=or;
}
$query.=$q_cond MANUFACTURER LIKE
19 matches
Mail list logo