10,940 Topics
 | |
| | Hi all. Have been trying to get my head around a problem in my custom messaging system. This is my msg table: id (PK) datetime_posted (datetime) from_id (FK for user id) to_id (FK for user id) title (the title obviously) msg (the body) status (0 = inbox, 1 - removed) … |
 | Hi, I want to connect with MySQL database form c#. Please suggest me best way to do this. Thanks. |
| | Hello, I have a tracking program I built for one of my websites so I know which keywords are getting visitors. Anyway, the tracking program works, but it fills my error logs with this one error: PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in... Anyway, … |
| | I downloaded MySql Connector/J, but i dont know how to install this driver in my JDK or Tomcat on windows XP. I read J/Connector documentation but i cant understand it. I copy jar file in JDK\lib\ext. Please Help me in this situation. Thanks you all.  |
| | Hi all, I am a student trying to access a database that is on a different server than where my web pages are stored. My webpages running PHP scripts are here (128.118.142.34 through 128.118.142.46) and my database is here (146.186.83.60) Here is the code that I implemented: [code]$con = mysql_connect(146.186.83.60, … |
| | Hi ive got this bit of code, trying to reteach myself stuff about PHP ive forgotten and having a general play. However i can only get this code to half work [CODE]<?php include_once("connect.php"); $username=$_POST['username']; $password=$_POST['password']; $email=$_POST['email']; $existing= "select * from CSLE_User where Username = '$username'"; $exist=mysql_query($existing) or die (mysql_error()); $num=mysql_numrows($exist) … |
| | Hello, please bear with me if this question is stupid. I'm fairly new to this and i really need to know. is it possible to use [B]"SELECT COUNT"[/B] to get the number of DIFFERENT values one column currently holds grouped by a value from another column.?  |
| | Hi guyZz... I'm a beginner in programming world..,! Can you help me guyZz of restoring data of mysql using vb6 codes..... Any reply and some source is really appreciated.... Thanks in advance..... Oscar Resonable |
| | I am new to database design and trying to create an anonymous mobile message board. I have two tables in my database and would like some one to look at them and give me some feed back so that I can ensure that i have an efficient design and that …  |
| | hi, i have my php pages done already and it's running good in my localhost but when i have uploaded it, search engine would not work. i have changed the appropriate database names and tables provided by the web host , but it just doesnt work still. I know that … |
| | Is there a way to send a streaming url such as mms or asx through mysql or a php file so that it does not appear in the source code? |
| | We have an app that we put on MySpace - it is hosted on a dedicated box and is database driven. Game is a static game and performs updates to the database and queries on stats and such. It is a battle type game, where actions such as attacks will … |
 | Hey, I need help getting that ugly yyyy-mm-dd format to change to something prettier. I would prefer being able to output it in the form like January 01, 2007. Something easy to read for the average user. I can leave it stored in yyyy-mm-dd in my database, but in my … |
| | Hi, I've been trying to set up a webserver for a while now, but with no luck. Here is the problem:- After I installed PHP,Apache,MySQL into a folder named 'server' on my local machine and followed the relevant steps to set them up; I used the following script to check … |
| | I am new to php, and i am making a simple ticket validation system for my school in the theatre, So we scan all the purchased barcodes from the ticket into the form which then posts the barcode data into insert.php which uploads that number to the database (this process … |
| | ok so i created a database and made a table that i inserted data into it. i would like to know how would i be able to put the extension .sql at the end of my table? |
| | This used to post data to mysql database: [icode]<form name="form1" method="post" action="<?=$_SERVER['PHP_SELF']?>">[/icode] Now the data does not post. Am I doing something wrong, or is this a server issue? How do I correct this? |
 | I'm playing around with SQLite, which is very similar to what i've seen in MySQL, and I want to write some code that returns the column names along with the data for output purposes. Is there an SQL query I could use to do that, or is it done differently … |
| | i made this code but it shows result Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\VertrigoServ\www\sanjay\rlc\closing.php on line 14 [code]<? include("admin/include/conn.php"); $today=date("Y-m-d H:i:s",strtotime("+5 hours, +30 minutes")); $c_closing="select * from member_information where child >=2"; $c_closing_query=mysql_query($c_closing); while ($c_row=mysql_fetch_array($c_closing_query)) { $c1_query="select * from member_information where Mem_sponsor_id=".$c_row['Id']." limit … |
| | I have XAMPP installed on my computer and started all features. When I type to browser on PC in my lan IP adress of my computer it shows me xamp welcome screen with everything working. But when I start demos which uses mysql databases (CD Collection or Phone Book) it … |
| | Basically I have created a site where someone can view a table which contains information about various servers. They can also create a report from this table selecting the fields they want to see in their report. Each field can be selected through a checkbox and there are 16 different … |
 | I have a drupal user table: [CODE]+------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+----------------+ | uid | int(10) unsigned | NO | PRI | NULL | auto_increment | | name | varchar(60) | NO | UNI | | | | pass | varchar(32) … |
| | Hi there, basically i'm trying to write a php script that allows me to retrieve the tour dates for my band from a MySQL table. I want the gigs.php page to show every upcoming gig that there is. On gigs.php i want a link to gigarchive.php which features all passed … |
| | Hi, I am using this query for count [ICODE]SELECT Count(ID) from Table[/ICODE] But its showing the count of all the fields which are empty and zeros. I want the count of fields which are empty and zero. please guide me. Thanks. Take care.  |
 | Hi All, Im trying to find a method to allow files to be: 1. Uploaded and stored in a mysql database 2. List them, with "change" and "delete" options 3. Allow them to be downloaded, or even just viewed I have tried using blobs, but to no avail. I have … |
| | hello all: i am using mySQL and I created a few tables and I am learning how I can use the SQL query on multiple tables. The following are the results which are quite confusing and it will be helpful if someone can help me understand as to how this … |
| | Hi guys , i want to fill a textbox with a data from my mysql database and i dont know how to do it , i already searched without a result , if someone can help me i would appreciate it . |
| | I just want to dispay all row from mysql table but got error as following: Note:I am using hostgator and try to display 40,000 query. [CODE]Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/firstint/buygadget/sitemapg.php on line 11 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in … |
| | Hi all Problem is I want to return unique results based on 2 fields: I have a table tags_photos which is a join table and has 2 fields: tagId and PhotoId. I want to create a page which has a list of all tags and a thumbnail against each tag. … |
| | God i'm having a terrible time trying to do this. Does anyone know how to set a javascript variable as a query result from a MySQL database. As an example, like this: Set this query: [CODE]$query4=mysql_query("select price from pricelist where item='$result3[item]'"); $result4=mysql_query($query4);[/CODE] into a variable: [CODE]var price[/CODE] i just can't … |
The End.