Page 1 of 1

php wont insert into ...

Posted: Sun Feb 01, 2009 7:37 pm
by pepe_lepew1962
Hello:

I am trying to get my insert into mysql to work and it just plain does not work. I have copied the insert part into a text file and manually executed the code via source and it works but for some reason it won't via php. Is there someting I am missing or not getting?

<?php
// Loop to pass the variables from previous script
//
foreach (array_keys($_POST) as $key)
{
$$key = $_POST[$key];
//print "$key is ${$key}<br />";
print "$key ==> ${$key}<br />";
}
//
//
mysql_connect("localhost", "root", "xxxxxxxxx") or die('Could not connect: ');
mysql_select_db("test") or die('Could not connect again: ');
//
$sql = ("INSERT INTO tblnadda (tblNADA_User01,tblNADA_User02) VALUES ('namef','namem')") or die('Could not add records ');

$result = mysql_query("SELECT * FROM tblnadda");

$num_rows = mysql_num_rows($result);

echo "$num_rows Rows\n";
//
?>

Re: php wont insert into ...

Posted: Sun Feb 01, 2009 8:31 pm
by requinix
Maybe it's just me but it looks like you're missing a "mysql_query" in there.