11,093 Topics
 | |
 | I'm playing around with SQLite, which is very similar to what i've seen in MySQL, and I want to write some code that returns the column names along with the data for output purposes. Is there an SQL query I could use to do that, or is it done differently … |
| | i made this code but it shows result Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\VertrigoServ\www\sanjay\rlc\closing.php on line 14 [code]<? include("admin/include/conn.php"); $today=date("Y-m-d H:i:s",strtotime("+5 hours, +30 minutes")); $c_closing="select * from member_information where child >=2"; $c_closing_query=mysql_query($c_closing); while ($c_row=mysql_fetch_array($c_closing_query)) { $c1_query="select * from member_information where Mem_sponsor_id=".$c_row['Id']." limit … |
| | I have XAMPP installed on my computer and started all features. When I type to browser on PC in my lan IP adress of my computer it shows me xamp welcome screen with everything working. But when I start demos which uses mysql databases (CD Collection or Phone Book) it … |
| | Basically I have created a site where someone can view a table which contains information about various servers. They can also create a report from this table selecting the fields they want to see in their report. Each field can be selected through a checkbox and there are 16 different … |
 | I have a drupal user table: [CODE]+------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+----------------+ | uid | int(10) unsigned | NO | PRI | NULL | auto_increment | | name | varchar(60) | NO | UNI | | | | pass | varchar(32) …  |
| | Hi there, basically i'm trying to write a php script that allows me to retrieve the tour dates for my band from a MySQL table. I want the gigs.php page to show every upcoming gig that there is. On gigs.php i want a link to gigarchive.php which features all passed … |
| | Hi, I am using this query for count [ICODE]SELECT Count(ID) from Table[/ICODE] But its showing the count of all the fields which are empty and zeros. I want the count of fields which are empty and zero. please guide me. Thanks. Take care.  |
 | Hi All, Im trying to find a method to allow files to be: 1. Uploaded and stored in a mysql database 2. List them, with "change" and "delete" options 3. Allow them to be downloaded, or even just viewed I have tried using blobs, but to no avail. I have … |
| | hello all: i am using mySQL and I created a few tables and I am learning how I can use the SQL query on multiple tables. The following are the results which are quite confusing and it will be helpful if someone can help me understand as to how this … |
| | Hi guys , i want to fill a textbox with a data from my mysql database and i dont know how to do it , i already searched without a result , if someone can help me i would appreciate it . |
| | I just want to dispay all row from mysql table but got error as following: Note:I am using hostgator and try to display 40,000 query. [CODE]Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/firstint/buygadget/sitemapg.php on line 11 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in … |
| | Hi all Problem is I want to return unique results based on 2 fields: I have a table tags_photos which is a join table and has 2 fields: tagId and PhotoId. I want to create a page which has a list of all tags and a thumbnail against each tag. … |
| | God i'm having a terrible time trying to do this. Does anyone know how to set a javascript variable as a query result from a MySQL database. As an example, like this: Set this query: [CODE]$query4=mysql_query("select price from pricelist where item='$result3[item]'"); $result4=mysql_query($query4);[/CODE] into a variable: [CODE]var price[/CODE] i just can't … |
| | Hello, I need to write a query for MySQL in vbscript that is just not coming to me. I have written it in vbscript with two SQL statements then did a date comparison in vbscript but it just grinds the server to a halt. What I need to do is … |
| | I have two problems: [LIST=1] [*]the download from mysql tables on unix system render some incorrect characters on imported tables on windows system [*]html generated by my php application reading that data appears incorrect - in some special character - . But, if I refrech my page, then the incorretness … |
 | "Error in my_thread_global_end(): 1 threads didn't exit" i got this error when i m trying to access my site....... please help me out fast!!!!!!!!!!!! and i m developer so i have no server access to change anything related core PHP and MYSQl directory....... :sad: Please Anybody Help!!!!! :'( Thanks in …  |
| | |
 | Greetings, I'm wanting to learn how to use PHP to check for things like how phpBB or PostNuke do during installation. For the PHP stuff, I would imagine that I'd use fread() (or a combination of functions like that) to check for a php.ini, then use it to determine the … |
| | Hello All, I am fairly new to PHP ... I am trying to build a basic order form for a small wholesale database and am completely stuck. The function of this page is display items and their price from the database along with an input box that will allow the … |
| | |
| | Hi all, This is an error im recieving on server, BUT, no error on local hostWarning: mysql_fetch_array(): supplied argument is not a valid MySQL result line 49 This is the code it is referring to.... [CODE] <?php $sql_query = "SELECT * FROM `indexinfo` WHERE id = '1'"; //store the queried … |
| | Hello. Help me, please. Need export BD (create dump file). I installed MySql.Data.msi from MySQL site.  |
| | [B] [I]please [/I][/B]I need to how tow [B]MySQL databases synchronize [/B]each to other . thanks for everything . mostafa |
| | Is it possibile to insert SQL in JSP? If you have examples about how to connect to a MySQL database from a JSP web page, how to view, edit, create tables please send. I am looking forward to receive some code about JSP & MySQL. Yours sincerely, Laurian Lazar |
| | Hi, I have the following table: Name Row(number) Nico 1 Marko 2 Peter 3 Joy 4 Kimi 5 I delete Nico and Joy: Marko 2 Peter 3 Kimi 5 And how to make a table would look as follows: Marko 1 Peter 2 Kimi 3 How to automatically re-arranged in … |
| | Hi, I'm in a IntrotoOOP class at my school, and my instructor asked me to look up how to fill a Java Swing Class ComboBox with data from a MySql Database. Does anyone know? This question has been quite hard to find any answers on and I have been really … |
| | hi, 'm a beginer. . i need a lil help to start learnin VB.. i dont hav much idea about it.. Kindly give me info of which book i can refer.. look fwd for much needed help.. |
| | Hi! I'm looking to update a field in a table via PHP, basically asking it to change a fields contents to 'foo' if it currently contains the word 'bar', or to change its contents to 'key' if it currently contains the word 'board'. I can't seem to get the syntax … |
| | [icode]$sql_posts = 'select * from posts limit "'.$start.'", "'.$limit.'"';[/icode] im getting error with this line ?what could be the matter.. plz help |
| | I ran this query on my database: [code=sql]select O.ORDER_NUM, O.ORDER_DATE, O.CUSTOMER_NUM, C.CUSTOMER_NAME, C.STREET, C.CITY, C.STATE, C.ZIP from CUSTOMER C, ORDERS O where O.CUSTOMER_NUM =148 and C.CUSTOMER_NUM = 148;[/code] +-----------+------------+--------------+--------------------------+----------------+----------+-------+-------+ | ORDER_NUM | ORDER_DATE | CUSTOMER_NUM | CUSTOMER_NAME | STREET | CITY | STATE | ZIP | +-----------+------------+--------------+--------------------------+----------------+----------+-------+-------+ | 21608 | … |
| | Hi, I am developing a website , in which I want guest to visit and make their accounts. when they make their account they give their information includeing Email and when they submit the button an email send to them for verification and when they click on a link their … |
| | Hello, I'm having an issue with a MySQL/PHP site I'm working on. I'm new to both. I've seen several posts that were similar or same but was unable to derive a solution based on my code. I have a form that will submit HTML code to a database. I know … |
| | Hi, I wonder if there is a solution to my query; I need to be able to produce a weekly report that will display all daily totals for that week or any previous week. I have toyed around with the weekday() function and the Week() function, but I don't know … |
 | I have 3 tables. Company, phone, companyPhone. The company table has an auto_increment companyID primaryKey The phone table has an auto_increment phoneID primaryKey The companyPhone table row is made up the companyID, and the phoneID. On my form the user will enter company information and the company phone number. After … |
 | Hi, Does anyone know of any simple to use software for bulk uploading products to an ecommerce website database? I dont know enough PHP or MYSQL to write my own scripts, so I was hoping there is a program to do it for me. I will have to use a … |
 | Pardon this post here as I didn't see any Postgres forum. I have a table with a 16 length bit value. Can someone please help me how I do the where clause on my select? example data for that field 0000000000000001 0000000000000011 0000000000000010 how would I select one of the … |
| | hi, I am using a live search snippet from "[URL="http://www.dynamicajax.com/fr/Suggest_Frontend-271_290_312_313.html"]http://www.dynamicajax.com/fr/Suggest_Frontend-271_290_312_313.html[/URL]". I started connecting it to my code, but i need help with expanding the search. It currently only searches for one field in the DB, but i want it to search more than one field from a table in the … |
| | my code : ********uploadImage.jsp************* [code=JSP]<form action="UploadImage" method="post" enctype="multipart/form-data" name="productForm" id="productForm"><br><br> <table width="400px" align="center" border=0 style="background-color:ffeeff;"> <tr> <td align="center" colspan=2 style="font-weight:bold;font-size:20pt;"> Image Details</td>[/code] ******UploadImage.java****** [code=Java]import java.io.*; import java.sql.*; import java.util.*; import java.util.regex.*; import org.apache.commons.fileupload.servlet.ServletFileUpload; import org.apache.commons.fileupload.disk.DiskFileItemFactory; import org.apache.commons.fileupload.*; import javax.servlet.*; import javax.servlet.http.*; public class UploadImage extends HttpServlet { @Override public void … |
| | So I've got a server host that runs my MySQL 5.1 db. I have a stored procedure in it, its similar to [ICODE]CREATE PROCEDURE CountUsersByFirstName(IN SearchName TEXT, OUT Count INT) BEGIN SELECT COUNT(*) INTO Count FROM Users WHERE Name = SearchName; END[/ICODE] the syntax of that may be off as … |
| | In this days, I am making dictionary site with PHP & Mysql. I write SQL like this [CODE]select * from dblist where `Word`='A' Union select * from dblist where `Word`like 'A%' Union select * from dblist where `Word`='%A%' Union select * from dblist where `Word`='%A'[/CODE] I don't use [CODE]`Word`='A' OR …  |
| | OVERVIEW: I am running a script on one machine that connects to a MySQL database on another machine that is outside of our university's domain. According to the administrator, network policies do not allow the compute nodes to access machines outside of our university's domain. COMPUTERS: A = compute node …  |
| | ok so i am doin a table that has info on all 44 presidents. i have to show the state the produces the biggest number of presidents...i am not sure how to do it. here is a lil bit of the table for you . I want it to show … |
| | Here is the error I recieve: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home1/edubnini/public_html/mysql_db_size.php on line 1 Here is the output of the script: [url]http://www.edub9intl.com/mysql_db_size.php[/url] [code] <?php /* ================================================================================ MySQL Database size reporter Version 1.0.0 --- Displays all MySQL databases with their size and privileges. … |
| | The following is my code it says "Stored procedures are not supported on this version of MySQL " whenever i try to run the website.. below is my code [code] default.aspx.cs using System; using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using … |
| | Hello is it possible to create a bar chart or some sort of chart based on two coloums from mysql table i want the graph to be displayed on php when the search is carried out im not sure if this has been done before but if so what do … |
| | I am doing a campus project in php regarding musical site and i have to insert ziped files of songs in the database. so, i don't know how to deal with the zip files. Therefore, help me.  |
| | How can I monitor my MYSQL database and the number number of threads and connections it has from a remote computer. my database is running on a ubuntu box and I would like to monitor the database from any of the three major platforms (windows, mac, linux)  |
| | ok so i am working on a program that has a table of all the presidents and info on each of them. i tried to insert the date of their birthdays and deaths, but just got 0000-00-00 for a result when i went to see what the outcome looked like. … |
| | [B]AUTO INCREMENT definition mismatch for Timestamp Datatype.[/B] Please explain what is the cause for this?  |
| | [code=php]<?php $con = mysql_connect("localhost:3306","pm" ,""); if (!$con) { die('Could not connect: ' . mysql_error()); } // some code ?>[/code] on writing the above code it is showing the following error: Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'pm'@'localhost' (using password: NO) in C:\wamp\www\p2.php on line 83 Could not connect: Access … |
The End.