Welcome Guest ( Log In | Register )



 
Reply to this topicStart new topic
> Php/mysql Function Problem
vizskywalker
post Jun 30 2005, 05:48 PM
Post #1


Techno-Necromancer
Group Icon

Group: Members
Posts: 1,018
Joined: 13-January 05
From: The Net
Member No.: 2,127



I am having a problem with some of the php/mysql functions. What I want to do is display the results that a MySQL shell would give a user when executing a query. Using the mysql_query() function I get a resource, but the mysql_fetch_row() and mysql_fetch_object() functions do not seem to be working. If requested, code can be provided, but what I'm looking for is more of an example on how to use these functions or other functions to display the output of a query. Thank you.

~Viz
Go to the top of the page
 
+Quote Post
miCRoSCoPiC^eaRt...
post Jun 30 2005, 06:13 PM
Post #2


PsYcheDeLiC dR3aMeR
Group Icon

Group: Admin
Posts: 2,242
Joined: 29-January 05
From: Nakorn Chaisri, Thailand
Member No.: 2,411



I'll make it sweet and short...

Take a look at this page: http://www.comptechdoc.org/independent/web...phpmysqlex.html

It has straight out examples of how to fetch all databse names, table names, field names and row results using those commands... all sandwiched together - but you shouldn't have problem figuring out. very easy syntax..

Regards,
m^e
Go to the top of the page
 
+Quote Post
vizskywalker
post Jun 30 2005, 06:37 PM
Post #3


Techno-Necromancer
Group Icon

Group: Members
Posts: 1,018
Joined: 13-January 05
From: The Net
Member No.: 2,127



Thanks, although that didn't have the solution, it led me to the solution. I need to have a user for the server, accessing anonymously was the problem.

~Viz
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. MySQL & PHP coding(9)
  2. Need Help With A PHP - MySQL Registration Script(13)
  3. Printing Out A Table(6)
  4. Need Some Help Using PHP & MySQL(4)
  5. [PHP + MySQL] Separating The Results By Pages(0)
  6. [PHP + MySQL] Encrypting Data(9)
  7. [php] Index.php?section=xx&pag=yy(6)
  8. How Do You Create A Secure Loging?(4)
  9. Important: Basics Of Using PHP And MySQL(9)
  10. Using The Php Mail() Function For Images Or Attachments(3)
  11. Need Help With Php/mysql And Web Servers Such As Asta's.(4)
  12. Need MySQL Alternative To The Syntax "or die()"(8)
  13. Re-order MySQL Table(11)
  14. PHP & MySQL: Displaying Content From A Given ID(6)
  15. How To Show Serial Nums In PHP Table For Contents Of MySQL DB(4)
  1. Php Mysql Errors(2)
  2. Sql Injection Prevention (passing Numerical Data Across Pages).(9)
  3. Php/mysql And Manual Page Caching?(4)
  4. Too Many Connections?(4)
  5. Extracting Mysql Maths Using Php(2)
  6. Anyone Know Of A Really Good Mysql Class?(4)
  7. Range Function(9)
  8. Warning: Mysql_num_rows()(1)
  9. Warning: Mysql_result(): Supplied Argument Is Not A Valid Mysql Result Resource In ...(4)
  10. Making A Link = Mysql_query(8)
  11. Making Something In Mysql Happen Only Once(10)
  12. Mysql Question(inserting Number From A Textfield)(3)
  13. Letting Users Add Mysql Data With Php(1)


 



- Lo-Fi Version Time is now: 6th September 2008 - 05:27 PM