[moteintheeye]

I've had a painful day of trying to get information from my live database using PHP but so far to no avail. I've created a test file, through which I've found out that the connection is being made (and hence all the connection details are correct) but for some reason, pulling information from the database fails. The code I've got works fine off-line and goes like this:

  $db = mysql_connect($dbserver, $dbusername,   $dbpassword) or die("Database Error: ".mysql_error());  
  mysql_select_db($dbname, $db) or die("Database Error: ".mysql_error());  
  $select = 'SELECT name FROM mote_proj WHERE id=1';
  $result = mysql_query($select, $db);
  while ($row = mysql_fetch_array($result)) {
    $nm = $row['name'];
    echo $nm;
  }

I've figured I'm still on PHP 4 but can anyone see where I'm going wrong?

Cheers,

Simon

[Tom]

Simon,

What are you entering for the dbserver?

Tom

[moteintheeye]

I've entered both "localhost" and "mysql.golf.xilo.net" (I know its not recommended but I was desperate).

I put in an echo to check if it is was connecting fine, and that came back saying OK, but getting it to pull out data is where I can't find a solution.

I wondered whether having an underscore in the table name was a problem, otherwise when specifying $dbname, do I keep or omit the log-in name that appears at the beginning of the name?

Otherwise I'm stumped!

Cheers

[Tom]

Simon,

Underscores in both the database name and username will not cause a problem but you do keep your username in the username and database name.

Normally something like;

username_databasename
username_databaseuser

Tom

[moteintheeye]

So that's how I have my databasename and databaseuser but I still can't get the data!

I tried changing the permissions for the user as it keeps coming back as read only (fine when I'm only getting data anyway) and even added a new user to test this, but no change.

So if there's no problem in the scripting, is there any other reason this can occur?

Is my site going to be hosted on golf if the database is?
Any other ideas?
Any simple way of checking the set up?
I developed on php 5 and MySQL 5 (I think) so am I going to have problems with lots of my scripts?

I've raised a ticket on this, so am i better keeping going there on here?
Service is much quicker here

Originally Posted by XILO-Tom

Simon,

Underscores in both the database name and username will not cause a problem but you do keep your username in the username and database name.

Normally something like;

username_databasename
username_databaseuser

Tom

[Tom]

Simon,

It could be a coding problem - if youve made it for PHP5 and MySQL5 - it is probable that you are using code for those versions that do not work with the versions we are running.

Golf will be the server you are on if the databases are there.

We've replied to your ticket but not heard back from you yet

Tom

[Kieran]

This may sound blindingly obvious, but seeing as I can see no fault with your code and you have had your script report that the connection to the database was successful, have you made sure that the username in question you are using to connect to the database has the required permissions to execute the query you have entered?

[Tom]

Also - possibly try and assign the permissions 'dba' and see if that helps

Tom

[moteintheeye]

I've checked my permissions if H-Sphere and it says that they are all ok, but is there a file I can edit to dictate this as it keeps on changing whenever I re-enter H-Sphere?
My assumption is that its all good, but worth checking.

Simon