sheridan

i love you.

i'm about to try to start on the development of a script that when you type in a textarea at the bottom of a news page, it will post it up on the news site (basically a forum in that aspect) but also i want the news page to show the last 5 posts and then have pages of history after that point. i'm wanting to know the basic concept of doing something like this. i'm probably completely wrong, but i'm thinking querying the database for all entries and using pagination on those queries. but i'm trying to think of how to do that without it being a million different queries? i realize it'll probably use the incrementing ID, then i want to store author, time posted, and message of course, and a title. i know how to set it up database side i believe. just i don't know the best way to pull the information i want without having a lot of overhead or something

thats what i did after posting that, that idea hadn't hit me yet.

i programmed a security image thing, but i programmed it on my computer, so it's taking it's fonts from C:\WINDOWS\fonts the webserver i am trying to implement it on is UNIX..can anyone help on what to set the font path at to load a font? and what's a good font to use? i want to use a serif font since the terminal ones are easier to read via bots. thanks

i just went into the other room and installed WAMP5 on my desktop computer, everything worked perfectly. i came back in here, uninstalled XAMPP, installed WAMP5 on this computer. same problems. what is the difference?

windows

i'm trying to do this: have a local mysql and apache server configured with php where i can develop locally. i don't want anyone else able to connect or whatever, just a little development lab for myself. i've tried installing everything individually, i generally left the configs alone, just changed the root directory for apache. this apparently worked for my friend who also did it, but not moi. after that i uninstalled everything and just ran XAMPP, that didn't work out either. but i've looked at the configs and they don't have a problem with root logins and such.

i have mysql configured to allow root login. i have a friend who had same setup as me as far as i know..i told him how to install...and it worked for him.

i uninstalled everything and then installed it all back via XAMPP...phpMyAdmin isn't working with XAMPP because it says it can't load the php mysql extension. but it's enabled in the php.ini and i've pasted the php_mysql.dll in lots of places...just won't pick it up. i'm assuming this was my problem before that it wasn't loading the mysql extension for the functions i was trying to do?

that makes no difference

i have written a php script that was going to be used for user authentication. it won't work locally, but it will work on the webserver i have access to. i think it's never connecting to my database locally. here is the code: <?php $user = "root"; $password = "sheridan."; $database = "test"; mysql_connect(localhost, $user, $password); //@mysql_create_db($database) or die ("could not create database"); @mysql_select_db($database) or die ("Error: ID10T"); $query = "CREATE TABLE users ( id int(11) auto_increment, username varchar(20), password varchar(20), email varchar(30), fname varchar(20), lname varchar(20), PRIMARY KEY(id), UNIQUE(id), KEY id_2(id) )"; mysql_query($query); mysql_close(); ?> any suggestions? something on my computer locally is possibly preventing the connection? or perhaps it has to do with my configuration of the database or something of that nature?