Hi can someone help please, This Query works perfectly in phpMyAdmin but not threough the php on the website, It will not oput put a result, any ideas?
<?php @include("inclds/db_connect.php"); ?> Testing <!-- body { margin-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; } .holder { margin:0 auto; width:900px; padding:0;} .holder ul { margin:0; padding:0 1px; background:#000; width:902px; border-left:1px solid #666; border-right:1px solid #666;} .holder li { margin:0; padding:3px; list-style:none; height:24px; background:#CCC; border-bottom:1px solid #666;} .bold { font-weight:bold;}li.account { float:left; width:94px;}
li.fname { float:left; width:94px;}
li.laname { float:left; width:144px;}
li.cname { float:left; width:244px;}
li.joindate { float:left; width:144px;}
li.active { float:left; width:44px;}
li.edit { float:left; width:54px;}
li.hidden { display:none;}
–>
<?php
if(isset($_REQUEST["Submit"]))
{
if(!isset($_REQUEST["AccountNumber"])
or !isset($_REQUEST["FirstName"])
or !isset($_REQUEST["LastName"])
or !isset($_REQUEST["CompanyName"])
or !isset($_REQUEST["JoinDate"])
or !isset($_REQUEST["Active"])
or !isset($_REQUEST["ClientId"]))
{
//Error handling
echo "Error message";
}
else
{
$TableName = "Clients";
$AccountNumber = $_REQUEST["AccountNumber"];
$FirstName = $_REQUEST["FirstName"];
$LastName = $_REQUEST["LastName"];
$CompanyName = $_REQUEST["CompanyName"];
$JoinDate = $_REQUEST["JoinDate"];
$Active = $_REQUEST["Active"];
$ClientId = $_REQUEST["ClientId"];
$sql = "INSERT INTO Clients (AccountNumber, FirstName, LastName, CompanyName, JoinDate, Active)
VALUES ('$AccountNumber', '$FirstName', '$LastName', '$CompanyName', '$JoinDate', '$Active');";
echo $sql;
$result = mysql_query($sql);
if($result)
{
echo '
' . $result . ' record(s) updated'; } else { echo '
' . 'Update failed: ' . mysql_error(); } } } else { echo "I MADE IT HERE"; $sql = 'SELECT AccountNumber FROM Clients ORDER BY AccountNumber DESC LIMIT 1'; $result = mysql_query($sql) or die("Query failed ($sql): " . mysql_error()); while ($row = mysql_fetch_array($result)) { echo $row["AcountNumber"]; } echo "I MADE IT HERE TOO"; } ?>
' . $result . ' record(s) updated'; } else { echo '
' . 'Update failed: ' . mysql_error(); } } } else { echo "I MADE IT HERE"; $sql = 'SELECT AccountNumber FROM Clients ORDER BY AccountNumber DESC LIMIT 1'; $result = mysql_query($sql) or die("Query failed ($sql): " . mysql_error()); while ($row = mysql_fetch_array($result)) { echo $row["AcountNumber"]; } echo "I MADE IT HERE TOO"; } ?>
|