10,932 Topics
 | |
| | I am reading records from a linked server table, and trying to use the output in the next update statement, not on the linked server. I am assigning it to a declared variable. The file is being updated with NULL, instead of the correct check number. Any help??? Example code: … |
| | Hi guys, I did a quick tutorial on the internet on using php and mysql. It is my first ever time using it so forgive me if im being a bit of a "NOOB". anyways ill post the script below and can you give me a few pointers about where …  |
| | Is this an appropriate place to submit a question concerning netbeans and creating queries?  |
 | Please tell me what I'm doing wrong. The sql query is in bold. [CODE]<?php //////////////////////////////////////////////////////////////////////////////// // // SECRET PAGE // // Invokes require_authentication() to ensure that the user is authenticated // //////////////////////////////////////////////////////////////////////////////// require("common.php"); require_authentication(); session_start(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns='http://www.w3.org/1999/xhtml' xmlns:b='http://www.google.com/2005/gml/b' xmlns:data='http://www.google.com/2005/gml/data' xmlns:expr='http://www.google.com/2005/gml/expr' xml:lang="en"> <head> … |
| | I am able to connect to the database and located the table. I am unable to populate the db. Attached is a in image of the phpmyadmin trucks table structure. Please help. I am excited to be so close to getting it right. [CODE] echo '<blockquote><blockquote><blockquote>'; echo '<form method="post" action="/inventory/">'; … |
| | Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Inetpub\vhosts\thepinflow.com\httpdocs\staff\checklogin.php on line 12 Wrong Username or Password That is the error message I am recieving. I was using another website to host a PHP/SQL website before, currently located at: [url]http://www.blackairplane.com/Pinflow/index.php[/url] which works. When I copied all the … |
| | Hi Everyone, Good Day,, can you help me to config mysql server to be able for me to connect to it thru a network. for example the mysql server is on the other pc and i am using a software in other pc. how can i connect to it.? thanks … |
| | Well, i am facing this problem when i try to configure my ODBC 3.51 Driver. I had successfully installed MySQL. Then i try to install and configure my ODBC 3.51 driver. I add a new user DSN, filling with the correct username and password, with the data source name. However … |
| | Hello, I'm having some sintax problems using PL/SQL in mySQL TRIGGERS.. I need some help please :). Here is the code: [code] CREATE TRIGGER modificou AFTER UPDATE ON monitor FOR EACH ROW BEGIN IF NOT EXISTS(SELECT estado_tmp FROM alteracoes WHERE id_tmp = OLD.id) THEN INSERT INTO alteracoes VALUES(OLD.id,NEW.estado); ELSE UPDATE … |
| | How do i store images on a mysql server and preview on a webpage using PHP. or how do i preview images using PHP on webpages.  |
 | Hi all, I want to insert multiple records into a table using one query. And my query is INSERT INTO table2(id,message) SELECT id FROM table1 WHERE condn,'hello' but it displays an error.... Can you help me? Thanx in advance.... jino |
| | Helo everybody How to convert database type from datetime to varchar? and decimal to varchar? Can I use this code? [QUOTE]CAST(now() as varchar(20))[/QUOTE] I use MySQL version 5.0.21 Other question: If I execute procedure [QUOTE]CREATE PROCEDURE `formatdate`(dtDate datetime) BEGIN SELECT date_format(now(),'%d-%m-%Y') AS idate; END $$[/QUOTE] in Visual Basic 6 using …  |
| | Hi everyone and thanks for reading! I have a MySQL database with a table called "lessons". Inside lessons there are about six or seven fields holding information about piano lessons. The table looks like this: [CODE]vid int(10) (Primary Key) title varchar(50) date date teaser varchar(500) description varchar(2000) vurl varchar(50) extra … |
| | Hi All, Can any body help me out how to pass an array values from php file to mysql stored procedures as parameter list and how to use the array inside the stored procedure. Please help me out to solve this problem. Thank you. |
| | I'm trying to carry out the following delete statements [CODE]DELETE FROM images AS i WHERE i.image_id = 803 AND i.plant_num = 2277 LIMIT 1 DELETE FROM images AS i WHERE i.image_id = 804 AND i.plant_num = 2277 LIMIT 1 DELETE FROM images AS i WHERE i.image_id = 805 AND i.plant_num … |
| | I am having a problem porting an application written in ASP, using an MS SQL Server database, to a different ISP using MySQL. Code that seems to run fine on the current site generates errors on the new site. My connection to the MySQL db is: [code] set objConn = … |
 | I have a ton of inserts in an sql file that look like this: [code] INSERT INTO grades (GWid, classid, semester, year, grade, required) VALUES(100000089, 'CS210', 'B', 'fall', '2006', 'yes'); [/code] but when I get my filled tables, the semester and grades are all null and the year is 0000. … |
