10,946 Topics
 | |
| | Hi, I'm not new to SQL or PHP, or basic queries of SQL databases, but I'm creating a site that's going to be dependent on having a really accurate search feature. Basically, I'm just looking for some help on how I can get started, because there's a ton of information … |
 | mysql error 2003 can't connect to mysql server on 10.31.158.157 (10061) what to do please help me thankyou in advance |
| | I have been looking for hours on how to do this and haven't found a solution yet, hope someone here can help! Part of my problem is that I'm new to php and web dev, so I don't know what I'm looking for terminology wise. Goal: This is part of … |
 | I am having trouble with this code: <?php // Username $username = $_POST['name']; $email = $_POST['email']; // MYSQL $con = mysql_connect('host','username','password') or die(); mysql_select_db('db', $con); $var = md5($email); $result = mysql_query("UPDATE `table` SET `imageEs`='$var' WHERE user_username='{$_SESSION['sessid']}'") or die(mysql_error()); echo "Profile image updated. <a href='http://www.awsomechat.comuv.com/update_profile.php'>Go back.</a>"; ?> I am trying to … |
| | I am having trouble with this code: <?php // Username $username = $_POST['name']; $email = $_POST['email']; $default = "default image"; $size = 40; // MYSQL mysql_connect('host','username','password'); mysql_select_db('database'); $grav_url = "www.gravatar.com/avatar/" . md5( strtolower( trim( $email ) ) ) . "?d=" . urlencode( $default ) . "&s=" . $size; $sql = …  |
| | I am newbie in php and i have code for retreving data from the website where the $id=id now i want to retreive the data based on the code Select * from users where cat1=cat1 and cat2=cat2 and also show the data according to the id in decrement order. i …  |
 | Hello. I'm trying to make a dropdown script to work and I'm stuck to a point where I feel the answer is simple ,but I simply can't see it . The script should display data from the MySQL Database when I choose the last option but I don't know how … |
