Query using a form issue.

mabans

Ok this is what is up. I'm using this script to use to add artist information to a MySQL database. So it checks to see if a value is set, if not it displays the form to do so. A person then fills out the information then submit which theorically should set the $_GET['add'] and carry over to the 2nd portion of the Script. Please look below and see what I am doing wrong. I'm not using the Thanks in advance..

<?php

if(!IsSet($_GET['add']))
{

?>

<html>
<head>
<title>Dina Art: Add a New Artistt</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="POST" action="admin_add_artist.php">
  <p>Artist First Name: 
    <input type="text" name="artistname">
    <br>
    Artist Last Name: 
    <input type="text" name="artistlastname">
  </p>
  <p>Artist Bio:<br>
    <textarea name="artistbio" cols="50" rows="5"></textarea>
    <input type="submit" name="Submit" value="Submit">
  </p>
  <input type="hidden" name="add" value="1">
</form>
</body>
</html>


<?php
}

else {

#########################################################
# DINA ART ADMIN MODULE: Database CFG Files             #
#########################################################
require("../../includes/configs/config.cfg");
require("../../includes/configs/select_db.cfg");

$artist_add = "INSERT INTO artist ('ID', 'artistname', 'artistbio', 'artistlastname') VALUES (' ', '$firstname', '$bio', '$lastname')";

$artist_add_action = mysql_query($artist_add);

if($result==0)

print ("there has been a problem with recording your information");

else

print ("Your information has been recorded");

}	
?>

laserlight

perhaps use
isset($_POST['add'])
instead

mabans

Now I made the changes as so but nothing seems to happen. I do not get the confirmation text as I have put below, instead it displays the same form with seemingly no update. I then check the MySQL database to see if it indeed has updated but no updated there as well.

Is there another way I can approach this?

SuperCam

I'll take a shot at this... The code, over all looks alright, I just put a few touch-ups to it to see what it might help...

<?php 

if(!isset($_GET['add'])) 
{ 

?> 

<html> 
<head> 
<title>Dina Art: Add a New Artistt</title> 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> 
</head> 
<body bgcolor="#FFFFFF" text="#000000"> 
<form name="form1" method="POST" action="admin_add_artist.php"> 
  <input type="hidden" name="add" value="1"> 
  <p>Artist First Name: 
    <input type="text" name="artistname"> 
    <br> 
    Artist Last Name: 
    <input type="text" name="artistlastname"> 
  </p> 
  <p>Artist Bio:<br> 
    <textarea name="artistbio" cols="50" rows="5"></textarea> 
    <input type="submit" name="Submit" value="Submit"> 
  </p> 
</form> 
</body> 
</html> 


<?php 
} 

else { 

 ##################################################
####### 
# DINA ART ADMIN MODULE: Database CFG Files             # 
 ##################################################
####### 
require("../../includes/configs/config.cfg"); 
require("../../includes/configs/select_db.cfg"); 

$artist_add = "INSERT INTO artist ('ID', 'artistname', 'artistbio', 'artistlastname') VALUES (' ', '$firstname', '$bio', '$lastname')"; 

$artist_add_action = mysql_query($artist_add); 

/// If $result == 0?
if($artist_add_action==0)
{
    print ("there has been a problem with recording your information"); 
}
else 
{
    print ("Your information has been recorded"); 
}
}     

?>

Well, when I was going through your code this is what I found:
When you are performing the query:
$artist_add_action = mysql_query($artist_add);

you then cehck in your if statement if $result == 0... I changed this to if($artist_add_action == 0)... maybe that will help a bit?