| | Hi, I need to send a SMS message or/and Email in my database project. Which one is better option for me; Shall i create database with Oracle or MySQL? Thanks  |
| | guyzz i wanted to make 2 connection in my inventory system. using mysql and access. i wanted to use the mysql as my main database..and if their no internet connection it posible save first the data in my access.. and if their an internet connection it will update and stored …  |
| | Hello everybody!!!! I am just curious if I can make a database where all the data are images like bitmap, jpeg and other pictures format... If yes, can you pls show me some code or sites to where I can learn a lot about this.. YOUR HELP IS HIGHLY APPRECIATED.... … |
| | I'm brand new to SQL queries, hoping someone can help me set up this query. I'm using [URL="http://www.phplist.com"]phpList [/URL]to manage my mailing list. All user defined attributes appear to be stored in a table called phplist_user_user_attribute. The structure of this table is:[INDENT][U]Field[/U], [U]Type[/U] attributeid, int(11) userid, int(11) value, varchar(255) [/INDENT]attributeid … |
| | hi ALL... i'm a new in IT woRLD.. right now i work with PHP, Apache, And MySQL i want to create aplication that already work(use Apache,PHP, MysQL but it stand ALone )being apLication that executable what i want is in the future all that i need is just install the … |
| | Hi, I put websites together using Xoops and OsCommerce. I need to know how to edit mysql databases using Cpanel. Please could you point me in the direction of some tutorials? There are some which show how to se up a database but not how to edit one. For example, … |
 | I am trying to replace mysql fields with this code... But unfortunatly it is not working... I do not know why... Here is the code please help me. Thank you. [CODE] <?php session_start(); if ($_POST['txtName'] != ''){ $host="****"; $username="****"; $password="****"; $db_name="****"; $tbl_name="****"; mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select … |
| | Does anyone know of a free tool or utility that I could use with pgAdmin III that would accomplish the same type of import functionality found in Navicat? |
| | Hello Everyboby!!! I just want to ask basic information but confusing in my part about the differences of ADO, ODBC and OLEDB ... I get confused in differentiating this three.... I hope you could help me with this problem... Your help is highly appreciated.... Thank You.  |
| | I'm trying to set permissions in mysql for an ecommerce open source application (freeway) for a path: Set the permissions on Freeway/images directory to 777 in my terminal I have typed: chmod 777 /Sites/Freeway/images but it is telling me that "no such file or directory exists", and yet when I … |
| | This maybe an old chessnut to you old sweats but I am a newbie to this.. I getting this error:- [B]mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\dsg\Mytest.php on line 9[/B] the database is called Camsdb the table is called DBF the fields of which there … |
| | Can someone help me figure this out. What do I need to do to set permissions in MySQL? Thanks in advance.  |
| | Hi, Here is my mysql sentence: [CODE]select last_insert_id() from pp;[/CODE] and the table pp is created by: [CODE]create table pp(id int not null auto_increment primary key,name varchar(255) not null);[/CODE] Now I'd like to change the above into sentences that are right in Oracle. First I create table: [CODE]create table pp(id …  |
The End.