m5638829
-
Posts
3 -
Joined
-
Last visited
Never
m5638829's Achievements
Newbie (1/5)
0
Reputation
-
How do you make the DELETE FROM tablename WHERE a link so that I can just click on it?
-
the first problem is that i want the search results to only display two of the 8 fields. when you click on a "learn more" button, another page is opened with all of the fields displayed. Second problem, I tried with the DELETE FROM tablename WHERE and it just messed it up. i will try again with that. So nevermind that issue.
-
Hello, I am trying to code a project and ran into a brick wall with one of my pages. I am pretty new at php/mySQL and can not figure this out. Now I know that you are not going to sit there and type my whole script out for me. That is NOT what I am asking. I need pointers, links to tutorials, or whatever help you can get me. I appreciate it very much! First off, I am recoding a site I created a little while ago in pure HTML to php. This site is a help wanted site and it has had massive amounts of hits and requests to put up listings. I have the pages to submit a listing, write that to the database, and one to show the results in a raw format. However, I am running into two problems. One is that I want to code the main page to just be a mysql query. This means that I want it to show just the company name and position available, then have a button to click to get the rest of the info about the job listing in a separate pop-up window. I can not seem to find code, tut or anything of the like about this. Second problem, in my raw data results (plan table showing database contents) I need a link that will remove the entry. I have tried a couple of scripts and messed up my code further. I was wondering if anyone knows of something that describes this is great detail. It is all in a table. Here is some of my code for the table with the DB contents: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>View All Job Listings</title> </head> <body> <?php require 'dbconnect.inc'; mysql_select_db("coushatta", $con); $result = mysql_query('SELECT * FROM jobs', $con); echo "<table border='1'> <tr> <th>ID</th> <th>Business Name</th> <th>Contact Name</th> <th>Phone Number</th> <th>Fax Number</th> <th>Email Address</th> <th>Position Open</th> <th>Open</th> <th>Filled</th> <th>Closed</th> <th>Listing Content</th> <th>Delete?</th> </tr>"; while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['ID'] . "</td>"; echo "<td><a href='" . $row['ID'] . ".html'>" . $row['business_name'] . "</a></td>"; echo "<td>" . $row['contact_name'] . "</td>"; echo "<td>" . $row['phone_number'] . "</td>"; echo "<td>" . $row['fax_number'] . "</td>"; echo "<td>" . $row['email_address'] . "</td>"; echo "<td>" . $row['position_open'] . "</td>"; echo "<td>" . $row['learnmore']; if ( $row['learnmore'] == TRUE ) { echo ""; } else { echo ""; } "</td>"; echo "<td>" . $row['filled']; if ( $row['filled'] == TRUE ) { echo ""; } else { echo ""; }"</td>"; echo "<td>" . $row['closed']; if ( $row['closed'] == TRUE ) { echo ""; } else { echo ""; }"</td>"; echo "<td>" . $row['listing_content'] . "</td>"; echo "</tr>"; } echo "</table>"; mysql_close($con); ?> </body> </html>