Jump to content
Killersites Forums


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Jarel101

  • Rank
    New member
  • Birthday 08/27/1990

Profile Information

  • Gender
  • Location
    Chicago, IL
  1. I'm creating a mysql keyword search on my website and I know how to search a single mysql table, my problem is I need to search 15 different tables simultaneously, they also all have the same column names. I was told I have to use JOINS or UNION JOIN but i've never used them before. How is this done? MY SQL SELECT: SELECT * FROM table1 WHERE keyword LIKE %colname% OR id LIKE %colname%
  2. I'm php newbie and I"m trying to create pagination for some DP results and I'm having some problems. I can view the pagination at the bottom of my DB results, however when I click on the numbers I remain on the same page. I'm using this 7 step pagination script: http://www.phpeasystep.com/phptu/29.html and I think my problem may be within step 7, im confused on what to do for that step, but it could be something else. I don't deal with code that often so this new to me. So my question is how do I get this script to work? <?php require_once('Connections/myconnectboi.php'); ?> <
  3. Just out of curiosity, how did you know it was DW produced code just by looking at it.
  4. I've created a keyword mysql search, it almost works perfect. The only problem is when I don't enter a keyword into the search form and leave it blank and click the search button, I get the data from my DB table, even though I didn't enter anything in the text box? When I enter a word that's not a keyword I just get a blank page. I would like to code it in away where when I don't enter anything and hit search or enter a keyword that I haven't added, I get a message that says "no results were found" or anything to that effect. My question is how do I do this? HERES MY CODE: SEARCH RESUL
  5. I changed the search form, but as you suspected It still won't return my db data. search page <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">'>http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml">'>http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> <form action="search_results.php" method="get
  6. That's exactly whats happening, How do I get this to work. I've followed this step by step: http://livedocs.adobe.com/en_US/Dreamweaver/9.0/help.html?content=WScbb6b82af5544594822510a94ae8d65-78ae.html but I still get no results
  7. I'm creating a image gallery and I'm about 90% complete. One of my final objectives is to create a keyword search for my image gallery. I have 4 fields in my DB, (id,layout,description,keywords) I want to be able to enter keywords into the text field to make the images with there descriptions show up. When I view my search page in firefox and type in a keyword in the text field, when the results page loads all I get is the field names in my DB table (id,layouts,desription,key_words) instead of the actual data...?? Someone told me to use LIKE instead of equal but that didn't work either. It
  8. Hi, I'm creating a image gallery and I'm about 90% complete. One of my final objectives is to create a keyword search for my image gallery. I have 4 fields in my DB, (id,image,description,keywords) I want to be able to enter keywords into a search and the images with there descriptions show up. I've been searching the internet and Youtube and I can't find any tutorials that I fully comprehend. I already have the keywords in my mysql. After inserting the form, text field and search button I don't really know the next step. For this project I'm using Dreamweaver Cs5, I'm not really an e
  9. Thanks allot, my problem is now resolved. You really made me realize how simple this was, I think I just over thought this. Again thanks
  10. Hi, I'm trying to create a web gallery something exactly like this: http: I'm about 70% done with this project, So far I have 4 fields in my DB table (ID,Image,Description,keywords). I have images in sets of 3 being displayed vertically on a webpage in descending order with pagination at the bottom as seen in the example. Here's my problem: I want to be able to click on an image and view that same image on another page, without creating a new page for every single image(as seen in the example). I here this is done by passing id parameters. To complete my project I've been following
  11. I didn't realize that site was wordpress, A more accurate example of what I'm trying to create is this: Please forgive me but I'm a super newbie at all of this, I don't understand how to use the <?php echo '<img src="' . $link_to_img . "' alt='' />"; ?> code, can you explain. How do I retrieve the link by querying the database?
  12. I'm trying to create something exactly like this: http://hypebeast.com/page/2/ I have some images on photobucket that I want to link to my mysql so I can display them dynamically on a web page...How is this done. I've heard I should store the image link in a blob field, but I've tried and it didn't allow me to right click and paste the link. I'm a beginner in php/mysql and any help would be greatly appreciated, thanks in advance.
  • Create New...