Have a small problem in my project

petes

Hello everyone.I`m new around here and am looking for a bit of help.
I have to make a small project using mysql php.I have to create a web application that allows to add show modify delete datas from the table.
i did most of this project but i have a small problem.When i want to add a new student to the table in the textboxes it appears something like:
 Notice: Undefined variable: row in D:\wamp\www\edit.php on line 27 and line 31,35
.What i wrote is:

<?php
$ID = $_GET["ID"];
if(trim($ID) != "new"){
      $connection = mysql_connect("localhost","root")
      or die("Can not connect to database.");

   $db = mysql_select_db("new", $connection) or die("Can't select database.");

   $result = mysql_query("SELECT * FROM`information`",$connection)
      or die("Can't query table.");   

   $row = mysql_fetch_assoc($result);
}

?>
<html>
   <head>
      <title>Information students - Edit</title>
   </head>
   <body>
         <body bgcolor="yellow">
      <h1>Edit data</h1>
      <form method="GET" action="submit.php">
      <input type="hidden" name="uid" value="<?php echo $ID;?>">
      <table border="1">
         <tr>
            <td>Name</td>
            <td><input name="name" value="<?php echo $row["name"]; ?>"></td>
         </tr>
         <tr>
            <td>year</td>
            <td><input name="year" value="<?php echo $row["year"]; ?>"></td>
         </tr>
         <tr>
            <td>Grade</td>
            <td><input name="grade" value="<?php echo $row["grade"]; ?>"></td>
         </tr>
<?php

if(trim($ID) != "new"){

   mysql_close();

}

?>
      </table>
      <input type="submit" name="submit" value="OK" />
      </form>
   </body>
</html>

djjjozsi

if you have ID, you wanted to get that from the information table, where the 'id' field is equal with that...

<?php
$ID = @$_GET["ID"];
if(trim($ID) != "new"){
      $connection = mysql_connect("localhost","root")
      or die("Can not connect to database.");

   $db = mysql_select_db("new", $connection) or die("Can't select database.");

   $result = mysql_query("SELECT * FROM `information` WHERE id=".(int)$ID ,$connection) or die("Can't query table.");

if(mysql_affected_rows()==0)
die("No result!");
else
$row = mysql_fetch_assoc($result);
}

?>

petes

I changed first part but it still doesn`t change anything.Still same error

<?php
$ID = $_GET["ID"];
if(trim($ID) != "new"){
		$connection = mysql_connect("localhost","root") 
		or die("Can not connect to database.");

$db = mysql_select_db("new", $connection) or die("Can't select database.");

$result = mysql_query("SELECT * FROM `informatii` WHERE `uid` = '$ID'", $connection) 
	or die("Can't query table.");
if(mysql_affected_rows()==0)
die("No result");
else	
	$row = mysql_fetch_assoc($result);
}

?>

NogDog

My guess would be that the query did not return any rows, thus the mysql_fetch_assoc() returned boolean false instead of an array. Add a check after the query is executed to see if mysql_num_rows() returns a value > 0.

djjjozsi

print and test the query in phpmyadmin,
and copy if there is error message...

NogDog

Threads have been merged...please do not cross-post the same question in multiple forums here.

petes

I still cant spot the error.The error appears on the pages where i use row.Didnt i declare it correctly or what must i do because in my textboxes where i should enter the name and the rest it appears that error My edit file looks like this now

<?php
$ID = $_GET["ID"];
if(trim($ID) != "new"){
      $connection = mysql_connect("localhost","root")
      or die("Can not connect to database.");

   $db = mysql_select_db("new", $connection) or die("Can't select database.");

   $result = mysql_query("SELECT * FROM `information` WHERE `uid` = '$ID'", $connection) 
		or die("Can't query table.");	
   $row = mysql_fetch_assoc($result);
}

?>
<html>
   <head>
      <title>Information students - Edit</title>
   </head>
   <body>
         <body bgcolor="yellow">
      <h1>Edit data</h1>
      <form method="GET" action="submit.php">
      <input type="hidden" name="uid" value="<?php echo $ID;?>">
      <table border="1">
         <tr>
            <td>Name</td>
            <td><input name="name" value="<?php echo $row["name"]; ?>"></td>
         </tr>
         <tr>
            <td>year</td>
            <td><input name="year" value="<?php echo $row["year"]; ?>"></td>
         </tr>
         <tr>
            <td>Grade</td>
            <td><input name="grade" value="<?php echo $row["grade"]; ?>"></td>
         </tr>
<?php

if(trim($ID) != "new"){

   mysql_close();

}

?>
      </table>
      <input type="submit" name="submit" value="OK" />
      </form>
   </body>
</html>

petes

Can someone please post here helping me solving this issue?Thank you