"Tell me the next 2 lines"

[katherine]

hi,

when we fetch data from database, we use these line.

include("connection.php");
connect("databasename");
$qry="select * from table1";
$rs=mysql_query($qry);
while($row=mysql_fetch_row($rs))
{
echo "$row[0] $row[1] ....";
}

Important: when we insert a row in a database, then above 3 lines are same.

include("connection.php");
connect("databasename");
$qry="insert into table1 values(1,'katherine','Computer Science')";
***********what will be the next line to add this column in the database.

Thans, Waiting for ur reply.

[katherine]

hi,

when we fetch data from database, we use these line.

include("connection.php");
connect("databasename");
$qry="select * from table1";
$rs=mysql_query($qry);
while($row=mysql_fetch_row($rs))
{
echo "$row[0] $row[1] ....";
}

Important: when we insert a row in a database, then above 3 lines are same.

include("connection.php");
connect("databasename");
$qry="insert into table1 values(1,'katherine','Computer Science')";
***********what will be the next line to add this column in the database.

Thans, Waiting for ur reply.

[jansky]

mysql_query($qry) or die ("Error in inserting ".mysql_error());

[jansky]

mysql_query($qry) or die (mysql_error());

[Weedpacket]

This sounds a bit like a school homework question.

[kimandrel]

<?php


/* Connecting, selecting database */

// Adds file with username and password
require("connection.php");
mysql_connect("localhost","$UserName","$Password") or die ("Cant connect to db");
mysql_select_db("databasename") or die ("Cant select db");

/* Performing SQL SELECT query for "Table1" */
$query = "SELECT * FROM table1";

/* Performing SQL INSERT query for "Table1" */
$query2 = "INSERT INTO table1 (1, name, type)
values(1,'katherine','Computer Science')"; 

/* Prints results */
$result = mysql_query($query) or die("Query insert into $query failed");

		 while ($row = mysql_fetch_array($result)){

 Print "$row[0]  $row[1]"			 



}
/* Ends php code */
?>

Please be sure

$query = "INSERT INTO table1 (1, name, type)

1, name and type is correct

[kimandrel]

<?php


/* Connecting, selecting database */

// Adds file with username and password
require("connection.php");
mysql_connect("localhost","$UserName","$Password") or die ("Cant connect to db");
mysql_select_db("databasename") or die ("Cant select db");

/* Performing SQL SELECT query for "Table1" */
$query = "SELECT * FROM table1";

/* Performing SQL INSERT query for "Table1" */
$query2 = "INSERT INTO table1 (1, name, type)
values(1,'katherine','Computer Science')"; 

/* Prints results */
$result = mysql_query($query) or die("Query insert into $query failed");

		 while ($row = mysql_fetch_array($result)){

 Print "$row[0]  $row[1]"			 



}
/* Ends php code */
?>

Please be sure

$query = "INSERT INTO table1 (1, name, type)

1, name and type is correct