Re: help me

Christo wrote:
I discovered that if i enter the id manually then it works, I do have
this field setup as auto inc and as PK and as not null, shouldn't this
field automatically assign its self a value of the next auto inc number
without mee having to input the id raw in the php code?

I would appreciate some help here as this has been an aim of mine for
some time to get mysql qworking and I am so so close.

TIA

Chris

PS - sorry if it appears as top posting, they look nicer on google
groups that way

thanks again

Chris


Christo wrote:

OK.

I have a mysql database and i have it displaying whats currently there
using php, the problem is that I cannot insert into the database
correctly. please check my code below

<?php
$username = "root";
$password = "************"; //edited
$server = "localhost";
$dbname = "dbname";

$title = $_POST["title"];
$news = $_POST["news"];
$id = $_POST["id"];
$date = "2006-15-11 00:15:15";

$dbc = mysql_connect($server, $username, $password) or die ("ERROR");
$select = mysql_select_db($dbname, $dbc) or die("couldn't connect to
dbname");

$sqlquery = "INSERT INTO tnews VALUES('$id','$title','$news','$date')";

//print "<html><body><center>";
//print "<p>You have just entered this record<p>";
//print "Title : $title<br><hr>";
//print "$news<br>$date";
//print "</body></html>";

print $sqlquery;
$results = mysql_query($sqlquery);

mysql_close($dbc);

?>

this submits the info from a form, the code for the form is below:

<form method="post" action="add.php">
Title: <input name="title" type="text" value="">
<input type="hidden" name="id" />
<br>
News: <input name="news" type="text" value="">
<br>
<br>
<input type="submit" name="submit" value="Submit">
</form>

I can see the insert query fine and it appears to be working however
the data isnt being put in the database. I am hosting php on my home
computer and it is being used with apache I am also hosting mysql on my
own computer and am using SQLyog and the GUI toold from mysql to
administer the db, I am a novice so please go easy but can anyone see a
reason why i cant get this data to appear in my database table?

Please please help me!!



As Carl said. Check the result of mysql_query() and, if it is false, call mysql_error(). This will tell you what your problem is.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================
.

Quantcast