[mysql] Forum Topics

I'm new at SQL, and i found this book that is amazing, so, i thought it would be cool share it with those guys (like me) that want to study Databases (SQL specifically) and don't know where to start... maybe we can exchange book titles and stuff, so we can …

I've been told this isn't possible which leads me to the following problem. I have a series of events stored in a database and at the moment I pull the info out and display each one on a new line using a while loop. What I'd like to do now …

i need a help.. i wanna insert an images into MySql database.did anyone have code snippet for my problem?..i hope u can show to me step by step,from the form to the final step insert an images to database..tq

Hi to all, I have a question and I hope to have an answer here. the Question is, is using MySQL DB in commercialweb site free of license or not? I know it's an open source, and to the best of my knowledge the using of open source applications like …

hi, Can anyone please show me how to use siss, and how to load data using SQL Server and SSIS. thank you

hi all, i have a string for example: $str="The annual general meeting is scheduled on ::date:: at ::time::. you all are requested to be present on ::date:: at ::time::." i store it in the Templates_T table in my DB. Template_ID =1 [for eg.] now this format can be used further …

I'm trying to write a little wrapper for executing MySQL statements, and I've run into a wall trying to use [inlinecode]mysqli_bind_param[/inlinecode] without knowing the number of variables I'm binding. Here's what I've got: [code=php] /** * Note: * . execSQL is variadic, just like bind_param * . prepareTypeStr is another …

i want a date selection form in jsp and that date variable should be caught in servlet so that i can insert date in mysql. its very urgent plz help me

Hi This is Rahul, i am a new commer.... any one solve my problem..... i have designed a form (LPO)in which it contains two panels. in that first one i put one combo box ie item code,which is alrady in the vendor master form. here in my lpo i chose …

Hi, I have this code. It works fine using PHP 4 and MySQL 5.0. but it doesn't work at all on my webhost (php4 mySQL 4) and I cannot for the life of me figure out why. Here's my code: /<? // Connect database. include("connectdb.php"); //if "Submit" button is clicked …

hi, I have only done basic sql queries and need help on this major one trying to combine many queries into one. What I need is to make the following queries into one: [code]SELECT Username, LastLogin, DateCreated, Views, MainPic, Logged FROM Users WHERE UserID=? SELECT COUNT(AlbumID) FROM ProfileAlbums WHERE UserID=? …

hi, I have only done basic sql queries and need help on this major one trying to combine many queries into one. What I need is to make the following queries into one: [code]SELECT Username, LastLogin, DateCreated, Views, MainPic, Logged FROM Users WHERE UserID=? SELECT COUNT(AlbumID) FROM ProfileAlbums WHERE UserID=? …

hi all, right now i'm trying to migrate from db2 running under linux to mysql v5.1. i manage to export out the db2 structure & data into a del (ascii) file. but when i try to load the data from the del file to mysql table, it generate an error. …

Hello everyone I have some code listed below, well with this code I it does not display anything in the listbox. When I have it displaying the stuff in the listbox it does not display the correct stuff...like less than 10. I have put the line of code in bold. …

Hey everyone, I'm working on some javascript code. What i have now is a list box that contains certain elements and another list box, blank at the moment, next to it. I want, when someone clicks an element within the first list box, that in the background, a MySQL statement …

:?: Greetings, I am brand new to php and mysql so get out the asprin. smile I am making a php file to pull information from dat files to update my database. When I run http://www.sandpointrealty.com/read2.php I get this error Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result …

Hi, I am new to mysql connectivity using jsp. but i have tried it with MS Access nd it worked out for me. I have installed jdk1.4, Tomcat5.0, mysql 4.1 and mysql_connector_odbc_3.51.21_win32.msi. For the following code i am getting error code 500.. I have set the Env paths as path …

Hi this might sound like a simple question to most but it is something that i have been trying for quiet a while. I have a table in mysql, which contains a name of a football match, date, time , and one of the variables is a link address to …

Hi, I am getting Error 302 "Object moved to here" from Spiders and from msn.com Click [URL="http://search.msn.co.uk/results.aspx?q=www.taylorsnet.co.uk&geovar=en-US&FORM=REDIR"]Cached Page[/URL] Can any body explain? The page contains one Response.Redirect(URL, True) in code but it if in a button It also contains five SQL Select statments Is this caused by ASP.NET, Me or …

