Bradley_James

You guys rock. Works like a dream! Thanks!

Hey Guys- I built a page where bands and musicians can submit their name, genre and website to a database that others can search. I'm trying to figure out how to get my PHP code to search both by genre and band name. Here's the line of code I'm referring to: $query = "select * from Information where genre like \"%$trimmed%\" order by genre"; I assumed that I could add "OR" after "genre" and then type "bandname" after that, resulting in "where genre OR bandname like \%$trimmed\" however, this doesn't work. Any help would be appreciated! -Brad

Alright it officially works, thanks again! But I also appreciate your patience with my SQL/PHP incompetence; for I have ONE MORE question. Now that users can post, I guess I never really figured out how to add a "delete" feature to the posts, where they can push "delete" and delete their post if they did it incorrectly. Again, thank you; I'm just a fun bundle of questions.

Ahh jeez, the fun just doesn't stop! I'm getting the following error when I type out what you gave me. Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/vhosts/practice-space.6te.net/search.php on line 48 Any ideas?

That works! Thanks a million man!

echo "<td>" . $row['website'] . "</td>"; That's the line the search posts in the fetch array when a user types in anything into the search bar, and I want 'website' to be the active link always. Where do I post the code? Thanks again!

What would the anchor tags be specifically? Isn't the code you posted "<ul>" a list tag? What would be a tag to change the text to an active URL?

My website is built, and it allows users to input three things, two of which are generic text, and one of which is a link to their website/Facebook page/etc. My question is that I've got it set up where someone may go to my site, search for someone who has inputed data (as said above), and it'll display that data. However, I want the first two sets of inputted information to display as regular text, and the website URL to be clickable when displayed. In my PHP code, is this solved by having that third text field something other than "varchar" or is it an entirely different line of code? Thanks!

Okay... Since my last post about the website I was working on, I've figured out what I was asking. But now, I've run into another problem... Once I have a functional form on my website where a user inputs data and presses submit, how do I go about getting it to remain posted where directed? So if the user types his first and last name and presses submit, how do I get their input to remain posted on the page, much like a guestbook? I'm a newbie at this stuff, but it's a must for mine and my partner's website. Thanks again! PS... I have the code for the form all typed out and it works, it just displays the data with $echo rather than posting it permanantly.

Hello all! Well, here's my dilemma. I understand how PHP and server side code works, I understand the important basics about PHP in general, I just need more specific help. I'm currently working with a partner in building a website that allows users to basically enter in information in text fields, add a picture to their post, and choose from a drop down menu what other page on the website they want the post to go to. (For all of the things I'm discussing here, I've drawn out pictures of what I want in Illustrator if anyone needs specifications.) Once the user presses "Submit" or "Accept" or whatever, it will post their information on the page they selected, organized with the picture a certain size on the left, and the text aligned ragged right on the right side of the picture. Below that, each "post" will be assigned a number based on the last post made to that page. So if I was the first one to post it, it'd show "1" in the data. I can imagine this isn't a simple process, but because I understand how PHP works, and also how comment systems in server side coding works, I just need to know certain things in the code, like organizing the inputed data when posted and what not. Any help or advice would be greatly appreciated by both me and my partner. Thanks!