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:
Code: <!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>
Php - mysql store data and use it later?
Hi, i' making a login page at the moment, however my username + password is stored many different places, and is kinda hard to get, so I have written this entire code:Code:
filesize() returns 0
I have a socket program that runs in an infinite loop, listening for connections, in this socket I have a method, that is supposed to open a file and write to the file, but I am having issues. Each
Parse Error with doctype
I'm getting a parse error with this simple code. I don't get it. It worked one time then when I reloaded the page in FF the code throws this parse error. Parse error: parse error in
On page view, minus credit
Hello all, please, I need a little help with this script. I am charging one credit (credits can be purchased, but that is unrelated) for view of a certain page. I need help in figuring out what php I
Dealing with code in db query
I am dealing with C code and I need to make sure it is encoded some how to ensure its integrity and then decoded. For security and later readability.
pointer 102 question
I read a book
problem with sql querry in php script
Hello guys, What I want to do is I want to read out a csv file and then but te conent ot the file in a msql datbase . So far it works but the problem I haven that if I want to let te script to the
Recording popularity by day, week.. all time?
Hey everyone, I'm creating a site designed around users uploading music. How can I implement a system that would effectively record information such as view count so that a user could find the most
quick question
Hi ..i have a questionhow do i set a var so it displays via an echoCode: $logo = '<img src="Images/tvguide/sabc1.jpg">';echo '<div
PHP Thumbnail Creation
Ok so i use this function to create thumbnails:Code: function createthumb($name,$filename,$new_w,$new_h){ $system=explode('.',$name); $src_img=imagecreatefrompng($name);