[code=php] <HTML> <?php if (empty($CSP_Name) || empty($Supervisor) || empty($Rep_Number) || empty($Department) || empty($Account_No) || empty($First_Name) || empty($Last_Name) || empty($Phone) || empty($ShipTo_Address) || empty($ShipTo_City) || empty($ShipTo_State) || empty($ShipTo_ZIP) || empty($Accept)) {echo "<h2>Please make sure you have filled in all required fields. Please use your browsers Back button</h2>\n"; echo "<h2>******REQUEST WAS NOT …

I get the following error in my code: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in.....line 20 This same thing occurs in lines 28, 54, 55, 108, and 109 I get another error in line 51: Warning: Cannot modify header information - headers already sent by …

Hi all, I am new here, (as you might have guessed :) After I get the PHP/apache thingy working Or kill myself whichever comes first I will be needed to set up a db back end I would like to pose a question to you learned folks. I notice many …

[COLOR=#000000]Hi,[/COLOR] [COLOR=#000000]I have this program written in Perl and to be tested on Linux-Fedora.[/COLOR] [CODE] #!/usr/bin/perl use Mysql; $host = "localhost"; $database = "DVDRentals"; $tablename = "Orders"; $user = "root"; $pw = "password"; # PERL MYSQL CONNECT() $connect = Mysql->connect($host, $database, $user, $pw); # SELECT DB $connect->selectdb($database); # DEFINE A …

recently i created a system using php and mysql to record faults that the ict technicians could get reported faults out of. so far it does everything i want but some senior members of staff now want the front end to give a report of status, one of the things …

Alright, this one has me stuck. I know it's possible, because I've seen an example in another thread, but mine is slightly different, and I can't figure it out. Ok, I have one script that pulls all the rows from a database, and displays the data using a while loop. …

hi guys... i have two static value and between 8 and 16 other dynamic variables...which returns from sql queries everything.. like page titles, subjects etc... everything based on number in tables, Statics: Language and Index Dynamic values: Categories from 1 to 6 SubCategories from 1 to 10 system works like …

I have a few questions for those who know so much about the web.. 1. Is it better to declare.. 20 variables and do all your SQL queries immediately, or to do like 10 variables and open your connection, do one query, then reset your variables and runt he queries …

Hi everyone. I am new to PHP and MySQL. I am trying to create an RSS feed that gets content from more than one database table. The database tables are "categories". And I want to retrieve the latest content from those categories for the RSS feed. I want to retrieve …

Hey everyone, i have a Mysql database and Php setup on a linux server. all are updated. WEll i have a form in which a user can enter three words.(not all at once) to perform the search on the database. Forms and php coding shown below. I have one index …

I've been configuring PHP with MySQL and ran into a few issues. I uncommented the line to include mysqli.dll and set extension_dir = "./ext". It still isn't working. Not sure if I'm missing anything. Got any clues?!

hi everyone.i want to develop a web based Exhibition using HTML with Dreamweaver & MYSQL. but i don't know from where can i begin my project.please tell me what things to include in my project.any one help i really appreciate.10qs

Hi there, My database contains two tables namely [B]Products[/B] and [B]Stocks[/B]. Product table consists of [B]ProductName(VARCHAR[100]), PackingStyles(VARCHAR[2000]) and Grades(VARCHAR[2000])[/B]. Primary Key is the combination of these three fields. The values of PackingStyles and Grades are entered using a listbox and so they are stored as comma separated values. The Stocks …

if you are having problems with encoding pages/characters, try this. <?php $servername='localhost'; $dbusername='myusername'; $dbpassword='mypassword'; $dbname='mydatabase'; connecttodb($servername,$dbname,$dbusername,$dbpassword); function connecttodb($servername,$dbname,$dbuser,$dbpassword) { global $link; $link=mysql_connect ("$servername","$dbuser","$dbpassword"); if(!$link) { die("Could not connect to MySQL"); } mysql_select_db("$dbname",$link) or die ("could not open database"); } ?> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9" /> <meta http-equiv="expires" content="now" /> …

Hey guys! Right heres the problem, I have made this script that basically displays all the data from a table from MySQL; pricelist. However it only displays the data when i have to manually write in all the database passwords and names and stuff, however when i use the require_once() …

hi everybody, Iam using mysql.I have a login form in which user vl enter his name and password.Now when he/she types upper-case or lower-case in the username field,mysql unable to check the case.Is not mysql 4.0 not a case-sensitive.can anyone suggest how to solve it.

Hi! I'm strugling with this task for my wife's business. They produce a local weekly ad paper and they want a db to mange their business. I'm having trouble with designing the "Product" table properly. This is how their pricing works: [Ad size] --------[1 week]--------[4 weeks]--------[8 weeks] --1/2---------------$10 -------------- $9---------------$8 …

I am trying to use this script to enter data into my database from an html form. [code] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>Item Entry - Opulentworx - Private</title> </head> <body> <form action="/php/itemENTRY.php" method="post" id="itemENTERdb"> <input type="text" id="itemNUM"/>Item #<br> <input type="text" id="quant"/>Quantity<br> <input type="text" id="date"/>Date<br> <input …

Hi, I don't under what I'm doing wrong. In my line of code I have 2 outputs: The first outout returns a value, however, when I try to output the second ConsoleLine I get a value of "0"?? I'm thinking it has something to do with Converting a string to …

Hi there, I wonder if you can help. I am looking for a database of UK postcodes, cities/town and coordinates. I need this data in order to construct a search portal. Where can i find such data? Many thanks, Daniel

I am pulling a simple query but basing it off of a group of sums. What I want to do is pull all the information from "albums" where albumID equals "photos" albumID. Then Grouping by Photos.albumID, I want to grab the sum of all the views of each albumid, and …

Hello, I am trying to set up a string where it taps two databases, Albums and Photos. I need to select the following columns of Albums database and Photos where the Albums.AlbumType='Nightlife' and then order by the sum of photos.views desc for ranking the top 4 (limit 4) This is …

billion in the building. I joined Daniweb cos of the state of my php, mysql, javascript, xml - basically all my web languages. make sure you anwser/reply my questions even the dumb ones!

Hey, I'm using a while loop to display all the rows of a table in my database, and wondered if anyone knows how I can make it so the background color of each row alternates between two different colors. I'm using php to call the information, so I can stick …

I am using this html form page... [code] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>Item Entry - Opulentworx - Private</title> </head> <body> <form action="/itemENTRY.php" method="post" id="itemENTERdb"> <input type="text" id="itemNUM"/>Item #<br> <input type="text" id="quant"/>Quantity<br> <input type="text" id="date"/>Date<br> <input type="text" id="cost"/>Cost<br> <input type="text" id="ground"/>UPS Ground<br> <input type="text" id="3day"/>3 Day …

hello i am sharmila i have small doubt about php and mysql.please anybody reply me.

I have this code to update the DB by subitting values in the checked columns The problem is that it skips some entries and does not always subit the values entered SQL Query $thisid=$_POST['id']; $nvalue = $_POST['newvalue']; $chkd = $_POST['checked']; foreach ($chkd as $key => $value) { $sql="update invoice_subcategory set …

Hi, I'm looking to update a MySql database from an applet. The 2 roots I was thinking were: Applet->php->database Applet->servlet->database But my webhost doesn't allow servlets/jsp, so I would like to try the php route. I've looked on the internet, but I can't find anything concrete to use, just lots …

First of all this is a crazy thing I have just done.. so please sit back and read the whole post.............. Today I finished my math final and decided to learn a new programming language..... MYSQL. So I was able make my way to [url]http://www.freewebmasterhelp.com/tutorials/phpmysql[/url] using Google I followed most …

Hi, I want to create a script that can be run daily(as cron job?) and which does the following: 1) Queries a MySQL database to return details of registered users. 2) For each user, compares their expiry date with today's date and if the remaining period is either 30,14,7,3,2 or …

Dear friends, i have problem in encrypting and storing the password field in my sql server 2005 database. i want to concat my user name and password field and then encrypt and store using md5 in c# using visual stdio 2005 can anyone please help me out...... preethi