[mysql] Forum Topics

Can someone point me in the right direction, what I am trying to do is use the result set that I have from a php query to a mysql table. I would like to be able to individually select a record from a query result that returns multiple records. I …

Hi guys...Good morning...I have following code. <?php $pid=$_GET['pid']; $conn=mysql_connect('localhost','root','') or die("Cannot connect to server"); mysql_select_db('developer',$conn) or die("Cannot connect to database"); $sql="select cnode,item,pnode from listviews where cnode='$pid'"; $res=mysql_query($sql) or die("Cannot execute query"); while($ar=mysql_fetch_array($res)) { $itm=$ar[1]; $pid=$ar[0]; } $sql="select cnode,item,pnode from listviews where pnode='$pid'"; $res=mysql_query($sql) or die("Cannot execute query"); echo "<table border='1'>"; …

Hey everyone, I'm attempting to delete records within my database but I'm having problems writing the query. What I need to do is delete records from my database that, within a field in this record, have a substring that I will pass to the mysql command. So for example, A …

hi i am new in PHP ,i am doing my job in a company and there are some existing project they tell to me plz check and remove errors ,i m trying more and more to remove this error but i m failure....plz help me. <?php require("header.inc.php"); session_start(); if(($useradmin)=='') { …

Hi, I'm having a having a hard time trying to insert some data into a mysql DB, so I'd like to know if there is some kind of error log that could help me. I've already looked into the binary log but it didn't help me. I also started mysql …

Until I figure out how to create passwords in a MySQL Database Im relying on HTML scripts to work. This does work, everything is good, except if I put it on the web people can discover the code by viewing the source. Now my question is, is there someway I …

Hey everyone, I am new to Ruby on Rails and I am having a problem that I can't seem to figure out. I have a mysql database that I created and I have created a model for it. I have did not create a migration, as the database is already …

Hi all...I'm looking for a very specific eCommerce solution, and I was wondering if anyone knew what application or system might be able to do this. I currently use the 1ShoppingCart system (which I'm sure a lot of you are familiar with), and so far, I've been told, that there …

I am trying pagination for a database-database search engine - this was the query $sql = "select id, name from student_adv WHERE name LIKE '%$search%' order by id limit $startIndex, $perPage"; and it worked fine when i had $search = John The problem starts when i put $search = John …

I have a script which takes the variable from a form and puts it into a mysql table. There is an entry, but inside the field it is blank. I have attached screenshots. This is my code [CODE] // prepare form values for insert $URL = mysql_real_escape_string($_POST['url']); // Make mysql …

Hello everyone. I've a degree in computer science. Just after finishiong my degree I started teaching for two years. Now I would like to go back to programming. Currently I'm studying PHP/MySQL and I want to get into Web development. Well I would like to get experience in real life …

I have a table containing various information describing room requirements for an architectural project with about 500 different rooms. Each record in the table represents a single room and its attributes. There are about 200 attributes in all, but each room uses only a small subset of those attributes. To …

when i run this query ...... update item set description=(select description from item where itemid=5384); i get this error message... Msg 279, Level 16, State 3, Line 1 The text, ntext, and image data types are invalid in this subquery or aggregate expression. there is a lot of text in …

Hi I need help. I know what I want to accomplish, but I do not know how to do it. The events are recurring every month, but not recurring at the same time or on the same day of the week. WHAT I NEED HELP ACCOMPLISHING: How to do I …

Hi, I would like to know a resource or simple solution for this, I have a mySQL database with lots of links. I need said solution to visit each link and download the HTML file for it. Like an indexer which is told where to index.

Dear members, Thank you in advance :icon_smile: I have a DataGrid (MS DataGrid control (SP6) (OLEDB) ) in a form. It is bound to the DataSource through code. I am using the latest MySQL database (utf8). Using Windows 2000 server SP4 and Windows XP. [B]Problem:[/B] My problem is that the …

Hi I need help. I know what I want to accomplish, but I do not know how to do it. WHAT I NEED HELP ACCOMPLISHING: How to do I insert data into a table for a date range of two or more months, where every second or third week should …

ummm, i got a for that is connected to a database, and have an add, edit, delete cmd buttons. if example i have "MyName" already on a certain field of a table on a database, then on my form i wanna add "MyName" also, what i want is there will …

the problem is this: Example I have five data in the datagrid(of course the data comes from the database.) and I want row of the datagrid to be highligted when the the data was found after searching it... If I have five rows and the data was found in the …

Hi. I'm starting to use clientdatasets after years with Zeos DBO and I'm facing some difficulties. I created a TSQLConnection, a TSqlDataset as a ctTable, a TDatasetProvider and a TClientdataset. I populated the clientdataset and tried an ApplyUpdates(0) to insert the records. But I'm getting a "cannot modify a read-only …

I am unclear how to write a query where I want all the entries in a specific month and date format from a MySQL table. I am not using DATE_FORMAT() with a NOW() correctly. I need to write a query that has a time field in the yyyy-mm-dd format to …

Hello, I am very new to Python and have, what I think, is a rather simple question. First, I am running Python 2.1 on Win XP. What I want to do is open a CF page after my process has run and pass the processID, that I will set, and …

Hello guys! So here's the problem. I'm making kinda simple forum and I'm using SiteMapPath to navigate through sections and threads. Like HOME>>Programming>>SomeThread. But that's not important... Also I have database with 3 tables. One with SectionID and SectionTitle, other one with ThreadTitle and SectionTitle , and the third table …

I'm trying to make a script to run via cron to backup my moodle database in mysql. However, I'm unable to get it to accept the password on the command line. (?) I'm trying to run the following command: #!/bin/sh date=`date '+%y-%m-%d'` mysqldump -u root -pmy_pwd -p -C -Q -e …

