[mysql] Forum Topics

The query below is correct. It returns the rows `paul` and `rick` because they have the highest rating of the child rows. This was solved for me with the below link. I am having trouble understanding the query. I understand joins, what i don't understand is `t2.rating is null`? [URL="http://sqlfiddle.com/#!2/97e60/2"]http://sqlfiddle.com/#!2/97e60/2[/URL] …

i have a page for user registration where i a form with a image tag to it. i want the user to fill the form but as soon as he uploads the image i want the image uploaded to be displayed on the image tag. Then i want all these …

how to create crystal report using sql quary in vb.net step by step.

Hi, I want to know. How to filter data. I have two mysql table as follow name: task_id task my_id 22 aaa 1 22 bbb 1 23 ccc 3 23 ddd 4 24 fff 5 subname:: task_id task my_id 24 fff 1 now my id is 1. I want to …

Hi to all, I want to pass the below statement to a report... Kindly help me how to do it ... select a.po_number,a.mr_number,b.item_code,c.item_desc, b.qty,b.rate from po_head a,po_detail b,item_master c where a.mr_number=b.mr_number and b.item_code=c.item_code and po_number = ' & combopo.text & '; kindly help...

Hi guys well I have two class's 1 class for my methods and another class for my GUI. In my method class I have my update statements for my database and in my GUI class I have obviously my gui and all my buttons that will produce a result when …

Ok. I am building a program for a small office and I have a little problem with the code so I thought it's better to post a topic before continiue.. I have search into google and a lot of forums about database connectivity and my problem is simillar to other …

Hi, I am making a website for a car database. I made a table called Cars with fields Name,Make,Model,Color,Doors. I have also made a search function: [CODE]SELECT * FROM Cars WHERE Name LIKE '%$search%'[/CODE] This is a general search that will search the whole table, but what if I wanted …

I set up a MySQL databse following this tutorial: [URL="http://www.saltycrane.com/blog/2008/07/how-set-django-mysql-ubuntu-hardy/"]http://www.saltycrane.com/blog/2008/07/how-set-django-mysql-ubuntu-hardy/[/URL] Here is what I did: [CODE]$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.0.51a-3ubuntu5.1 (Ubuntu) Type 'help;' or '\h' for help. Type …

Basically my app obtains data from a mysql server and displays it in a list view. What I want is for data from different columns (but the same row) to be as different items in a Dialog Box. I followed a tutorial on how to connect to a mysql server …

Hi I am having problems with authenticating session. I moved this over from a different site where I was testing it and didn't change anything but now it doesn't seem to be working. The site connects to the MySQL data base and if the info is wrong it says so. …

This is my first post on Daniweb. I am developing a social networking site and the register form isn't quite working as expected. Here is the PHP code : [CODE]<? $title = 'Register' ?> <?require ('scripts/top.php'); ?> <link rel='stylesheet' type='text/css' href='scripts/form.css'/> <div id='content'> <h1> Register an account </h1> <div id='form'> …

Guys I installed mySQLdb in Ubuntu with: [CODE]mydeskt@mydeskt-desktop:~$ sudo apt-get install python-mysqldb[/CODE] but when I go to the python interpreter and type: [CODE]>>> import mySQLdb [/CODE]I get: [CODE] Traceback (most recent call last): File "<stdin>", line 1, in <module> ImportError: No module named mySQLdb [/CODE]It is installed though, because when …

hi i have a problem in binding sum of my sql table column's in sp format into a text box could you help me i want to know how can i bind stored procedure out put result in c# sharp i want to sum a column of my table and …

Hi thought i'd try here see if anyone can help solve this quicker. First off we have a email database. The main table is the email data, all unique rows per email address with a unique id. eg. emailid,email 1,email@example.com 2,email@example.co.uk Next we have another table which logs the data …

I have been having some issues with a date compare I have been getting a date from a database in YYYY-MM-DD format, and trying to compare todays date to that date to see if it has expired, then also a 30 day from the YYYY-MM-DD to check if it is …

