10,940 Topics
 | |
| | Good day, I am getting an error on a log-in script: mysql_query(): 4 is not a valid MySQL-Link resource I've done some research on this and followed such advice as: [LIST] [*]ensuring the mysql connection is closed after the results have been returned [*]testing any sql strings I define in … |
| | Hey guys complete noob/novice here, Looking to join multiple tables identical in structure. It's meant for a search box in my school project. [COLOR="Red"]If I have table 1 and table 2 identical in structure, when the user searches for "keyword" it will search through both table 1 and table 2 … |
| | Hi. Well, I am able to program in Java and connect it to MS Access and be able to distribute it as long as I have the *.mdb file together with the *.jar file. Now, I want to have my database on MySQL. I am already able to do it …  |
 | Hello All, I wand Firefox to remember my password when i login in phpmyadmin. But Firefox doesn't ask me to 'Remember password'. When i inspect phpmyadmin form using developer tool, i done see any trick. Secondly i also want in my website coding that when user log in Firefox don't … |
| | hello am a newbie sad to say but i got a big problem regarding to the auto increment. i use innoDB for storage but somethinggoes wrong! i dont know why. whenever i input new data (such as name add and tel, member ID should increment by one) there is no … |
 | |
| | OK, I have a table that has: id (int), name (varchar), parent (int) If parent contains NULL it IS the "parent" otherwise it is the child of a parent So: id=1 name=Meals parent=0 Means the above record is a "parent" (there are 100's of parents). So far, so good? Next … |
| | hi every one, i am trying to store store procedure result into temporary table tried using DELIMITER $$ DROP procedure IF EXISTS `Merge` $$ CREATE procedure `Merge`() begin create temporary table table1 call sp1(); create temporary table table2 call sp2(); End $$ DELIMITER ; error :: Script line: 3 You … |
| | hi every one, how to return table using functions i tried DELIMITER $$ DROP function IF EXISTS `test` $$ CREATE function `test`() returns table begin return (select * from users); End $$ DELIMITER ; error: Script line: 3 You have an error in your SQL syntax; check the manual that …  |
| | Please help me on this file upload. [CODE] <form id="form_2" action="files_upload.php" method="post" enctype="multipart/form-data"> <input type="hidden" name="MAX_FILE_SIZE" value="50000000"> File:<input type="file" name="file" class="input" maxlength="350"" /><br /> <input type="submit" name="submit" value="Upload File"> </form> [/CODE] [CODE]<?php if(isset($_POST['submit']) && $_FILES['file']['size'] > 0) { $fileName = $_FILES['file']['name']; $tmpName = $_FILES['file']['tmp_name']; $fileSize = $_FILES['file']['size']; $fileType = $_FILES['file']['type']; …  |
 | I'm having a little trouble writing an if statement to update a couple of database fields based on matching a student ID between 2 tables. This is a form where I pass the initial Student and Class IDs to the SQL statement (this works just fine, but when I try …  |
 | [CODE]<?php mysql_connect("localhost","root",""); mysql_select_db("database_name") ?> <form name="search" action=""> Search: <input name="q" type="text" /><input name="search" type="submit" value="Search" /> </form> <?php if(isset($_GET['q'])){ // include database connection $sql = "SELECT * FROM article WHERE title LIKE '".$_GET['q']."' "; $exe = mysql_query($sql); while($row = mysql_fetch_array($exe)){ } ?> <table> <tr> <td> <a href="article_detail.php?id=<?php echo $row['id'];?>" class="header_menu"> … |
| | Hi All I would be greatfull if somebody could help me out with this one. ive been scratching my head all day in trying to find a solution. I have a order confirmation page which displays the entire order on a shopping cart. this page inserts a row into table … |
| | Hello, I am using the handle_options function in a client program written in C that is using the MySQL API. Considering there is no actual reference to this function (to my knowledge) except the book 'MySQL' (or something) written by DuBois, I'm asking for help here. So I want to … |
| | I just stumbled over this: [ICODE]mysql> select "abc" = 0; +-----------+ | "abc" = 0 | +-----------+ | 1 | +-----------+ 1 row in set, 1 warning (0.06 sec) mysql> show warnings; +---------+------+-----------------------------------------+ | Level | Code | Message | +---------+------+-----------------------------------------+ | Warning | 1292 | Truncated incorrect DOUBLE value: … |
| | hi someone help me with this error:( Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\CDX\class_lib.php on line 57 Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\xampp\htdocs\CDX\class_lib.php on line 57 [CODE] <?php class contactdirectory{ private $db_host = 'localhost'; // Database … |
| | I am reading data from a mysql db to my webpage. I wish to make a google pi-chart but have no idea how to pass the data from php (html?) to javascript(?) to populate the graph. I'm reading the rows into the html page ok, they are dispaying in a … |
| | Hi I have an occasional problem with the following scripts Here is the file upload form [CODE] <?php session_start(); if(isset($_SESSION['username']) == false){ header("Location: login.php"); exit(); } if(($_SESSION['userlevel']) != 'admin'){ header("Location: login.php"); exit(); } ?> <!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" /> … |
| | Good Day, I have troubles with compiling MySQL++ with Visual Studio 2010 Express edition, I've downloaded MySQL Complete Pack and installed Development tools (server, includes etc), downloaded MySQL++ 3.1.0 and runned vc2008 solution with my vc2010 and compressed it for 2010, I've included everything from MySQL folder and MySQL++ install … |
| | what;s wrong with this mysql trigger logically?? [CODE] DELIMITER | CREATE TRIGGER comment_count AFTER INSERT ON comments FOR EACH ROW BEGIN UPDATE sub_sections as t1 SET t1.published_comment_count = (select count(id) as cnt from comments where article_id=t1.id and published=0 and status=0) WHERE id= (select article_id from comments order by date_modified desc …  |
| | <?php include "db/config.php";?> <?php function loginCheck($username,$password) { $sql=mysql_query("select UserId, UserName, Password from user_login where UserName= '$_POST[username]' and Password= '$_POST[password]'"); $name=$sql['UserName']; //echo"hi".$name; //select * from user_login where UserName='mownam' and Password='welcome' $result =mysql_query($sql); //$uname=$_REQUEST["username"]; if(mysql_num_rows($result) > 0) { echo "<center>successfully logged<br />".$uname; } else { ?><div align="center" style="background-color: #FFFFCC"style="font:"Courier New" , Courier, … |
| | I installed mysql and apachi form fedora14 installation dvd when I installed fedora. no I want to run mysql interpreter for training mysql (I'm student). when I run mysql command I receive error: [CODE]$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)[/CODE] I looked … |
| | I don't know am i asking right question or not but my question is: I want to create a simple search site so I've team with different jobs. I have its database part to handle. I should create its database and i have not idea what should i do. I'm …  |
| | Hey, I'm having a problem executing the following code: [CODE] <?php session_start(); require('connect.php'); if($_POST['username'])){ $name=$_POST['username']; $checkUsername = mysql_query("select * from users where UserName='$name'"); if(mysql_num_rows($checkUsername){ echo 'Logged in successfully!'; $_SESSION['username'] = $name; } else{ echo 'The username or password you've entered is not valid!'; } } ?> [/CODE] |
| | how to create binary tree method in mysql  |
 | Hi All, I am new to the site, and also to PHP and MySQL, so please go easy on me for asking what may be an obvious question for many. I am wanting to store the data from a sign-up form in a MySQL DB, but I cannot get my … |
| | Please can someone tell me what are things that I should add to my database, do I add my website pages to my database too ?,please I am sorry for this question I don’t know anything.  |
 | Hi All experts, I am facing problem with mysql view. I have migrated my database from oracle to mysql qith views, View on Mysql is created , but when i try to execute query it takes a long timw , some times it time qout server connection, Any body help … |
| | Hello , I would like to enquire if how could I put MYSQL Row to a TextBox ? Here is my code [CODE]Private Sub Form1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load MySqlConnection = New MySqlConnection MySqlConnection.ConnectionString = "server=localhost;Port=3306; user id =root; password=****; database=visualbasic" MySqlConnection.Open() Dim Myadapter As … |
| | i have this code to create a contact directory and my instructor wants me to create a function for database connect to minimize the coding and if an instance to change the server it is easy to change. <?php if(isset ($_POST ["add"])){ $name = $_POST['name']; $address = $_POST['address']; $email = … |
The End.