[PHP-DB] Re: Problems with INNER JOIN

2009-01-29 Thread Martin Zvarík

This will work:

$sql = 
SELECT admin.AdminID, workorders.WHAT_YOU_WANT
FROM admin
INNER JOIN workorders ON admin.AdminID=workorders.AdminID
HAVING admin.username='.$_SESSION['user'].'
;


Terion Miller napsal(a):

Hi Everyone! I am having problems getting an INNER JOIN to work and need
some tips trouble shooting where the problem may be.

What I'm trying to do is match up AdminID's from two tables and display only
that users orders, sounds simple enough right...but I can't get it to return
the AdminID...

My Query:

   $sql =
 SELECT admin.AdminID , workorders.AdminID
 FROM admin
 INNER JOIN
 workorders ON
  (admin.AdminID=workorders.AdminID)
 WHERE admin.UserName =   '.$_SESSION['user'].' ;


  $result = mysql_query ($sql);
  $row = mysql_fetch_assoc ($result);
  $Total = ceil(mysql_num_rows($result)/$PerPage);

Thanks for any tips on how else I can accomplish this...
Terion



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] Re: Problems with INNER JOIN

2009-01-29 Thread Terion Miller
Thanks Martin, oddly enough that still doesn't pull any results, it won't
even print the variables if I try to list them to see, I know my db
connection is good checked that, and can do really simple queries, would
something be preventing a JOIN from working?
When I Reveal my variables this query snippet:
$sql = SELECT admin.AdminID, workorders.WorkOrderID
FROM admin
INNER JOIN workorders ON admin.AdminID=workorders.AdminID
HAVING admin.username='.$_SESSION['user'].' ;



  $result2 = mysql_query ($sql);
  $row2 = mysql_fetch_assoc ($result2);
  $Total = ceil(mysql_num_rows($result2)/$PerPage);

Returns this:
$sqlSELECT admin.AdminID, workorders.WorkOrderID FROM admin INNER JOIN
workorders ON admin.AdminID=workorders.AdminID HAVING
admin.username='tmiller' $result2$row2

Terion

On Thu, Jan 29, 2009 at 11:56 AM, Martin Zvarík mzva...@gmail.com wrote:

 This will work:

 $sql = 
 SELECT admin.AdminID, workorders.WHAT_YOU_WANT
 FROM admin
 INNER JOIN workorders ON admin.AdminID=workorders.AdminID
 HAVING admin.username='.$_SESSION['user'].'
 ;


 Terion Miller napsal(a):

  Hi Everyone! I am having problems getting an INNER JOIN to work and need
 some tips trouble shooting where the problem may be.

 What I'm trying to do is match up AdminID's from two tables and display
 only
 that users orders, sounds simple enough right...but I can't get it to
 return
 the AdminID...

 My Query:

   $sql =
 SELECT admin.AdminID , workorders.AdminID
 FROM admin
 INNER JOIN
 workorders ON
  (admin.AdminID=workorders.AdminID)
 WHERE admin.UserName =   '.$_SESSION['user'].' ;


  $result = mysql_query ($sql);
  $row = mysql_fetch_assoc ($result);
  $Total = ceil(mysql_num_rows($result)/$PerPage);

 Thanks for any tips on how else I can accomplish this...
 Terion


 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] Re: Problems with INNER JOIN

2009-01-29 Thread Martin Zvarík

What I wrote with HAVING doesn't do any difference - replace back to WHERE.

Your query is OK.

Try: echo mysql_error();

And try to remove the condition WHERE admin.user... if that outputs 
anything.


Martin


Terion Miller napsal(a):

Thanks Martin, oddly enough that still doesn't pull any results, it won't
even print the variables if I try to list them to see, I know my db
connection is good checked that, and can do really simple queries, would
something be preventing a JOIN from working?
When I Reveal my variables this query snippet:
$sql = SELECT admin.AdminID, workorders.WorkOrderID
FROM admin
INNER JOIN workorders ON admin.AdminID=workorders.AdminID
HAVING admin.username='.$_SESSION['user'].' ;



  $result2 = mysql_query ($sql);
  $row2 = mysql_fetch_assoc ($result2);
  $Total = ceil(mysql_num_rows($result2)/$PerPage);

Returns this:
$sqlSELECT admin.AdminID, workorders.WorkOrderID FROM admin INNER JOIN
workorders ON admin.AdminID=workorders.AdminID HAVING
admin.username='tmiller' $result2$row2

