CODE of First page.
<?php
require_once ('mysql_connect.php'); // connecting to database.
// Im making the query.
$query = "SELECT CONCAT(Id) AS Id, (Name) AS Name, (Description) AS Des, DATE_FORMAT(Date, '%M %d, %Y') AS dr FROM AddTable1 WHERE Description IS NOT NULL ORDER BY Date ASC";
$result = @mysql_query ($query) OR die; // Run the query.
$num = mysql_num_rows ($result); // How many codes are there?
if ($num >0)
{ // If it ran ok
// Display numbers
echo "<p><big><b>These are the current number of entries: $num</b></big></p>";
// Display headers
echo '<table align="center" border="2" cellspacing="2" cellpadding="2">';
echo '<tr>';
echo '<td align="left"><b>Id</b></td>';
echo '<td align="left"><b>Name</b></td>';
echo '<td align="left"><b>Category</b></td>';
echo '<td align="left"><b>Date</b></td>';
echo '<td></td>';
echo '<td align="left"><b>Click edit to update</b>';
echo '<td align="left"><b>Show the table</b></td></td>';
echo '</tr>';
// Fetch the data
while ($row = mysql_fetch_array($result, MYSQL_NUM))
{
echo "<tr>";
echo "<td align=\"left\">".stripslashes($row[0])."</td>";
echo "<td>$row[1]</td>";
echo "<td align=\"left\"><a href='edit.php?=".edit."'>$row[2]</a></td>";
echo "<td align=\"left\">$row[3]</td>";
echo "<td align=\"left\"><a href='edit.php?=".edit."'>$row[4]</a></td>";
echo "<td><a href='edit.php?=".edit."'>".edit."</a> <br></td>";
echo "</tr>\n";
}
echo '</table>';
mysql_free_result ($result); // free up resources.
} else { // If it didnt run OK.
echo
'<p>there are no codes in this query</p><p>' .mysql_error() . '</p>';
}
mysql_close(); // Close the database.
include ('WSfooter.inc'); // footer included.
?>
___________________________________
CODE of Show.php
<?php
// This page is to get the sql query to show the table being selected
// The title and header
$page_title = 'Show information';
include ('WSheader.inc');
// Variable Declaration with if statement
$c = $_Get['Code'];
// Query time - for selection of data
require_once ('mysql_connect.php'); // I am making a connection to database
// Variable Declaration with if statement
// This query should show the data from agenda section
$result = mysql_query("SELECT Code FROM AddTable2 WHERE Code='" . $c . "'");
if (!$result) {
die ("<p>Error performing query: " . mysql_error() . "</p>");
}
else {
echo ('<p>Your password is: '.$result.'.</p><p>Your password is case sensitive. Make sure you enter it correctly.</p>');
}
mysql_close(); // Close the database.
include ('WSfooter.inc'); //Showing footer
?>
As you said DATATYPE of CODE column is Text type, in select statement, is should be enclosed within quotes as I have made changes in the above code.
Please always follow INDENTING of your code. This will always make you code readble and would be easier to anyone to debug incase of error. Else if would be a pain to go through the code, and anyone for that matter would hesitate to debug that.
The doubt I have here is what does "edit" mean in your first page code? I dont think that is meaningfull, coz, for me it doesnt look like a variable. The hyperlinks in your first page should be something like
href="show.php?Code=". $Code
This should be fetched in show.php as I assume.
I am not sure what your select statement do in the first page. May be you can explain the flow between these 2 pages more in detail. That would help me understand what you are trying to do.
Cheers!
-Vijay G
