error in MySQL

[saiman]

Good day for all, i have some question about MySQL database..

i have code

<? include "connect.php";?>
<?

 mysql_select_db ("$my_database");
   
$string=$_POST['string'];
if (!empty($string))
{

mysql_query("INSERT INTO test(phrase) VALUE('$string')");
}
?>             
                       
<?
$query = "SELECT phrase FROM test";
$result = mysql_query($query);
$i=0;
while ($row = mysql_fetch_array($result)) {
   $arr[$i]=$row['phrase'];
$i++;
}
$rand=rand(0,$i-1);
?>
<div align=center><img src="bigheart.gif"></div>
  <div style="position: absolute; top: 299px; left: 145px;right:145px; font-family: Arial; font-style: normal; font-variant: normal; font-weight: bold; font-size: 11px; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none; color: rgb(0, 0, 0);"><?php echo "$arr[$rand]";?></div>

in "connect.php" i choose my host,pass,login and database...
$mysql_host="mysql-cossacks.x10hosting.com";

all right,but i have ERROR "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in "... i tested this code in local machine and it work

Somebody help me plz(

 

[Gouri]

The mysql host should be localhost
$mysql_host="localhost";

the database name should be like cpanelusername_databasename
the database username should be like cpanelusername_databaseusername

 

[priyaa161]

try to use "localhost" in place of "mysql-cossacks.x10hosting.com".

 

[saiman]

i corrected connect.php

$mysql_host="localhost";
$mysql_login="saiman_root";
$mysql_password="************";
$my_database="saiman_test";

 $link = mysql_connect("$mysql_host", "$mysql_login", "$mysql_password")
   or die ("Could not connect to MySQL");

but all the same i see error =(

 

[vishal]

i corrected connect.php

$mysql_host="localhost";
$mysql_login="saiman_root";
$mysql_password="************";
$my_database="saiman_test";

 $link = mysql_connect("$mysql_host", "$mysql_login", "$mysql_password")
   or die ("Could not connect to MySQL");

but all the same i see error =(

Check your database name and fields .Whether the character case are same or not.

 

[saiman]

hmm...i choose mysql_login=saiman_root ! it's correct data

 

[Gouri]

Hi saiman,

change the query url to this so we can know where exactly the error is.

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

 

[priyaa161]

<?php
$dbhost = 'localhost';
$dbuser = 'saiman_root';
$dbpass = '************';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');

$dbname = 'saiman_test';
mysql_select_db($dbname);
?>

http://www.php-mysql-tutorial.com/wikis/mysql-tutorials/connect-to-mysql-database.aspx

 

[saiman]

Hi saiman,

change the query url to this so we can know where exactly the error is.

ohh,i see error No database selected
it's mean what i selected incorrect name database...
why i can't come into phpmyadmin?(

 

[priyaa161]

ohh,i see error No database selected
it's mean what i selected incorrect name database...
why i can't come into phpmyadmin?(

You have not selected any of the database. You need to add this line:

mysql_select_db($dbname);

 

[Gouri]

You have not selected any of the database. You need to add this line:

mysql_select_db($dbname);

He used but he has to keep it with in the connect.php

@ priyaa161 check the first post code.

 

[saiman]

ohh..i have new error

<?
$dbname="saiman_test";
 mysql_select_db ("$dbname") or exit(mysql_error());   //Access denied for user 'saiman_root'@'74.63.233.5' to database 'saiman_test'
   
$string=$_POST['string'];
if (!empty($string))
{

mysql_query("INSERT INTO test(phrase) VALUE('$string')");
}
?>

What does it mean?

 

[Anna]

In cPanel, under mysql database, you need to assign the user to the database and give it all available privileges.