[RESOLVED] Alpha Links giving error (Help)

phpstuck

I get the following error when I try this... I think maybe I am becoming too cross eyed from staring at it and thinking the refresh button will fix it somehow magically if I click it one more time!

A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z |
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Group\Apache2\htdocs\test\MPfinal\noupload\alphatest.php on line 14

As you can see the link (letters) show up and actually work. They will append to the url (...?letter=A ) If I remove the query and just put an echo statement in, the letter will print that I have ust clicked on.... Any help would really be greatly appriciated!

<?php
include 'db.inc';
echo "<font face='arial' size='2'> <b>";
$alphabet = range('A', 'Z');
foreach ($alphabet as $letter) {
    echo '<a href="' . $_SERVER['PHP_SELF']
        . '?letter=' . $letter . '">' . $letter . '</a>  |   ';
}



$query = "SELECT * FROM define WHERE name LIKE '". $_GET[letter] . "%'";
   $result = mysql_query($query);
   while($record = mysql_fetch_assoc($result)){
     while(list($fieldname, $fieldvalue)=each($record)){
       echo $fieldname.":<b>".$fieldvalue."</b><br>";
     }
     echo "<br>";
   }
?>

bpat1434

Well, there is a syntactic error in your query probably, or your database isn't filled with the right information. and of course, an obvious question for you:

Are you connecting to the database in previous code that you're not showing? If not, then you need to connect to it first. If so, then the query isn't returning anything, or it's returning one result.

What you should do is to print the query:

$query = "SELECT * FROM define WHERE name LIKE '". $_GET[letter] . "%'";
print_r($query);
   $result = mysql_query($query);

See if it's structured as you want it to be. If not, you've got a starting point. If it is, then go check your mySQL database and see if has the values you're looking for.

Yet another possiblity is that when you first load the page, it looks for a query of something like:

"SELECT * FROM define WHERE name LIKE '%'"

Also, is your table named "define"?

~Brett

phpstuck

All that did was print the entire query line and the letter I am clicking on at the end.. However it still does not pull anything from the database. Yes the database is called define, my db file is correct and I can pull items from it onto the page without the alpha link. However when I add the alpha link something is going bad. I have read and read and read and cannot find anything that helps be with the fetch for this one.

bpat1434

Printing the query was the point. That way you can see what query is actually being run on the database so you can double check to make sure the query that is being run is the one you want.

I do have some ideas....

What does your database setup look like? I'm trying to recreate it on my end, and don't know what your database looks like so I can only go so far.

~Brett

phpstuck

I really appriciate the help... Here is the database.

-- Table structure for table `define`

CREATE TABLE define (
defineid int(11) NOT NULL auto_increment,
lifetype varchar(25) NOT NULL default '',
username varchar(20) NOT NULL default '',
word varchar(50) NOT NULL default '',
define text NOT NULL,
uses text NOT NULL,
post_date datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (defineid)
) TYPE=MyISAM COMMENT='definitions' AUTO_INCREMENT=37 ;

bpat1434

Okay, so let me ask you this:
If you run a query looking in the column "name" for a value that starts with "A" and has anything after it, what exactly do you expect to retrieve?

I only ask that because in your query you say you want to grab info based upon the "name" column, yet in your table dump, there is no column titled "Name".

You can see that my test page works perfectly fine: phpStuck's Alpha Page

And here's my table structure that I am using:

CREATE TABLE `define` (
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=261 ;

Hope that you can see the minor error in your table/query.

~Brett

phpstuck

Hmmmm.... I think now I will go hide somewhere.... I had changed the name in the table the evening before this all started giving me headaches.... And well Ummmmm sometimes the simplest things aren't the most obvious. LOL well thank you for the extra set of eyes you certainly figured that one out. I am sorry that I missed that. Marking this as resolved.

bpat1434

awesome... glad to hear you figured it out...

~Brett