Search results for query: *

Thank you, this helped me alot!! The connection was there, but I had forgotten to select the database..Thanx all.. That was really a nwbie-error!!

Is there a way to be absolutely positive 100% sure that the connection to the db is working here as well?

The names of the fields in the DB (gjest) is: id-integer autoincrement navn Varchar(35) hjemmeside Varchar(35) tid Varchar(35) melding (text) The connection works on another page, so it should be working here as well

<?php include ("conn.php"); //this is the statement to get all the info $sql = mysql_query("SELECT * FROM gjest"); // go through each row in the result set and display data from the table while ($row = mysql_fetch_array($sql)) { // give a name to the fields i.e. $row['name of column in...

<?php include ("conn.php"); //this is the statement to get all the info $sql = mysql_query("SELECT * FROM gjest"); // go through each row in the result set and display data from the table while ($row = mysql_fetch_array($sql)) { // give a name to the fields i.e. $row['name of column in...

Thank you, but no, It doesent help me.. I still get the same error-message:[i] Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource [i] Now I've tried to echo them, but it still doesnt work...

Thank you, but I still got the same error. And what is the difference between using ' ' and " "?

I have a valid connection to the DB

This is my code: <?php $sql="SELECT * FROM gjest"; $query=mysql_query($sql); while($datas=mysql_fetch_array('$query')){ ?> Navn:<?php echo $datas["navn"]."<br>"; ?> Hjemmeside:<?php echo $datas["hjemmeside"]."<br>"; ?> Dato:<?php echo $datas["tid"]."<br>"; ?> Melding:<?php echo...

YES!! Thank you very much Chacalink!!

Ok,thank you, I tried, still the same message. Her is the sql i get : INSERT INTO gjest(navn, hjemmeside, tid, melding) values(dsf, fdsf, Mon Jan 31, asf) This looks allright dont it? All the rights are set for the user who inserts into the DB

My code in the form is this: <form method= "post" action="process.php"> Navn : <input type= 'text' name= '$navn' > <br><br> Hjemmeside : <input type= 'text' name= '$hjemmeside' > <br><br> Comment : <input type= 'text' name= '$kommentar' > <br><br> <input type= 'submit' value= 'Skriv inn' >...

Thank you very much!! This helped me..

it is meant to count the numbers allowed in the databasefield. (lengde=length) Just to assure you, i have opened the database rs with this code: <% option explicit Dim rs, Conn, Kurskode, Kursnavn, Klassetrinn, Rom, Periode, Valgfag, sql, sql2, rs3 response.buffer = false Set Conn =...

<% If Request.QueryString ("knapp") = "ny" then 'administrator vil legge inn nytt kurs sql2="select * from Kurs" response.write sql2 rs3.open sql2, Conn, 3, 3 rs3.Addnew lengde= RS3("Kurskode").DefineSite verdi=request.queryString("Knr") if len (verdi)>lengde then RS3("Kurskode")=left...