7,368 Topics
|
|
|
|
my script returns this error: Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\wamp\www\php_test\user_inter.php on line 17 <?php $db = mysql_connect("localhost"); mysql_select_db("room_p7", $db); $query = "select * from members"; $result = mysql_query($query); while($record=mysql_fetch_assoc($result)){ while(list($fieldname, $fieldvalue) = each($record)){ echo $fieldname.": <br>".$fieldvalue.":<br><br>"; } echo "<br><br>"; } ?> 
|
|
|
#I need a php script that fetches a registered users info from the Mysql database and prints them on the page when a user visits his/hers profile page via a link showing his name, like facebook # * Heres the code that id like to show as the profile pag … 
|
|
|
Hi all, hey guys could you please help me in this issue: i get warning message whenever i try to run my login form Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\db.php on line 10 unable to connect to the database i am using xampp, …
|
|
|
I attempted to get the records from the MySQL database and display it on a Grid View but nothing appeared. The code is below: MySqlConnection myconn = new MySqlConnection("server=localhost;user id=root;password=db;database=workers;"); // myconn.Open(); string strSQL = "select * from details"; MySqlDataAdapter mydata = new MySqlDataAdapter(strSQL, myconn); MySqlCommandBuilder cBuilder = new MySqlCommandBuilder(mydata); …
|
|
|
#MySQL TABLES CRASHED BUT STILL WORKING WHEN RESTORED TO MySQL ON ANOTHER SYSTEM, WHY ???# Hi everyone, I'm a software developer and just started my professional career life, question here i want to ask is ... that few days ago i was at client site to resolve some issue in …
|
|
|
Hi, I have a database called my_db1 which contains 3 tables. Out of the 3 tables one table is being populated 24*7. My hosting provider (i.e godaddy) provides 25 Mysql databases 1 GB each. What should I do if the database exceeds the 1 GB size limit? Is there a …
|
|
|
hello, i'm currently working on a website for my team fortress 2 server, and am now getting to the premium part. i would like to make a page where people select either a subscription or a one-time payment and then pay it. when the payment is done, they would be … 
|
|
|
Hello guys. I have a form in which i have some dynamically generated input fields like this: <input value="March" name="month[March]" type="hidden"> <input value="April" name="month[April]" type="hidden"> <input value="May" name="month[May]" type="hidden"> . . . How do i add the input data for each month to mysql? Thanks!
|
|
|
Hello there, I am a newbie in MySQL and I am extremely confused about one thing. I am currently creating four tables. There's a primary key I have specified for the first table which is a foriegn key in the second table. Now the problem is that I want the … 
|
|
|
Hello, I'm having a problem using the jTable plugin. I'm fairly new to using jquery. Here is my problem: I have an database name reg and has fields (fname, lname.....avatar). What i want is to show the contents of the database using jTable. Now, I don't know how to display … |
|
|
I have text being loaded onto the page from a MySQL database. When the text is clicked, using JavaScript the element is replaced with a textbox displaying the text. I want to be able to use a MySQL update query to change what is in the textbox and so it … 
|
|
|
okay...seem to be experiencing some problem here....in my pc, the web application is running perfectly....but when i run it from my handheld, its showing error... this is my code <?php session_start(); //starting session $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="test3"; … 
|
|
|
<table> <tr><td>Date</td><td>Job_id</td><td>Active</td>/tr> <?php while ($row = mysqli_fetch_assoc($rs_total)) { ?> <tr> <td><? echo $row["Date"]; ?></td> <td> <?php echo "<a href='work.php?ID=".$row['Job_id']."'>".$row['Job_id']."</a>"; ?></td> <td><? if($row["Active"]==0) echo "Active"; else if ($row["Active"]==2) echo "Completed"; else echo "Not active"; ?></td> </tr> <?php }; ?> </table> in this code i want to transfer the id on pop …
|
|
|
Hi, I am vishnu kumar. I knew the basics of Java but this is the first time i am building a project based on java (Java Swing actually). This is my final semester project and for last two months, i am doing my project. I initially thought the database(along with …
|
|
|
I have four database tables locality table: localityid, locality. jobtype table: typeid, type. applywork table: id, userid, applyfor applicationsent, jobtypeid, vacancyseenon companyname, doorno buildingname, street, localityid, postcode, telephone, website, email, notes users: id, role, name, surname, gender, username, password. I have a page to edit selected field from applywork. I …
|
|
|
|
Hello. :) So I am creating a grading system where users can compute student's grades on selected ID Number. The problem is after clicking the COMPUTE button, an "Error!" message display. So far I can save the grades in database but I can't compute it. I'm sorry I'm new to …
|
|
|
I have a live update system for a football team, which I input the following: Date, Score, Event (Goal, Red card, Yellow Card, none), Details So 4 columns. At the top of the page, I want to display the latest score, so bascially I want to grab whatever the current …
|
|
|
Hello guys, well... I want to create an HTML-JScript that will store some values in DB (Like Visitors IP) Because blogspot.com dont give DB, we just can have a html/js gadget, i sayd to use a DB wich is hosted in other server, is that possible? 1) will be 1 …
|
|
|
I have developed a web application and it works very well in the localhost. but when i put it to the web server the relationships in the table doesn't work. for example when a parent row is deleted all the child rows associated with it should be deleted. but it …
|
|
|
I have a table ... Ratings (userid, movieid, ratings, time) where ... select count(*) from ratings where userid = X; (No of ratings of a particular user) Here, X ranges from 1-6040! How should I get the count of each user and then store it in another table 'Users' in … 
|
|
|
Hi I have imported a number (500+) posts into Wordpress from another CMS (Expression Engine). On a number of posts I have a problem with the way paragraphs are being displayed and I can trace this back to the post data that has been copied across. For example, when the …
|
|
|
Hi all, I have a table 'table 1' which has a primary key. Now I want to create two other tables with a composite key in each one, composed by primary key and a foreign key both referencing table 1 's primary key. However I can only do it with …
|
|
|
I have a table which has a foreign key that links to a primary key in another table. That id has information on it in which I want it to show while having a sum on the information. Is there a way to do it? To clarify here's a code …
|
|
|
I thinking about a project to build up a web based application. I am not able to understand what should be structure of the database. [B][COLOR="Red"]Problem:-[/COLOR][/B] Data is in bulk which is of a big general store, and they have 50,000 transaction minimum each day. They store all data and …
|
|
|
Dear all, The first query works while the second doesnt, am not able to figure, can u please help me out. 1) // $query3="insert into ttrough(am,pm) select ttam.subject,ttpm.subjectpm from ttam,ttpm where ttam.class != ttpm.classpm limit 1";// this one actually takes two columns from different tables and checks whether they are …
|
|
|
So I'm trying to create a PHP and MySQL program where users can add, update, delete, view and search records. But the problem is I can't update records whenever I click update button. Here's my code --> [CODE] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html> <head> <title>Update Record</title> </head> …
|
|
|
I have three table that are linked like this. Each content is linked to a category and each category is linked to a section. Like this sections_table -section_id -section_name categories_table -category_id -section_id -category_name contents_table -content_id -category_id -content_title -content_description I want to write a query to display only content from a …
|
|
|
Hi everyone! So, I'm trying to create a program which users can add, update, delete, view, and search records but I am having a hard time about updating records in my database. In my Update form, I've got 1 dropdown menu or option that contains ID number and when I …
|
|
|
Hey everyone, I am trying to develop an addon for my admin area to send a text to my clients. I am trying to populate a select menu that will list clients that have added their mobile phones. I am using the following tables. [LIST] [*]tblclients [*]tblcustomfields [*]tblcustomfieldsvalues [/LIST] At …
|
The End.