Can someone help me with a complicated search parameters

Please support our ASP.NET advertiser: Intel Parallel Studio Home
Thread Solved

Join Date: Sep 2007
Posts: 1,080
Reputation: SheSaidImaPregy is an unknown quantity at this point 
Solved Threads: 68
SheSaidImaPregy SheSaidImaPregy is offline Offline
Veteran Poster

Re: Can someone help me with a complicated search parameters

 
0
  #11
Feb 22nd, 2008
all the "a" and "b" where for is a quick reference to the table. Instead of always putting tablename.columnname, you can name the table and reference it as that name

newname.columnname

Hence:
  1. SELECT a.City, b.State FROM Cities a, States b
  2.  
  3. instead of:
  4.  
  5. SELECT Cities.City, States.State FROM Cities, States
Last edited by SheSaidImaPregy; Feb 22nd, 2008 at 5:52 pm.
Reply With Quote Quick reply to this message  
Join Date: Feb 2008
Posts: 36
Reputation: jtapp is an unknown quantity at this point 
Solved Threads: 0
jtapp jtapp is offline Offline
Light Poster

Re: Can someone help me with a complicated search parameters

 
0
  #12
Feb 22nd, 2008
Thanks - I loaded the latest code and its starting to shape up... there are some formatting issues, but I think I can figure all of that out.

The remaining issue seems to be the table/query at the bottom of the page. It lists the Officers, their titles, email and phone. It seems to be messed up...
Reply With Quote Quick reply to this message  
Join Date: Sep 2007
Posts: 1,080
Reputation: SheSaidImaPregy is an unknown quantity at this point 
Solved Threads: 68
SheSaidImaPregy SheSaidImaPregy is offline Offline
Veteran Poster

Re: Can someone help me with a complicated search parameters

 
0
  #13
Feb 22nd, 2008
I didn't make any changes to your second query. I changed the first query for the results page. But the view page should be the same query as you had a long time ago, except for the "WHERE" clause.

Also, in your html, replace this:
  1. [/url]
  2.  
  3. with this:
  4.  
  5. </a>
Reply With Quote Quick reply to this message  
Join Date: Feb 2008
Posts: 36
Reputation: jtapp is an unknown quantity at this point 
Solved Threads: 0
jtapp jtapp is offline Offline
Light Poster

Re: Can someone help me with a complicated search parameters

 
0
  #14
Feb 22nd, 2008
Ok, I'll research it some more......
Reply With Quote Quick reply to this message  
Join Date: Feb 2008
Posts: 36
Reputation: jtapp is an unknown quantity at this point 
Solved Threads: 0
jtapp jtapp is offline Offline
Light Poster

Re: Can someone help me with a complicated search parameters

 
0
  #15
Feb 22nd, 2008
well, the code is identical from before...

The error message is on the following:
while ($row = mysql_fetch_array($query))

any ideas?
Reply With Quote Quick reply to this message  
Join Date: Sep 2007
Posts: 1,080
Reputation: SheSaidImaPregy is an unknown quantity at this point 
Solved Threads: 68
SheSaidImaPregy SheSaidImaPregy is offline Offline
Veteran Poster

Re: Can someone help me with a complicated search parameters

 
0
  #16
Feb 22nd, 2008
It is most likely telling you that you are trying to display data that isn't there.

Just for giggles, trade out the query to the one you had before, except change the WHERE clause to the current one. Maybe I made a typo somewhere.
Reply With Quote Quick reply to this message  
Join Date: Feb 2008
Posts: 36
Reputation: jtapp is an unknown quantity at this point 
Solved Threads: 0
jtapp jtapp is offline Offline
Light Poster

Re: Can someone help me with a complicated search parameters

 
0
  #17
Feb 22nd, 2008
Nope, that didn't solve it. But you have already helped me tremendously.. I'll try to figure it out. Thank you very, very much and let me know if there is anything I can do in return... I don't know maybe there is a rating thing on this forum....
Reply With Quote Quick reply to this message  
Join Date: Sep 2007
Posts: 1,080
Reputation: SheSaidImaPregy is an unknown quantity at this point 
Solved Threads: 68
SheSaidImaPregy SheSaidImaPregy is offline Offline
Veteran Poster

Re: Can someone help me with a complicated search parameters

 
2
  #18
Feb 22nd, 2008
There is, "Add to SheSaidImaPreggy's Reputation"
Reply With Quote Quick reply to this message  
Join Date: Feb 2008
Posts: 36
Reputation: jtapp is an unknown quantity at this point 
Solved Threads: 0
jtapp jtapp is offline Offline
Light Poster

Re: Can someone help me with a complicated search parameters

 
0
  #19
Feb 24th, 2008
SheSaidImaPregy- are you available to answer one more question related to this thread?
Reply With Quote Quick reply to this message  
Join Date: Sep 2007
Posts: 1,080
Reputation: SheSaidImaPregy is an unknown quantity at this point 
Solved Threads: 68
SheSaidImaPregy SheSaidImaPregy is offline Offline
Veteran Poster

Re: Can someone help me with a complicated search parameters

 
0
  #20
Feb 25th, 2008
Of course, just shoot.
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC