Jump to content


Photo

PHP/MySQL


  • Please log in to reply
3 replies to this topic

#1 Beere

Beere

    Young Padawan

  • Members
  • Pip
  • 15 posts

Posted 31 October 2004 - 08:00 PM

I have created an 'add tutorial' system in php/mysql. It all works out perfectly. The only thing I need help with is to get the tutorials out from the database. I want to be able to show them on my site you know :)

cheers
//Beere

#2 Unreal

Unreal

    like.. TOTally cool!

  • Members
  • Pip
  • 241 posts

Posted 01 November 2004 - 03:56 PM

we cant realy help you if you dont show us a part of your script..

#3 Gio

Gio

    Jedi In Training

  • Members
  • PipPip
  • 317 posts

Posted 01 November 2004 - 05:55 PM

Show the db table, and any other useful code please...

#4 rc69

rc69

    PHP Master PD

  • P2L Staff
  • PipPipPipPip
  • 3,827 posts
  • Gender:Male
  • Location:Here
  • Interests:Web Development

Posted 02 November 2004 - 11:04 AM

$sql = mysql_query("SELECT * FROM table");

while($r=mysql_fetch_array($sql)){
echo "$r[title]<br>
$r[description]<br>
$r[program]
<hr>";
}

try something like that... but change things around, if you know how to insert the stuff then you should know what else you want in the sql statement, and in the $r[blah] area:

since its in an echo you dont need $r['blah'], just change blah to the name of the column you want displayed

and if you're still confused, show something to help us out (i.e. the table structure, php version, ect...)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users