Terion

On Thu, Jan 29, 2009 at 11:56 AM, Martin Zvarík mzva...@gmail.com wrote:


This will work:

$sql = 
SELECT admin.AdminID, workorders.WHAT_YOU_WANT
FROM admin
INNER JOIN workorders ON admin.AdminID=workorders.AdminID
HAVING admin.username='.$_SESSION['user'].'
;


Terion Miller napsal(a):

 Hi Everyone! I am having problems getting an INNER JOIN to work and need

some tips trouble shooting where the problem may be.

What I'm trying to do is match up AdminID's from two tables and display
only
that users orders, sounds simple enough right...but I can't get it to
return
the AdminID...

My Query:

  $sql =
SELECT admin.AdminID , workorders.AdminID
FROM admin
INNER JOIN
workorders ON
 (admin.AdminID=workorders.AdminID)
WHERE admin.UserName =   '.$_SESSION['user'].' ;


 $result = mysql_query ($sql);
 $row = mysql_fetch_assoc ($result);
 $Total = ceil(mysql_num_rows($result)/$PerPage);

Thanks for any tips on how else I can accomplish this...
Terion



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php






--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] Re: Problems with INNER JOIN

2009-01-29 Thread Terion Miller
When I removed the WHERE admin.user... part it did return something, granted
it returned one adminID and one order (which did belong together) but the
adminID was not mine so I don't know how it picked that one randomly ...is
there a way to do what I need using two queries one to find out the users ID
then another to pull the workorders with that id? Can't believe this is
proving so hard..
Thanks for helping!
Terion



On Thu, Jan 29, 2009 at 12:55 PM, Martin Zvarík mzva...@gmail.com wrote:

 What I wrote with HAVING doesn't do any difference - replace back to WHERE.

 Your query is OK.

 Try: echo mysql_error();

 And try to remove the condition WHERE admin.user... if that outputs
 anything.

 Martin


 Terion Miller napsal(a):

 Thanks Martin, oddly enough that still doesn't pull any results, it won't

 even print the variables if I try to list them to see, I know my db
 connection is good checked that, and can do really simple queries, would
 something be preventing a JOIN from working?
 When I Reveal my variables this query snippet:
$sql = SELECT admin.AdminID, workorders.WorkOrderID
 FROM admin
 INNER JOIN workorders ON admin.AdminID=workorders.AdminID
 HAVING admin.username='.$_SESSION['user'].' ;



  $result2 = mysql_query ($sql);
  $row2 = mysql_fetch_assoc ($result2);
  $Total = ceil(mysql_num_rows($result2)/$PerPage);

 Returns this:
 $sqlSELECT admin.AdminID, workorders.WorkOrderID FROM admin INNER JOIN
 workorders ON admin.AdminID=workorders.AdminID HAVING
 admin.username='tmiller' $result2$row2

 Terion

 On Thu, Jan 29, 2009 at 11:56 AM, Martin Zvarík mzva...@gmail.com
 wrote:

  This will work:

 $sql = 
 SELECT admin.AdminID, workorders.WHAT_YOU_WANT
 FROM admin
 INNER JOIN workorders ON admin.AdminID=workorders.AdminID
 HAVING admin.username='.$_SESSION['user'].'
 ;


 Terion Miller napsal(a):

  Hi Everyone! I am having problems getting an INNER JOIN to work and need

 some tips trouble shooting where the problem may be.

 What I'm trying to do is match up AdminID's from two tables and display
 only
 that users orders, sounds simple enough right...but I can't get it to
 return
 the AdminID...

 My Query:

  $sql =
SELECT admin.AdminID , workorders.AdminID
FROM admin
INNER JOIN
workorders ON
 (admin.AdminID=workorders.AdminID)
WHERE admin.UserName =   '.$_SESSION['user'].' ;


 $result = mysql_query ($sql);
 $row = mysql_fetch_assoc ($result);
 $Total = ceil(mysql_num_rows($result)/$PerPage);

 Thanks for any tips on how else I can accomplish this...
 Terion


  --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php




 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] Re: Problems with INNER JOIN

2009-01-29 Thread Martin Zvarík
Are you sure you have MORE than ONE [order + admin that belongs 
together] in those tables?


Now, turn on your brain and don't wait for my instructions, you already 
know what to do... test test test




