[Resolved] setting up test query

[skeetley]

I am setting up a test query.

This is my code:

<?php
$dbh=mysql_connect ("localhost", "user", "pass") 
or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("user_events"); 

$query = "SELECT * FROM events_yxh";
$result = mysql_query($query);

if ($result) {
    while ($array= mysql_fetch_assoc($result)) {
        print "$array[event_title]";
    }
} else {
    print "<li>No results.</li>";
}
?>

Now I connect to the db fine, but my query doesn't work. I keep getting No results. I have a table called events_yxh and it has two test records in it. It has to be something simple I am missing, but I can't figure it out. I know you guys will see it right away and I thank you for your help.

Shout out to batman for all his help in a different thread.

[Hiccup]

if ($result) {
    while ($a= mysql_fetch_array($result)) {
        print "$a['event_title']";
    }
} else {
    print "<li>No results.</li>";
}
?>

Try that...

[skeetley]

Thanks but I get:
Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' on line 11

Line 11: print "$a['event_title']";

[Hiccup]

Do you have a column named event_title?

If yes, try this:

echo $a['event_title'];

I think it's the double quotes screwing it up...

[skeetley]

When I take the double quotes off as you suggest, it returns the dreaded No results message.
I have a column in my table called events_title. It is there I swear. It is of type varchar(60).
There are two records in there and both have an event_title.

I guess if the coding is sound, it has to be a problem with my table, but it looks go to me.

[laserlight]

Well, make a check then:

<?php
$dbh = mysql_connect ("localhost", "user", "pass") 
	OR die('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("user_events");

$query = "SELECT * FROM events_yxh";
$result = mysql_query($query)
	OR die('Query error: ' . mysql_error());

if ($result) {
    while ($array = mysql_fetch_assoc($result)) {
        print $array['event_title'];
    }
} else {
    print "<li>No results.</li>";
}
?>

[skeetley]

Ahh, I finally figured it out.

I was using a right username, but one without access to that part of the database. So it didn't get rejected at the first error, but couldn't retrieve any results.

Thanks for all your help.