installation problem with mysql gem

Hi,

Can someone help with my install of mysql gem? This is the error I have been getting. When I did the gem install of mysql there was no error. If you want to see the entire log of the install I will send it.

Thank you so much,

Joe

[Hosea:~/ruby] jja% cat bday.rb #!/usr/bin/env ruby

require 'mysql' require 'date'

m = Mysql.new("localhost", "root", "", "Development")

print "Birthday Report --- #{Date.today}\n" print "------------------------------------------\n" print " Name Birthdate Age DaysTil\n" print "------------------------------------------\n"

r = m.query("select name, dob, (TO_DAYS(CURRENT_DATE) - TO_DAYS(dob))/ 365.25 as age,              (DAYOFYEAR(dob) - DAYOFYEAR(CURRENT_DATE)) as daystil              from birthdays              order by daystil")

r.each_hash do |i|     printf( "%-10.10s %10.10s %5.2f %5.0f\n",             i['name'],             i['dob'],             i['age'],             i['daystil'] ) end

[Hosea:~/ruby] jja% bday.rb dyld: NSLinkModule() error dyld: Symbol not found: _mysql_stmt_store_result   Referenced from: /usr/local/lib/ruby/gems/1.8/gems/mysql-2.7/lib/ mysql.bundle   Expected in: flat namespace

Trace/BPT trap