7,368 Topics
| |
I'm currently linking two different tables in two different databases. One contains all the info from a product, while the othe contains information about the installation of the product. The SQL I use only returns those products that HAVE an entry in my install table, but many don't ie they … | |
| This is a MySQL PHP question... how to count no of fields in a perticular database and in a perticular table?? I have three columns in a table :id , name , info I have to print the unique persons.. how could I?? How to code it in php?? Can … |
| How to print more than one results in a page?? I want to print 10 results per page and show next button if it have more than 10 results.. In the next button it will show another 10 results.. How to code it..?? And please explain the code if you … |
Hi, I'm actually drafting a MySQL query to be fed into Jasper Reports, and since I can no longer manipulate the resulting data in PHP as it will automatically be translated into a chart by jasper, I need my mysql statement to be able to generate what I need on … | |
Pls help: [B]Warning:[/B] require(connect_to_mysql.php) [function.require]: failed to open stream: No such file or directory in C:\wamp\www\chibenda\root_directory\index.php on line 3 [CODE]<?php $db_host = "localhost"; // Place the username for the MySQL database here $db_username = "root"; // Place the password for the MySQL database here $db_pass = ""; // Place the … | |
I need to write a method to return the number of rows I have in my table. This code I've written so far; [code] <pre><?php class Database { private $connected=false; private $user,$pass,$host; private $db; private $result=array(); public function initialize($user, $pass, $host) { $this->user=$user; $this->pass=$pass; $this->host=$host; return $this; } function connect($dbname) … | |
Hi, got some help from tesu on another thread but i am struggling to get this working. my individual query returns 2 results which is correct from the database. however when i try it with a view joining the multiple table with same query it returns 2 results but only … | |
Hi, I am setting up a notes table, and wondered what the best type would be? Currently i have set it to Varchar with length 500 Would that take up more space than say a Lontext type in the database? Thanks | |
Hi, I got some great help on the forum to create my total due query. However it produces it with just total due, how could i have it by month? each table has a DueDate column which i would like to show on the query along with the users FullName … | |
Hi guys, Need some help here. I have created an individual query for each product which works absolutely fine. However i want to be able to join it so i can display on my page who is due for a review. [CODE]SELECT clients.*, protection.* FROM (clients JOIN protection ON protection.clients_ClientID=clients.ClientID) … | |
Hi, I am somewhat new to PHP and MySQL and I am having a little trouble with what I want to do, which is assign a cell for each option selected and a price or insert the price into MySQL table depending on the option selected. Whichever is easier or … | |
I'm developing a very simple VB app in Visual Basic 2008, where i have a textbox being dynamically updated with a value every second, i need this value to be inserted into a mySQL DB, i have made the connection ok but not too sure how to structure the VB … | |
Hey there, I have a code to remove the duplicates in one of my table but I cant seem to be able to ORDER the way mysql select the values. Here is my initial table: [url]http://img196.imageshack.us/img196/2421/tablesw.jpg[/url] [CODE]mysql_query("CREATE TABLE new_table as SELECT * FROM test GROUP BY url") mysql_query("DROP TABLE test") … | |
Hi, need help with inputing images to mysql. I read lots of previous thread about it but couldn't find the proper answer. this is code for my basic form: [CODE]<form id="form1" name="form1" method="POST" action="<?php echo $editFormAction; ?>" enctype="multipart/form-data"> <table width="100%" border="1" cellspacing="1" cellpadding="1"> <tr> <td>tytul</td> <td><label> <input type="text" name="tytul" id="tytul" … | |
I have 3 tables. Here is the relevant information needed for each. items ------ prod_id order_id item_qty orders -------- order_id order_date order_status acct_id accounts ------- acct_id is_wholesale items is linked to order by the order_id and orders is linked to accounts via acct_id I need to sum item_qty for all … | |
Hi, I'm trying to make a rather simple Visual Basic app with which I can update some tables within my MySQL databases. I've been following [URL="http://www.vbmysql.com/articles/vbnet-mysql-tutorials/the-vbnet-mysql-tutorial-part-3"]this tutorial[/URL] from page 3 on, as the first 2 pages where on how to initialize a local MySQL database. My MySQL database is on … | |
| I have created one php file which open a mysql database in my local system... I want to know that i have created a database in PhpMyAdmin.. What would be the user and password.. And how to run that php file.. Can I run it in a web browser to … |
hi guys really i don't know what im doing wrong... i am trying to process multiple radios with mysql. the first step has involved me echoing the results on the process page. each time i select any radio option it simply displays the first row result. this is that i … | |
[CODE]<?PHP $results = mysql_query("SELECT * FROM messages, comments WHERE messages.user_on='$user2' AND comments.msg_id_fk = messages.msg_id ORDER BY messages.msg_id, comments.com_id DESC") or die(mysql_error()); ?>[/CODE] | |
Hello Guys... I'm a novice in both php/mysql. I'm creating an application and have many problems with it.I need help with some of the areas. First my application is a multiple forms based. The first page is that an admin logs into it by authenticating with mysql (This part I've … | |
| Hi, I am beginner in PHP and MYSQL ... Before using mysql i have created database in text files.. Now I have to convert it into the table of mysql database.. The things i want to do is .. first open the specific folder and into that open the sub … |
| Hi, I am beginner in PHP and MYSQL ... Before using mysql i have created database in text files.. Now I have to convert it into the table of mysql database.. The things i want to do is .. first open the specific folder and into that open the sub … |
G'day, I've got a small problem. As all who post here usually do. I've got my table [CODE]CREATE TABLE IF NOT EXISTS `attractions` ( `attID` int(11) NOT NULL AUTO_INCREMENT, `attName` varchar(255) NOT NULL, `adultPrice` double NOT NULL, `childPrice` double NOT NULL, `referenceID` int(11) NOT NULL, PRIMARY KEY (`attID`), UNIQUE KEY … | |
Hello all :) Me and a friend of mine we are working in a project at the moment. We populate our database each one with his own data but now we need to merge our tables. The database has the same name in both machines, and also table name. I … | |
I am trying to create a set of league table in MySQL and PHP. I can get the tables to show the top and bottom 5 values but the problem is when I have less than ten records in the system. When this occurs the same people can appear in … | |
Hi all, I am a php rookie. I like to get a PHP function returning an array which gets a string(search query) and db results(an array) as arguments. This array should be sorted in ascending (alphabetical) order with search query positions. I tried of querying the results but i struck … | |
Hi, I was wondering if someone could help me, i have nearly complete my site and need some help creating the queries to produce my commission and pipeline. my table structure is: [CODE]CREATE TABLE `pipeline_commission` ( `ProductID` varchar(75) NOT NULL, `Pip_CommID` int(11) NOT NULL auto_increment, `PipComm_UserID` int(11) default NULL, `clients_ClientID` … | |
Is there a way to get a distinct value from a table and echo it as a id for a div tag and still have the rest of the values echo too? Say I have a table with these values: category item With 3 categories each having 3 items I'd … | |
[CODE]#---------------------------- # Table structure for litorder #---------------------------- CREATE TABLE `litorder` ( `id` int(10) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `address` varchar(50) NOT NULL default '', `xdate` date NOT NULL default '0000-00-00', `ref` varchar(20) NOT NULL default '', `code1` varchar(50) NOT NULL default '', `code2` varchar(50) NOT NULL … | |
hi friends I am developing a osCommerce website and I am strucking with displaying items. Ok Ill explain what my issue in my site ok I am using a sql query to display all the product in database. ok this is my query [CODE]$products_new_query_raw = "select * from " . … |
The End.