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: wh
On Monday 12 July 2004 10:31, Marcjon wrote:
> Oh yeah, I tried doing a
> WHERE forumusers.username=forumuserprofiles.username
> It worked, but if I added a AND forumusers.username = 'search string
> here' it didn't return anything.
This should work if your 'search string here' *exactly* matches
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 u
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
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 "";
$query="select ID, Name, Version from software";
$result=mysql_query($query) or die("Could not quer
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 M
You have to give the Mutli select box a name as an array. eg:
val1
then in PHP, you can access $experts as an array.
while (list ($key, $val) = each($experts)) {
print "$key = $val\n";
}
Jason End wrote:
I writing a software catalog that features "experts",
who a people especially skill
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
g list
> Subject: [PHP-DB] Multiple select
>
>
> Hello guys
>
> I need to pass multiple choices from multiple select lists.
> I have -
>
> Select ...
> AP11
> AP12/AP14
>
>
>
> I can choose multiple items on the list, but only the last
>
edu.co>cc:
Subject: [PHP-DB] Multiple
select
Hello guys
I need to pass multiple choices from multiple select lists.
I have -
Select ...
AP11
AP12/AP14
I can choose multiple items on the list, but only the last item chosen will
be carried over to the final form page.
How do I get I get it too carry multiple items?
Thanks a lo
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 mess
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 all
quot;'Morten Nielsen'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, March 22, 2002 12:53 PM
Subject: RE: [PHP-DB] Multiple SELECT querys
> $query = "SELECT myvalue FROM mytable WHERE some_condition";
> $result = mysql_query($query) or die("E
query = "SELECT * FROM other_table WHERE this_val 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] Multi
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 (http://www.php.net
rse you may want to add checks on what was entered or build a
mechanism so that you don't necessarily join all the filters with 'OR'. But,
I think you get the idea. Hope it helps.
Court
> -Original Message-
> From: Geoffrey Makstutis [mailto:[EMAIL PROTECTED]]
>
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 dynam
Bogdan Stancescu wrote:
> In HTML:
>
> (note the name has PHP-like array definition)
>
> In PHP:
> for ($i=0;$i if ($i==0) {
> $q_cond="where";
> } else {
> $q_cond="or";
> }
> $query.="$q_cond MANUFACTURER LIKE '$manufacturernames[$i]' ";
>
> }
You'll have to add another space
In HTML:
(note the name has PHP-like array definition)
In PHP:
for ($i=0;$i 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
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
21 matches
Mail list logo
