Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 199903

[PHP3] data doesn't seem to be INSERT INTOing From: Alan Wicks (aswicks <email protected>)
Date: 03/14/99

Greetings,
I have created a db and table (mSQL) and am absolutely sure
that they are there. They were both created above this step
in the same program and I polled the table to return the
variable names. It acts as though the data is not being
inserted into the db. This is for mSQL. Any ideas? Code
is below. Thanks, Alan S. Wicks.
--------------
// enter data into the fields: fields var1 char(5), var2
char(10), var3 int.

msql($dbname, "INSERT INTO $table1 VALUES ('HERE', 'THERE',
'100')");
msql($dbname, "INSERT INTO $table1 VALUES ('NOW', 'THEN',
'200')");

echo "POST_INSERT<BR>"; //this shows up.
/*
Gets here. I have tested for validity
of names $dbname and $table1.
*/

$selstr = "SELECT * FROM $table1";
$result = msql($dbname, $selstr);
echo "RESULT = $result<BR>"; //this value comes back as 5

$result_count = msql_NumRows($result); //this value comes
back as zero (0).
echo "RESULT COUNT = $result_count<BR>";
echo "NUMBER OF ROWS = " . msql_NumRows($result); // this is
zero 

--
PHP 3 Mailing List   http://www.php.net/
To unsubscribe send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest list:  php3-digest-subscribe <email protected>
For help: php3-help <email protected>  Archive:  http://www.php.net/mailsearch.php3
List administrator:  zeev-list-admin <email protected>