Terion Miller napsal(a):
When I removed the WHERE admin.user... part it did return something, 
granted it returned one adminID and one order (which did belong 
together) but the adminID was not mine so I don't know how it picked 
that one randomly ...is there a way to do what I need using two 
queries one to find out the users ID then another to pull the 
workorders with that id? Can't believe this is proving so hard..

Thanks for helping!
Terion



On Thu, Jan 29, 2009 at 12:55 PM, Martin Zvarík mzva...@gmail.com 
mailto:mzva...@gmail.com wrote:


What I wrote with HAVING doesn't do any difference - replace back
to WHERE.

Your query is OK.

Try: echo mysql_error();

And try to remove the condition WHERE admin.user... if that
outputs anything.

Martin


Terion Miller napsal(a):

Thanks Martin, oddly enough that still doesn't pull any
results, it won't

even print the variables if I try to list them to see, I know
my db
connection is good checked that, and can do really simple
queries, would
something be preventing a JOIN from working?
When I Reveal my variables this query snippet:
   $sql = SELECT admin.AdminID, workorders.WorkOrderID
FROM admin
INNER JOIN workorders ON admin.AdminID=workorders.AdminID
HAVING admin.username='.$_SESSION['user'].' ;



 $result2 = mysql_query ($sql);
 $row2 = mysql_fetch_assoc ($result2);
 $Total = ceil(mysql_num_rows($result2)/$PerPage);

Returns this:
$sqlSELECT admin.AdminID, workorders.WorkOrderID FROM admin
INNER JOIN
workorders ON admin.AdminID=workorders.AdminID HAVING
admin.username='tmiller' $result2$row2

Terion

On Thu, Jan 29, 2009 at 11:56 AM, Martin Zvarík
mzva...@gmail.com mailto:mzva...@gmail.com wrote:

This will work:

$sql = 
SELECT admin.AdminID, workorders.WHAT_YOU_WANT
FROM admin
INNER JOIN workorders ON admin.AdminID=workorders.AdminID
HAVING admin.username='.$_SESSION['user'].'
;


Terion Miller napsal(a):

 Hi Everyone! I am having problems getting an INNER JOIN
to work and need

some tips trouble shooting where the problem may be.

What I'm trying to do is match up AdminID's from two
tables and display
only
that users orders, sounds simple enough right...but I
can't get it to
return
the AdminID...

My Query:

 $sql =
   SELECT admin.AdminID , workorders.AdminID
   FROM admin
   INNER JOIN
   workorders ON
(admin.AdminID=workorders.AdminID)
   WHERE admin.UserName =   '.$_SESSION['user'].' ;


$result = mysql_query ($sql);
$row = mysql_fetch_assoc ($result);
$Total = ceil(mysql_num_rows($result)/$PerPage);

Thanks for any tips on how else I can accomplish this...
Terion


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP Database Mailing List (http://www.php.net/)

To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] Re: Problems with INNER JOIN

2009-01-29 Thread danaketh
Try that query in console or use Navicat/phpMyAdmin to run it. Remove 
the HAVING part to see if the SELECT returns what you need.


Terion Miller napsal(a):

Thanks Martin, oddly enough that still doesn't pull any results, it won't
even print the variables if I try to list them to see, I know my db
connection is good checked that, and can do really simple queries, would
something be preventing a JOIN from working?
When I Reveal my variables this query snippet:
$sql = SELECT admin.AdminID, workorders.WorkOrderID
FROM admin
INNER JOIN workorders ON admin.AdminID=workorders.AdminID
HAVING admin.username='.$_SESSION['user'].' ;



  $result2 = mysql_query ($sql);
  $row2 = mysql_fetch_assoc ($result2);
  $Total = ceil(mysql_num_rows($result2)/$PerPage);

Returns this:
$sqlSELECT admin.AdminID, workorders.WorkOrderID FROM admin INNER JOIN
workorders ON admin.AdminID=workorders.AdminID HAVING
admin.username='tmiller' $result2$row2

Terion

On Thu, Jan 29, 2009 at 11:56 AM, Martin Zvarík mzva...@gmail.com wrote:

  

This will work:

$sql = 
SELECT admin.AdminID, workorders.WHAT_YOU_WANT
FROM admin
INNER JOIN workorders ON admin.AdminID=workorders.AdminID
HAVING admin.username='.$_SESSION['user'].'
;


