mysql query problems

DKY

someone please look over this query, I'm having problems. For some reason its not creating a row. The whole code is below, but I'm narrowing it down to just this snippet. the if statement works cause when I put something in the "po_history" input box and click submit I echo it out at the bottom just to see if its creating the value in the if statement after the submit button is pressed and it is. What's not creating a value is the po_history_query and the po_history_result at the bottom. I don't know what the problem is. I just can't figure it. any help is appreciated. Thanks in advance

<? 
$table = "hotlines"; 
$submit  =  $_POST["submit"];  

if ($submit == "Submit P.O. History")  

{  

$po_history = $_POST["po_history"]; 
$po_history_query = "INSERT INTO $table (po_history) VALUES ('$po_history')";     

if (!($po_history_result = mysql_query($po_history_query)))  

{  

    $mcrmessage = mysql_error();  

    echo "$mcrmessage<br>";  

    die();  

}  

}  

$disconnectmysql = mysql_close($connectmysql); 
echo "<br>$table<br><br>"; 
echo "$po_history<br><br>"; 
echo "$po_history_query<br><br>"; 
echo"$po_history_result"; 
?>

<html><head><title>PDC Hotline Form Tab 3</title>
<LINK REL="STYLESHEET" HREF="style.css">
<meta http-equiv="imagetoolbar" content="false"></head>
<body topmargin="2" leftmargin="0">
<?

require("connect.php"); 
$connectmysql               = mysql_connect($host,$user,$password) or die ($cantconnectmysqlmessage); 
$db                         = mysql_select_db($database,$connectmysql) or die ($cantconnectdatabasemessage); 


?>


<FORM ACTION="<?$PHP_SELF?>" METHOD="POST" NAME="PO_History">
<p align=center>
<table width="550" cellspacing="0" cellpadding="0" border="0" bordercolor="#000000">
<tr>
<td><p align=center><font id='header'>P.O. History</font><br><br></td>
</tr>
<tr>
<td><p align=center><TEXTAREA NAME="po_history" ROWS="20" COLS="100%" WRAP></TEXTAREA></td>
<tr>
<td><br><p align=center><INPUT TYPE="submit" NAME="submit" VALUE="Submit P.O. History"></td>
</tr>
</table>


<?
$table = "hotlines";
$submit  =  $_POST["submit"]; 

if ($submit == "Submit P.O. History") 
{ 

$po_history = $_POST["po_history"];
$po_history_query = "INSERT INTO $table (po_history) VALUES ('$po_history')";	

if (!($po_history_result = mysql_query($po_history_query))) 
{ 
    $mcrmessage = mysql_error(); 
    echo "$mcrmessage<br>"; 
    die(); 
} 
} 
$disconnectmysql = mysql_close($connectmysql);
echo "<br>$table<br><br>";
echo "$po_history<br><br>";
echo "$po_history_query<br><br>";
echo"$po_history_result";
?>

</form>

</body></html>

Azala

Try this:

<?
if ($_POST['submit'] == "Submit P.O. History")
   mysql_query("INSERT INTO hotlines (po_history) VALUES ('".$_POST['po_history']."')") or die (mysql_error());

mysql_close($connectmysql);
?>

If that doesn't work then you have an error in your SQL which mysql_error() should report.

Azala

DKY

I've made the edits and it now looks like so. To see the page go to http://dky.sytes.net/hotlines/PO_History.php
it still doesnt work.

<html><head><title>PDC Hotline Form Tab 3</title>
<LINK REL="STYLESHEET" HREF="style.css">
<meta http-equiv="imagetoolbar" content="false"></head>
<body topmargin="2" leftmargin="0">
<?

require("connect.php"); 
$connectmysql               = mysql_connect($host,$user,$password) or die ($cantconnectmysqlmessage); 
$db                         = mysql_select_db($database,$connectmysql) or die ($cantconnectdatabasemessage); 


?>


<FORM ACTION="<?$PHP_SELF?>" METHOD="POST" NAME="PO_History">
<p align=center>
<table width="550" cellspacing="0" cellpadding="0" border="0" bordercolor="#000000">
<tr>
<td><p align=center><font id='header'>P.O. History</font><br><br></td>
</tr>
<tr>
<td><p align=center><TEXTAREA NAME="po_history" ROWS="20" COLS="100%" WRAP></TEXTAREA></td>
<tr>
<td><br><p align=center><INPUT TYPE="submit" NAME="submit" VALUE="Submit P.O. History"></td>
</tr>
</table>


<?
if ($_POST["submit"] == "Submit P.O. History")
   mysql_query("INSERT INTO hotlines (po_history) VALUES ('".$_POST['po_history']."')") or die (mysql_error());

mysql_close($connectmysql);



echo "<br>$table<br><br>";
echo "$po_history<br><br>";
echo "$po_history_query<br><br>";
echo"$po_history_result";
?>

</form>

</body></html>

but, if I make a file from scratch with no form and no if statement that looks like this it works perfectly fine.... Maybe there is something wrong with my if statement

<?

require("connect.php"); 
$connectmysql               = mysql_connect($host,$user,$password) or die ($cantconnectmysqlmessage); 
$db                         = mysql_select_db($database,$connectmysql) or die ($cantconnectdatabasemessage); 


$po_history = "testing testing 12345";
mysql_query("INSERT INTO hotlines (po_history) VALUES ('$po_history')") or die (mysql_error());

echo "<br><br>$table<br><br>";
echo "$po_history<br><br>";
echo "$po_history_query<br><br>";
echo"$po_history_result";
mysql_close($connectmysql);
?>

Azala

put this in your form:

<input type="hidden" name="INSERT" value="GO">

Then change the IF statement to:

