Recent content by perlone

Thank You. I was thinking about varchar(15) too.

Hi, I'm using phpMyAdmin and what 'type' of feld do you think IP address should hold? So far I have 'TEXT'. Is this ok? Thanks.

Thank You!

Hello, I'm creating a voting system and I was wondering if you could help me. I have 2 columns - gid,IP. `gid` is the ID for game and `IP` is for IP Address. gid | IP 6 |xx.xxx.xx 7 |xx.xxx.xx 6 |xx.xxx.xx 6 |xx.xxx.xx I want to display the results like this: GID | Votes 6 | 3 7...

Thanks again, it works like a charm :)

Hello again, If I wanted to search for the game `title` as well, can you show how to do it? So far I did this but don't work: my $sql = 'select title,keywords from index_tble'; @array = map {'%' . $_ . '%' } split(/\s+/,$q); if (@array){ $sql .= " where "; my @a; push...

Hello Coderifous, Thank you so much for your kind code. It works very well and it loads faster as well. Thanks again :)

Hello Coderifous, Thank You so much for your code, but when I tried your code, I got the following error: Cannot execute statement! called with 1 bind variables when 0 are needed

Thank You Guys. You guys are eally helpful :)

Thank You! It works a lot better :)

Hello, I'm really new to regular expressions and I was wondering if anyone could give me a hand. What I have is some data on mySQL which contains `title`, and `keywords` and I want the user to search through the title and keywords. Here's an example: Table: games ID | Title | Keywords...

oh thanks. That makes my life alot easier :)

Hello, I'm creating a program where users gets to add a review about a specific product, so far I created normal like when they add the 'comments', it adds to the database. I'm using mySQL for database and I was wondering if anyone could show me how to lock something with DBI. Thank You.

Hello, I have a database filled with keywords and the program let you search for it. For example of my data: [keywords] quest,alien,campy,3d What I want to do is let you search through the keywords. So I have the following: $q=param('q'); if ($keywords =~/$q/i) { print "match"; }...

thank you!