[SOLVED] failure on query

[ccnaboy_2000]

$query = "INSERT INTO repository (url) VALUES ('".$link."')";
print $query. "<br /><br />";
mysql_query($query) or die("cannot execute query");

 

This is what it prints

 

INSERT INTO repository (url) VALUES ('http://ezinearticles.com/ssp/ezinearticles.xml')

 

cannot execute query

 

The $query value doesnt look bad? Whats wrong with the query?

[marknt]

try this

 

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

 

[HoTDaWg]

<?php
$query = "INSERT INTO repository VALUES ('".$link."')";
mysql_query($query,$yourlinktoyourconnection) or die(mysql_error());
?>

- here is the proper format in my opinion

- you can not echo anything since insert will insert, to echo you will need to use the SELECT statement:)

- heres a good tutorial on the select statement http://www.php-mysql-tutorial.com/php-mysql-select.php

[Waldir]

try

$query = "INSERT INTO repository (url) VALUES ('".$link."')";
print $query. "<br /><br />";
mysql_query($query) or die(mysql_error());

 

and post your error

[ccnaboy_2000]

well the echo was not a part of the $query variable that is passed to mysql_query. it was more for debugging the $query variable to make sure it had the correct data in it.

[ccnaboy_2000]

thanks guys I figured it out. I created the column with the wrong type. =D