record not adding
I am really stuck in this one, Ii just can't get it working.
when i check my table after running this code, the record never gets added.
If you happen to spot the problem ( i am sure most of you will) please drop me a quick post and guide me)
// the table in which i am adding this record is called (BusFile) it is under a database called (Business)
<title>Business PHP add</title>
foreach($HTTP_POST_VARS as $varname => $value)
$db1=mysql_connect($dbhost, $dbuname, $dbpass);
echo "Record Added<br><a href=\"BusinessAdd.htm\">click here</a>
to return to Business Information Control<br>";
$query="INSERT INTO BusFile set ".
Have you done any error checking to make sure the query worked?
i am using phpmyadmin sir, i am not certain about the query check but when i open the table to see teh records, it still says zero records?
thank you very much for reading my post and trying to help me.
what is this "set" doing in an INSERT Statement? I think it has to be "values".
I dont have any idea of this "mysql" but am aware of simple PL/SQL. might be, this works out in mysql too...
I have tried it every way i know how ( not many, but acouple lol)
I am givng up, i hope a more experienced gemtlemen can help me.
your insert statement is not standard (and doesn't follow the other form)
INSERT into table(column_list..) VALUES(value_list...);
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)