Hi all, I am new to shell script and really help. I need to connect to MySQL and do some proccessing. How can i do that? Thanks

Hi :) I have 3 DataGrids (and even more in the future) that supose to present data from a DataBase. When i press on the main DG all the rest are updated according to a cartein Code Index. The problem is that its very slow and i want to make …

<?php require("header.inc.php"); /*session_start(); if(($useradmin)=='') { header( "Location: error.php" ); } */?> <html> <head> <link rel="icon" href="favicon.ico" type="image/x-icon"> <link rel="shortcut icon" href="favicon.ico" type="image/x-icon"> <link rel="stylesheet" href="colors.css"> <title>Admin Area : Users</TITLE> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> <SCRIPT language=javaScript type="text/javascript"> function D(url) { window.open(url,"data","width=550,height=600,scrollbars=no,resizable=no"); } </SCRIPT> </head> <body> <? //This variable is for date …

Hi. I am fairly new to mysql, so help is appreciated. I have two tables and I wish to count some results from two tables and combine them onto one row, and then join an ID to another table. The problem is as follows: Table A: This lists information of …

hi ! i m new to IT.i want to know ,how the data from a mysql database can be sent to excel sheet...............kindly help me..............thanks

Hey everyone, Well, our college wants us students to make one "mini-project", a site with a database plus something in e-commerce. Now, I've chosen the topic as "comics". Can you guys help me create one ? Nothing too complex. Here's what I have on mind. The site will have 3 …

Ok, I'm relatively new to php/mysql/apache and I've got myself stuck(I bet that sounds familiar) Here's where I'm at: [LIST=1] [*]I successfuly installed Wampserver onto my PC(latest release) and tested that php is working using the phpinfo script(all good); [*]I have an installation of oscommerce on my main webserver which …

heres the deal, i have created a table called tvprograms on a mySQL database and have added the fields id, program and comments and have populated the database. The first thing i need to do is list just the programs in a php form but not the comments. I then …

Hi, I just joined this community and inspired by roaming in it. However, I would like to discuss a problem - I'm having. I'm developing an application for property management. I've a table with some general columns as well as some specific. For example; General: [Buy OR Sell] , [Plot …

hi the below code i have used for attendance,when the user clicks submit...the person date,time,id will get stored in the database...... i want to know how to calculate the no of days he has worked...... ex:wen the admin checks on th 15th of the month...it should display how many he …

hi there, could someone please recommend a good book on PHP (i am new to php). I would like said book to cover how apache/mysql/php and drupal work together, and also some eamples of php in action. many thanks.

Hi, Got a bit of a problem with form, i need to be able to update a number in a mysql database using an html form. so basically i need to increment or decrement a number using a text box and a submit button. heres the code i got: ============================================== …

Hi, Got a bit of a problem with form, i need to be able to update a number in a mysql database using an html form. so basically i need to increment or decrement a number using a text box and a submit button. heres the code i got: ============================================== …

Hello Seasoning Greating! Hello to you all i am a student in a college and we are in a group we are giving the task to choice a project topic to write on VB and the project should be related to what is in our environment such as! 1) sending …

I've a table named [transaction] [B]idtransaction [/B] is my primary key ---------------- [transaction] ------------------------- idtransaction | customerID | amount | transDate [B]Amount[/B] is the credit or debit / they differ when amount < 0 it is credit and when amount > 0 it's debit Sample Data idtransaction | customerID | …

Im very new to SQL in general, let alone coding it into python. I can interact with a MySQL database just fine for the most part, but im running into some problems here... This is the function in my script that keeps raising errors: [CODE=python] def NewChar(): """ NewChar() - …

HI all am trying to construct this hybrid of java and mysql. the data comes from a mysql database and I want it to display in the gui. this I have achieved thus far. However I have buttons that sort by surname, first name, ID tag etc....I need event handlers …

Hi there, I've been this online office management system hyperoffice.com for a while now & I never liked the program b/c of all the bugs, it wasn't designed properly (user interface) & tech support always blames us (not just me, even my VA & techie) for their issues, plus they …

I am having fits trying to come up with previous/next buttons for my particular project. I want the user to be able to easily browse through shifts. I have 3 shifts per date and that is how it is stored in the db. Right now I have the users going …

Is it possible for someone to hack into my database/table? if so should i name my table/database: database 5465464577688960985047834?

Favorite 3rd party software with MySQL Results of a poll conducted on favorite 3rd party software with MySQL: [url]http://mysql-dba-journey.blogspot.com/2007/12/favorite-3rd-party-software-with-mysql.html[/url]

Hello! I have set up a script form called " form tools " without a problem, This script gathers all information in the registration form and stores it into a database (php and mysql), Now I would like to randomly choose 5 people from the data I collected from the …

I have a mysql database with user input fields. Some of these varchar fields contain commas as part of the data. When I try to display these fields they are treated as arrays and display only the first "element". This occurs both with mysql_fetch_row() and mysql_fetch_array(). I'm chagrined I haven't …

HI I want to submit csv file data into mysql using php. One of the fields contain data : date with format (dd-mm-yyy). I want to store the data in mysql with date format (yyy-mm-dd). pls tell me how 2 do. pls help me Thanks. bye

hello, I am designing a web site using ASP.Net over VB , and I need to have user login window, I 've had it from the control and the users specified from the ASP.net configuration but : I wonder if I can bind users from a table containing usernames and …

there would be a account balance area, upgrade area, members profile area , cash ptc area , point ptc area, paid to signup area, and this would be linked to mysql so that everything happen over a click automatically and i need not have to do it manually.