insert and display mySQL/PHP

nazariah

down here is my script to insert data from php to mySQL and display it into table...
however this scripts cannot work...
plz help me..
for your info, my database's name is login and my table's name is inter_section.

<?php
$query = "INSERT INTO inter_section (no, section, subject, date_assigned, date_completed, userid) " .
"VALUES('$no', '$section', '$subject', '$date_assigned', '$date_completed', '$userid')";

$result = mysql_query($query);

mysql_connect("hostname", "username", "password");
mysql_select_db("login");
$query = "INSERT INTO inter_section VALUES('$no', '$section', '$subject', '$date_assigned', '$date_completed', '$userid')";
$result = mysql_query($query);
?>

<head><title>Inter-section status report assign by development design</title></head>
<h3>INTER-SECTION STATUS REPORT ASSIGN BY DEVELOPMENT DESIGN</H3>
<body>
<?php
mysql_connect("localhost","username","password");
mysql_select_db("login");
?>
<?php
$result = mysql_query("SELECT * FROM inter_section");
echo "<table border = '1'>\n";
echo "<tr>
<td>No.</td>
<td>Section</td>
<td>Subject</td>
<td>Date Assign</td>
<td>Date Completed</td>
</tr>\n";
while ($myrow = mysql_fetch_row($result))
{
echo "<tr><td>$myrow[0]</td><td>$myrow[1]</td><td><a href='$myrow[2]'>$myrow[2]</a></td>
<td>$myrow[3]</td><td>$myrow[4]</td></tr>\n";
}
echo "</table>\n";
?>

sonicphpr

try this, it might be longer, but the query's might make more sense for you.

<head><title>Inter-section status report assign by development design</title></head>

<?
/--------- DATABASE CONNECTION INFO ---------/
$hostname="hostname";
$mysql_login="login";
$mysql_password="password";
$database="db";

/--------- DATABASE CONNECTION COMMANDS ---------/
if (!($db = mysql_connect("$hostname", "$mysql_login" , "$mysql_password"))) {
print("Can't connect to database.");
} else {
if (!(mysql_select_db("$database",$db))) {
print("Can't connect to table.");
}
}

$query = "INSERT INTO inter_section VALUES('$no', '$section', '$subject', '$date_assigned', '$date_completed', '$userid')";
$result = mysql_query($query);

?>
<body>
<h3>INTER-SECTION STATUS REPORT ASSIGN BY DEVELOPMENT DESIGN</H3>

<table border = '1'><tr>
<td>No.</td>
<td>Section</td>
<td>Subject</td>
<td>Date Assign</td>
<td>Date Completed</td>
</tr>

<?
$result = mysql_query("SELECT * FROM inter_section");

$num=mysql_numrows($result);
$i=0;

while($i < $num) {

$no=mysql_result($result,$i,"$no");
$section=mysql_result($result,$i,"$section");
$subject=mysql_result($result,$i,"$subject");
$date_assigned=mysql_result($result,$i,"$date_assigned");
$date_completed=mysql_result($result,$i,"$date_completed");

echo "<tr><td>$no</td><td>$section</td><td><a href='$subject'>$subject</a></td>
<td>$date_assigned</td><td>$date_completed<td></tr>";

++$i;
}
?>
</table>
</body>

Anon

I didn't see any problems - if you have access to the database directly you might want to make sure you got the info in there. I did put some comments in to help with error checking. Hope this helps.

<?php

//I'm going to assume this is just a typo as you
//don't connect to the database yet and repeat the same query below
//$query = "INSERT INTO inter_section (no, section, subject, date_assigned, date_completed, userid) " .
//"VALUES('$no', '$section', '$subject', '$date_assigned', '$date_completed', '$userid')";
//$result = mysql_query($query);

$result = mysql_query($query);
//try error checking
echo mysql_error();
?>

<head><title>Inter-section status report assign by development design</title></head>
<h3>INTER-SECTION STATUS REPORT ASSIGN BY DEVELOPMENT DESIGN</H3>
<body>

<?php
mysql_connect("localhost","username","password");
mysql_select_db("login");
?>
<?php
$result = mysql_query("SELECT * FROM inter_section");
echo "<table border = '1'>\n";
echo "<tr>
<td>No.</td>
<td>Section</td>
<td>Subject</td>
<td>Date Assign</td>
<td>Date Completed</td>
</tr>\n";
while ($myrow = mysql_fetch_row($result))
{
//you also can put the column name in the [] as in $myrow[no] $myrow[section]...be sure not to use quotes
echo "<tr><td>$myrow[0]</td><td>$myrow[1]</td><td><a href='$myrow[2]'>$myrow[2]</a></td>
<td>$myrow[3]</td><td>$myrow[4]</td></tr>\n";
}
echo "</table>\n";
?>

Anon

also, i always use
mysql_fetch_array($result) instead of mysql_fetch_row($result)

don't know if that will he