7,368 Topics
 | |
| | Hi all... I've been teaching myself PHP and MySQL for the past few weeks so I'm pretty new at it. But this question has more to do with javascript (which I have been using for some time) than it does PHP. I am letting the user enter a date into … |
| | Hi guys, I'm fairly new to PHP and mySQL, using a book to help me learn. I want to create a small site to help me improve my skills, but I'm a bit stuck on the database design part. I want to be able to list various public companies and … |
| | Hi, I can't seem to work around the problem. If someone could please point me in the right direction for why the login.php page reloads when I enter the correct empid and password from the database. here is my code: [CODE] <?php require_once("nocache.php"); if (isset($_POST['submit'])) { $id = $_POST["empid"]; $pword … |
| | Hi everyone, that's my first post in these MySQL forums :) In college they gave us a E/R in order to make it on MySQL Workbench and I'm not sure if it is OK. If you could help me it'd be great :D Because I started with MySQL just a … |
 | Hello, Anybody knows about Relational Database Primer. Is there any difference between Relational Database Primer & Relational database? What is the concept of Relational Database Primer? |
| | 1)CREATETABLEProject( ProjectNovarchar2(5)notnull,ProjectNamevarchar2(20), StartDatedate, FinishDatedate,PRIMARYKEY(ProjectNo)); 2)CREATETABLEAssignment( StaffNonumber(3)notnull, ProgramNovarchar2(4)notnull,PRIMARYKEY(StaffNo,ProgramNo), FOREIGNKEY(StaffNo)REFERENCESStaff(StaffNo), FOREIGNKEY(ProgramNo)REFERENCESProgram(ProgramNo)); 3)CREATETABLEStaff( StaffNonumber(3)notnull, StaffNamevarchar2(10), SalGradenumber(2)CHECK(SalGradebetween1and12), YearsExpnumber(2), ProjectNovarchar2(5),PRIMARYKEY(StaffNo), FOREIGNKEY(ProjectNo)REFERENCESProject(ProjectNo)); 4)CREATETABLEProgram( ProgramNovarchar2(4)notnull, Titlevarchar2(20), Languagevarchar2(20),PRIMARYKEY(ProgramNo), CHECK(Languagein('VB','JAVA','ORACLE','C','XML'))); for the code above, what type of integrity constraints will be on them? (how many do u think?) also; i've created this code (below) but there seems to be …  |
| | hey guys, im doing a databases project and im a little stuck this statement wont work(its part of a jdbc) and i get the following error messahe, any suggestions as to why? [CODE]stmt.executeUpdate("CREATE TABLE LOCATION (" + "serial VARCHAR(10)," + "notice TINYINT(10),"+ "intransit ENUM('T','D')," + "dtnoticeissued DATETIME," + "lat NUMERIC(8,4)," … |
| | Hello there, I've been having problems creating a part of my mail system that makes messages look red when they haven't been read, and white when they have been read. This is what I'm using right now [code=php]mysql_query("UPDATE Mail SET Read=1 WHERE ID={$messageID}");[/code] The SQL ID Field is a smallint … |
| | I'm having this issue displaying the results I need. The issue is that I cannot condense my results and end up with extra. The code I currently have is below. [CODE] SELECT category.*, content.* FROM `category` LEFT JOIN `content` ON category.categoryid = content.parentid WHERE category.parentid = 1 ORDER BY category.title … |
| | I have this very weird project that my boss gave me. Given my cws.sql file inside "C:/", i need to create a batch file wherein it will automatically create database cws; and use cws; in MySQL Server. Hope Someone can help me. :'( |
 | Hi all... I am a developing a website using a joomla. I need to display a content but the should filter according to the date. I need only display content which are in between current date and before 30 days. my current mysql quary is SELECT * FROM events WHERE … |
| | Hello.. i have this problem.. im doing some kind of late static binding. im really a new to this and don't know how to solve this problem. please help me to solve it... What i want to do is instead of using `static:: $arr[0].",".static:: $arr[1]` i want to iterate though …  |
| | |
| | I have read other threads on this topic, but I haven't found anything that works for me. I have a table that stores comments for orders. There are many notes for each order and I want to select the newest comment for each order so I can have a list … |
| | Guys, I can run an update query from command line and it updates records but if I'm running same query from a procedure it returns empty set. Any idea why? The update query is below. 1. Create function Age 2. Update table set column1 = Age(column2) 3. CREATE DEFINER = … |
| | Hi, I've set up a secure connection between unixODBC driver manager / MySql ODBC driver on solaris (where we run informatica) and mySql on Windows. It works, but the problem is, that whereas getting informatica to pull data (select) from MySql is reasonably fast, uploading data (inserts) are painfully slow. … |
| | i am a new to php, am trying to get the code below to work - i am getting it is returning resource id#14 Please bail me out file 1 [code] <table> <tr> <td width="245" class="style8"><?php echo "<b>".$database->getLastPoems()."</b>"; // Echoes: string echo $result; ?></td> </tr> </table> [/code] file 2 [code] …  |
| | |
| | i have a regular expression that's supposed to match any string containing certain words in no particular order. the pattern is in PHP: [CODE]var $pattern = /^(?=.*\bword1\b)(?=.*\bword2\b)(?=.*\bword3\b).*$/gmi[/CODE] this pattern works well both in javascript and php but in SQL, it does not work. I searched and found out that some … |
| | Hi I'm writing a piece of code to update a users password when they have forgotten it, but, for some reason I cannot seem to get it to work. It is always echoing out that the secret answer is wrong. It's probably something stupid that I have looked over, if … |
| | hi, please help this problem , iwill used query after while condition this will not run the program. |
| | How do I integrate a database developed using HTML and javascript and a database developed using MySQL? |
| | Trying to get results from 5 tables where the userId is the same. I am getting like 8k rows for where there should be about 20-30 or so. Here is my statement: [CODE]mysql_query("SELECT * FROM userrating, postratings, blogCommentRatings, commentratings, gamecommentratings WHERE userrating.userId = '$this->userId' AND postratings.userId = '$this->userId' AND blogCommentRatings.userId … |
| | Hello, my name is Matias (Mathew for english people) and I am 16 years old. And I am from Argentina !!! I joined this Community because I know a lot of things that I can share here of simply respond... I am a student from an idustrial school call Huergo … |
| | Hi, how to write the MYSQL Query select count(*) from (SELECT user_id FROM `reports` group by report_id) as tb where tb.user_id=5 in Cakephp inside the Loop [CODE]$users=$this->User->find('all'); foreach($users as & $user): //for each $user['User']['user_id']; which gives the User ids as 1 2 3 4 5 ... endforeach; $this->set('users', $users);[/CODE] |
| | [HTML] i am having four combo boxes.the item in the combo box is taken from the database.we select the data whatever we want and clicking the submit button report want to be displayed. While selection in the combo boxes, they may select all the fields sometimes they may select one … |
| | hello everyone i'm new to this site and i'd like help in any form with a project i'm about to undertake. i would like to store .doc files in a database and retrieve them with the aid of a search string to be input by varying users (basically a search … |
| | Can someone tell me why I am unable to update a table in mysql using php with session data. First of all, I have done some reading around daniweb and Im not sure if i should be using UPDATE or INSERT to update the table. I have session_start(); at the … |
| | Hey everybody, My company decided to improve the management of some data contained in csv files by loading their content in a mysql database. I heard that this is part of the process called ETL. Is that right? If that's so, which tool can I use in order to do … |
| | i use vb with Access. I have 2 tables table1 & table2 i create a data report showing the data from table1. [B]My aim is to display the data from table2 on the same report in its next page(s). [/B]any kind of help, suggestions will be highly appreciated. with regards … |
The End.