10,940 Topics
 | |
 | A very simple MySQL database class. [B]Usage:[/B] [CODE]// connect $config = array( 'host' => $host, 'user' => $user, 'password' => $password, 'database' => $database); $DB = Database_MySQL::getInstance($config); // set query $DB->query("select * from table1 where col1 = %d and col2 = '%s' LIMIT 1", 5, 'a'); // get rows $rows … |
| | First of all, thank you for taking the time to read my question. With the following code, what I have done is make a database in MySQL and created a table using python. I then imported an excel document with three columns. These three colums are: 1. POS_TYPE which is … |
| | Hi everyone. I am trying to make an if statment that will show text saying create an album if the user has no albums but if they have one or more albums then it will show their albums. Now I have sorted out everything but when I get to the …  |
| | hi .. i am working on chat system ..there are two types of user one are register and other are guest and i have to add guest user..in to database as temporary so they can chat with each other the problem i am facing is with there names i want …  |
| | Hello anybody! I have some idea and I don’t know if it will work. I am planning to make a user management system using the mysql database but the problem is I don't know where to start because in MySQL database the password is encrypted with password() function and it … |
| | Hi Everyone. Could anyone give me some pointers in creating a PHP, MySQL ShortCode system. I want to create a system where a user can SMS a keyword to a short code SMS number. [B]Example:[/B] [COLOR="Red"]SMS pizza to 33333[/COLOR]. Then the server checks pizza in MySQL DB and replies with … |
| | I have 2 forms, Form5 and Form4. Form5 has a datagridview with customer info, you double click the row header and that opens up form4, inserts customer info into texboxs on form4 My problem is when you click customer 1 or customer 2 the textboxes always fill with customer1. the …  |
| | Hi, I have been working with php for awhile now, but I am bum fuzzled on this one: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxxxx/public_html/xxxxx/index.php on line 5 adminlogin.php <?php include "mysql.php"; $res=mysql_query("select * from pagelay"); $mygrow = mysql_fetch_array($res); ?> now the other page …  |
| | This might be a stupid question, as I am a complete beginner in the world of AJAX/Javascript. However, I am trying to build a website using Ajax combined with PHP/MySQL. The issue I have at hand is that the PHP variables and functions that I have included in the header.php … |
| | help anyone! i can add records to mysql database but it won't appear in the listview. can you check out what's wrong with my code. pleeaaasssee.. help needed badly.. :( [CODE] Imports System Imports System.Windows.Forms Imports MySql.Data.MySqlClient Public Class bookForm Dim myconn As New MySqlConnection Dim sqlQry As String = … |
| | Ok I am very new to the php mysql world so please bare with me. I have set up a database for an apartment complex with a table containing the following: [code] create table apartments (apt_num int not null, available varchar(5) not null, beds int not null, baths int not …  |
 | Good morning, i know this was probably asked before, but im kinda in a jam. i have a database where it has a date field and a time field. i want to use a radio button to filter the fields. Say i have 3 radio buttons, the first one only … |
| | On my search result page, I wanted to search for "Nintendo DS Lite - Pink" I used following code: Ex: [code] $search_text = "Nintendo DS Lite Pink"; $kt=split(" ",$search_text);//Breaking the string to array of words // Now let us generate the sql while(list($key,$val)=each($kt)) { if($val<>" " and strlen($val) > 0) … |
| | Hello! I have written this dialog to connect to a MySQL database. It asks for the Username and Password, and it should use this data to connect to the database. [CODE]#! /usr/bin/env python # pwd.py import wx, MySQLdb class LoginDlg(wx.Dialog): def __init__(self): wx.Dialog.__init__(self, None, -1, 'Login', size=(250,150)) # widgets userLbl … |
| | Hello all, I recently made a mysql database using python and imported an excel file into the database. However, I am having some issues with some of the python. Using the following code, I have selected 11 numbers from a table in the database. # c.execute('SELECT REF_PNL FROM actual_data_table WHERE …  |
 | To help increase sales, your management decides to give customers a one-time bonus. Here are the credit rules: for 1-15 credits, add 1 credit for 16-30 credits, add 2 credits for 31+ credits, add 10% and round up (10% of 35 is 3.5, rounded up to 4) Write an update …  |
| | hello guys.. can anyone please help me i have created a Simple search for my database..the search form contains a drop down menu of the field names and user select the field name and input the keyword and then Click on search to retrieve matching records from that particular field.. … |
| | I just cannot get this solved and after way too much time on this, I'm here for help. Here's my code snippet: [CODE] while ($row = mysql_fetch_assoc($result)) { $domain = $row["domain"]; $domainwww = "www.".$domain; //$domainwww = "www.google.com"; $sql2 = "SELECT url_id, url FROM urls WHERE url='".$domainwww."'"; [/CODE] My problem is … |
| | Hello there! I have a question - I'm trying to display store categories (ex: Apparel and Accessories) in this code. The categories display perfectly, but when I click on said categories, they do not display the items underneath it. I've populated the database with a few values, but they still … |
| | I have a file upload website. Information about files and the files themselves are stored in a mysql database. I want to allow the users to delete their own files. On every line I have put a delete button. My concern is which is the most secure implementation. I am …  |
| | Hi, I need to update the product quantity in the product table according to the quantity which the customers ordered...Since I am new to this field I dont know how to do it with a query. This is what I want to do in more details.As the administrator checks for … |
| | Hi, I looked for any posts on this but couldn't find any, it should be pretty easy. I have a Company table with parent_id that points to a company itself. I want to get the names of the parent, if any. So if I have my table as cpy_id cpy_name … |
| | Hello there, I'm in the process of learning C# and windows forms. What I'm trying to do is adapt some scripts I have already made using PHP and MySQL to work in a windows environment and GUI. I previously wrote it using PHP because I was already familiar with the … |
| | Hi experts, I have a problem which is I can't write arabic text as values of table , here is the steps I have done , please help me and correct me if I am mistaken this is what I did: ************************************************** set names utf8 COLLATE utf8_general_ci; create database see; … |
| | i frnds, Many times i try to retrieve image from database. Successfully it upload to database. but cant retrieve. any one know this? Thanks in advance.... |
| | Hi, I would like to make an Online Course Application System. I'm just wondering, what are the frameworks,technology that I need to get started? I'm thinking of using PHP and MySQL. I've used Joomla before, but for normal web page, is Joomla capable of handling such system? Thanks. |
| | Hi, i have been trying in vain all day to assign child name to a parent id in an innodb table with foreign key. I can retrieve the parent id fine, but the problem is when i try to insert child name, PHP doesn't seem to be passing any values … |
| | Im getting an sql error saying "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 '' at line 1" These are the 2 queries... $sql = "DELETE FROM tbl_category WHERE cat_id=$cid"; $sql2="INSERT INTO tbl_sales … |
| | I want to match two tables values in different databases. How i can do this?  |
| | Information is arranged that You can assign highest to the least. Ascending or time. If the text is Ascending. They are sort of az if a number from 0 up to sort it indefinitely. Now it is a problem that If we want to give it up before then bangkok … |
The End.