khuti

hi, duno if this seems easier for u, but i find it easier to do things like this.. $db = mysql_connect("localhost", "user", "pass"); mysql_select_db("database_name", $db); $result = mysql_query("SELECT * FROM table_name ORDER BY sumink_like_id_is_always_good ASC", $db); while($row=mysql_fetch_array($result)) { echo("name ur field:" . $row['field_name']); echo("if more than one thing u can do it like this"); echo("1: " . $row['field_name'] . " 2: " . $row['2nd_field'] . "); } mysql_close(); --- hope this helps.. khuti

hi, i think ur starting out in sumthing too deep personally, if u no anything about programming u would no how easy it is to do that.. i would suggest starting off with sumink like vbscript.. its not used much these days but its easy to get to grips with. once u understand the conecept of programmin.. things like this n javascript will b much easier. anywho what u wana do is call the field from the database isnt a variable so like.. $record_no = $row['tables_field_name'] + 1; then u display it like.. echo("recored number: " . $record_no . " - "); if u dont no how to do the rest of the code like a database connection n query or if none of this makes any sense. id would seriously giv up on this stuff for now. go learn sumink easier like i said above. n come bk to this later when ur feeling more comfortable with programmin. hope this helps, khuti

hi, duno if this is guna mean anything but ive recently installed linux on one of my machines with apache php n mysql all set up.. ive dun a phpinfo() test on the localhost bit.. and it works.. it also has the mysql info on there so im sure its all set up ok. ive set up a super user on the mysql bit and set up a basic small database with it. rite question 1: ive tried to create more users so i dont always have to sign in as the super user for mysql.. but when i log out and try to sign in as the new basic users.. it says access denied.. can any1 help me understand why? im pretty sure ive done it all rite. question 2: when i try to access my database through php i get nothing. i cant understand why, im like 99.5% sure my coding is correct. ive uploaded to images so u can see what i get and what my code is.. also ive put in little hello/hi/boo things to determine where the code is getting stuck. ull see what i mean.. links:pic1 - pic2 if anybody knows the prob or can help me to solve this prob so i can get my local server thingy workin properly id really appreciate it. im dying to get this up so i can save time creating my webpages n stuff. thanks for your time readin.. khuti