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!

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...
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?