andalib14

tnx bro it seems to work but the contents now comes up in a messd way...like this Dvd Name : ANdalibs dvd Contents:hey i seem to like u i want it to come up like: Dvd Name : ANdalibs dvd Contents:hey i seem to like u how can i do that? and can i sumhow make it and unorderd list??

i have a code where the elements of a dvd shud be viewd not in a line but with new lines when the user views the elements... <?php include('session.php'); include('session_check.php'); ?> <?php include('database.php'); if(isset($_SESSION['user_name'])) { $session=$_SESSION['user_name']; $sql1="select * from user_table where user_name like '%$session%' "; $result1=mysql_query($sql1); $row1=mysql_fetch_array($result1); $id=$row1['id']; $sql="select * from dvd_info where user_id like '%$id%' "; $result=mysql_query($sql); while($row=mysql_fetch_array($result)) { echo "Dvd Name : ".$row['dvd_name']; echo"</br>"; $array=array(); $array=split(",",$row['contents']); $size=count($array); echo "Contents:"; for($i=0;$i<$size;$i++) { echo $array[$i]; } //echo " Contents :".$row['contents']; echo "<br /><br />"; } } ?> <form action="home.php" method="post"> <center> <input type="submit" value="Home" > </center> here the contents come up in a line...how can i seperate each content by new line/? by the way i hav asked the users to enter the contents when they save them separateing by ENTER.

try this : $result = mysqli_query($query); //instead of $result = mysqli_query($dbc, $query); //and then $row=mysql_fetch_array($result);

im developing an application that can stor dvd informations...users can register and then can login..after login they can add new dvds or show dvds or search dvd contents...my problem is...say im a new user and i log in and save a dvd with its contents...then i log out...some other user logs in and then adds his dvd info...then when he hits show dvds he can see d whole database..both mine and his dvds..i want to make user accounts private..say i will not c what the other user saves but only he can...how can i do that?? im adding some of the codes that will be modified actually..i duno how ! plz help [attachment deleted by admin]