Terion Miller napsal(a):

 Hi Everyone! I am having problems getting an INNER JOIN to work and need


some tips trouble shooting where the problem may be.

What I'm trying to do is match up AdminID's from two tables and display
only
that users orders, sounds simple enough right...but I can't get it to
return
the AdminID...

My Query:

  $sql =
SELECT admin.AdminID , workorders.AdminID
FROM admin
INNER JOIN
workorders ON
 (admin.AdminID=workorders.AdminID)
WHERE admin.UserName =   '.$_SESSION['user'].' ;


 $result = mysql_query ($sql);
 $row = mysql_fetch_assoc ($result);
 $Total = ceil(mysql_num_rows($result)/$PerPage);

Thanks for any tips on how else I can accomplish this...
Terion


  

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php





  


--

S pozdravem

Daniel Tlach
Freelance webdeveloper

Email: m...@danaketh.com
ICQ: 160914875
MSN: danak...@hotmail.com
Jabber: danak...@jabbim.cz



Re: [PHP-DB] Re: Problems with INNER JOIN

2009-01-29 Thread Terion Miller
Yes I've already done that and checked the db etc and I've turned my brain
ON hours ago, I came to the list because I'm stumped and have tried all
manners of different ways to tell mySql

if admin ID = session user then get workorders where orderID = admin ID





On Thu, Jan 29, 2009 at 1:28 PM, Martin Zvarík mzva...@gmail.com wrote:

  Are you sure you have MORE than ONE [order + admin that belongs together]
 in those tables?

 Now, turn on your brain and don't wait for my instructions, you already
 know what to do... test test test



 Terion Miller napsal(a):

 When I removed the WHERE admin.user... part it did return something,
 granted it returned one adminID and one order (which did belong together)
 but the adminID was not mine so I don't know how it picked that one randomly
 ...is there a way to do what I need using two queries one to find out the
 users ID then another to pull the workorders with that id? Can't believe
 this is proving so hard..
 Thanks for helping!
 Terion



 On Thu, Jan 29, 2009 at 12:55 PM, Martin Zvarík mzva...@gmail.com wrote:

 What I wrote with HAVING doesn't do any difference - replace back to
 WHERE.

 Your query is OK.

 Try: echo mysql_error();

 And try to remove the condition WHERE admin.user... if that outputs
 anything.

 Martin


 Terion Miller napsal(a):

 Thanks Martin, oddly enough that still doesn't pull any results, it won't

 even print the variables if I try to list them to see, I know my db
 connection is good checked that, and can do really simple queries, would
 something be preventing a JOIN from working?
 When I Reveal my variables this query snippet:
$sql = SELECT admin.AdminID, workorders.WorkOrderID
 FROM admin
 INNER JOIN workorders ON admin.AdminID=workorders.AdminID
 HAVING admin.username='.$_SESSION['user'].' ;



  $result2 = mysql_query ($sql);
  $row2 = mysql_fetch_assoc ($result2);
  $Total = ceil(mysql_num_rows($result2)/$PerPage);

 Returns this:
 $sqlSELECT admin.AdminID, workorders.WorkOrderID FROM admin INNER JOIN
 workorders ON admin.AdminID=workorders.AdminID HAVING
 admin.username='tmiller' $result2$row2

 Terion

 On Thu, Jan 29, 2009 at 11:56 AM, Martin Zvarík mzva...@gmail.com
 wrote:

  This will work:

 $sql = 
 SELECT admin.AdminID, workorders.WHAT_YOU_WANT
 FROM admin
 INNER JOIN workorders ON admin.AdminID=workorders.AdminID
 HAVING admin.username='.$_SESSION['user'].'
 ;


 Terion Miller napsal(a):

  Hi Everyone! I am having problems getting an INNER JOIN to work and
 need

 some tips trouble shooting where the problem may be.

 What I'm trying to do is match up AdminID's from two tables and display
 only
 that users orders, sounds simple enough right...but I can't get it to
 return
 the AdminID...

 My Query:

  $sql =
SELECT admin.AdminID , workorders.AdminID
FROM admin
INNER JOIN
workorders ON
 (admin.AdminID=workorders.AdminID)
