10,940 Topics

Member Avatar for
Member Avatar for closetosane

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 …

Member Avatar for closetosane
0
170
Member Avatar for giemman

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 …

0
51
Member Avatar for dimplemodi

"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 …

Member Avatar for kvprajapati
0
41
Member Avatar for BabyEyes

hi all, i have a problme and i need help. i am making a guestbook which 3 fields that are comment upload picture and email address. what i would like to ask how can i make the sql statement so as the user upload an image it be saved in …

Member Avatar for kvprajapati
0
62
Member Avatar for BillBrown

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 …

Member Avatar for diafol
0
140
Member Avatar for zeusofolus

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 …

Member Avatar for zeusofolus
0
733
Member Avatar for nobby85

i am using xampp on my computer and i want to carry a backup of my database using the mysqldump command

Member Avatar for peter_budo
0
47
Member Avatar for whiteyoh

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 …

Member Avatar for whiteyoh
0
73
Member Avatar for MAcKZloy

Hello. Help me, please. Need export BD (create dump file). I installed MySql.Data.msi from MySQL site.

Member Avatar for Ramy Mahrous
0
69
Member Avatar for mostafa aedera

[B] [I]please [/I][/B]I need to how tow [B]MySQL databases synchronize [/B]each to other . thanks for everything . mostafa

Member Avatar for guru12
0
50
Member Avatar for llazar

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

Member Avatar for kvprajapati
0
260
Member Avatar for Lolalola

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 …

Member Avatar for eantz
0
90
Member Avatar for srivathsa_4

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..

Member Avatar for srivathsa_4
0
212
Member Avatar for jay.barnes

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 …

Member Avatar for jay.barnes
0
90
Member Avatar for dmotah

[icode]$sql_posts = 'select * from posts limit "'.$start.'", "'.$limit.'"';[/icode] im getting error with this line ?what could be the matter.. plz help

Member Avatar for praghna
0
39
Member Avatar for tones1986

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 | …

Member Avatar for tones1986
0
98
Member Avatar for ayesha789

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 …

Member Avatar for ayesha789
0
163
Member Avatar for MArun25039

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 …

Member Avatar for guru12
-1
5K
Member Avatar for acaciasd

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 …

Member Avatar for guru12
0
108
Member Avatar for Sailor_Jerry

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 …

Member Avatar for Sailor_Jerry
0
143
Member Avatar for bubbafunk1

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 …

Member Avatar for bubbafunk1
0
103
Member Avatar for kireol

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 …

Member Avatar for kireol
0
96
Member Avatar for sassenach

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 …

0
67
Member Avatar for farahshafilla

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 …

Member Avatar for kvprajapati
0
2K
Member Avatar for headedtomexico

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 …

Member Avatar for headedtomexico
0
369
Member Avatar for saturngod

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 …

Member Avatar for ShawnCplus
0
95
Member Avatar for vodkalove

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 …

Member Avatar for jlm699
0
90
Member Avatar for ROTC89

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 …

Member Avatar for davidn
0
101
Member Avatar for edub9

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. …

Member Avatar for ShawnCplus
0
200
Member Avatar for omaheshwar

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 …

Member Avatar for omaheshwar
0
156

The End.