I have bought a legal copy of SQL Server 2000 to put on one of my websites but can't seem to get it to load. Any ideas?

Dear Experts, I'm newbie in php. Can anyone please help to check my code as below: Blank value inserted to Mysql using dropdownbox. Thanks in advance. [CODE] <?php mysql_connect("localhost","root","") or die("Error: ".mysqlerror()); mysql_select_db("project_Test"); $Serial_Number = $_GET['Serial_Number']; $sql = "select * from `TestTable` where Serial_Number = $Serial_Number"; $query = mysql_query($sql); $row …

I would think that this wouldn't be a complex thing, but I guess I'm wrong. I want to create tables in a database based upon a string created by input variables including a parent ID. My Code: -- create table named the value in @newname SELECT CONCAT('Entity_', @@IDENTITY) into @newname; …

heyy guys...really could use some help here... my table is not updating its value, but there are no errors...the syntax seem to be correct [CODE] <?php session_start(); $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="testing3"; // Table name $invoice_no=$_SESSION['invoice_no']; $container_no=$_SESSION['container_no']; // …

hey people please tell me what to do , when ever i use mysql_fetch_array(data) i get this error : [CODE] Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in C:\xampp\htdocs\awah.biz2\classes\class_lib.php on line 34 [/CODE] please tell me what to do , here is the class_lib.php: [CODE] <?php class …

Hi, I am making a website for a car database. I made a table called Cars with fields Name,Make,Model,Color,Doors. I have also made a search function: [CODE]SELECT * FROM Cars WHERE Name LIKE '%$search%'[/CODE] This is a general search that will search the whole table, but what if I wanted …

Hello everyone. First, a little about me. I started off web development in .Net (C#) and found it to be not suiting my style. Then I moved on to PHP and instantly fell in love with it. I've been practicing it for the last 40-45 days and have covered up …

Hey guys I was hoping I could get some help with the design of this database. If need be, I'll try to explain it best I can of what it's supposed to do, I think I have most of it set up right, I just think something is wrong with …

I use dreamweaver, PHP and MYSQL. I need some help and any is appreciated, I have alot of knowledge in html learnt from some college, little in php and none in mysql, I am self teaching php and mysql, so forgive me if the question is too easy. :) Ok …

is it possible to have a script that when i run that script it will log into a database and delete all the entries from specific database tables? if it is how would that look for database name "test" and "table 1, table 2, table 3, table 4 and table …

I wanna to know the difference between mysql_fetch_Assoc and mysql_fetch_Array..I am a little bit confused at its usage..Kindly provide with a sample example also...Any help would be appreciated

How to connect mysql with difference server If my all file is in 192.168.0.100 and mysql server is 192.168.0.200 I got Error "sorry, could not load your data, please try again later" when try it. If bote all file and database is in same server , It run correct. [CODE]<?php …

I am adding a csv file upload script for my webid auction site. I tested it outside the webid script in a simple test database and it worked fine. I need to make some changes to it. It should catch the user's id and create an auto increment item id. …

hi, I am currently making a website and was wondering how to make it so that when a button is clicked it will update a field in the database by +1. This is sort of a 'like' system for photos so someone can view a photo and then press this …

I have a LAN connection with my project and I need to display a running time and date of with labels anyone have an idea? is it curdate and curtime?

I need helping thinking though something. I am pulling dates, Year, Month of that year and an amount. I then want to go to the next year. So, 2010 then 12 rows of the months with amounts, then 2011 then 12 rows of the months printed out with amounts... Ex: …

I am using Doctrine as my ORM and it only reads XML/YMAL files and I was given a schema in form of MySQL script. Is their anyway to dump a MySQL db to a ymal file?

I have a [I]fairly[/I] simply query that is taking a long time when run from C# via [icode]MySql.Data.MySqlClient.MySQLCommand[/icode] but the same query runs about 100x faster when I run it through the MySQL Workbench (GUI utility) Here's the code in C#: [code] tCom.CommandText = "(SELECT ID, Timestamp FROM jobdata WHERE …

