Jump to content

Recommended Posts

Posted (edited)

umm you think iv not done that.

php has like 50 pages and sql has like 4 results and there not waht i need.

I just need to be abel to get query from database.

hrm i just was thinking i think i figured it out for myself to put it to test right now...

Edited by kcd-clan
Visit mEMy programs made.Iul - IulG-V Console - G-V Console_RandomLetter - _RandomLetter()Saftey Kill - Saftey Killcolorzone() = colorzone()
Posted

Post your script, I should be able to help you find your problem.

~cdkid

AutoIt Console written in C#. Write au3 code right at the console :D_FileWriteToLineWrite to a specific line in a file.My UDF Libraries: MySQL UDF Library version 1.6 MySQL Database UDF's for AutoItI have stopped updating the MySQL thread above, all future updates will be on my SVN. The svn location is:kan2.sytes.net/publicsvn/mysqlnote: This will still be available, but due to my new job, and school hours, am no longer developing this udf.My business: www.hirethebrain.com Hire The Brain HireTheBrain.com Computer Consulting, Design, Assembly and RepairOh no! I've commited Scriptocide!
Posted (edited)

#include <MySQL.au3>
$sql = _MySQLConnect("usn","pwd","root","somehost.com")
$qur = _Query("SELECT * FROM `users`");Get every column from the "users" table
With $qur
While NOT .eof;Do until we've reached the last record
If $qur.Fields("username").Value = "username" then;Check username
$pass = $qur.Fields("password").Value
exitloop
EndIf
.MoveNext;Move to the next record
WEnd
EndWith
_MySQLEnd($sql)

Replace the values such as "sa", "somehost.com", and "root" with your

Username, Password, Host, and Database

Replace "SELECT * FROM users" with

"SELECT * FROM " and your user table

etc.

~cdkid

Edited by cdkid
AutoIt Console written in C#. Write au3 code right at the console :D_FileWriteToLineWrite to a specific line in a file.My UDF Libraries: MySQL UDF Library version 1.6 MySQL Database UDF's for AutoItI have stopped updating the MySQL thread above, all future updates will be on my SVN. The svn location is:kan2.sytes.net/publicsvn/mysqlnote: This will still be available, but due to my new job, and school hours, am no longer developing this udf.My business: www.hirethebrain.com Hire The Brain HireTheBrain.com Computer Consulting, Design, Assembly and RepairOh no! I've commited Scriptocide!

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...