Hamtaro
Feb 1 2005, 03:44 AM
| | I have a chat PHP script, that I need a little help with. I'm wanting to use PHP/MySQL so that it will show the most recent message first. What it's doing, is showing the oldest message first, and newest message last. Is there something I can do to reverse the order of the messages? Thanks.
(I know...I've had to ask for PHP help often, but I can't quite get a PHP book right now...sorry) |
Reply
LuciferStar
Feb 1 2005, 08:38 AM
first of all, you have to design your structure of the database, add a timestamp to each record,like that,you can sort all the records by timestamp, then you can reverse the record.
Reply
bjrn
Feb 1 2005, 10:55 AM
Well, the easiet fix would be to edit the query that gets the data from the database. Yo don't have to edit the database itself at all. If you have something like SELECT * FROM chats you should have SELECT * FROM chats ORDER BY date DESC Edit the table and field names to fit your database. I always get confused when sorting date fields, but I think DESC does newest to oldest, but if it still shows oldest first, replace DESC with ASC.
Reply
LuciferStar
Feb 1 2005, 02:23 PM
To avoid getting the whole data from the database, try: SELECT * FROM chats ORDER BY date DESC limit 10
Reply
Hamtaro
Feb 2 2005, 02:28 AM
Thanks a lot! That really helped! I had no idea that reversing the order was so si,mple! Also, thanks for showing me how to limit the data received from the dababase. That helped me out a lot!
Reply
Similar Topics
Keywords : reversing, order, items, database
- Ms-access Database Question
Allowing Web Access to the Informaton (3)
How Do I Connect To Live Database With Php Script?
while being hosted with ComputingHost (6) I am not new to programming. I want to create a form to add some values into my tables, the code
are all working. But I am not sure what is the URL to connect to my site's database. All along,
I have been testing through MAMP, which provides a local copy of mySQL. Can anyone lend me a hand?
My site's URL is http://limetouch.com/ ....
Connecting Php Site To Database
(6) Please Help Me with this site's error http://gatewaybiz.x10hosting.com/surf/ ....
Can Database Column Names Start With A Number?
Can database column names start with a number? (1) Can database column names start with a number or must they start with a letter like php vars? Like
my_table.1fieldname ? Does this vary from db system to db system? Is it considered good/bad form? ....
Auto Pruning An Sql Database With Php
How can i do this? (4) Hey all. Now i have a DB, an SQL DB, and i need to auto prune the data there to delete rows lder
than a certain time, lets say 2 months for now, the question is how do i do this? The obvious thing
is just to add a field which is the numerical representation of the month when the data is entered
and every time the DB is accessed it will check this number against the current month,in a numerical
format, and if the difference is two or greater that row is deleted, so if the month is January, it
would be O1 and if the current month is march then it would be O3 and the diff....
Read Xml And Import Into Database
question (2) hi all , i have one big problem i need to know , how i can read xml file and then save strings in
xml in database for example its my xml CODE <?xml version="1.0"?>
<numbers> <arash>1</arash> <kiarash>2</kiarash>
</numbers> i want my soruce read this xml file and then save string into arash field in
mysql database for example in this source arash string is " 1" and kiarash string is "2" my fields
in mysql are standard and we have 2 field with names "arash" and "kiarash" please help me , if yo....
Download Database Backup
Download Database Backup (0) Hi all i want write backup system like Phpmyadmin export in single file , my question is what is
backup query ? i must write manul query for backup for example loop query to get string form
database and write into one file or php have backup query ? thanks /wink.gif"
style="vertical-align:middle" emoid=";)" border="0" alt="wink.gif" /> ....
Editing Information In A Mysql Database And Deleting Rows
(5) I need help with a couple of things. First, I need to know how to retrieve information from a mysql
database and edit it then re add it to the database. I also would like to know how to easily delete
a mysql row. And I want this done without going to phpMyAdmin. Thanks for the help!....
Importing .csv Into Mysql Database
NEED HELP! (6) I need help importing a .csv contents into a Mysql database. I have this. But its not working.
CODE <?php connection = mysql_connect("******", "**********",
"********") or die ("Unable to connect to server"); $db =
mysql_select_db("b9_259782_CC", $connection) or die ("Unable to select
database"); fopen ('csvranks.csv', 'r');
mysql_query("INSERT INTO test_table (id, name, guild, level, exp) ?> What
am I doing wrong? The mys....
Php Search Engine Script For Mysql Database
(11) A search engine is provided to facilitate the user with undemanding and clear-cut search options.
The search facility includes simple search, search by title, search by word/phrase, ect… Thus, the
user is at a safe distance from the risk of selecting files/folders ambiguously. In addition, a
history of recent searches can be preserved for future perusal. Now
day’s visitors have a large option for his needs on internet and so visitors are not vesting their
time by following the dead links on your site. So a search engine is essential for your....
Problem To Join Tables In Database
Problem in joining (many to many) relation (3) Please help me. I'm building a group of database fro a program. the situation is like this:
'user' may have 1 or more class(es). 'class' itself may have 1 or more user in its
classroom. I'm bad at explaining... maybe like this: A program is made to write data of
classroom. Hikaru has a math class at Monday and statistic class at Tuesday. The math class itself
consists of about 50 students in a classroom. So, Hikaru (user ) may have one or more class at
time, math class (class) may have one or more students at time. So, basically I must mak....
File In Database
Question.thanks (1) Hi all i write this code i want when you see download.php (this code) my file goes for download for
user sorry my english is not very good its a file database project for my university but when i
browse this code my soruce file (.zip) echo in my page and dont goes for download my next querstion
about safe mode i saw (php.net and zend) when safemode is on file databaseing and header() is not
working . is it true ? if is it true i save my file at hosting and no (database) i want write
standard script . plz help me thanks more and more CODE include("config.php&....
Code To Install Mysql Database Table?
(5) Can anyone show me example code of how to install a database table instead of me having to upload an
file with it in, so i can do it from a php page? Thanks in advance ;-)....
Showing Numbers Of Mysql Entries In A Database Table
It should be easy, but I don't know how... (7) I have a database, and need to know how to show the numbers of entries. So, if there are 10 entries
in the selected database table, it will show the number 10 . I'm pretty sure this should be
easy, but I don't know how to do it. Can someone tell me? /smile.gif"
style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" />....
Crontab Automated Database Backup
using crontab to make automated database (2) i'd like to make an automated database backup as following: 1- i would like to optimize my
databse's tables. 2- I would like to remove any existing backup tarfile. 3- I dump the database
to a /tmp file. 4- I tar the database dump and then delete it. i wrote the following shell: CODE
#!/bin/sh rm -rf /tmp/mybackup.sql.tgz mysqldump -uroot -pmypass --opt mybackup >
/tmp/mybackup.sql.backup cd /tmp/ tar -zcvf mybackup.sql.tgz mybackup.sql.backup rm -rf
/tmp/mybackup.sql.backup ....
Login / Authetication System Using Database
adding information (4) Is there any way to make such database where I can write like name and passwords.. Then make an
login box, and when somebody trys to acces the login he needs to write the name and password.. Then
it is verifyed if is there such name and password and if it is then acces the page.. I think there
is posible something like that with MySQL (db).. but can anybody say me a script or way to make
something like that? Alredy thanks......
Can You Add Images Into A Mysql Database?
Using Php? (20) I'm learning php in class right now, but I'm still not that good at it, what I'm
wondering is when I write the php so that it can connect with a database, can I at the same time
have it that it is able to display back images that I choose. Like, I want a search feature, where
you can search for a keyword, and it will bring back a list of all the possible entries with that
keyword, but each of these entries will have a photo associated with it. Now, do I put these image
files directly into the database, or do I write the code to link them from my files to th....
Is Doing The Whole Database / Php Thing Worth It?
Question from the inexperianced... (13) I'm planning on a site redesign, and I'm going to add some very basic php includes in there,
because I've managed to figure out how to do them. I wanted to use them to do includes of my
navigation, so I'd only have to update in one place when new links are added, as opposed to
having to update several pages all at once. I'm not sure what else php can be used for, and I
did a search on it, and it pretty much all said includes and databases. Well, databases, I
don't know how to make, and I was wondering if it's really worth my time to figure i....
Database Extraction Layer
Does php has Database extraction layer? (1) Hi PHP geeks, Do you know if php has Database extraction layer? like Java has. Which is used for
development of database layer, so it become easy to change the database if you wish to without
modifying so much code underneath.... Any ideas is welcome. I am sure there should be something
which is being used and reliable and mature. I am new to PHP so want to use it if it is there. Good
to know from experienced developer about there developing experience. Thanks in advance.....
Script That Deletes A Row In A Mysql Database Usin
(1) I have just made a script that deletes a row in a mysql database using an image as a button.
However it will only work in FireFox and not in IE. Can any one see away around this and help me
root out the problem. This is the script in short: PHP Code: CODE $query_products =
"SELECT * FROM manufacturer ORDER BY name ASC";
include('external_files/pagination.php'); // If the form was submitted, delete
the items selected from the database
if(isset($_POST['delete'])){ $query = 'DELETE FRO....
Personal Blog
[ Database Required ] (4) Okay, after a week, I have successfully created a personal web blog. I first created it using a flat
text file, I but realized that it was just too limited like that. So, I redid it in a
database-compatible manner. NOTES: CODE - This blog does not support comments yet. If you
want, you can build on this script by creating a comment system as well. I may also update it
with a comment system in the future. - You should have an average to intermediate knowledge of
MySQL commands and database manipulation in general, especially if you want to add a ....
Help Importing Mysql Database Results
Need help formatting link (3) I am having trouble formatting my table to display the results of a mySQL query the way I want.
Here is the part of my code: CODE $result = mysql_query("SELECT * FROM uploads
WHERE Category='Drama'") or die(mysql_error()); ?> <table
cellspacing="2" cellpadding="2"> <tr> <th>Title</th>
<th>Author</th> <th>File</th></tr> <?php // keeps
getting the next row until there are no more to get while($row = mysql_fetch_array....
Writing To Database Problem With Mysql - Not Writing Forum Post
(3) I'm making a forum and I've had several problems tonight which I've come here to ask
then found the answer to myself, but this one is stumping me. Whenever it goes to write the post to
the database, it saves the poster, and the time, but the part where the message would go is empty.
Here's the code, with comments about what it's supposed to do (what I wanted it to do and
thought it did): CODE $imsg = stripslashes($_POST['msg']);
//Get message if(strlen($imsg) > 5 && strlen($imsg)....
Mysql Edit
editing info in a MYSQL database (4) I have a simple database with a php form thats inserts the info into the database, and another file
that extracts the info to display the info on another page.... Now my question is ......how do i
add the EDIT button to edit the database??? here is my database CODE CREATE TABLE `businesses`
( `id` int(10) NOT NULL auto_increment, `business` varchar(255) NOT NULL
default '', `description` text NOT NULL, `emailaddress` varchar(255) NOT NULL
default '', `website` varchar(255) NOT NULL default '', ....
Chatbox / Guestbook
No Database required (2) Okay, this is a simple script that lets your visitors enter in messages via a chatbox/guestbook. You
can use this how you like. Adjust it if need be. It's very simple, so there is much room for
improvement. Enjoy! CODE echo "<form action='chatbox.php'
method='get'>"; echo "Name: <input type='text'
name='visName' size=15><br>"; echo "Message: <input
type='text' name='message' size = 15><br>"; echo "<input
type='submit' value....
Guestbook Script
(Using Flat Files, no database) (2) Okay, I wrote a cool little Guestbook script a few weeks ago. It is very simple (one page of php)
that uses flat files (text files). Using this script, you never need to use a database (you can if
you want, but that's up to you). Anyways, here is the php code. Enjoy! CODE <?php
print "<form action='whateverthepageis.php' method='post'>"; print
"* Your name: " . "<input type='text' name='yourName'>";
print "Email: " . "<input type = 'text' name = '....
Looking for reversing, order, items, database
|
*RANDOM STUFF*
*SIMILAR VIDEOS*
Searching Video's for reversing, order, items, database
*MORE FROM TRAP17.COM*
|
advertisement
|
|
