10,940 Topics
 | |
| | This doesn't really have anything to do with Php but I'm following a php tutorial so...I've NEVER used any database system before... Anyway, I'm following this tutorial, [url]http://buildingbrowsergames.com/2008/04/15/designing-your-database/[/url] I'm up to the part where your making the user sql table in the tutorial. I have no idea where to input … |
| | Hi, Im trying to install a mysql service for a noinstall mysql. At the same time I want to set the variable log-bin-trust-functions-creators=1 but it throws this error 100506 10:49:15 [Warning] '--skip-locking' is deprecated and wil be removed in a future release. Please use '--skip-external-locking' instead. This is how I … |
| | [QUOTE]Hi all, i am working on php. so now i need to echo the value obtained by mysql. so can any one... thank u. [/QUOTE] [CODE]$sql2="select reportingto from users where username='$_SESSION[username]'"; mysql_error(); $result2 = mysql_query($sql2);[/CODE]  |
| | Hello, I have two different tables I need to extract data from. They are linked by a number, that is to say the value of the field 'number' in table 1 is the same value as the value of the field 'num' in table 2. I can select data from … |
| | Okay, fairly straightforward mysql insert from a form, the insert works fine but i wanted to have it check for duplicates first and kick out an error if the name already existed in the table. That said, I worked out a few errors in the jsp, and have it down … |
| | I'd like to start using databases with my websites. I use PayPal shopping cart now and want to automate adding sales items for my customers product. It seems like PHP/MySQL is the easy answer. Am I right? I don't really want to build a whole cart just most of a … |
 | What features does PHP/MySQL provide to deal with concurrent systems? E.g, If I have a table, and I only want to allow one user to update at any one time. I want to put a lock on the database until the update is complete, then once that request is processed, … |
| | G'day, I've just been cleaning up some of my queries, and have opted to use a MySQL view for simplification of my queries, as i was using multiple queries to get the values that i wanted. However, I cannot quite figure out how to iterate through the view. My view … |
| | I'm sitting my CMA next week, and am rather embarrassed that i have to ask this. i have some java code, that i'm looking to clean up. and in it is my SQL queries. I've tried running joins on my tables but none quite get the effect that i've achieved … |
| | I am trying to create a plan for users based on their top 3 choices. I want to display results all together on a results page. I have database populated and form (check boxes) created. I cannot seem to put the two together. I want them to choose 3 choices … |
| | Hi I'm just trying to input two string variables into 2 fields of a database that are VarChars. [CODE] $name = "jear"; $pass = "jartt2"; $query = 'INSERT INTO `user` (`id`, `name`, `password`, `char_name`) VALUES (NULL, '$name', '$pass', 'test')'; $result = mysql_query($query); [/CODE] This is the snippet of code that … |
| | This is my code, as seen here: [url]http://pcafansa6.hosticks.com/episode1.php[/url] [CODE]<?php /*********************************** * PhpMyCoder Paginator * * Created By PhpMyCoder * * 2010 PhpMyCoder * * ------------------------------- * * You may use this code as long * * as this notice stays intact and * * the proper credit is given to … |
| | Hi everyone, Ok, what I want to do is display a url that's stored in my database within an iframe when the specific record is selected. The code I had to display the record correctly is: [code] <?php $conn = mysql_connect(HOST,USER,PASS); $db = mysql_select_db("***") or die( "Unable to select database"); … |
| | Safari can’t open the page because the server unexpectedly dropped the connection. This sometimes occurs when the server is busy. Wait for a few minutes, and then try again. When I try to post the form with Firefox i just get a black page. This problems started when i changed … |
| | hi, i have the following table: +------------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+-------------+------+-----+---------+----------------+ | IpAddressesID | int(11) | NO | PRI | NULL | auto_increment | | PhysicalServerID | int(11) | NO | | NULL | | | VmID | int(11) | … |
| | Hi i just did some codoing and heres the error i get when i try to use my register forum [code] Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/rpimager/public_html/RPImager/register.php on line 32 Account created. [/code] Here's the docs that i use it for. why i … |
 | Hi all. I'm new with jsp and i'm just looking for create a login solution. I use a mysql database and what i'm looking for is what follows: Make a query to my sql database and then insert the output of one field in a variable. I need this variable …  |
| | Hi Does Anyone know how to display a table based on user selected fields? In my search box, once the user searches lets say all the female students, all the female students will show with all the fields of that particular table. then if need to print a report i … |
| | Hey everyone, Um, I've been working with PHP and MySQL for a few weeks, and to store text I've always been stripping anything but alphanumeric characters, which has worked fine until now. For my next project [I want to create a simple CMS/forum for my website], I need to store … |
| | I was looking to make a VERY simple PHP/MySQL loginish username site, as an exercise, when I came across the problem of storing info on the users. I am very new at this (hence the need for an exercise), so I was wondering if anyone could direct in the right … |
| | Hi is it possible to count days between columns, something like [CODE]datediff(date_finished-date_started) as 'days'[/CODE] only datediff works just with actual dates, and I'd like to have the days number for every row counted automatically with the rsults in a new temporary column'days'; I hope it makes sense. Please could you … |
| | hi all i know that to be able to bakckup with mysqldump i need to type mysqldump -u [username] -p [password] [databasename] > [backupfile.sql] i was just wondering how can i pass that command from a windows app using c# |
| | A new site that I have to work with requires me to use putty to connect to the site if I want to work remotely as opposed to logging in to their phpMyAdmin to manipulate my data.. I am unfamiliar; please read that has having no knowledge of how to … |
| | Hello guys, i'm having an issue with updating the record in my database. everything seems to work well except that whenever i try updating the record via the mysql update procedure, it just returns with no errors and the record is not update. i tried echo'ing the $result to see … |
| | Can someone look at this and tell me why I'm getting an empty tar? [code] #!/bin/sh #### mysqldump --opt --user=[my username] --password=[my password] | tar cvz > backup.tar.gz #### echo | mutt -a backup.tar.gz -s \"Database Backup\" [my email] #### rm backup.tar.gz #### [/code] Thanks! |
| | # Query_time: 6.081227 Lock_time: 0.000085 Rows_sent: 1 Rows_examined: 1339 SELECT COUNT(id) FROM `article` WHERE `category` = 'shkrime-te-perkthyera' Is there a way to speed it up. Should I index the category column? Or what do you suggest? I use this query to get the number of articles on that category! |
| | Hi, I am trying to set up a section on a site where the results that are shown come from a table. I want to get the number of the 'current_round' then subtract 1 from it and use that value. I have looked up MySQL dev site, and assume that … |
| | Hi, I am trying to display some results where one column is equal to another column in a table. End goal: display all the results where the round and current round are the same number for every team in the table. the number of teams will change as the number … |
| | hey i have two tables in a database that i will like to join in the below code, but i cant. i can only use one table at a time. $result = mysql_query("SELECT name,price from products WHERE itemid = '$id'",$cxn) or die ("Unable to retrieve information from database"); if i … |
| | Hi, I want a MySQL stored procedure which can parse an excel file and save it in the csv format,after which the values in the file can be imported into a table. Kindly help me with a solution for this asap. Thanks, Narayana |
The End.