Search DaniWeb - mysqlquery

Re: mysqlquery not working 11 Years Ago by Squidge > mysqlquery("SELECT image_id FROM image WHERE ???"); Why not : `mysqlquery("SELECT image_id FROM image WHERE user_id = $_SESSION['user_id']");` mysqlquery not working 11 Years Ago by hwoarang69 … that user_id_s is same line of image_id_g) neeeeeeeeeeeeed help here mysqlquery("SELECT image_id FROM image WHERE ???"); full code… Problem in updating Access 2003 database from VB 2008 13 Years Ago by gravikiran …DBUSERS" dbConn.Open() dadap = New OleDbDataAdapter(mySqlQuery, dbConn) dtable = New DataTable() cmdBuilder = …cmd.Transaction = trans Try cmd.CommandText = mySqlQuery cmd.ExecuteNonQuery() trans.Commit() Catch ex As… Variable Turns Null 13 Years Ago by keyroche …query properly if($query == ""){ return mysql_fetch_array($this->mysqlQuery); }elseif($query != ""){ return mysql_fetch_array($query); }else…NULL value if($query == ""){ return mysql_num_rows($this->mysqlQuery); }elseif($query != ""){ return mysql_num_rows($query); }else… Re: Problem in updating Access 2003 database from VB 2008 13 Years Ago by gravikiran …Application.Info.ProductName, "Settings", "LastLogIn", username) mySqlQuery = "UPDATE DBUSERS SET STATUS = 'ACTIVE' WHERE USERNAME='" … Dim trans as new OleDBTransaction = dbConn.BeginTransaction cmd = New OleDBCommand(mySqlQuery, dbConn1) cmd.Connection = dbConn1 cmd.Transaction = trans Try cmd.… Creating dll using c# 11 Years Ago by ZER09 …using MySql.Data.MySqlClient; namespace gLibrary { public class MySQLQuery { protected internal static string connectionString; public class ConnectionString… is to have something like this Using gLibrary.MySQLQuery; namespace something { class something { //then … Re: Variable Turns Null 13 Years Ago by keyroche …ICODE] itself knows that the variable [ICODE]$mysqlQuery[/ICODE] is a query resource, but as…quot;From numRows(): "; var_dump($this->mysqlQuery); $numberOfRows = mysql_num_rows($this->mysqlQuery); echo $numberOfRows; return $numberOfRows; } [/… it dumping the variable [ICODE]$this->mysqlQuery[/ICODE], and it shows as this: [… Re: Problem in updating Access 2003 database from VB 2008 13 Years Ago by lolafuertes … try you can change the lines [CODE]cmd = New OleDBCommand(mySqlQuery, dbConn1) cmd.Connection = dbConn1 cmd.Transaction = trans Try cmd….CommandText = mySqlQuery cmd.ExecuteNonQuery()[/CODE] by [CODE]cmd = New OleDBCommand(mySqlQuery, dbConn1, trans) Try cmd.ExecuteNonQuery()[/CODE… Re: Problem in updating Access 2003 database from VB 2008 13 Years Ago by gravikiran …Info.ProductName, "Settings", "LastLogIn", username) mySqlQuery = "UPDATE DBUSERS SET STATUS = 'ACTIVE' WHERE USERNAME='"…trans as new OleDBTransaction = dbConn.BeginTransaction cmd = New OleDBCommand(mySqlQuery, dbConn1, trans) Try cmd.ExecuteNonQuery() trans.Commit() Catch ex… Perl and MySQL 16 Years Ago by tech291083 …it. [/CODE] [CODE] [root@localhost PracPerl]# perl mysqlquery.pl Mysql connect('database=DVDRentals;host=localhost','root',...) failed: … user 'root'@'localhost' (using password: YES) at mysqlquery.pl line 12 Can't call method "selectdb&…quot; on an undefined value at mysqlquery.pl line 15. [/CODE] [COLOR=#000000]I … Re: Creating dll using c# 11 Years Ago by ZER09 so what you suggest for this thank you but is there a way to accomplish the code like this using gLibrary.MySQLQuery; Installing Script problems 15 Years Ago by missaaliyah … the first error page: [CODE=language]<?php function mysqlQuery($query){ $result=mysql_query($query) or die("<xmp… $result; } function getConfig() { $query = "SELECT * FROM config"; $result=mysqlQuery($query); // while ($row = mysql_fetch_array($result)) // { // $config = $row; // } $config = … Re: SQLQuery Help 14 Years Ago by finalist … lines to the queries.sql lines? Tried: richeditSQL.Lines.Assign(mysqlQuery.SQL); mysqlQuery.SQL.Assign(richeditSQL.Lines); Not working.[/QUOTE] May be… SQLQuery Help 14 Years Ago by Singlem … lines to the queries.sql lines? Tried: richeditSQL.Lines.Assign(mysqlQuery.SQL); mysqlQuery.SQL.Assign(richeditSQL.Lines); Not working. store SELECT query result in variable 13 Years Ago by zarulhamdi …;Initial Catalog=ozeki;Integrated Security=True") Dim mySqlQuery As String = "INSERT INTO ozekimessageout (receiver… 'test', 'send');" Dim mySqlCommand As New SqlCommand(mySqlQuery, myConnection) myConnection.Open() mySqlCommand.ExecuteNonQuery() myConnection.Close() End … Login Error 11 Years Ago by jclinx … to modify the code and using zymic database [http://mysqlquery.zymichost.com](mysqlquery.zymichost.com) first i create the index.html <… Re: Last 24 Hours 14 Years Ago by samuelmoneill …;) Debug.Print "Prev_date Formatted: "; prev_date MySQLQuery ("Select * from live_alarms Where Date_stamp = '"… cur_date_date = Format$(cur_date_date, "YYYY/MM/DD") MySQLQuery ("Select * from live_alarms Where Date_stamp = '" … Re: Vb.net SMS application 9 Years Ago by Logn …;Persist Security Info=True") Dim mySqlQuery As String = "INSERT INTO ozekimessageout…;', 'send');" Dim mySqlCommand As New SqlCommand(mySqlQuery, myConnection) 'mySqlCommand.ExecuteNonQuery() myConnection.Open() mySqlCommand.… Re: tables 17 Years Ago by digital-ether …($query); // pseudo funciton to query mysql $user_info = $table_rows[0]; // assuming mysqlQuery returns table rows in an array format, then the user… Re: MySQL 15 Years Ago by cwarn23 … of tutorials at [URL="http://www.tizag.com/mysqlTutorial/mysqlquery.php"]http://www.tizag.com/[/URL] Re: Creating a search which collects data from MYSQL Database and displays. 14 Years Ago by kekkaishi … take this tutorial at [url]http://www.tizag.com/mysqlTutorial/mysqlquery.php[/url]. Have a skim thru all the links. :) Re: Creating a search which collects data from MYSQL Database and displays. 14 Years Ago by Will Gresham … take this tutorial at [url]http://www.tizag.com/mysqlTutorial/mysqlquery.php[/url]. Have a skim thru all the links. :)[/QUOTE… Re: Cronjob for modify table content (replace) 13 Years Ago by pritaeas [url]http://www.htmlcenter.com/blog/running-php-scripts-with-cron/[/url] [url]http://www.tizag.com/mysqlTutorial/mysqlquery.php[/url] Re: Send email using PHP to multiple recipients in mysql db 12 Years Ago by Stefano Mtangoo [QUOTE=PatrikIden;1693843]how to get 1 email from mysql and send the mail to that emailaddress?[/QUOTE] 1. [URL="http://www.tizag.com/mysqlTutorial/mysqlquery.php"]MySQL Select[/URL] 2. [URL="www.w3schools.com/php/php_mail.asp"]PHP Mail[/URL] Re: php important QUESTION....???? 10 Years Ago by AARTI SHRIVAS mysql_query() function is used to execute database query in php. http://php.net/manual/en/function.mysql-query.php http://www.tizag.com/mysqlTutorial/mysqlquery.php http://stackoverflow.com/questions/12700741/apply-condition-on-mysql-query-in-php Re: upload photo other than jpg 9 Years Ago by RonKevinT.Manuela thanks should I do the same with mysqlquery? Re: How to count max occurence of rating 9 Years Ago by pzuurveen You don't do a [query](http://php.net/manual/en/function.mysql-query.php) checkout [www.tizag.com](http://www.tizag.com/mysqlTutorial/mysqlquery.php), [www.w3schools.com](http://www.w3schools.com/php/php_mysql_select.asp) Re: mysqlquery not working 11 Years Ago by dany12 ok if you make the select than you should trageted for the user that has that image this is my opinion Re: mysqlquery not working 11 Years Ago by hwoarang69 i not sure if i understant you Re: mysqlquery not working 11 Years Ago by hwoarang69 ah right. i was thinking some thing else. thanks alot squidge