Problem with insert query

[floridaflatlander]

I have worked on this for hours and can't find the problem.

 

My $r doesn't query for some reason

I've tested the database connection and variables with echo statements and they work, also there is an SELECT statement above this that checks to see if the name is in use and it works like it is suppose to. I just can't get this code to work.

I have php5, the database connection with host, user, pw and database name are correct and isn't redefined or exited. The SELECT I mentioned uses the same connection.

 

Can any one see whats wrong with this

 

$q = "INSERT INTO vendors (id_vendor, name, s_discrip, discript, phone, zip, id_loca, email, web_title, web_url, photo, date_reg)

VALUES (NULL, '$name', '$s_discrip', '$discrip', '$phone', '$zip', '$loca', '$email', '$ws_title', '$ws_url', 'photo', CURRENT_TIMESTAMP);";

 

$r = mysqli_query($dbc, $q);

 

Thanks

S

[PFMaBiSmAd]

How about using mysqli_error($dbc) to get php/mysql to tell you why the query is failing?

[Maq]

If I had to take a wild guess, it would be that one of your fields is an integer and you're passing in a string.

[PFMaBiSmAd]

Un-escaped data?

[floridaflatlander]

I use mysqli_connect_error() ,  all tables are in the same database as the location table that fills out a drop down menu to get $loca and that works so I have a db connection.

 

I only have two integer columns. One is auto_increment and the other is a number representing the location

[Pikachu2000]

I use mysqli_connect_error() , 

 

Really? Where? It isn't in the code you posted.

[floridaflatlander]

The mysqli_connect_error() comes in in an include statement before the queries, DB_HOST etc. are defined with define statments.

 

$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME) OR die('Could not connect to MySQL;'. mysqli_connect_error());

 

if (!$dbc){

trigger_error('Could not connect to Mysql: ' . mysqli_connect_error());

}

 

Also would think all is OK since I use two selects on the form that enters the info, one to check for user name the other to get location IDs

[Pikachu2000]

Oh, not mysqli_connect_error(), mysqli_error(). The latter is used to report errors in query executions.

if( !$result = mysqli_query($dbc, $query) ) {
     echo "<br>Query string: $query<br>Resulted in error: " . mysqli_error($dbc) . '<br>';
}

[floridaflatlander]

Duh,  this is embarrassing, I spent all afternoon looking at this stuff.

 

The column name for the description is  descrip not discript.

 

Thanks to all for the help. I can't say it enough.

 

S

 

[Pikachu2000]

We've all done something like that, no biggie.

[DavidAM]

We've all done something like that, no biggie.

 

NOT ME!! 

 

Well ... not today at least. --- OK, actually, not since lunch. 

[Maq]

We've all done something like that, no biggie.

 

NOT ME!! 

 

Well ... not today at least. --- OK, actually, not since lunch.