Today's Posts Follow Us On Twitter! TFL Members on Twitter  
Forum search: Advanced Search  
Navigation
Marketplace
  Members Login:
Lost password?
  Forum Statistics:
Forum Members: 24,254
Total Threads: 80,792
Total Posts: 566,472
There are 2031 users currently browsing (tf).
 
  Our Partners:
 
  TalkFreelance     Design and Development     Programming     PHP and MySQL :

Insert into database help?

Thread title: Insert into database help?
     
    Thread tools Search this thread Display Modes  
Prev Previous Post   Next Post Next
08-04-2008, 06:07 PM
#1
Caden is offline Caden
Status: Junior Member
Join date: Jul 2006
Location: Denver, Colorado
Expertise:
Software:
 
Posts: 66
iTrader: 0 / 0%
 

Caden is on a distinguished road

Send a message via AIM to Caden Send a message via MSN to Caden

  Old  Insert into database help?

OK I have this form that inserts stuff into a database so I can later display the information I insert. And I order it by newest, the code I use for that is

Code:
$queryRecent = "SELECT name FROM table ORDER BY name DESC LIMIT 0,10";
Is this wrong or right? What I want it to do is display the newest one I inserted on top, because it's a Top 10 Recent Updates section. It inserts everything I do, but sometimes doesn't display it before the older ones I've inserted which is the whole point of this script.

But anyway, when I looked in phpMyAdmin in my table, it had some of the stuff I entered into it, but also a bunch of empty fields as well. What could be the problem?

     


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 

  Posting Rules  
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump:
 
  Contains New Posts Forum Contains New Posts   Contains No New Posts Forum Contains No New Posts   A Closed Forum Forum is Closed