Recent content by piki to to loss

HI i have a program tht can search through my table on my database and display the output with a while loop while ($row= mysql_fetch_array($result)) { $var=$row['var']; echo $var; } this code works perfect! but how could i make my results display as most recent first? like how can i make the...

HI i have a program tht can search through my table on my database and display the output with a while loop while ($row= mysql_fetch_array($result)) { $var=$row['var']; echo $var; } this code works perfect! but how could i make my results display as most recent first? like how can i make the...

Hi, I have run into a slight problem and was wondering if anyone could help me. ok first off I am trying to search the table 'friendships' on my database. in the this table there are 3 columns (sender, receiver,approved). i have set up a search engine bases off of this website...

ok i'm havign trouble filling in my timestamp field. it keeps showing up as 0000-00-00 00:00:00 how do i insert that current time of the user when they submit there id time in? like INSERT VALUES INTO table ('$time') what var/function can i use to get this value that will fit in with the...

When the website user preforms an action with the database i save it to my database (using NOW()) so it's in the right timpsace format. but how do i get it into Month, days year Hours:min:sec like i extracted the value off of my database and i have it set as a var. wht do i have to do to this...

Hi, you know how with tables in databases you can set an id field to auto increment so tht when u insert values u can just leave tht field blank and it will auto increment from the last time? likewise is it possible for me to set type so that if i leave the field blank (when inserting values)...

HI all. I know u can set mysql to auto increment a column number (say an id for example) but this involves creating a new row. Is it possible for the mysql to just have one row and keep incrementing that one number? If not what are some solutions I could use. I need to have a unique number for...

Hi I'm new yet learning really fast with php and mysql. I even made a small site just to check my skills out (www3.comli.com) My question is, is it possible to create a table that can add slots to it after it has been made. example if table_1 has the slots "id","email","name" and i create it...

Hi how do i get a value from my mysql table? & how can I set a php variable to a value on my mysql table? easy 10 points thanks

Hi, ok so i'm a HS student who is interested in electrical engineering. I want to get a feel of wht it is so as to better ensure if this is wht i want to do for a living. I'm quite taken with robotics and making "gadgets." My question is how hard would it be to make a calculator with an LCD...