| | I keep getting this error message 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 's Hits and had 24,000 listener sessions; over 30 days. Get 5 commercials a day' at line 7 <!DOCTYPE … |
| | Hello all, I'm having a bizarre problem with the most basic of logins. I'm using a function to pass two parameters, just email and password but it just will not work and I can't understand why. I ran the query in the database and it returned a COUNT value of … |
| | Ok, What i need is a Login script that will verify the information that is on a MySQL database. What people will do is sign up on a website and their Login information will be stored on the database. Then they will be able to login to a special members …  |
| | Hi, I'm just want to ask if it's possible if I want to update multiple record with same condition at the same time. For example, I have a table named *userTable*, it has two field, *year* and *status* fields. On year *field*, it has value of years and on *status* …  |
| | Hello, a noob in web programming here. Doing some course related database, would appreciate any help :), I want to ask whether any of you can help me on how to retrieve get data from mysql using php function, but separate each data from mysql one by one, cause i … |
| | Hi. I'm Mike, a developer in Los Angeles, working for a small company. Quick question: I want to write something that's potentially a contract job posting (at the company I work for), but really the project isn't defined well enough yet for me to be comfortable handing it off, saying … |
| | Hi, I have been looking at a few tasks I want to do using a MySQL DB and Python. Therefor I'm spending some time looking at the MySQLdb module for Python and how I can use it. I've worked out a few bits but I want to be able to … |
| | I need a bit of help understanding what I should do here. I have an .php page called view that has the following drop down form code in it. $sql = "SELECT DISTINCT dept FROM sw_lic WHERE dept != ''"; // (1) $result2 = mysql_query($sql); echo "<form action='NB_sw_lic/filter_view.php?$nt' method='POST'>"; // …  |
| | Hi All, How to Play Sound where record of mysql table is added?. thank you. |
| | Hi, I am looking for a procedural PHP script that would allow me/my users to upload video content in a number of popular formats. I would also like all the information to be linked into a MySql database as well. I already have a upload script for uploading documents but … |
 | I have two pages one called upload-file.php, this page uploads the image into the database and my folder. My PHP page looks like this. if (move_uploaded_file($_FILES['uploadfile']['tmp_name'], $file)) { $insert=mysql_query("insert into match_item_image set item_id='".$_SESSION["session_temp"]."', image='".$name."', adid='$adid'") or die(mysql_error()); $cc=mysql_insert_id(); echo "success".$cc; My other page consist of a javascript function which displays …  |
| | Hi all, Help me please. i have two table: outbox and contact. condition outbox table befor query/ insert. CREATE TABLE outbox ( id int(11) NOT NULL, phone_number varchar(30) NOT NULL, message varchar(200) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; Contact table: CREATE TABLE contact ( id int(11) NOT …  |
| | Hello all! I have hit a small bump in my development of a program I am working on. Basically what I need to happen is this; for each item in the listview it executes a SQL query to input values into a database. In this case it pulls the quantity … |
| | I have two pages one called upload-file.php, this page uploads the image into the database and my folder. My PHP page looks like this. if (move_uploaded_file($_FILES['uploadfile']['tmp_name'], $file)) { $insert=mysql_query("insert into match_item_image set item_id='".$_SESSION["session_temp"]."', image='".$name."', adid='$adid'") or die(mysql_error()); $cc=mysql_insert_id(); echo "success".$cc; My other page consist of a javascript function which displays …  |
| | Not sure the best way to ask this question, but here goes... I have a Database table that has a column called pos_id that is an auto increment field, and I have used it as a tracking device for the next position number in a company forced matrix system... Now … |
| | Hi, I'm writing a small C program to clean the radius radacct table, removing ended sessions records and inserting on a separated database. The problem is that MySQL C API doesn't have an easy way to insert the result of a query on another database/table directly, you have to build … |
 | hi all, I am new to php and have started some coding.I want to insert values in one table1 and update values of table2. It worked for me last day..but today it doesnt work.I have hardly changed any code.i guess except fr deleting some comments in code..u plz tell me … |
| | I am trying to display my vbulletin usergroup ids for each user who posts an ad in my photopost classifieds. in doing this I can execute my code based on that usergroup id. I have been working on this for 3 days now and I just can't get it to … |
| | Hey Guys, I've got a question that's gotten me stumped. Granted, i've been away from MySQL and daniweb for well over 18months, i've picked up pretty much where i left off back then, and am just filling in the blanks as i go along. **My question is:** i have a … |
| | Hi I'm having issues with **get_magic_quotes_gpc()** function. I download this **Ajax File and Image Manager** from this site: http://www.phpletter.com/DOWNLOAD/ I install it on tinymce & fckeditor to test it out. They both work. I try to link the images and it didn't work and I also realizes the links are … |
| | Ok so I have a script that I am writing and I have encounted a problem. I can not get the information from a dropbox to submit into mysql data base here is my script. <form action="work.php" method="post"> <table> <tr> <td>Email:</td> <td><input type="text" name="Email" tabindex="1" /> </td> </tr> <tr> <td>Messgae:</td> … |
| | hello i want to add search functionality to my website . my task is to get input from user then check it if its domain like google.com then (do work 1).... else if keyword like news etc then search database so i made search.php mysql_query("SELECT * FROM `table` WHERE `title` … |
| | I tried to insert data using the following code, but I really I don't know how can I get result and what is the problem in my code, I tried to build firstly my form then I write the insert query and send it to a new form , any … |
| | Hello i can not figure out how to take images from my database to jQuery gallery. User uploaded images in the data base. Images are sorted by date. And how I can do, what all imges goe's in the jQuery gallery, besause now i can get all imges in one …  |
| | Please help me. I want to connect to mysql using the connection string from connectionstrings.com. It gives me error that: format θƒ the initialzation string does not conform to specification starting at index 13. Please help me.... •̸ŤђαϞĸs ĩ̷̊ñ advance  |
| | Hi There, I'm busy developing a PHP / MySQL billing system for our company but can't seem to get the following working for me. I need to have 1 page that will display the extensions billing period / month for local, national and international calls and it needs to be … |
| | Hi there, Can anyone help? Why is the following code displaying "P1P2P3..." etc, instead of "P1 , P2, P3 ,.." etc. ? Thanks Paul <!--Conect to database--> <?php include "connects/patientconn.php"; ?> <?php $query = "SELECT `Patient I.D.` FROM `patient`"; $result = mysql_query($query); while($patient = mysql_fetch_assoc($result)) { $pt = implode(" , … |
| | Hi Everyone, I am a beginner in PHP and would need your help with this. I get this problem: Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in database.php on line 207 Here is my code: include("constants.php"); class MySQLDB { var $connection; //The MySQL database connection var …  |
| | I'm trying to get a flot graph to show my jsonencoded array seen below: [["aa",71],["ab",69],["ac",66],["ad",61],["ae",79],["af",78]] In the array the first is what i want on the xaxis and the second is the corresponding value. Right now my flot graph outputs an empty chart and I'm thinking that the array need … |
| | I'm trying to make multiplication in web shop that will show real price: **discount * tax * product price * 1 piece= real price** But I just don't know how to do it, I try 1 million things, spend about 48h just to make it, but, without success, no matter … |
| | function returnnotify(){ $result = mysql_query("SELECT * FROM rentcustomer WHERE Expiredtime = CURDATE()"); $count = mysql_num_rows($result); if ($count >= 1){ echo $count; }else{ echo "0"; } } now when I run the code above ,it will prompt out this error: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in … |
| | Hi can someone tell me how to create an sql statement in which I can include multiple conditions? e.g. I want to select all from a particular table in which I can enter different keywords that would produce different results such as all items by a particular brand e.g. microsoft … |
| | Hello People. I would like to ask you're assistance with a little problem I am having. When I execute this code: string sql2 = "INSERT INTO worlds (worlds_ID,worlds_active,worlds_name,worlds_x,worlds_y) VALUES ('', '1', 'Test', '250', '250');"; MySqlCommand cmd = new MySqlCommand(sql2, OpenCon()); addtolog("server", "World Created"); it does not make the new row … |
| | <?php $title=$_POST["title"]; $theme=$_POST["theme"]; $con=mysql_connect($dbserver,$dbusername,$dbpassword); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db($dbname, $con); $query=mysql_query("SELECT * FROM setup WHERE id=".$_SESSION['id']); $result = mysql_query($query); $num_rows = mysql_num_rows($result); if ($num_rows > 0) { while($row = mysql_fetch_array($result)) { $_SESSION['id'] = $row['id']; $_SESSION['title']=$title['title']; $_SESSION['theme']=$theme['theme']; } { mysql_query("UPDATE setup SET title='".$title."' , theme='".$theme."'WHERE … |
| | Hello, I want to display the fields that were updated. When a user edits their information, example; "FIRST NAME:John LAST NAME: Stih Update to:UPDATE users SET firstname = '$firstname', lastname = '$lastname' FIRST NAME: John LAST NAME: Smith I would want it to print "You updated your Last name" |
| | I on my drop down boxes it keeps on selecting more than one option I just want it to select out of one row... for some reason this won't work nothing shows - $query["cost1"] = "SELECT ourprice as text, ourprice as value FROM `fruitinventory` WHERE seeddescription='%s' AND fruitdescription='%s'"; Something shows … |
| | I WANT SEND ITEMS INTO DATABASE WITH ONE TIME CONNECTION OPEN ? MYCONN.OPEN(); FOR(INT I =0; I < CODE.COUNT ; I ++) { DB.SUBMITITEMS(CODE[I]); //IS IT RIGHT IF I HAVE 100 ITEMS TO SEND DATABASE WITH ONCE TIME OPEN CONNECTION OF DATABASE; OR I NEED TO REOPEN AND CLOSE CONN …  |
| | In my desktop application whenever execute the code to backup my database from java application the app goes on waiting state may be for password , which we have to enter while backing up from command line. But i've provided the username and password of database in the code. Why …  |
| | Dear experties, I want to display data from Mysql by keyword but my code doesn't work. Maybe you have suggestion for this environment. please... |
| | 1 down vote favorite You can't vote for your own post. (click on this box to dismiss) I have a very big problem with my website. I have a form, more like a text box used in submitting comments, that not the problem. The problem is displaying the comments. I … |
| | trying to develop a system to assign grades to students. The system reads marks from my database, and assigns a grade after getting average of scores. Used case statements, keep throwing errors. So i tried if statements but its giving me issues. Someone know a better way to do it? … |
| | I have a bunch of drop down boxes, then after they are selected the the total amount automatically appears at the bottom.. the only problem is it appeears like this - <span id="resp">Total</span> How would I make this insert into the database? |
 | Help, I need a free hosting site! I have a website made of PHP that I need to upload to a web server and a VB.net application on my PC, I saw tutorials on how to connect my VB.net application to my database located in the web server with my …  |
The End.