$result = mysql_query...

[comtek]

Below is a snip that I am playing with... everything appears to be working except:

$result = mysql_query ($query);

I get results from the $_POST and $query usig the print_r but nothing for the $results

Am I coding something wrong?




Code below:


if (isset($_POST['submit'])) {

require_once ('dbconnect.php'); // Connect to the database.

$query = "INSERT INTO patients (firstname, initial, lastname, dob, ) VALUES ('$firstname', '$initial', '$lastname', '$dob', NOW())";
$result = mysql_query ($query);

echo '<pre>';
print_r ($result);
echo '</pre>';

echo '<pre>';
print_r ($query);
echo '</pre>';

echo '<pre>';
print_r ($_POST);
echo '</pre>';

[HardCoded]

$query = "INSERT INTO patients (firstname, initial, lastname, dob, ) VALUES ('$firstname', '$initial', '$lastname', '$dob', NOW())"; 

MySQL will be erroring out on this query, something like fields not matching parameters.

You should issue queries with

 $result = mysql_query($query) or die(mysql_error()); 

while debugging

[jinkas]

also, if you print_r on a query result, you'll only get a result ID

if you want to actually see the data you'll have to fetch from the result