[SOLVED] Mysql error

[affordit]

I get this error

 

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)

From this query

 

<?php
include("k_falls_dbinfo.inc.php");
mysql_connect(mysql,$username,$password);
@mysql_select_db($database) or die(mysql_error());
$query_content= "SELECT * FROM content_table WHERE item = $mynumber";
$result=mysql_query($query_content) or die(mysql_error());

echo $query_content['heading'];
echo "<BR>";
echo $query_content['image'];
echo "<BR>";
echo $query_content['description'];
echo"<BR>";
echo $query_content['description'];
?>

 

Can someone tell me whats wrong?

[CerealBH]

im sure ur aware "mysql" dosn't have $ infront of it? are u connecting to another server or is it ont he localhost?

[avo]

Hi

 

Check this line

 

mysql_connect(mysql,$username,$password);

 

Your missing $

 

should be

mysql_connect($mysql,$username,$password);

 

[affordit]

I don't use the $ on any of my queries and the others work OK. I am connecting to the yahoo servers.

[p2grace]

First of all, you need the $ or static text.  If the server's on the localhost you could just change it to that with quotes around it.  After that try changing the code to this:

 

<?php
include("k_falls_dbinfo.inc.php");
mysql_connect('localhost',$username,$password); // this would have to be $mysql if it's not on the localhost
@mysql_select_db($database) or die(mysql_error());
$query_content= "SELECT * FROM `content_table` WHERE `item` = '$mynumber'";
$result=mysql_query($query_content) or die(mysql_error());
$arr = mysql_fetch_assoc($result);
extract($arr);
echo $heading;
echo "<br />";
echo $image;
echo "<br />";
echo $description;
?>

[affordit]

OK tried all of the above and I still get the error

 

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)

 

I also dropped the table and rebuilt it and inserted a record to test it still get the same error.

 

I ran queries on the other tables and dbs and they all work fine.

 

Thanks for taking the time to look

 

Any other suggestions??

[Codein]

I get this error

 

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)

From this query

 

<?php
include("k_falls_dbinfo.inc.php");
mysql_connect(mysql,$username,$password);
@mysql_select_db($database) or die(mysql_error());
$query_content= "SELECT * FROM content_table WHERE item = $mynumber";
$result=mysql_query($query_content) or die(mysql_error());

echo $query_content['heading'];
echo "<BR>";
echo $query_content['image'];
echo "<BR>";
echo $query_content['description'];
echo"<BR>";
echo $query_content['description'];
?>

 

Can someone tell me whats wrong?

 

Firstly, you're missing $ from the start of mysql.

 

However, the most prominent error I can see is here:

 

$query_content= "SELECT * FROM content_table WHERE item = $mynumber";
$result=mysql_query($query_content) or die(mysql_error());

echo $query_content['heading'];
echo "<BR>";
echo $query_content['image'];
echo "<BR>";
echo $query_content['description'];
echo"<BR>";
echo $query_content['description'];

 

 

$query_content doesn't hold any information called from the database. It just holds the mySQL query you wish to execute as a string. $result is what holds the information that has been extracted from the db. However, you can't just extract information from this so you must do:

 

while ($info = mysql_fetch_array($result)) {
echo $query_content['heading'];
echo "<BR>";
echo $query_content['image'];
echo "<BR>";
echo $query_content['description'];
echo"<BR>";
echo $query_content['description'];
}

 

What this does is loop through the raw information extracted from the database and then puts it into an array, where the keyname for each element is the column header (like, 'heading', 'image', etc).

 

I hope this helps

[p2grace]

Is the database and the php server on the same box?

[affordit]

Codein  Thanks it did help me understand a little better about how the while loop works.

I got it working now I had to drop the db and recreat it then it worked thanks for all your help!!

 

p2grace  Yes they are they are both on the Yahoo servers Thanks for your help I now have a better understanding of mysql_fetch_assoc You guys have a great day

 

Thanks

[darkfreaks]

Hit solved topic plz