Forum: HTML and CSS  25 Days Ago |
| Replies: 3 Views: 2,368 Re: This page is not Valid HTML 4.01 Transitional!
You know I agree with Zachery fully, but unfortunately my job required that all our pages pass the W3c validator and I tell you, I wish I had too much time on my hands.
My big problem right now is a... |
| Forum: MySQL Aug 27th, 2008 |
| Replies: 24 Views: 631 Re: Query help
Thank You! Thank You!
If only you could see the back flips I'm doing now.
It was two things;
one of the avatar should have been avatar(s) and the ticks around the user_id.
I'm really grateful.... |
| Forum: MySQL Aug 27th, 2008 |
| Replies: 24 Views: 631 Re: Query help
SO yea, I thought that is what you meant. I put the query into a variable and called the variable with an echo
and got back this:
select ma.user_id, ma.memberfname, ma.memberlname, ma.avatar_id,... |
| Forum: MySQL Aug 27th, 2008 |
| Replies: 24 Views: 631 Re: Query help
Yes, I understand about only getting back one record. That is as I hoped.
I'm still confused. Did I not terminate the statement with a semicolon?
And to store the query in SQL??? Would that... |
| Forum: MySQL Aug 27th, 2008 |
| Replies: 24 Views: 631 Re: Query help
Again, Thank you for all of your time, but I regret to say I'm getting the error "not a valid MySQL result resource"
Here is the exact statement I entered.
$result=mysql_query("select ... |
| Forum: MySQL Aug 27th, 2008 |
| Replies: 24 Views: 631 Re: Query help
Thanks for all your help. I really appreciate it.
I would like to consolidate it . I just had a realization of why the pic shows up when there is one associated with the user.
I'm doing two... |
| Forum: MySQL Aug 27th, 2008 |
| Replies: 24 Views: 631 Re: Query help
Yes. There is an pic for avatar_id=1.
Do I need to call avatars.pic in my query? |
| Forum: MySQL Aug 27th, 2008 |
| Replies: 24 Views: 631 Re: Query help
Yes, It is a file path to the picture.
If I change back the select statement to:
$result=mysql_query("select
members.user_id,... |
| Forum: MySQL Aug 27th, 2008 |
| Replies: 24 Views: 631 Re: Query help
Wow! Okay. So , with that select statement, and putting
{$row['avatar_id']} in the echo statement I can see all the members and their avatar_ids
All members who do not have an avatar, print an... |
| Forum: MySQL Aug 27th, 2008 |
| Replies: 24 Views: 631 Re: Query help
Thank you again Dickersonka,
I thought I had, as you suggested, but I'm still not making a connection to the avatars table.
Here's my table layout
Avatars
-------------------------------
avatar_id... |
| Forum: MySQL Aug 27th, 2008 |
| Replies: 24 Views: 631 Re: Query help
Thank you too varmadba.
And like dickersonkas solution, I think I'm getting close with your suggestion too, but I get a blank response. (which is better than a bad query)
I called all the columns... |
| Forum: MySQL Aug 27th, 2008 |
| Replies: 24 Views: 631 Re: Query help
Thanks dickersonka,
left joins are pretty new to me, but I think I got pretty close with:
$result=mysql_query("select
members.user_id,... |
| Forum: MySQL Aug 26th, 2008 |
| Replies: 24 Views: 631 Query help
Thanks in advance for anyone who can help me with this query.
I want to select all from table one and the matching image from table two.
Using the following inner join query works great:
... |
| Forum: MySQL Aug 6th, 2008 |
| Replies: 6 Views: 390 Re: Count Comments?
Yes! That is exactly what I am trying to do. Thank you for understanding.
However, I am stumped by how to display the 'comment_cnt'. I've not used the 'AS' statement before. How do I pass that as a... |
| Forum: MySQL Aug 4th, 2008 |
| Replies: 6 Views: 390 Re: Count Comments?
Again, thank you, but no luck.
I'm not sure what is wrong.
As an example, it would be like how the Topic/Threads listed on this site.
Thread Name | Replies | Views
I'm sure that info all lives... |
| Forum: MySQL Jul 31st, 2008 |
| Replies: 6 Views: 390 Re: Count Comments?
Thank you Shanti for your help, unfortunately that isn't quite what I am trying to do. Instead of counting how many stories are posted, or how many comments are posted, I want to know how many... |
| Forum: MySQL Jul 30th, 2008 |
| Replies: 6 Views: 390 Count Comments?
Hi, Thanks in advance for any help someone could offer.
I'm trying to display a list of stories submitted to my site from a table titled stories, the name of the person who submitted the story and... |
| Forum: PHP Jun 4th, 2008 |
| Replies: 2 Views: 867 |
| Forum: PHP May 23rd, 2008 |
| Replies: 3 Views: 624 |
| Forum: PHP May 22nd, 2008 |
| Replies: 3 Views: 624 Undefined index error
Hello.
I'm getting an undefined index error with the following code and I can't for the life of me figure out why. Any insight would be greatly appreciated.
I'm using an html form and a PHP file to... |
| Forum: PHP Apr 30th, 2008 |
| Replies: 4 Views: 333 Re: Search Help
Thank you so very much. That is exactly what I was looking for!!! |
| Forum: PHP Apr 24th, 2008 |
| Replies: 4 Views: 333 Re: Search Help
Thank you for your quick reply, but what I'm doing is using a select menu to choose what field the search query is looking in. However, I would like the select menu value to equal multiple... |
| Forum: PHP Apr 23rd, 2008 |
| Replies: 4 Views: 333 Search Help
Hi. I'm trying to search multiple DB fields with a Select Menu and I don't know where to start.
for example, from the code below I would like the value ='strAuthorname' to actually search the... |
| Forum: PHP Apr 9th, 2008 |
| Replies: 10 Views: 790 |
| Forum: PHP Apr 8th, 2008 |
| Replies: 10 Views: 790 Re: Trouble with password recovery emal script
Now after some testing last night, that no, I am not sure it is working. (Thank you ShawnCplus).
So I guess my question is how do I retrieve the 'teampassword' and set it as a variable? What am I... |
| Forum: PHP Apr 7th, 2008 |
| Replies: 10 Views: 790 Re: Trouble with password recovery emal script
Thank you for replying, however the getvar script seems to be working as it display's the correct variables in an echo statement on the web page, just not in the email.
Here is the getvar... |
| Forum: PHP Apr 7th, 2008 |
| Replies: 10 Views: 790 Trouble with password recovery emal script
Hello and thanks in advance to anyone that can help. I trying a simple password recovery script that emails the password after a registered user enters their email. For testing purposes I have been... |
| Forum: PHP Apr 2nd, 2008 |
| Replies: 7 Views: 431 Re: update' select menu
Again, Thank you.
I'm afraid I understand a little of what you are suggesting to do.
I do not want the form to submit on change.
Can you explainhow to "Check if it matches". I'm doing U.S states... |
| Forum: PHP Apr 2nd, 2008 |
| Replies: 7 Views: 431 Re: update' select menu
First, let me say thank you for such rapid responses.
I apologize. I'm probably not explaining myself correctly.
I do not have any trouble updating the record with the select menu, what I can't... |
| Forum: PHP Apr 2nd, 2008 |
| Replies: 7 Views: 431 |
| Forum: PHP Apr 2nd, 2008 |
| Replies: 1 Views: 401 'update' select menu
Thank you in advance to anyone who can answer this for me.
In a registration form of mine the user selects the state they live in with a drop-down menu.
In the 'Update' form I would like their... |
| Forum: PHP Apr 2nd, 2008 |
| Replies: 7 Views: 431 update' select menu
Thank you in advance to anyone who can solve this for me.
In a registration form of mine the user selects the state they live in with a drop down menu. |
| Forum: HTML and CSS Feb 8th, 2008 |
| Replies: 26 Views: 11,351 Re: To create a registration page and login page
I too am getting the "Sorry, could not log you in. Wrong login information." error. I've changed the password field to VARCHAR 25.
Additionally, when I do the register.php page There is no error... |
