10,939 Topics

Member Avatar for
Member Avatar for joy39

i am starting to learn to connect a cprogram to a mysql database. i have got this elementary program to connect to server , create a database and disconnect from it. [code]#include <stdio.h> #include<windows.h> #include <mysql.h> static char *opt_host_name = NULL; /* server host (default=localhost) */ static char *opt_user_name =NULL; …

Member Avatar for pritaeas
0
199
Member Avatar for garyjuano

i had a database with 4 column and each column has a value, below are the sample. ---------------------- col1-col2-col3-col4 -- 1------4-----7--------- 5------3----------10--- 6------------5----12--- my question is how can i get the lowest value in each row? here's an output that i wanted to get: 1 3 5 and here's my …

Member Avatar for pritaeas
0
140
Member Avatar for MeeDeggi

I need some help with radio button data and how to code it in PHP to insert the data into MySQL. Here is my [B]Form Code[/B]: [CODE]<form method="post" action="update.php"> First Name: <br /> <input type="text" name="fname" size="35" /><br /> Last Name: <br /> <input type="text" name="lname" size="35" /><br /> Phone …

Member Avatar for Red_Rain
0
210
Member Avatar for PF2G

Hi, I'm doing an app that adds info to a MySQL BD [CODE] Imports MySql.Data.MySqlClient Public Class curso_add Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click OpenFileDialog1.Filter = "Ficheiros de Imagem |*.jpg;*.bmp;*.png;*.gif" OpenFileDialog1.FilterIndex = "2" OpenFileDialog1.Title = "Escolha uma imagem..." OpenFileDialog1.InitialDirectory = "C:\" OpenFileDialog1.ShowDialog() End Sub …

Member Avatar for PF2G
0
231
Member Avatar for RockyMtnHi

I have a loop that writes out data for franchises. It works the first time through, but not the 2nd. Here is the page where the data is written out: [URL="http://184.172.137.97/~royl21st/1.php"]http://184.172.137.97/~royl21st/1.php[/URL] Here is the code that spits out the wrong data after the first successful loop. Any ideas? [code] $areaCodeData …

Member Avatar for pritaeas
0
215
Member Avatar for rotten69

Hi all, I haven't changed anything in the config file in phpMyAdmin folder. I don't know why the WAMP server gives me this error. Although everything was working perfectly yesterday. Does anyone know how I can fix this problem? [CODE] You don't have permission to access /phpmyadmin/ on this server. …

Member Avatar for rotten69
0
106
Member Avatar for Pravinrasal

hi, I developed one web application and I have created div in JavaScript and on that div I have created more than one images and when I click on save button i want to save all images on to the database and when I retrieve that image from database as …

Member Avatar for stultuske
0
193
Member Avatar for billmudry

Before I really dig in ----- HAPPY NEW YEAR EVERYONE! A few of you may remember that I have been working on producing a large wood knowledge base (woodsoftheworld.org). It is totally none profit. I am getting much closer to having enough working that soon I hope to be able …

Member Avatar for urtrivedi
1
2K
Member Avatar for PsychicTide

Hello fellow daniwebians, I seem to have run into a problem echoing MySQL/HTML and am hoping one of you may be able to point me in the right direction. I'm trying to echo portions of HTML(if there is an event for that date) inside HTML that's not echoed, so it …

Member Avatar for PsychicTide
0
148
Member Avatar for rotten69

I created a foreign key on a table just using this statement. When I wanted to drop it, phpMyAdmin didn't allow me to do so. Would anyone suggest a nice way of getting away with it? [code] ALTER TABLE `likes` ADD CONSTRAINT (fk_user_id) FOREIGN KEY REFERENCES `users` (user_id); [/code] This …

Member Avatar for rotten69
2
6K
Member Avatar for issaru07

hi everyone, i encounter problem when trying to create a form page to upload images to images folder and imagelocation will store information for the pathname where the image will be located ( will be used for display image in future) the code below does not have any error when …

Member Avatar for diafol
0
180
Member Avatar for sirlink99

I am getting an access denied error when I am writing to the database I am using this line [CODE] LOAD DATA INFILE 'upload.txt' REPLACE INTO TABLE Test FIELDS TERMINATED BY ',' [/CODE] I have made sure I allowed remote SQL, and I made sure to give the user all …

Member Avatar for smantscheff
0
87
Member Avatar for nathanpacker

Hey, I'm running a mysql query, and would like to run a script if the query returns no results. But what do I use to test for no results? Something like: [PHP] if (!$query) { do this } [/PHP] But just not sure how to implement it. Little help?

Member Avatar for BradChesney79
0
2K
Member Avatar for joy39

hi! another query! i want to insert values into the table 'employee' for the 'adddress' field in such a way that the large address comes in two or three lines like this [code] empid empname address mobile grade basic Joyban1 Joy banerjee 5/67, 1234567890 2000 10000 nehru colony, kolkata 700045 …