I want to retrieve email from database and send message to all the email address. I have written code for that but it is not working. I want someone to help me look at the code below and point out where am making mistakes and the correction. The first page …

Good Morning... First let me start by thanking those of you that respond with great education information in here.. You have made my learning curve (time invested) much shorter than it would have been with just a reference manual. I know I still have a lot to learn, but this …

Hey everyone, The query i'm trying to perform shows a list of auctions that a user has bid on, name, id, date ended, current price etc. But also the number of bids that the user has placed on the time. [CODE] SELECT id, name, count(*) AS bid_count FROM wp_wpa_bids WHERE …

Hello people, I hope everyone is well. I have just started learning silverlight and retrieving data through Linq to SQL. I have a problem with retrieving certain coulums from the table. I can retrieve through an object that retrieves all the columns but I don't want this. i managed to …

Ok, as easiest as i can explain. - There are many child.sid to parent.id - There are many child.nid to child.sid - There are many child.id to child.nid child.id is just the id of a child row. And each row has rating column. In the query i'm grouping by child.nid. …

Hi! Could someone show me how to implement swap algorithm in php and mysql? ie: I have 4 records in a table each are sorted by column position say position 1 2 3 4 if I move an existing position from 4 to 1 number 1 will be moved to …

good day guys; I hope somebody could help me again with my problem I'm working with this for a month now and It seems I cant analyze what's wrong with my code. now here's what I want to happen I want to count and pull the records from a table …

hey.can someone help me..??? how can i filter records from the database depending on the length of each record??? example..i only want to display records with the length of the fieldname lastname <> 5. what is the formula for this using crystal report?? im currently using this: length({tablename.fieldname}) <> 5 …

Greetings! I have a website [url]www.lanceronlinejobs.com/our_franchises.php[/url] I have a franchise images. I want to display each franchise record from database whenever a user click on franchise link. Here is my code. ourfranchises.php code: [CODE]<?php include('fconnection.php'); $sql = mysql_query("SELECT * FROM tbl_franchise ORDER BY id DESC") or die(mysql_error()); $row3 = mysql_fetch_array($sql); …

Hi all, I'm sure this is a simple problem, but hopefully someone will be able to help. I'm trying to connect to mysql through perl, however when I use the command [CODE]use Mysql;[/CODE] it is giving me an error. I am assuming it is probably something to do with the …

hello there im trying to add 2 links to a login menu after the user had logged in it should display there name followed by you are logged in. but if there user level is -1 then it should also add below that the 2 links create fixture and reset …

HI All, Whenever user clicked the check box and used the things... its should be updated the current column. Here is table table 1 2 table 2(current value) 1 = becaused one of the items been used for work. Could anyone please give me some example..

I want to select records from my table which have a date which is older than 200 days. The following code calculates that date and displays it on the page as '2011-08-10': [CODE] $todayDate = date("Y-m-d");// current date echo "Today: ".$todayDate."<br>"; //Subtract 200 days from today $rptdate = strtotime(date("Y-m-d", strtotime($todayDate)) …

Hello all, Guys need some advise and some help regarding displaying data from database... so, basically this is what i'm trying to do, have a keyword (invoice_no)...i'm suppose to search the database, and the find record...the display the remaining attributes (document_no,pallet_no and so on) invoice.php [CODE] <FORM ACTION=".php" METHOD=get> <h1>Enter …

This question was asked in my viva. Each Foreign key must exist as a primary key. Foreign keys values can change over time.. According to me the second statement is false.But he said that they can change values...Is it so???

i have 2 methods to check if words appear within a piece of text, the method only checks for a word once but i want it to check more than once [CODE] while ($pos_words = mysql_fetch_assoc($pos)) { if (strpos($review_text, $pos_words['word']) !== FALSE) { $good++; } } //Get negative words and …