[MYSQL Date]

So if you have in your table 3 rows...ID, (id) the date posted (p_date) and the content (content)

 

to upload,

mysql_query("INSERT INTO example (id, p_date, content) VALUES(null, NOW(), 'whatever' ) ") or die(mysql_error());   

 

to display it row by row

$result=mysql_query("SELECT * FROM example");

while ($row = mysql_fetch_array($result)){
echo 'ID - '.$row['id'].'<br>';
echo 'Date - '.$row['p_date'].'<br>';
echo 'Content - '.$row['content'].'<br>';
}

 

try that >_>

 

(adapt it of course)

 

Do i need to make a new file or add it to an existing one?

 

That's just how you fetch the information include it in your current file and use variables to store the information and display it only whenever you need it. If that makes since?

 

The point im trying to get to is where do i add the code i made the table in PHPmyadming now I keep getting a load of code but have no idea what to do with it and where to add it.

[MYSQL Date]

So if you have in your table 3 rows...ID, (id) the date posted (p_date) and the content (content)

 

to upload,

mysql_query("INSERT INTO example (id, p_date, content) VALUES(null, NOW(), 'whatever' ) ") or die(mysql_error());   

 

to display it row by row

$result=mysql_query("SELECT * FROM example");

while ($row = mysql_fetch_array($result)){
echo 'ID - '.$row['id'].'<br>';
echo 'Date - '.$row['p_date'].'<br>';
echo 'Content - '.$row['content'].'<br>';
}

 

try that >_>

 

(adapt it of course)

 

Do i need to make a new file or add it to an existing one?

[MYSQL Date]

But how do i get the code from the table i created in PHPmyadmin??

[MYSQL Date]

Hey,

 

I have set up a mysql database with a date feature. I need this date feature to work so when it is submitted it will show the date it was submitted. Everything is done apart from this so I am very keen to get it finished. I made the table in phpmyadmin and now I do not know whats next. If its to complicated to explain in a post feel free to add me on msn steve@whitepixeldesign.com.

 

Thanks

[dreamweaver and php]

wiked you got it working

[Education Level]

Depens on the company but experience helps

[Is this the real price of websites?]

it's stupid there just accepting some bad quality site for a cheap price

[HTML Help!]

Yes try making it in ie.

 

[ff bug?]

Ok good you got everything working

[User System + Word onto picture]

I need a user system where people can sign in. Then they need to be able to type info in eg. name etc. then choose a design and the text goes over the design. Also a rep system so they can be giving good rep or bad rep. Please email stephen@cogrid.co.uk for more info.

 

P.S this is a free project, but is willing to have advertisment or portfolio work.

 

 

[Text Over Picture and user system]

I need a system so people can select a design then n a form put like there email address then it is put on the design. This needs to be able to be edited. Which means it will need a user system. This will be an unpaid project but contact me on stephen@cogrid.co.uk for more info orif your intrested.

 

Steve

[Project needs you]

Hey Guys,

 

I have a new idea that has brilliant potential. I dnt want to post it because many can copy but if your intrested in making php then read on.

 

If you become a programmer you will be investing yout time and work. Then when we earn money you get paid, as simple as that. So intrested? Add me on msn steve@adr.ulmb.com and speak to me. If you dnt have msn send an email to stephen@cogrid.co.uk.

 

Cheers

[Tournament System (Unpaid)]

Hey,

 

I need a simple tournament system for my new site i am making named Total Battles.

 

• Registering and Login
  
• Create Clan
  
• Invite Player to clan
  
• Edit Clan
  
• Challenge Team
  
• Report Loss
  

 

You would get full credit for site and can add to portfolios, add your copyright and have links to your site.

 

Intrested? Add me on msn at steve@adr.ulmb.com.

 

Many Thanks,

Steve

[Gaming Ladder (unpaid)]

Hey,

 

I need a gaming ladder created for my new gaming site. If your intrested contact me.

 

Email/MSN - steve@adr.ulmb.com