<?
if ($_POST['INSERT'] == "GO")
   mysql_query("INSERT INTO hotlines (po_history) VALUES ('".$_POST['po_history']."')") or die (mysql_error());

mysql_close($connectmysql);
?>

DKY

Now it looks like this and still doesnt work, I'm baffled.

<html><head><title>PDC Hotline Form Tab 3</title>
<LINK REL="STYLESHEET" HREF="style.css">
<meta http-equiv="imagetoolbar" content="false"></head>
<body topmargin="2" leftmargin="0">
<?

require("connect.php"); 
$connectmysql               = mysql_connect($host,$user,$password) or die ($cantconnectmysqlmessage); 
$db                         = mysql_select_db($database,$connectmysql) or die ($cantconnectdatabasemessage); 


?>


<FORM ACTION="<?$PHP_SELF?>" METHOD="POST" NAME="PO_History">
<input type="hidden" name="INSERT" value="GO">
<p align=center>
<table width="550" cellspacing="0" cellpadding="0" border="0" bordercolor="#000000">
<tr>
<td><p align=center><font id='header'>P.O. History</font><br><br></td>
</tr>
<tr>
<td><p align=center><TEXTAREA NAME="po_history" ROWS="20" COLS="100%" WRAP></TEXTAREA></td>
<tr>
<td><br><p align=center><INPUT TYPE="submit" NAME="submit" VALUE="Submit P.O. History"></td>
</tr>
</table>


<?

if ($_POST['INSERT'] == "GO")
   mysql_query("INSERT INTO hotlines (po_history) VALUES ('".$_POST['po_history']."')") or die (mysql_error());

mysql_close($connectmysql);
?>
</form>
</body></html>

Azala

If this doesn't work i'm missing something basic here...

<?php 

require("connect.php");  

$connectmysql               = mysql_connect($host,$user,$password) or die ($cantconnectmysqlmessage);  

$db                         = mysql_select_db($database,$connectmysql) or die ($cantconnectdatabasemessage);  

if ($_POST['INSERT'] == "GO") 
   mysql_query("INSERT INTO hotlines (po_history) VALUES ('".$_POST['po_history']."')") or die (mysql_error()); 

mysql_close($connectmysql);

?>
 <html><head><title>PDC Hotline Form Tab 3</title> 
<LINK REL="STYLESHEET" HREF="style.css"> 
<meta http-equiv="imagetoolbar" content="false"></head> 
<body topmargin="2" leftmargin="0">

<FORM ACTION="PO_History.php" METHOD="POST" NAME="form1"> 
<input type="hidden" name="INSERT" value="GO"> 
<p align=center> 
<table width="550" cellspacing="0" cellpadding="0" border="0" bordercolor="#000000"> 
<tr> 
<td><p align=center><font id='header'>P.O. History</font><br><br></td> 
</tr> 
<tr> 
<td><p align=center><TEXTAREA NAME="po_history" ROWS="20" COLS="100%" WRAP></TEXTAREA></td> 
<tr> 
<td><br><p align=center><INPUT TYPE="submit" NAME="submit" VALUE="Submit P.O. History"></td> 
</tr> 
</table>
</form> 
</body></html>

DKY

Originally posted by Azala
If this doesn't work i'm missing something basic here...

hahaha, yeah you and me both. I put the code you suggested in a different file called pohistory2.php and changed the form action to pohistory2.php and it doesnt work either.

http://dky.sytes.net/hotlines/pohistory2.php

Azala


<?php 
if ($_POST['INSERT'] == "GO") 
   print $_POST['po_history'];
?>
 <html><head><title>PDC Hotline Form Tab 3</title> 
<LINK REL="STYLESHEET" HREF="style.css"> 
<meta http-equiv="imagetoolbar" content="false"></head> 
<body topmargin="2" leftmargin="0">

<FORM ACTION="test.php" METHOD="POST" NAME="form1"> 
<input type="hidden" name="INSERT" value="GO"> 
<p align=center> 
<table width="550" cellspacing="0" cellpadding="0" border="0" bordercolor="#000000"> 
<tr> 
<td><p align=center><font id='header'>P.O. History</font><br><br></td> 
</tr> 
<tr> 
<td><p align=center><TEXTAREA NAME="po_history" ROWS="20" COLS="100%" WRAP></TEXTAREA></td> 
<tr> 
<td><br><p align=center><INPUT TYPE="submit" NAME="submit" VALUE="Submit P.O. History"></td> 
</tr> 
</table>
</form> 
</body></html>

This works fine on my web server.

DKY

I put the above code in a file on my server called test.php and here it is.

http://dky.sytes.net/hotlines/test.php

it doesn't seem to give me the result back.

Azala

Did you configure anything in your .htaccess file?

Are you running PHP in some weird modus...?

I have no clue what's wrong with your server config but that code is working.

DKY

so, it works on yours, but not on mine, right? at least it seems that way to me. maybe if I upgrade my php? As far as server config, I've never configured anything but the php.ini file. All I did to that was change the location of php and put it in the system folder, you know. Just simple first time configuration stuff.

DKY

YES!!! the test.php script seems to work. I upgraded my php from 4.0.5 to the latest 4.3.10

Azala

Yep, works on my web server .

Although I find it strange that some PHP works and some don't.

Do try to upgrade PHP or get an ISP that has it already set up properly.

That's all the advice I have at this point i'm afraid.

Try searching google, sometimes people have had the same problems and have posted solutions at some message board far far away.

Cheers.

Azala

Great, i'm happy for you!

Make sure you always have the latest, if only to be sure you got the latest security fixes installed.

DKY

I can't thank you enough, it still seems buggy, but I think I can continue from here. I'm probably forgetting a " or something. Thanks again I appreciate it.