Page 4 of 5

Posted: Tue Aug 15, 2006 12:40 pm
by RobertGonzalez
At this point here, it is not. It is coming from the images table.

Code: Select all

$result = mysql_query("SELECT * FROM images");
while ($row = mysql_fetch_array($result)) {
     $images[$row['name']] = $row['value'];
} 

$max_results = $row['maxshow']; 
// As of theline above $row is the result from the select on the images table

Posted: Tue Aug 15, 2006 12:50 pm
by adamb10
I updated the code to change max_results stored in settings. I forgot to change the variable. Even after changing the variable it still didnt work.

I think I need a new pagination script since it never worked anyways.

Posted: Tue Aug 15, 2006 12:57 pm
by RobertGonzalez
Try a different one. There are a few in the snippets forum I believe.

Posted: Tue Aug 15, 2006 1:23 pm
by adamb10
I'm redoing the entire database since I used columns before. :X

Posted: Tue Aug 15, 2006 1:34 pm
by RobertGonzalez
How much expeirence do you have with PHP and databases? Just wondering.

Posted: Tue Aug 15, 2006 2:05 pm
by adamb10
I thought I had a moderate amount but now I think I'm a n00b at it. I've used MySQL for around 1 1/2 years now.

Posted: Tue Aug 15, 2006 3:59 pm
by RobertGonzalez
Cool. It just seemed like you were getting crossed up a bit in that script you were using. It's all good. We are here to help. Keep plugging away at it and sooner or later you'll be a PHP Codemonkey like the rest of us.

Posted: Tue Aug 15, 2006 6:48 pm
by adamb10
The script is a guestbook and is actually one of the more advanced ones out there. I got Custom BBCode, World Filter, Baning, search(broken now), and soon smiley management.

Anyway I just found out that every query in the script has to be rewritten so now I'm kinda <span style='color:blue' title='I'm naughty, are you naughty?'>smurf</span> off.

Posted: Tue Aug 15, 2006 7:19 pm
by RobertGonzalez
Well, good luck. Remember there are a lot of seasoned developers here that are willing to help you figure out your stresses and messes.

Posted: Tue Aug 15, 2006 8:26 pm
by Weirdan
World Filter
that should be great! Image

Posted: Wed Aug 16, 2006 8:09 pm
by adamb10
I need some help again creating a table in my database.

This table requires an id field. I set up 3 fields...

name
value
id

The id is a primary key with auto increment. I create 2 rows called ip and reason but this is where the problem resides...

Image

What do I do about it?

Posted: Wed Aug 16, 2006 9:03 pm
by RobertGonzalez
What are you trying to do with this table?

Posted: Wed Aug 16, 2006 9:22 pm
by adamb10
Its to hold ips and a reason. It's for banning visitors from the script.

Posted: Wed Aug 16, 2006 9:37 pm
by RobertGonzalez
You are going to need a little more in your table. Maybe like this...

ban_id ( int(11), autoincrement, primary key)
ban_user_id (int)
ban_date
ban_release_date
ban_ip
ban_reason (varchar(255) or text)

Posted: Thu Aug 17, 2006 8:59 am
by adamb10
Why do I need the additional info?