18,960 Topics
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 …
this has been driving me nuts. It should work. $value2 is an array with two strings in it. mysql_num_rows should return 1 row for each string. instead it returns zero. I simplified it below and cannot get it to work. it should echo "equals one". [CODE]$value2 = $_POST['topic']; foreach($value2 as …
Hi.. i'm new to JSP. i'm currentli tryin to compare two tables in mysql and reflect the difference. i used the code below but when i display it..nothing is being reflected.Please do help and guide me.Thank you. String sql = "Select * from examinerdb where NOT EXISTS(SELECT * from dbexaminer …
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 …
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Data Store</title> </head> <body> <?php $host="localhost"; // Host name $username="root"; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="sample"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", …
the problem is mysql_num_rows is returning zero rows.. when it should return 1 row. the variable $value is an array with two strings (testa and testb)... when i remove the foreach loop and replace $key with 'testa' in the query it works(returns 1 row). how do i solve this?... both …
Sorry but i am really having a hard time with these datasets :). if anyone knows a awsome tut on them i would be very gratefull what i am trying to do is use a database then fill the datasets. i can do that part. but now i want to …
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 …
Hi Community of DANIWEB, first time here, first post below...and I'm pretty new at this as well. I'm getting this error "Column count doesn't match value count at row 1" My code is: [CODE]$insertSQL = sprintf("INSERT INTO tearSheet (". "compType, ". "compType2, ". "report_date, ". "numEmployees, ". "cliNumber, ". "execSummary, …
Confusing question? The only way I can explain it best is to show it: [CODE] Table1 --------------------------- Name Num1 Num2 Num3 Devin 224 18 845 Scott 322 32 652 Jim 179 46 929 Tim 202 41 562 [/CODE] [CODE] Query Getting Max Value --------------------------- Num1 Num2 Num3 322 46 929 …
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 …
Please help me to make a program regarding on connecting vb.net user login program into a sqlyog enterprise database.. Please help me....
I have a simple 2 option drop down menu which corresponds to a column in my database. The drop down menu is not populated by the database it is just used to update the data in that 1 column. However I was wondering if it would be possible to make …
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....
I have a HTML form Having two fields [B][I]From:[/I][/B] and [B][I]To:[/I][/B] both are [I][U]text[/U][/I] fields(to genereate a report).I want to use these data to query on two tables based on the date specified(DD-MM-YYYY) i.e from and to and using these to select values from the two tables visitor_in and visitor_out …
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 …
Who can repair this it really a wizard. I try to add a column to an existing table. It a compound foreign key column from ather two. [CODE]ALTER TABLE valoare_lucrari ADD COLUMN id_oferta FOREIGN KEY (id_ofertant, id_proiect) REFERENCES valoare_lucrari(id_ofertant, id_proiect)[/CODE] It may be a problem of sintax or even it …
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 …
I have Webpage written using PHP that displays data from MySQL tables. I want my page to refresh after new records are entered to the database.
<?php $con = mysql_connect("localhost", "root", ""); if (!$con) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db("kar",$con); $sql = "SELECT * from valid"; $result = mysql_query($sql,$con); print_r(mysql_fetch_assoc($result)); echo "<br>"; mysql_close($con); ?>
Hi, I am about to blow my brains out. Im sure you've been there! I am trying to create a table in my MySQL database and getting this error -> SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds …
I teach debate at my school and i was wanting to create a way of posting team scores from each match. The part I am having trouble at is the rank. What i want to do is to rank each set of points ( FOO & BAR ). Then use …
Can anyone help me? Can i know what is the difference between superkey and primary key? what is actually candidatekey?
Hi all, I've been learning PHP and SQL slowly over the past couple of weeks for a project (so please be gentle!). I have a database, MEMBERS, as follows: [CODE] ID | Name | Job Title | Current Employer | State | Manager 1 | Joe Smith | Sample Title …
The script is supposed to receive data from a HTML form and update the table based on the supplied information. This is what I get: "Connected successfully Selected successfully Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in on line 39 Query was empty" [code=php] <? $name = …
Hello fellow daniwebians. So I've encountered this problem with querys in PHP. In the system I am working on at the moment we've created an install file which tests the db connection, creates the db structure e.t.c. But when creating the database the query fails. The query it self i …
i wrote a query... it must return false instead its returning false..i cant find why public static function find_cart_id($cid){ $query="SELECT customer_id FROM tblshopping_cart WHERE customer_id='$cid'"; if(mysql_query($query)) { return true; } else { return false; } } even if i use some text instead of `$cid` it still returns true :( …
I have added case 9 into this document and added the appropriate entries elsewhere to make it work however i cannot get this to enter the checkboxes correctly. When i go to the form and I select checkboxes and i list the options and sav ethem, it goes into the …
I need help in deciding which DBMS is best suited to fit my system, would it be MySQL or SQL Server Express. The system is a TPS,it stores and manages job applicants data (name, address, gender, educational level, skills, etc). Since I am only a student and this is just …
Hellow programmers, I have a table with two columns as foreign keys and I need to obtain a composite foreign key. what is the correct sintax? Alter table..... Thank you in advance
Hi everyone I'm trying to create a PHP/MySQL script which will allow a user to enter some details about an image (.jpg or .gif or whatever) and upload it to a MySQL Table. Now, I've got it working perfectly in Firefox 3.6.8 and in the script portion below, it outputs …
Hi sir's outthere,i need youre help...Please i need to strip the html tag in my record in my mysql database here's how it look in my database CITY Country ADELAIDE | AUSTRALIA</td></tr></tbody></table></div><div style="clear:both; paddi hope somebody know how to strip this tag. i try $country2a = strip_tags($cntry); but it didnt …
Ok, here's the catch: i am using ExtJS + PHP + MySQL to make a real-time chat site, based solely on AJAX requests. Yea, reverse AJAX would be cooler, but i haven't met anything easy to use enough to incorporate. (maybe you could suggest something !) The site would be …
Hi I am using Navicat and have two tables that have a one to many relationship. I have a table called rlbbulbs and a table called rlbbrand. brandID is the primary key in rlbbrand and is supposed to be the foreign key in rlbbulbs. Navicat has a way of creating …
Briefcase application Access 2003 two way replication Are there any open source databases that allow two way replication exactly the way Access 2003 handles it? I have a desktop app that I would also like to have live on the web but I have to use Open Source software like …
Hi i am trying to design a social networking site for my project. i have to design the database for the social networking with user profile and friends contact list as like facebook and orkut. can anyone help me to implement the database design with fast and accuracy retrieval of …
Hi I want to create a database that can store the friends contact list as like social networking what is the best way to design the database structure and easy to retrieve the contacts of friends using mysql. i need solution for this, HELP ME regards ~Deepu~
Hello all, I need to find all the records of one table that relate to ALL records of another table. I was thinking that I can check to see if a two tables are equal (via sub-selects). Is there a way to compare tables in SQL or is there an …
I am using the code below to insert the username and password to keep thi id and password record i want the change that if the id and password exist it replace the id and password in the database [CODE]$username=$_POST['login']; $password=$_POST['passwd']; $con=mysql_connect('localhost','root',''); //establishing connection with server mysql_select_db("sql", $con); //selecting DataBase …
Hi all, I try to view latest date and amount from history table for each branch (branch table :viscawangan). But accouter problem to view [B]amount [/B]value. [CODE] SELECT b.kod_cawangan,b.nama_cawangan, MAX( a.tkh_data ) AS tarikh_data,[B]a.amount[/B] FROM history a, viscawangan b WHERE a.kod_caw = b.kod_cawangan GROUP BY kod_caw [/CODE] Here i give …
Hi all I'd just like to know if it's possible to specify two different values for the same column in a WHERE in MySQL. For example [CODE=mysql]...WHERE column1 = 0 OR WHERE column1 = 20[/CODE] That's what I'm using at the moment but it only returns a result where column1 …
I am trying to connect to a SQL server 2008 database from within Eclipse. My SQL server uses integrated authentication for login. Eclipse prompts for integrated authentication , but it is unable to login. I get an error message as "This driver is not configured for Integrated authentication". The sqljdbc_auth.dll …
Does anyone know why the following subquery is using filesort and scanning all rows in the table according to EXPLAIN? I am trying to get the total of the top ten scores and the result is fine. [CODE]EXPLAIN SELECT SUM( score ) AS top10_total FROM ( SELECT score FROM answers …
I'm coding my own blog which is almost completing. I'm facing a problem on one thing. How can I insert comma separated tags in mysql table? I want to insert every comma separated tag as the new entry in the table. I would be thankful if anyone will help me …
The End.