7,368 Topics
| |
I began to develop a simple coupon site. my db design Contains 4 tables: users deals category city when user purchasers a coupon i connect to getway payment service. in my accont at the getway service i can see all the transaction from my site. does it's meen that i … | |
I have a php/mysql/html table of results The query is [CODE]$result = mysql_query(' Select var1, sum(var2) round(Avg(var3),0) round(Min(Price),2), round(Max(Price),2), round(Avg(Price),2) as AvgPrice, Country, From table Where country = "Australia" Group By var1 having var3 > 5 Order By var3 DESC') or die("SELECT Error: ".mysql_error()); $num_rows = mysql_num_rows($result); print "<table width=800 … | |
Hi Guys, Can someone help me. I am using FCK Editor when I add a new news article to my website. When entering each new article, I have included an option where there is a drop-down list to select a particular news category. In the front-end of the website the … | |
Hello everyone, I have a problem with this code php: [CODE]<?php $sql = mysql_query("select * from news left join categories on news.category_id = categories.id group by category order by categories.id "); while($row=mysql_fetch_array($sql)){ ?>[/CODE] html: [CODE]<div class="title" align="center"> <?=$row['category']?> </div> <div class="headlines"> <span style="float:left;"><?=$row['subject']?></span> <span style="float:right;"> <?=$row['date']?> </span> </div>[/CODE] the problem … | |
please help me!!! im restarting the mysql server from putty: Empty pid file /var/lib/mysql/mysqld.pid for /usr/sbin/mysqld when i checked mysql status, unused running unused running what's the problem?? im using putty in configuring mysql server thanks in advance. | |
hello guys, please give me any idea about solving this problem. I have two tables categories: id .... category .... parent ________________________________ 1 .... general .... 0 2 .... news .... 0 news: id .... headline .... category_id ________________________________ 1 .... headline1 .... 1 2 .... headline2 .... 2 3 … | |
Hi people, well i am a computer science student and my dissertation title is "An Agent Based Tutoring System" and i am using JADE to do it and MySQL for the database. Can any one help me in doing it?? I want you people propose me some ideas so as … | |
[CODE]Imports MySql.Data.MySqlClient Imports System.Data.SqlClient Module connection Public conn As MySqlConnection Public Sub xconnect() conn = New MySqlConnection conn.ConnectionString = "Server=localhost;User=root;Database=test;pwd=;" Try [U][B][COLOR="Red"]conn.Open()[/COLOR][/B][/U] MsgBox("Success") conn.Close() Catch ex As MySqlException MsgBox(ex.Message) Finally conn.Dispose() End Try End Sub End Module System.TypeInitializationException was unhandled Message="The type initializer for 'System.Transactions.Diagnostics.DiagnosticTrace' threw an exception." Source="System.Transactions" TypeName="System.Transactions.Diagnostics.DiagnosticTrace" … | |
i got 3 users to be registered in the registration form through radio button admin,manager and employee... after registration of a admin the other 2 raadio buttons shud only enable in the registration form... admin shud be disable............ how to implement this in php........... | |
how to increase my mysql databse server partitioned in /var/lib/mysql using putty?? my server is linux open suse. can i have a step by step procedure??thnks. | |
i have mysql xml field like this [CODE]<?xml version="1.0" encoding="UTF-8"?> <record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.loc.gov/MARC21/slim"> <leader>00764nas </leader> <controlfield tag="221">011258</controlfield> <datafield tag="578" ind1=" " ind2=" "> <subfield code="a">jaun</subfield> </datafield> <datafield tag="356" ind1=" " ind2=" "> <subfield code="a"></subfield> <subfield code="c"></subfield> </datafield> <datafield tag="333" ind1=" " ind2=" "> <subfield code="d">ali</subfield> <subfield code="p">22</subfield> </datafield> <datafield tag="222" … | |
I have two tables that I'm using in this query. We'll call the first one "userGroups" and the second "links". I've included their structure below. I have one system that is running an older version of MySQL, and I also have a system running a newer version. Older Version: 5.0.91-community-log … | |
guys, can anyone help me on this problem? i have two tables then what I want is that, when an identical item is found in table2, it will not be displayed. Example: [CODE] Table1 Table2 item1 other1 item2 other2 item3 item2 item4 item3 [/CODE] Condition: if we use this query: … | |
I am wanting to set up a home server using an old computer, after doing some costs it would work out considerably cheaper than using a hosting service, and although less reliable I feel it would be some good and valuable experience. I have installed Ubuntu server edition onto my … | |
Hi guyz,, I have 2 table like, [B]table1[/B] [B]Name[/B], [B]Number[/B] Gates 123456789 Bill 987456321 John 874123658 Peter 562314752 [B]table2[/B] [B]Number[/B], [B]Message[/B] 123456789 Hai hello 874123658 Gudmorning 123456789 Something Went 123456789 verY Nice morning 562314752 Hai spidy.. My Question is how to select all records from table 2 and also i … | |
I have a mysql table that has id, name, type, size, content, and link. I have pages download.php and showimage.php. I want the link to affect the image so when the user clicks it sends them their. I only created showimage.php cause I had ran out of options on how … | |
i can't install vb.net connector 6.4.4 help | |
So, I wrote the following program to connect to my local mysql server and create a table in the existing "test" database. The program compiled without any errors, but I got the following run-time error: java.sql.SQLException: Cannot connect to MySQL server on localhost:3306. Is there a MySQL server running on … | |
I've run into a bit of a problem following a database replace last week. I need an expert in MySQL to help me out as I don't know a thing about the service. If you can help me, I'm able to offer $30 pay. It could be a piece of … | |
hi... im doing project for a school...and new to php and mysql..just learning.. i have to create one loginpage with 3 different users like corres,principal and the staff in the table field what type i have to give like ENUM or SET.. i want to assign 0 for corr,1 for … | |
Hi a have 4 tables [ICODE]Table A ID | Data 1 --------------- 1 | A 2 | W [/ICODE] [ICODE]Table B ID | Data 2 ----------------- 1 | B 1 | C 2 | X [/ICODE] [ICODE]Table C ID | Data 3 ---------------- 1 | D 1 | E 1 … | |
hi m using php n mysql m trying to merge two tables of same database and then print them but somehow it is not working it gives me the error my code is [CODE]<?php session_start(); print_r($_POST); $con=mysql_connect("localhost","root",""); mysql_select_db("pras2",$con); $date= $_POST['date']; $shift_num=$_POST['num']; $query="SELECT shift_id FROM shift WHERE shift_no='$shift_num' AND date='$date'"; $result=mysql_query($query); … | |
please help me!!! im restarting the mysql server from putty: Empty pid file /var/lib/mysql/mysqld.pid for /usr/sbin/mysqld when i checked mysql status, unused running unused running what's the problem?? im using putty in configuring mysql server thanks in advance. | |
I'm running the following code in PHP to generate the random list of movies from the database but since value of genere is an array it is just capturing the first value of the array. How can I modify the query so that I can get all the values of … | |
Hi, I have this program that uses OLEDB connection to open the excel file, and imports it's data. Then I use mysql connection to inserts all this data. Now my question is, is it possible that I can use mysql connection in opening the excel file, or only OLEDB connection … | |
Hi all........... I shud just how to use ENUM type in mysql..like shud i give any field in form in a website and how to assign a values for eg 0 for admin,1 for manager and 2 for the staff using phpmyadmin?? please help me................. | |
Hello I'm looking to allow users upload pictures onto my site and have it displayed and linked to their site.. This process is for Ad purposes. Ive looked into php mysql uploading images but ive ran into a lot of threads condemning the practice and suggesting saving the images to … | |
Hi everyone, I had this problem with phpMyAdmin and successfully fixed it. Then, after some days, I encountered the access problem with the WAMP server. I haven't changed anything yet. Or maybe, I need to set up the environment variables? The message I'm getting is that [QUOTE]Forbidden You don't have … | |
Hi I have one sql query. using this query i can download 10 lakhs of data in csv file for 6 hours. now i want to download 20 lakhs of data for 6 hours or less. please tell me how to increase the performance. SELECT id as imp_addr_id,userEmail, email ,name,mobile_no,gender,city,income,profession,experience,country,pincode,type … |
The End.