10,946 Topics
 | |
| | Hi, wonder if anyone can help. I want to insert a jpeg as blob data into a table column holding blob values. So far I just can't seem to come up with the right script to run in mysql workbench. The jpeg is stored on the same machine where mysql …  |
| | Hi, I can't solve this problem: I have a query which fetches the contents of the page meta tags from a database. It works fine when I have the query on page but when I turn it into a function (which is placed in my functions file) and call it …  |
| | Hi everyone, I’m having some difficulties with a query which purpose is to give users with more than one thread (called CS) in current year a 5% point “raise”. My relational schema looks like this: Thread = ([B]threadid[/B], threadname, threadLocation) threadoffering = (threadid, season, year, user) user = ([B]name[/B], points) … |
| | Hi I'm currently creating a basic math tutor for kindergartners and i'm using dreamweaver 8 as my text editor with PHP and MySql. One of my modules involves lessons in which i would want to put addition and subtraction and i have created a flash documents to demonstrate(addition and subtraction) … |
| | Hi all, I've looked through this forum for some hours and am absolutely unable to fix my problem; no matter what I do. I'm trying to pass a PHP variable as part of a MYSQL query like so: [CODE] $id = $_GET["bodyid"]; $blog = getEntries("SELECT `Articlebody` FROM `Blog` WHERE id … |
| | Hi all, I have a database with contact info, and I need to display the info in groups. Currently in my database table called contacts I have a field called 'groups'. The values are 'favorites', 'home', 'work', and 'friends'. I tried creating a page called group.php and used a dropdown … |
| | Hi guys, I'm trying to UPDATE the image that has been already in the database with another image using a form in PHP. I got the uploading working all fine already. Just the edit part. With this code, I get no error, but the MySQL table is not written with … |
| | Hey guys, I've just started coding php, for a school project. I'm creating a member login system with functions to add/edit contacts. Currently I'm stuck at updating the contacts. I'm able to pull up data into a form in a page called 'edit.php', but after updating and clicking submit, it … |
 | I've been scratching my head for a bit now and I can't think of a way to make a mysql_query pull a set of data that matches a number in an array. It's easier to explain what I want to do with code.. so here goes.. Then I need my … |
| | hi, i am using the following code to retrieve information for todays date: [CODE]<?php $query = "select * from CUSTOMER where DATE (date) = DATE(NOW())"; $result = @mysql_query($query, $connection) or die ("Unable to perform query.<br />$query<br/>"); $num_rows = mysql_num_rows($result); echo "$num_rows"; ?>[/CODE] i cant seem to find any code to … |
| | i have this weird problem and i dont know how to make it work. the problem appears after i consider the OR statement.without or statement the first part is working . So idont how to use this statement in mysql. i hope someone can help me. Down is my script. … |
| | hi, I have written the perogram in perl and i want take previous date in "April 3 2010" in this formate . plz tell me how can i get this. [code=perl]#!use/bin/perl use Date::Format; my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime(); my @weekday = qw(Sunday Monday Tuesday Wednesday Thursday Friday Saturday); my @month = … |
| | hi, could anyone recommend a free mysql query builder? i have been working on a database and had some help with some small queries, however i need to create a large recordset through dreamweaver and wondered what tool i could use to generate my query visually? many thanks |
| | Hi everybody. right now i'm doing a hotel reservation system using php and phpmyadmin. The process involved 1) user inputs check-in and check-out dates (to check what rooms are available during the dates input) 2) database is queried for all room categories AVAILABLE within the dates indicated step 1 and …  |
| | Hi, I have a search form that picks users of class name of course name. Now I have a problem viewing data in categorization from mysql database with php. For Example I need the following: Course Name: Name Class Name: Name 1. Name Surname(User) 2. Name Surname(User) 3. Name Surname(User) … |
| | Hello and Thanks, I am trying to create a teacher grade book for my school, I have a mysql database 'gradebook' and two tables 'students' and 'data' (mysql code below) to start, I am also using PHP. I have googled this to death and can't seem to come up with … |
| | Hello I need to do search through a mysql db on a column and search how many values are equal to a number and than post the number of the values that are equal to this. I would like the number of the values to be saved into a php …  |
 | Dear Friends, I use the following: MySQL Server 5.1 MySQL Workbench 5.2 OSS I have a strange problem. I have a backup of my MySQL database with MySQL Workbench 5.2 I use MySQL Workbench 5.2 for importing MySQL database. That's works fine, see Annex. Then i go to SQL Development, … |
| | I have a field Status in my table message Its value when any message is entered in table is 1 but I want to alter it to 0 after 1 day of message posting how can I do so Plz help me |
| | I have a small desktop application created, i wan to create a login function for this. i have a database using MySQL which stores user name and password. i wan to know how to compare the user name and password entered in the text field with the data in the … |
| | Hey Guys, I am developing one tool on perl to moniter mysql database in many systems(in all types of OS). I want to track some info like this getting databases parameters , getting database schemas, get logspace .... etc , what could be the good approach in perl.. If you … |
| | hi, I have date in this format December 2 2009 December 2 2009 December 2 2009 and i want to insert it in my table in mysql .I m inserting this with the help of perl means i m doing my program in perl .ook at my program [code=perl]#!/usr/bin/perl use … |
| | Hello, I am really sorry for posting this here but I couldn't find anything simular to the net. I need to insert datetime values into my mysql db and in particular the current time second and minute value and than I want to call this value and do a $current_time-$mysql_time … |
| | Hello, I have two tables--QUESTIONS, ANSWERS. I store the questions in one table and the answers in the second. Table Structure--QUESTIONS Field 1: Question_ID Field 2: Question Field 3: Question_Type (There are 3 types of questions) Field 4: Step_ID (There are 15 steps in the program) Table Structure--ANSWERS Field 1: … |
| | I'd like to display the contents of some fields in a MySql table as a table on a webpage. I found sample scripts, but I'm doing something wrong in trying to adapt them. Can anyone give me a link to a webpage that displays a table like this, so I … |
| | Hi, I would like to update the products table "ProductPrice" with the value "saleprice" from the distpricelist by matching the sku. the "products" table is permanent, I upload a csv file and fill the "distpricelist" with the new data. so basically i need help with a mysql statement to update … |
| | hey guys very sorry for creating a new thread here but i couldn't find my queries in available threads I just want to connect the java applets with mySQL database, so that the project i am working on, should move forward. Any suggestion would be thankful. The code specs would …  |
| | I have a table like this (say, friends): [CODE] |_name1_|_name2_| | james | sarah | | bob | james | | james | dave | [/CODE] I want all james' friends. It will need to include 'bob' as well but I can not figure out what the query will need … |
 | Hello There, I am Using This code to backup mysql database from my hosting server. [CODE]#!/bin/bash # # MySQL Backup Script # VER. 2.5 - http://sourceforge.net/projects/automysqlbackup/ # Copyright (c) 2002-2003 wipe_out@lycos.co.uk # # This program is free software; you can redistribute it and/or modify # it under the terms of … |
| | hi, [code] mysql> GRANT ALL PRIVILEGES ON *.* TO user@% IDENTIFIED BY password; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '% IDE NTIFIED BY Savem3' at line 1 mysql> … |
| | Hi. I'm trying to write a script that fetchs image codes from a mysql database to display them into a 3 columns table. I got this so far: [php] $selection = $_GET['scelta']; $query = 'SELECT photo_code FROM'. $selection .';'; $result = mysql_query($query); $rows_nb = mysql_num_rows($query); print('<table width="75%" border="0" align="center">'); while … |
| | Hi, I am wondering if i am able to insert 2 entries from a form to mysql. for example: [CODE]</tr> <tr> <td bgcolor="#eeeeff"> Is it a shared devices?<br> <font color='#F62817'>** If yes, please indicate the shared device num. </font> </td> <td bgcolor="#eeeeff"> <SELECT name="shared"> <option value="No"SELECTED>No</option> <option value="Yes">Yes</option> <INPUT type … |
 | I have a script that runs a static chatroom(User has to refresh the page manually). When a user submits a post, the user's data(Username, title, user level, etc..) is stored in the DB along with the post. The script for getting the post looks something like this: [code=php] $result = … |
| | hi I would like to be able produce statistics on my web page by counting the numbers of rows in my sql database. for example. within my database i have 10 defects in my table called "defects". 9 defects are major, 1 defect is a minor. is there a way … |
| | Good morning all, I am having a few issues. Firstly, I am no expert whatsoever so I may not have done anything conventionally. I have been able to create a form with many fields, click submit and data is inserted into a table in my database. I was then also … |
| | How do i join two tables in MySQL to form a third table having certain columns from both the tables?:?:  |
| | Hello guys, I am trying to make a very simple booking system. The booking will be either for the current or the next year only. There are three fields; number of person, type of meal and date. In any particualr day and meal, the number of person can't exceed 100. … |
| | hi, looking for some advice on the deisgn of my tables i currently have setup. the app is a sales management system. the sellers sell insurance policies, be it life, buildings etc what i was wondering was to allow calculations of commission due from each product table (as they all … |
| | Hi everyone and thank you for helping me... again :icon_neutral: I am trying to perform a MATCH AGAINST sql query on one of my table called "what". [ICODE]id (int 11) PRIMARY org-id (int 11) keyword (varchar 100) FULLTEXT bid (DECIMAL 4,2)[/ICODE] I want to perform a search on the column … |
| | i have two table in my database which is the room table and roomtype table.i'm using phpmyadmin. [B]room table[/B] room_no r_roomtypeID [B]roomtype table[/B] roomtypeID roomtype how can i create a query that can select A random room_no from "room table " based on the roomtypeID in the "table roomtype" p/s … |
| | Hi, i am relatively new to mysql just learning the basics really. i have googled this but there is so many discussions on it. Could someone just give a simplified answer to what is the difference between using Union or Join and when would you use one or the other? … |
 | Okay, not sure if this is the right spot, but here's my issue. So, my mom is taking a php programming class, and she's learning how to use MySQL and the phpMyAdmin. She wanted to activate the passwords for the root and admin users, and instead of asking me for … |
 | This is my first post to DaniWeb, and I've read the Member Rules, so I think this is the correct forum. I have created a page in PHP that collects seven items of data then displays them lower on the same page. The data columns are: name, alignment, origin, archetype, … |
| | working on a system with 2 tables both have the exact same fields - the tables are past_participant and course_participant - CP table has all current students whilst the PP has only past students. after a course concluded, that set of students is transferred from CP to the PP table. … |
| | Hello friends, i have developed my application in MySql. My database is distributed among the 3 servers, if 1 of the server gets updated, then i want to updated remaining servers. Otherwise i want to replicate the database...please help... |
| | Wanted help in connecting to a MySQL database named Airline having table Booking with 8 columns and performing update and insert operations. Please please help. Thank you.  |
| | Hi! I am new in PHP. I have a table which stores user surnames and 12 months each having a value of 1 or 0. I need via a form in PHP to check whether or not this value is 1 or 0, and be able to control this values … |
| | So here is my search query set [CODE]/all possible input combinations //name and id combinations if($q != '') { if($id != '') { $sql = "select * from course_participant where name LIKE '%$q%' and nic='$id'"; $result = mysql_query($sql); $num_rows= mysql_num_rows($result); }else{ $sql = "select * from course_participant where name LIKE … |
| | so there are 2 tables course participant and past participant - both have same fields. i want to write a query that selects both from course participant and past participant if search option "find all" is called. i out everypossible combination but it just doesnt get right - pls help |
| | from mysql command line, what's the command to import query from a text file? does mysql has this ability? it would be handy if so.... does the text file have to have mysql file type? please be a bit specific. thanks very much. |
The End.