Jump to content

Insert-problems


beginann

Recommended Posts

Hi,

In my MySQL-table I have four fields: nr, namn, link and byt.

Nr and name are no problems. I the linkfield I want a link to a picture and in the byt-field I want a standardvalue, which means that if I click there I will go to a form, where I can change the link to the picture if I want to.

 

This is my code:

 

<?php

if(isset($spara)){
	if(isset($nr) && $nr != "" && strlen($nr) <= 4
	&& isset($link) && $link !=""){

$query="INSERT INTO lista_1 nr, link VALUES ('$nr', '$link') WHERE nr='$nr'";

$result = mysql_query($query);
		if(!$resultat){
			echo "<div class=tabell4><table><tr><td>Länken kunde inte läggas till. MySQL rapporterar: " . mysql_error() . "</td></tr>";
			echo "</table></div>";
			}
		else {
			echo "<table><tr><td>Länken är inlagd</td></tr>";
			echo "</table>";
		}
       	}
}
// Stänger anslutningen till vår databas
        mysql_close($connection);
?>


<div id="Layer1">
  <form id="form1" name="form1" method="post" action="<?=$PHP_SELF?>">
    <table width="80%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td colspan="2"><span class="rubrik_14_bold_italic">Fyll i nedanstående och klicka på sänd!</span><br />
          <br />
          <span class="text_12">För att se ändringen behöver Du klicka på "Uppdatera"-symbolen i verktygsraden.</span></td>
      </tr>
      <tr>
        <td> </td>
        <td> </td>
      </tr>
      <tr>
        <td class="text_12">Växtens nr </td>
        <td><input name="nr" type="text" id="nr" size="10"  value="<?=$s_nr?>"></td>
      </tr>
      <tr>
        <td class="text_12">Bildlänk</td>
        <td><input name="link" type="text" id="link" size="40" maxlength="60" value="<?=$s_link?>"></td>
      </tr>
      <tr>
        <td class="text_12"> </td>
        <td> </td>
      </tr>
      <tr>
        <td class="text_12"> </td>
        <td><input type="submit" name="spara" value="Skicka" /> 
		<input type="submit" name="drop" value="Rensa" /></td>
      </tr>
      <tr>
        <td class="text_12"> </td>
        <td> </td>
      </tr>
    </table>
  </form>
</div>

 

In the byt-field I have succeeded to get a standardvalue by coding like this: <a href="byt1.php" target="_blank">Ny bild</a>

 

I have also added:

 

<?php
include_once("dbmanager.php");
?>

 

and that works because I have got information from the database by using SELECT in another file.

 

My problem is that I can´t put in new links in my database, something seems to be wrong, but I can´t find out what it is. Please help!

A-B

 

Link to comment
https://forums.phpfreaks.com/topic/70531-insert-problems/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.