WHERE admin.UserName =   '.$_SESSION['user'].' ;


 $result = mysql_query ($sql);
 $row = mysql_fetch_assoc ($result);
 $Total = ceil(mysql_num_rows($result)/$PerPage);

 Thanks for any tips on how else I can accomplish this...
 Terion


  --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php




 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php





Re: [PHP-DB] Re: Problems with INNER JOIN

2009-01-29 Thread Martin Zvarík

SELECT adminID FROM admin WHERE username= $username 

$adminid = mysql_fetch_row ...

SELECT * FROM workorders WHERE adminid = $adminid



Terion Miller napsal(a):
Yes I've already done that and checked the db etc and I've turned my 
brain ON hours ago, I came to the list because I'm stumped and have 
tried all manners of different ways to tell mySql


if admin ID = session user then get workorders where orderID = admin ID





On Thu, Jan 29, 2009 at 1:28 PM, Martin Zvarík mzva...@gmail.com 
mailto:mzva...@gmail.com wrote:


Are you sure you have MORE than ONE [order + admin that belongs
together] in those tables?

Now, turn on your brain and don't wait for my instructions, you
already know what to do... test test test



Terion Miller napsal(a):

When I removed the WHERE admin.user... part it did return
something, granted it returned one adminID and one order (which
did belong together) but the adminID was not mine so I don't know
how it picked that one randomly ...is there a way to do what I
need using two queries one to find out the users ID then another
to pull the workorders with that id? Can't believe this is
proving so hard..
Thanks for helping!
Terion



On Thu, Jan 29, 2009 at 12:55 PM, Martin Zvarík
mzva...@gmail.com mailto:mzva...@gmail.com wrote:

What I wrote with HAVING doesn't do any difference - replace
back to WHERE.

Your query is OK.

Try: echo mysql_error();

And try to remove the condition WHERE admin.user... if that
outputs anything.

Martin


Terion Miller napsal(a):

Thanks Martin, oddly enough that still doesn't pull any
results, it won't

even print the variables if I try to list them to see, I
know my db
connection is good checked that, and can do really simple
queries, would
something be preventing a JOIN from working?
When I Reveal my variables this query snippet:
   $sql = SELECT admin.AdminID, workorders.WorkOrderID
FROM admin
INNER JOIN workorders ON admin.AdminID=workorders.AdminID
HAVING admin.username='.$_SESSION['user'].' ;



 $result2 = mysql_query ($sql);
 $row2 = mysql_fetch_assoc ($result2);
 $Total = ceil(mysql_num_rows($result2)/$PerPage);

Returns this:
$sqlSELECT admin.AdminID, workorders.WorkOrderID FROM
admin INNER JOIN
workorders ON admin.AdminID=workorders.AdminID HAVING
admin.username='tmiller' $result2$row2

Terion

On Thu, Jan 29, 2009 at 11:56 AM, Martin Zvarík
mzva...@gmail.com mailto:mzva...@gmail.com wrote:

This will work:

$sql = 
SELECT admin.AdminID, workorders.WHAT_YOU_WANT
FROM admin
INNER JOIN workorders ON admin.AdminID=workorders.AdminID
HAVING admin.username='.$_SESSION['user'].'
;


Terion Miller napsal(a):

 Hi Everyone! I am having problems getting an INNER
JOIN to work and need

some tips trouble shooting where the problem may be.

What I'm trying to do is match up AdminID's from
two tables and display
only
that users orders, sounds simple enough
right...but I can't get it to
return
the AdminID...

My Query:

 $sql =
   SELECT admin.AdminID , workorders.AdminID
   FROM admin
   INNER JOIN
   workorders ON
(admin.AdminID=workorders.AdminID)
   WHERE admin.UserName =  
'.$_SESSION['user'].' ;



$result = mysql_query ($sql);
$row = mysql_fetch_assoc ($result);
$Total = ceil(mysql_num_rows($result)/$PerPage);

