•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 427,197 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,219 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting
Views: 823 | Replies: 19 | Solved
 |
•
•
Join Date: Sep 2007
Posts: 1,057
Reputation: 
Rep Power: 4
Solved Threads: 61
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:
newname.columnname
Hence:
SELECT a.City, b.State FROM Cities a, States b instead of: SELECT Cities.City, States.State FROM Cities, States
Last edited by SheSaidImaPregy : Feb 22nd, 2008 at 4:52 pm.
•
•
Join Date: Feb 2008
Posts: 36
Reputation:
Rep Power: 1
Solved Threads: 0
Light Poster
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...
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...
•
•
Join Date: Sep 2007
Posts: 1,057
Reputation:
Rep Power: 4
Solved Threads: 61
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:
Also, in your html, replace this:
[/url] with this: </a>
•
•
Join Date: Feb 2008
Posts: 36
Reputation:
Rep Power: 1
Solved Threads: 0
Light Poster
Ok, I'll research it some more......
•
•
Join Date: Feb 2008
Posts: 36
Reputation:
Rep Power: 1
Solved Threads: 0
Light Poster
well, the code is identical from before...
The error message is on the following:
while ($row = mysql_fetch_array($query))
any ideas?
The error message is on the following:
while ($row = mysql_fetch_array($query))
any ideas?
•
•
Join Date: Sep 2007
Posts: 1,057
Reputation:
Rep Power: 4
Solved Threads: 61
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.
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.
•
•
Join Date: Feb 2008
Posts: 36
Reputation:
Rep Power: 1
Solved Threads: 0
Light Poster
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....
•
•
Join Date: Sep 2007
Posts: 1,057
Reputation:
Rep Power: 4
Solved Threads: 61
There is, "Add to SheSaidImaPreggy's Reputation"
•
•
Join Date: Feb 2008
Posts: 36
Reputation:
Rep Power: 1
Solved Threads: 0
Light Poster
SheSaidImaPregy- are you available to answer one more question related to this thread?
|
•
•
•
•
•
•
•
•
DaniWeb ASP.NET Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
adsense adult advertising biometrics blogging bomb book business coding community copyright development earth engine environment failure forum google internet legal malware marketing mcafee microsoft monetization msn news operating pagerank phishing photo privacy publishing revenue search security seo silverlight software space spyware support system technical universe video web webmaster wiki yahoo
- Differences Between Java and C/C++ (C++)
- Complex Store Procedure (MS SQL)
- it's simple but yet complicated...php and mysql search.. (PHP)
- Need Help Creating a Search Page (ColdFusion)
Other Threads in the ASP.NET Forum
- Previous Thread: problem viewing in browser...
- Next Thread: indeterminate progress bar
