FRIHOST • FORUMS • SEARCH • FAQ • TOS • BLOGS • DIRECTORY

You are invited to Log in or Register a Frihost Account!

SQL Insert

Frihost Forum Index -> Scripting -> Php and MySQL

This is my code

Code:

$sql = "mysql_query(INSERT INTO banners (by, linkurl, bannerurl) VALUES ('$by', '$linkurl', '$bannerurl'))";

Some reson it wont insert into my database.

this is the stru

Code:

CREATE TABLE `banners` (
`id` INT(11) NOT NULL ,
`by` VARCHAR(30) NOT NULL ,
`linkurl` VARCHAR(150) NOT NULL ,
`bannerurl` VARCHAR(150) NOT NULL,
PRIMARY KEY (`id`)
) TYPE = MYISAM ;

Its not putting any thing into the database

DanielXP wrote:

This is my code

Code:

$sql = "mysql_query(INSERT INTO banners (by, linkurl, bannerurl) VALUES ('$by', '$linkurl', '$bannerurl'))";

Some reson it wont insert into my database.

What reason?
You are not showing the mysql_query() call. Are you calling mysql_query()?

Find the reason it wont insert by checking MySQL error

Code:

$sql = "INSERT INTO banners (by, linkurl, bannerurl) VALUES ('$by', '$linkurl', '$bannerurl')";
$res = mysql_query($sql);
if (!$res) {
$reason = mysql_error();
echo '<p class="error">There was an error.<br>';
echo 'The error was: <b>', $reason, '</b><br>';
echo 'Please <a href="mailto:you@example.com">report</a> a bug. Thank you</p>';
exit(0);
}

DanielXP wrote:

This is my code

Code:

$sql = "mysql_query(INSERT INTO banners (by, linkurl, bannerurl) VALUES ('$by', '$linkurl', '$bannerurl'))";

Some reson it wont insert into my database.

this is the stru

Code:

CREATE TABLE `banners` (
`id` INT(11) NOT NULL ,
`by` VARCHAR(30) NOT NULL ,
`linkurl` VARCHAR(150) NOT NULL ,
`bannerurl` VARCHAR(150) NOT NULL,
PRIMARY KEY (`id`)
) TYPE = MYISAM ;

Its not putting any thing into the database

the code should be this:

Code:

$sql = mysql_query("INSERT INTO banners (by, linkurl, bannerurl) VALUES ('$by', '$linkurl', '$bannerurl')");

LOCK PLEASE

-close-

Related topics

Visitor notebook for php
An idea to stop people NOT reading TOS.
MySQL DB Backup script - minor problem
Help with mysql query
image upload, and return url to image
how to simplify these codes?
Login System Tutorial Part 1 Creating Registration
execute php string

forum fireboard sur joomla 1.5
SQL
SQL
Prefix 0 in int data type in SQL
.sql problem
Trying to move SQL database
importing SQL databases
Error, insert query failed - My nick is'nt a db friend =/

how to insert data into mysql base from a web page
Need to know what Phpbb databases to insert when registrati
[man] SQL Error : 1054 Unknown column \'session_admin\ en DB
Problems with SQL
SQL Injection
sql problem
Validating sql statements
Strange SQL cursor problem. Pls do not ignore if can help.

This topic is locked: you cannot edit posts or make replies.

Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2007 Frihost, forums powered by phpBB.