Thanks for any tips on how else I can accomplish
this...
Terion


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP Database Mailing List (http://www.php.net/)

To unsubscribe, visit: http://www.php.net/unsub.php






Re: [PHP-DB] Re: Problems with INNER JOIN

2009-01-29 Thread Chris

Martin Zvarík wrote:

This will work:

$sql = 
SELECT admin.AdminID, workorders.WHAT_YOU_WANT
FROM admin
INNER JOIN workorders ON admin.AdminID=workorders.AdminID
HAVING admin.username='.$_SESSION['user'].'
;


Don't use having in this case - this should be a 'where' clause.

A 'having' clause is processed AFTER everything else (after where, after 
joins, after aggregate's are calculated like sum/max/min), using it like 
this will cause performance issues where you shouldn't have any.


--
Postgresql  php tutorials
http://www.designmagick.com/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] Re: Problems with INNER JOIN

2009-01-29 Thread Terion Miller
Actually I have tried EVERYTHING suggested and it just does not work, in my
last query here I put in a user I know has orders and still nothing :

$sql3 = SELECT admin.AdminID, workorders.WorkOrderID,
workorders.DATE_FORMAT(CreatedDate,'%m/%e/%y') AS SubmitDate,
workorders.Location, workorders.AdminID, workorders.FormName,
workorders.Status FROM admin INNER JOIN workorders  ON admin.AdminID =
workorders.AdminID WHERE admin.username = 'lhanford' ;

Are there mySQL settings that could prevent JOINS?


On Thu, Jan 29, 2009 at 3:44 PM, Chris dmag...@gmail.com wrote:

 Martin Zvarík wrote:

 This will work:

 $sql = 
 SELECT admin.AdminID, workorders.WHAT_YOU_WANT
 FROM admin
 INNER JOIN workorders ON admin.AdminID=workorders.AdminID
 HAVING admin.username='.$_SESSION['user'].'
 ;


 Don't use having in this case - this should be a 'where' clause.

 A 'having' clause is processed AFTER everything else (after where, after
 joins, after aggregate's are calculated like sum/max/min), using it like
 this will cause performance issues where you shouldn't have any.

 --
 Postgresql  php tutorials
 http://www.designmagick.com/


 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] Re: Problems with INNER JOIN

2009-01-29 Thread Chris

Terion Miller wrote:
Actually I have tried EVERYTHING suggested and it just does not work, in 
my last query here I put in a user I know has orders and still nothing :


$sql3 = SELECT admin.AdminID, workorders.WorkOrderID, 
workorders.DATE_FORMAT(CreatedDate,'%m/%e/%y') AS SubmitDate, 
workorders.Location, workorders.AdminID, workorders.FormName, 
workorders.Status FROM admin INNER JOIN workorders  ON admin.AdminID = 
workorders.AdminID WHERE admin.username = 'lhanford' ;


Are there mySQL settings that could prevent JOINS?


Definitely not.

Try it manually in two parts:

select adminID from admin WHERE username='lhanford';

remember that id, then:

select * from workorders where adminID='admin_id_from_last_result';

Any results?

--
Postgresql  php tutorials
http://www.designmagick.com/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] Re: Problems with INNER JOIN

2009-01-29 Thread Terion Miller
Yep they both work separately ... can't believe I've been stuck on the same
thing all day, it seems like an easy thing...

On Thu, Jan 29, 2009 at 5:09 PM, Chris dmag...@gmail.com wrote:

 Terion Miller wrote:

 Actually I have tried EVERYTHING suggested and it just does not work, in
 my last query here I put in a user I know has orders and still nothing :

 $sql3 = SELECT admin.AdminID, workorders.WorkOrderID,
 workorders.DATE_FORMAT(CreatedDate,'%m/%e/%y') AS SubmitDate,
 workorders.Location, workorders.AdminID, workorders.FormName,
 workorders.Status FROM admin INNER JOIN workorders  ON admin.AdminID =
 workorders.AdminID WHERE admin.username = 'lhanford' ;

 Are there mySQL settings that could prevent JOINS?


 Definitely not.

 Try it manually in two parts:

 select adminID from admin WHERE username='lhanford';

 remember that id, then:

 select * from workorders where adminID='admin_id_from_last_result';

 Any results?


 --
 Postgresql  php tutorials
 http://www.designmagick.com/




Re: [PHP-DB] Re: Problems with INNER JOIN

2009-01-29 Thread Chris

Please post under the other replies, it makes it easier to follow.

Terion Miller wrote:
Yep they both work separately ... can't believe I've been stuck on the 
same thing all day, it seems like an easy thing...


From what you've shown us it should work.

Maybe post the output of:

show create table workorders;
show create table admin;

to see if we can spot any discrepencies (maybe one has 'AdminID' and one 
has 'ID' or something).


Do you get any errors from mysql when you run the full query with the join?

--
Postgresql  php tutorials
http://www.designmagick.com/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php