10,942 Topics
 | |
| | Please someone should help me before I faint. I have been working with this login script and am getting this error on a server: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/utimate/public_html/PhpPractice1/index.php on line 32. When I test it with wampserver, I will get this … |
| | I am using MySQL to store the RSS feed contents that are updated every few hours. I truncate the database once a day. But during the day, whenever same feeds are updated every few hours I get duplicate entries piled up. Is there any PHP script that I can run … |
| | Does anyone know the SQL statement for replacing a string in the whole of a database. My database is called DB1 and I want to remove any instance of "Table/". Many Thanks, |
| | I am currently using a script to run RSS feeds and dump all data into a MySQL. Every time I run it, it creates a duplicate entry into a database. Is there any way, I can just program a script to only get new feeds? I have some feeds subscribed … |
 | Due to the compability between PHP and MYSQL I am hoping someone has a solution to my problem :( I wish to reset the auto increment field and get them "redone" as such. Problem being: When I delete a row it leaves an incorrect auto increment, as a total as … |
| | Hi everubody! I have a huge issue with dates and encoding in my database. Two weeks ago I restored a database from an Xcloner copy to my site, since then all problems are there. My site language is Spanish, and I was using in Wordpress define('DB_CHARSET', 'UTF8'); Since then if …  |
 | I made a test database to store items in a database, but I keep getting an error when trying to import from a txt file. Here is my txt file [CODE] 1,Lánc 2,Fa 3,Csavar 4,Lakat [/CODE] How could I fix this problem? Also is there a reason I need to … |
| | hi, i have two databases and each one have diferent fields names and tables and i want a creat a map for each field and each table and export to a database to the other i have tested the mysql migration but i can´t choose a diferent table in the … |
| | Hello.. i have a table named Tuition with fields: TuitionNum,TotalFee,Fine,levelNum,SchoolYear,DateCreated,Removed,DateLastModified,UserID I inserted record successfully but when i'm trying to display TotalFee using this code, [CODE] myConnString = "server=localhost;" _ & "user id=root;" _ & "password=fiancee;" _ & "database=anneclaire" SQL = "SELECT TotalFee FROM Tuition WHERE levelNum='" & TextBox1.Text & "' …  |
| | i need help, i want to pass a value to javascript from php and it keeps giving me "null". i want to get what picture the user selected. [CODE] <?php mysql_connect('localhost','root',''); mysql_select_db("ajax"); $query="SELECT * FROM xxxx"; $result= mysql_query($query); while($row= mysql_fetch_array($result)){ $rating=$row['ID']; echo "<img src =\"" .$row['filepath']."\" /><br/><a id=".$row['ID']." value='rating' onclick='getrating();'> … |
| | Hi, I'm not familiar with the AJAX way of doing this, hence why I'm posting this. I've got this form that needs to check if the user input is already in the database, if this isn't the case it should disable the submit button and display an error depending on … |
| | Hey guys, i have a javascript code for the "state-city" selection dropdown in my form. Now i have to provide an option for the user to add a state or add a city if it is not already present in the dropdown. I'm using php and mysql. Please help. Thanks …  |
| | Dear, I am making an ordering form and all of the products' data are stored in a MySQL database. The menu form to select products are all [B]working with plain HTML[/B] not php echo's. But now I can change products' info via a separate web page by updating the MySQL … |
| | |
| | HI , CAN ANY ONE TELL ME HOW CAN I UPLOAD A FILE TO MY WEB SERVER WITH OUT USING <INPUT TYPE="FILE"/> , I JUST WANNA USE I BUTTON TO UPLOAD A FILE , AND WHENEVER I CLICKED ON THAT BUTTON I WANNA A FILE WHICH IS ON MY SYSTEM … |
| | hi, i looked all the codes but i could not really see it - i dont really understand coding-. after registration this website send an activation code but i want to make the user active when they actually register. when they register their status is set to A but for … |
 | hi all, I have doubt on Index,I know Index are used to increase the performance of table but my question is where to create Index whether primary key table or foreign key tables ? |
| | Hi, I want to create a database like Dmoz(dmoz.org). I have a problem with creating parent child relation. I want to create parent child relation. This parent child relation will be assigned to a 'links' table. In the links table I will insert data whether in root category or subcategory …  |
| | what would cause this error, it seems that database can be connected but i cannot do it with the below code to this specific database on this server but i can connect to some other host database with below code, can you please help? [ICODE]Warning: mysql_query() [function.mysql-query]: Can't connect to … |
| | hi, my client side files are in one server and server side codes and the mysql in one on my client side files config i see the below [ICODE]$config["db_host"] = "mysevercodessideIP"; $config["db_user"] = "myuser"; $config["db_pass"] = "mypassword"; $config["db_name"] = "myDBName";[/ICODE] i get the error [ICODE]MySQL Error:Can't connect to local MySQL … |
| | Hey, I'm currently using mysql_real_escape_string() to protect against SQL injection. Is there a way to exploit this? I have already tried \ to try to make the query \', thus making it just a regular backslash. I have heard of the Big5 exploit, but I don't know how to use …  |
| | hi i have below structure in my database table id eve_id cat_id member add_date 1 Tel1 5 1,2,3,4,5 0000-00-00 2 Acc2 2 3 0000-00-00 3 For3 3 1 0000-00-00 4 Acc4 2 5 0000-00-00 5 Acc5 2 6 0000-00-00 now my query is as below [CODE]$memque="select * from tblevent where …  |
| | Hi i am looking for simple intranet project in java with mysql.Can anyone post this kind of project or suggest some sites. Appreciated if u replay on this. Cheers!  |
 | hi mysql athlets!)) Guys, please tell me - how to solve problem like this = I have sql-query like this one (imagine that all this tables and fileds exists - and error can't be in its adsence) = [CODE] select NAME from (TAB1 left join TAB2 on TAB1.ID = TAB2.ID) … |
 | I want to write a wrapper around MySQL but I will in future extend it to support other databases. I will cover only nasic useful features (commons) but it should be extensible in future with minimal change. I want to write an interface but I cannot get good tutorial to … |
| | hi, i finally learned how to install mysql and phpmyadmin but now i need to find out the ip adress for the specific datebese i can login IP/phpMyAdmin but i need an ip adress instead of "IP/phpMyAdmin" can you please help me? $dbH = "ip"; $dbU = "user"; $dbP = … |
| | hi, i can connect thru ssh or phpMyAdmin but when my website or the application is trying to access to my database i get the below error (part of the error) i googled but i could not really understand how i need to fix this. (i dont know much about … |
| | How to clear the mysql query cache? RESET QUERY CACHE; is not working. Thanks in advance |
| | I made a classified site and am concerned that my database design amd sql queries may not be optimal. Need your suggestions. This is how the site works now: The user selects his colony, and my app shows posts made from the colony and posts made from nearby colonies. 2 … |
| | i think with this function users can add some amount to their account but what i would like to do is each day user login i want to add the some amount automatically. each day user login to the site i want to add 1000coins amount to their account and … |
The End.