10,940 Topics
 | |
| | ok so my development folder is in xammp htdocs (php codes) i am trying to insert an image to a table and when i display it on the php pages, it does not show why is this?? i used the absolute and relative path both. the images i need to …  |
| | im looking to convert this code using prepared statments if possible but am open to suggestions [CODE=php] function list_owner_notes(){ $id = $this->id; $sql = "SELECT nid, title FROM notes JOIN hubs ON notes.hub_url=hubs.hub_url WHERE owner = '$id'"; $result = mysql_query($sql) or die(mysql_error()); $notes = array(); / for($i=0; $row = mysql_fetch_array($result, … |
| | Hi I have a bunch of .pdf's full of music notes in a library and I want these notes to be [I]search-able[/I] from my site using three values (that, would be very nice if can be [I]combined[/I] using AND and OR operators): 1) author; 2) title 3) keyword. - How … |
 | Hi everybody I have been using mysqldump utility to dump the contents of database to a file. Everything is ok but i want to eliminate the "USE `db_name`;" statement that appears in mysqldump. Is it possible to do that. Please help:sweat: |
| | Hi! i want to send 10,000 email to my users i have shared web hosting. i think i have only this solution. i want a simple php coding. if some one visit at my site an email automatically send from database list. i have a mysql table -------------------------------- | ID … |
| | This is the code for my TV guide website (stored on localhost)'s articles in PHP: [CODE] <?php //connect to mysql //change user and password to your mySQL name and password mysql_connect("localhost","root","PASSWORDREMOVED"); //select which database you want to edit mysql_select_db("tvguide"); //select the table $result = mysql_query("select * from epdata"); //grab all … |
| | I am trying to get my date that people enter into a form from mm/dd/yyyy to input it into the database. I can't seem to get this to work, I guess I only know enough to hang myself, what would someone use to get this to function properly? I've been … |
| | Hi, I am using MySQL Version 5.0.45. I am getting time out error while trying to access large data. I am performing 2 operations: a) I am loading the data file into the database b) I am retrieving the data from the database. 1) Loading the data file into the … |
| | Just need to know whether or not mysql server supports multiple strings of databases. Will the performance be hindered ? My company has a server that holds a few large databases for now (20GB and larger). In the near future more and more databases will be added. Adding more databases … |
| | Hi, Why not uploaded the data into db? Do not show any error. [CODE] string City = "Berlin"; string MyConString = "SERVER=localhost;" + "DATABASE=test;" + "UID=root;" + "PASSWORD=;"; MySqlConnection connection = new MySqlConnection(MyConString); MySqlCommand command = connection.CreateCommand(); command.CommandText = "insert into city(city) VALUES (@City)"; command.Parameters.Add(new MySqlParameter("@City", MySqlDbType.VarChar, 40)).Value = City; … |
| | I get these errors in a script of mine: [CODE]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\www\vhosts\myradiostation\test.php on line 13[/CODE] and my original page (included in another page): [CODE] <?php //connect to mysql //change user and password to your mySQL name and password mysql_connect("localhost","root","PASSWORDREMOVED"); //select … |
| | Right now, I have a PHP script which - ideally - selects "posts" from a table, based whether or not the the time in the post is greater than the current time. [code]if(isset($_POST['id'])) { $id=addslashes($_POST['id']); $time=date("h:i:s"); $sql=mysql_query("SELECT * FROM public_wis WHERE mig_id='$id' AND time >= '$time'"); if(mysql_num_rows($sql)!=0) { while($rows=mysql_fetch_array($sql)) { …  |
| | Hi, I was wondering if it was possible to update the value of a mySQL cell by a method similar to using += in php code. For example, I'd like to do: [code] $sql = "UPDATE inventory WHERE userID = '$_SESSION[userID]' SET money+='$ssmoney'"; [/code] I know I can instead run … |
| | Hi There I'm a newcomer to php trying to develop a basic photo album. I have created a simple template in htm, and am trying to use php to show 15 thumbnails per page. However, I am experiencing the error message: "Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL … |
| | For some reason this is killing me, I am trying to update the field available to '-1' and don to '0' when the user submits the correct string into the input box, the thing I cant work out is why available wont update but don will the code is below … |
| | I have a small script that connects using ssh and opens a tunnel on port 3306. It works in the ipython interpreter if i type it in manually. However when I try to run the script from the interpreter or command line I get the error message "Can't connect to … |
 | First off I apologize for being a newbie to MySQL but one must learn somewhere... I am attempting to create a stored procedure that take input (primary key) and finds a field for that record and output to a variable... my code so far: [CODE]CREATE PROCEDURE sp_dealer_name( IN dealerID CHAR, … |
| | I have 2 tables 1st INVHD 2nd INVDT In INVHD I have following fields InvNo, InvDate,CustCd, CustName, TotalDisc (Discount on total Invoice), GrandTotal In INVDT I have following fields InvNo, RowNo,ItemCode, Qty, Rate, BaseVal, etc…. Now I need a query to be generated for The customer CustCd, CustName, Sum(totalDisc), Sum(GrandTotal) …  |
| | Hai, I had a database with tables id,name,email. ( Total about 25 thousand of rows in that database ) . I want to do mails to these email ids daily. Now in this condition so much email ids are repeating bcoz I converted a excel file to musql. It is … |
| | Hello, I have been checking for data integration / transfer programs able to help with Mysql. I have had some advice from some people but have not found the right software yet. The main feature would be to be able to migrate important quantities of contacts and data every day. … |
| | Hi people, Do you have any good sites for C++ MySQL.Especially how the 'query' part works in the C++. Thanks a lot!!! |
| | I am using this insert statement - [code=sql] INSERT INTO `crispwer_unipro`.`users` ( `user_id` , `user_name` , `password` , `email` , `activationkey` , `status` , `fname` , `lname` , `dob` , `gender` , `course_id` , `college_id` , `city_id` ) VALUES ( '2', 'k', 'k', 'kk@gmail.com', '', 'activated', 'keval', 'kothari', '2009-12-27', 'M', … |
| | Hello all! :) I dont know if this is the right forum..Here's part of my code: im using php to generate a wml page. It works fine. I want to populate a checkbox using data from mysql db. rand_keys() : store the ids in random order $row(): stores the ids … |
| | How do i start mysqlserver with option of --log-bin using phpmyadmin. Where do i set mysql server startup options in phpmyadmin. |
| | Hello all! :) I dont know if this is the right forum..Here's part of my code: im using php to generate a wml page. It works fine. I want to populate a checkbox using data from mysql db. rand_keys() : store the ids in random order $row(): stores the ids … |
| | Hi, everyone! I'm new to DaniWeb and also to PHP and MySQL. I have a script, previewfile.php, that extracts files of various file types (currently .doc, .docx, .xls, .xlsx, and .pdf) from a MySQL database and is supposed to display them to the user. I'm encountering difficulties in displaying the …  |
| | this is my code [code=php] $query="call call_history('','$real_sdate','$real_edate','$level','$userid',@_count,'0','10')"; //Listing the result $rs = mysqli_query($mysqli,$query); $rs = mysqli_query($mysqli,"SELECT @_count"); while($row = mysqli_fetch_assoc($rs)) { print_r $row; }[/code] always i get blank result or error mysqli_fetch_assoc() expects parameter 1 to be mysqli_result i want to do it with procedural mysqli.. not with oop mysqli..!! … |
| | I have been developing a MySQL database backup and restore appliation in windows forms. This application crates a dump of a mysql database at remote location and imports everything from the dump file back into local mysql database. MySQL database is located at the server which hosts my php website. … |
| | I am trying to accomplish two things with the code below: 1. Make the output display using an adjustable variable for the html table. output: ex: a variable of $tr=4 would display 4 rows of images, instead of a single row of images that I need to scroll across the … |
| | hi, i have this code that suppose to return 1 -> 5 rows from mysql table. when i run it, all i get is the first row from the result. if i'm remarking the code and placeing this line i see all the results [CODE]print_r($row);[/CODE] what am i doing wrong? … |
The End.