Member Avatar for hericles
0
93
Member Avatar for wolf29

I have a very simple wish, to dump all databases so I can lock up a backup of the databases, tables, users and so on. It looked like [CODE]mysqldump -v --all-databases -u root -p secret > "${directory2}""$h"_mysql_dumpall.sql[/CODE] worked, however the file contained a little error message telling me I had …

Member Avatar for wolf29
0
432
Member Avatar for liphoso

is it possible to move a database from one machine to another? maybe like copying the tables...

Member Avatar for drjohn
0
80
Member Avatar for gilgil2

Hi I have a database of information and the code to get that data out of the database based on the url, it will be some like [url]www.website.com/thekooks[/url] and then will display the information in the database for them. The bit I am struggling with is where do I put …

Member Avatar for phorce
0
127
Member Avatar for gilgil2

Hi, I am trying to make a link based on info stored in MySQL, the code I have got so far is [CODE] if (isset($_POST['search_now'])) { $result = mysql_query("SELECT * FROM bands WHERE BandName LIKE '%$BandName%'"); $page = "<a href=\"http://www.website.com/$row['PageName']\">$row['BandName']</a>"; while($row = mysql_fetch_array($result)) { echo 'Band Name: '; echo $row['BandName'] …

Member Avatar for gilgil2
0
146
Member Avatar for joy39

i am creating a table employee which looks like this [code]use employeemaster; drop table if exists employee; create table employee ( serial int unsigned NOT NULL auto_increment, empid tinytext NOT NULL , empname varchar(255) NOT NULL, address text NOT NULL mobile bigint unsigned NOT NULL, grade char(2) NOT NULL, basic …

Member Avatar for joy39
0
109
Member Avatar for NullReturned

So I'm having this weird issue, where I can do SELECT statements and INSERT statements just fine, but when I do this UPDATE statement, it sorta works. It runs without errors, and even outputs that 1 row is affected. But when I check the MySQL, nothing is updated. I've echo-ed …

Member Avatar for mikulucky
0
276
Member Avatar for jacob21

I need a tooltip where I can show content dynamically using (Query String [B]demo.php?id=12[/B]; id will change) jQuery, AJAX and MySQL.

0
59
Member Avatar for Octipus

All right. So i have child, parent, activity and register table and i want know how much money a parent will pay for his child if the child have 1 or more activities. So i came out with this code: [CODE]SELECT CONCAT_WS (' ', parent_title, parent_fname, parent_sname) AS 'Parent/Carer Name', …

Member Avatar for Octipus
0
216
Member Avatar for inni2626

Hello everyone, I haven been trying to connect to my database but i have been getting this error: Error message: SQLSTATE[28000] [1045] Access denied for user 'mgs_user'@'localhost' (using password: YES) Does anyone know what is causing this error? please advice thanks

Member Avatar for pritaeas
0
65
Member Avatar for peterpa

WELL I AM TRYING TO DO THIS BUT NOT GETTING ANY RESPONSE FORM SERVER DELIMITER // CREATE PROCEDURE getchgp(in ol varchar(100),in nw varchar(100),in sch varchar(100),out res varchar(100)) BEGIN SELECT pass INTO res FROM registration WHERE pass=ol AND schno=sch; UPDATE registration SET pass=nw WHERE schno=sch AND pass=ol; END // DELIMITER ; …

Member Avatar for smantscheff
0
59
Member Avatar for roottybrian

Am trying to restore a MySQL database using the 'mysql -u root db < my_db' command. In vb's process.start. it gives me the default output you get when you type MySQL - help. Can someone tell me what's up. I guess it cannot see the < symbol. Regards.

Member Avatar for roottybrian
0
113
Member Avatar for xecure

I have a database full of user. This is roughly how the database looks: [CODE]| username | sex | birthdate | zip_code | |----------+-----+------------+----------| | coolUser | M | 02-14-1987 | 90210 | | blueUser | F | 06-16-1982 | 10011 | | . | . | . | . …

Member Avatar for Sogo7
0
385
Member Avatar for sakarora

please help me..!! i urgently need a php script which would send email to a recipient if changes/insert occur in database. Details: suppose i have table name employee with fields: emp_id name email status 1 abc abc@xyz Yes 2 xyz xyz@acb NO now, say if status of emp id changes …

Member Avatar for sakarora
0
127
Member Avatar for xecure

I have a database full of user. This is roughly how the database looks: [CODE]| username | sex | birthdate | zip_code | |----------+-----+------------+----------| | coolUser | M | 02-14-1987 | 90210 | | blueUser | F | 06-16-1982 | 10011 | | . | . | . | . …

Member Avatar for smantscheff
0
172
Member Avatar for fahimcse2k9
Member Avatar for showman13

I know this sounds strange, but I messed up in a 'Manual' change to a DB table, and need to find a couple of records that I have no pathway to find... Explanation We have a member table called 'members' several different position tables, one for each level called position_1, …

Member Avatar for showman13
0
199

The End.