10,946 Topics
 | |
| | hi guys, found out about this forum a few weeks ago and found it very useful in regards php issues, i started to experiment with the language lately so i'm still a beginner, i need some help the following code: [CODE]<body> <?php ob_start(); include 'cms/core/config.php'; include 'cms/core/opendb.php'; if(isset($_POST['save'])) { $description … |
| | hi, i am a newbie in mysql and i have some questions about performance tuning. 1-) in a system where you have to store information about a user, such as, user_name, id, last_log, is it better to store all the information needed in one table (lets assume 30 fields in …  |
| | Hi i installed the system as instructed but when i try to login with my username and password this error is shortly being displayed: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/smledit/public_html/sms/classes/crc_login.cls.php on line 129 You can check it out at: [url]http://www.sml.com.mt/sms/pages/crc_login.php[/url] Looking Forward to …  |
| | Hi, I created a sample frame in Java and connected with the database and when i converted to exe file the database is not accessible ..can any1 suggest me is it possible to access database in exe else wat method do i need to implement in order to acheive this. |
| | Hi I will explain what I am trying to do: I have used MYPHP admin to create a database where user booking details will be stored in a table called bookings. Now I need to retrieve all the bookings for a specific date. For achieving this I have created two … |
| | Hello, I am trying to add hyperlink to my mysql query result. I have a table called EastLondon which consist of the following: [code] (restaurant_id INT UNSIGNED PRIMARY KEY, restaurant_name VARCHAR(20), phone_number VARCHAR(20), picture varchar(8), website varchar(40)); [/code] I extract all these info into a table using php. What I …  |
| | [I]<< Split from [URL="http://www.daniweb.com/forums/thread6923.html"]http://www.daniweb.com/forums/thread6923.html[/URL] >>[/I] Hi i installed the system as instructed but when i try to login with my username and password this error is shortly being displayed: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/smledit/public_html/sms/classes/crc_login.cls.php on line 129 You can check it out … |
| | I have a java applet on my web page. How do i get it to send data to my mysql database? I was looking at jdbc but i don't think it works on remote servers(I am using a web hosting service). |
| | Hi I am brandnew to php and my sql. i am trying to put guest entry to my web. when i run my web, i get this error : `Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource` Here are the surrounding lines $SQL="SELECT * From Guestbook"; $Content=mysql_query($SQL); …  |
| | I need to put some static pages into a mysql table This is a sample static page HTML Code: <title>acquital</title> <meta>acquital</meta> <type>lawglossaryitem</type> To be acquited of a crime is to be deemed to be innocent of the charges after a court hearing. This is different from a <a href=lawglos_Discharge.html>Discharge</a>, where … |
| | Hello everyone ! This mysql user management fcking damn BULLSHIT (i think we can state it) begins really to drive me mad.. I got a win 2003 server running mysql, somehow i lost root access from the localhost meaning that i'm actually unable to make a backup from my database, … |
| | hi everyone i want to insert and retrieve images from the mysql using php(in wamp server).actually i searched the net and tried with many codes but cudnt find a solution.in the last one tht i tried,i created a table tht includes a blob datatype for one of its attribute and … |
| | Hi there Guys! I migrated my site to a new server and I had backed up my site. I uploaded the compressed version of the backup to the new server. But when the upload was completed i saw that i wasn't compressed. Anyways, I'll tell you step by step of … |
| | I need mysql queries for the following : (A)i have table with column headings emp name and password sno empname password 1 ani abcdefgh 2 venus bcde 3 joe bcdef 4 mary abcdef Q1:I want a mysql query to select and display the passoword whose character length is from 3 … |
| | Hello, i'm very new to c++ and i'm trying to create some sql but dont really know how. i need a very simple query in php i would do something like: [CODE] $page = "pagedata"; $sql = "INSERT INTO data SET field = '$page'"; [/CODE] i know i cant do … |
| | relative php noob needs help, have tried 3 or 4 differnet ways to get an image along with other post data from an html form to save into a mysql db. other data saves fine, no luck at all with image. php and form code below. HELP. Thanks in advance. …  |
| | Hi, If you see my other post about writing data to a file i am not doing that now i am using a database instead. Anyway .... Before i start i would like to say i am very very new to PHP and no very very little about MySQL writing. … |
| | Hi, I been having allot of help on here certainly from 'Josh Connerty', who has done a fantastic job of helping me. I am learning php and am enjoying it. So before i start a big thanks to Josh Connerty and this forum existing as it is a pleasure to … |
| | Hai all, I have create a web page in php. I am retrieving the values from mysql database and showing as grid view on page. I want to take a print on paper upto only datagrid. What to do..? Please help anyone with code....  |
| | I have mySQL 5.1 installed on a Windows Vista machine. I'm really curious as to where the file lives that holds the databases I created. I'm assuming it's in the mySQL install directory but I just don't know where (C:\Program Files\MySQL Server 5.1\?). Does anyone know?  |
| | Hey, I have the following query which I would like to insert into another table which I guess would demand some kind of loop or such. The query: [CODE]$colname_GetName = "-1"; if (isset($_SESSION['MM_Username'])) { $colname_Name = $_SESSION['MM_Username']; } mysql_select_db("db_name"); $query_Recordset = sprintf("SELECT * FROM Table WHERE UserName = %s", GetSQLValueString($colname_GetName, …  |
| | Hi, Everybody! I have one problem, I want to use same sql query in MySql and SqlServer. In case of Sql Server generally you have to write query in this way- select * from databasename.dbo.tablename but in case of MySql you have to write query in this way- select * … |
| | |
| | Hi. I am working on a php-mysql project. My table contains a field called "ID", which i have declared as teh PRIMARY key. but what i want is, that when the user tries ot insert record B into the table, an **ERROR message** should be displayed, showing that a record … |
| | here is my problem i have a data base and i have one table named request_recommend(requestid,status,for_email,sender_email,receiver_email) and one named connections(mail,connected_mail,type_of_con,comment,dateOfJoin) and i want to create a trigger who does not allow to create request_recommendation tuple if the writer and the recommended is not connected i really do not how to … |
| | Hello, I have this piece of code. [code=java] private Vector getColumn(ResultSet rs) throws SQLException { Vector row = null; ResultSetMetaData rsmd = null; boolean moreResults = rs.next(); if (moreResults) { row = new Vector(); rsmd = rs.getMetaData(); do { switch(rsmd.getColumnType(1)) { case Types.VARCHAR: row.addElement(rs.getString(1)); System.out.println(rs.getString(1)); break; case Types.INTEGER: row.addElement(new Integer(rs.getInt(1))); … |
| | Hi! I want to know that how can i use buttons to update ( edit or delete) records from the php form directly into the database... Thanks |
| | hi, i am a novice and have recently started practicing some php tutorials. there is this bit of code that involves HTTP authentication which makes sense up until this part: [CODE] // connect to database $dbc = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); // grab the user entered log-in data $user_username = … |
| | Hello, I have this piece of code. Help with Code Tags java Syntax (Toggle Plain Text) [code=java] private Vector getColumn(ResultSet rs) throws SQLException { Vector row = null; ResultSetMetaData rsmd = null; boolean moreResults = rs.next(); if (moreResults) { row = new Vector(); rsmd = rs.getMetaData(); do { switch(rsmd.getColumnType(1)) { … |
| | Hi,all Here is the sql sentence i wrote on my php file. But when i test with it nothing show up which there should have some results?? My idea is :get the sw and ne point, choose every value live inside the rectangle in my database [CODE=php]//zips is my table … |
 | this is the link i got it from: [URL="http://www.learnphponline.com/scripts/email-activation-for-php-forms"]http://www.learnphponline.com/scripts/email-activation-for-php-forms[/URL] this is the error im getting please also consider im n ew and dont know how to find the manual maybe it is a common known thing or something im asking anyways i wouldnt know waht to look for either its … |
| | Hi there what i'm trying to do is: return a car manufacturer from a MySQL database and have the text returned a hyperlink to the car manufacturer website. The below just returns the manufacturer without a hyperlink: [B]$row['manufacturer'][/B] Would i make a row in the database called 'carmakeurl', store the … |
| | i got this error: [code]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\db.php on line 13[/code] my php code is this: [code=php] <?php //Database Info $dbhost="localhost"; $dbuser="root"; $dbpass="something"; $dbname="somedb"; $table="users"; //Connect to Database $con=mysql_connect($dbhost, $dbuser, $dbpass); mysql_select_db($dbname, $con); $user=$_POST['user']; $pass=$_POST['pass']; $query = "SELECT * FROM $table … |
| | Howdy, I am trying to write a simple program in java that creates a database with some tables and adds some data, but I keep gettin this error: [CODE]java.sql.SQLException: No database selected[/CODE] I am posting the code below, it's really easy to understand. Please HELP!!! I am new at mySQL … |
| | basically i want to be able to display an image from a mySQL database using PHP. I heard about this BLOB binary stuff & decided it was too complicated. How would i store a url so that i could access and display it directly in PHP. For example, would i … |
| | Hi to all I need some help to write a java program to parse 2 text file one containing the details of the database and the other the data that will be used to insert in the tables of the database A sample for the first file : schema : … |
| | Hi all ! I have been assigned a task to implement an insert query into table a [i] only if [/i] a record doesn't exist in table c. I have been scratching my head for past 2 days and even my best friend [i] google [/i] didn't help me much, … |
| | I have been trying to format a date that I receive from a value in a mysql database. The format in mysql is as follows. 1986-08-02 I want to convert that to Aug. 2, 1986 I tried the date function in php and it was not working for me. Anyone, … |
| | I apologize beforehand if this topic is in the wrong place. Quite honestly I am desperate for help. I have a project for school involving Firefox and making an extension that is a visual database. My professor suggested I use SQL Lite to make the database. I am so beyond …  |
| | hello i got this error while taking a backup in mysql usung mysql administrator Error Performing Backup: Could not open file for writing backup. what does it mean how can i get rid of it the error at last table to be backedup |
| | I'm trying to create a form that updates a MySQL record when the user clicks a LINK, not a button. I don't want to open another page for this. There really isn't a need for me to post my code right now, as I'm trying to figure out how to … |
 | hi all i would like to create a registration and login and selection database, css, mysqladmin. need lots of help.. thanx something like this for example.. I am/We are a: Man Woman Couple (man and woman) *Interested in meeting: a Man a Woman a Couple (man and woman) a Group … |
| | I am new to PHP. I have a MySQL database with a column of URL's. I have a PHP script that randomizes the URL's and echoes the result to the browser. I just need a need a way to turn the randomized URL into a clickable link. I would imagine … |
| | Dear Masters, I have a problem on comparing data. I have two databases that have a similar (if not same) tables, but holds different data, and I want to merge the two tables. But can't seem to figure the easy way to do that, again and again I use script …  |
| | Hi i'm trying to write a simple SQL command to use within PHP. I want to select the whole table, sort by one of the columns, then only display the top 100 rows. Without the[B] WHERE rownum <=10[/B] it works fine. But it displays the whole contents of the table … |
| | i am having an issuse not sure how to approach this i have setup a area that grabs user's / user data by a search now i dont get the same results when i do lower case and uppser case any ideas ? [code]$query = "SELECT * FROM `users` WHERE … |
| | how can i find size of my database what is the max table size in mysql is table size shown is in terms of kb or mb in mysql by default actually dis is the max_data length shown using "show table status" 281474976710655. means data size is shown in kb … |
| | hi im a newbie at this but im getting a error message that says: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pickurau/public_html/classes/Lib/Query.php on line 27 and line 27 starts with the if(!mysql_affected_rows() || mysql_num_rows($this->rs) < 1) return false; does anyone know how can i fix … |
| | how to implement a java class making dynamic queries in java that access mySql tables query,insert & delete taking changing conditions & parameters every time like : SELECT field_names FROM tablename WHERE condition every time it takes different field_names , tablename and conditions  |
| | Hello, I am trying to store a single MYSQL result into a 2 dimensional array, for example I would like to end up with something like this: array[0][0] = result[0] , array[0][1] = result[1] , array[0][2] = result[2] ..... Here is my code: [code] $tempCat = array(); for ($i=0;$i<$numcat;$i++) { … |
The End.