[mysql] Forum Topics

Hello I have information comming from a form to the process below. the process validates user input using preg_match found in a function (valid.php) before inserting into a mysql database. This is my first attempt to use preg_match to validate user input and may have coded it incorrectly. The database …

hello can anyone tell me how to insert the NULL value into a field?

Hello I am using mysql with html to create a webpage I have a table called people This table has 2 fields, first_name and second_name I have 5 records in this table I want to select this information out of the MYSQL database and into fields on a form These …

I have a problem of pagination of turns out you of one query of search on a DB MySQL. With this code I succeed to visualize the first 5 records out to you in one page but when go in the successive pages it makes to see the first 5 …

I'm real stuck on a php jump script. Basically a value is called from my .html pages; somthing like this: <a href="jump.php?m=c"> which looks at the jump.php page and redirects the user. I track the number of clicks in a MySql database. I want the code to check the database …

Hi..plz..help me with the installation of mysql rmp for linux system...the purpose of my download is i am connecting my system to the router and trying to monitor the attach and any pre signature of the attack..plz..tell me the website address to downlaod and the version..

Hi Developemnt on win2003 server. Final server will be linux Apache,Mysql and PHP is being used. I use 2 scripts(form and process). The form displays multiple dynamic rows with chechboxs, input box for units of service, description of the service and each row has its own dropdown list of unit …

Hi, I'm trying to include non-lating characters in a jsp application, is there anything I should know about? because leaving it alone just doesn't work, setting the page content to "UTF-8" or any other encoding just doesn't work......what else is there? I noticed that the sun forum (my application is …

Hi I'm using JSP with Mysql.The Compile time no error.but in the run time the exception has been thrown, java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver i've set the classpath as well and i've attached jar file in the tomcat lib directory These are the class path settings C:\Program Files\Apache Software Foundation\Tomcat 5.5\common\lib\servlet-api.jar;C:\Program Files\Apache Software …

Hi, Is there any way to import data from MS Access in MYSql, so that I can add new members in groups in IPB-- this is solely a discussion forum for a digital media network targeted for college and high school students in the area. This is kind of a …

Hi all!! Brand new to this place and so far the forum is best by far!! Now to the good stuff: I am currently working on a project that involves php and mysql. The part that I am now is the "admin" section. I am setting up so the user …

UPDATE: MY COMMENTS POST BUT NOTHING ELSE? I have a form that collects firstname, lastname, email, attachment(file), and comments. I can query from my database, but when i submit data the fields are BLANK? What is going on? Below is sql on export. Table structure for table `clientlist` -- CREATE …

Hi, I'm glad to be here since I need advice and help regarding web development. I'm a web designer and wanted to improve and learn more about web development like doing web applications-- I specialize in Flash, php and xml. But I have a new job that will surely add …

Seems to search fine but only displays first record of result. Need to display all matching records. Here is the code [code]<? // Connect database mysql_connect("localhost","user","pass"); mysql_select_db("members"); // If submitted, check the value of "select". If its not blank value, get the value and put it into $select. if(isset($select)&&$select!=""){ $select=$_GET['select']; …

Hi to all :cheesy: The Problem::-| ======== I was wondering if someone could perhaps help me with a problem i have for a while now. I want to use two dropdowns and a submit button. Sounds pretty easy, but when php and mysql comes in, then it gets a bit …

Hello, I am facing a problem in ASP. The scenario is... I have a database with the following Colums and the data type of all Colums are integer id|score1 | score2 | score3 ------------------------------------ 1 | 10 | 4 | 10 | 2 | 5 | 51 | 10 | …

Hi all, I am having trouble working out how to pull up shipping options from a table based on two parameters, countryID and productCode. I have the following 2 tables: [B]ECOMMERCE_shipping[/B] shippingID countryID productCode cost1to2 [B]SYSTEM_countries[/B] countryID countryName What I want to do is feed it say, 3 product codes …

Hello I am attempting to upload a backup (gzipped SQL), to my server via phpmyadmin but it is just over the max upload limit therefore I cant upload it! How can I get around this.. is there another way of uploading the phpmyadmin gzipped backup, or changing that limit? I …

Hi, My goal is to perform a single SQL query (“select xxx from yyyy etc etc”) to a Database over a LAN, using BORLAND C++ 4.5 and managing USERNAME and PASSWORD. I tried 2 methods so far : Method N.1) I used “Tquery”, TdataSource and TDBedit components linked togheter and …

There are 2 columns in 1 database for [I]Id[/I] and [I]name[/I] but the serial number is random. I want to update those serial number in serial order, how to? Like id Name ------------ 1 Shouvik 5 Joe 6 Mathew 3 John 4 James 2 Jack I want to update it …

Hello. I go by JWig online. I am the webmaster of [URL="http://www.clgi.org"]CLGI.org[/URL], and various other sites for friends (see signature). This site (DaniWeb) has helped me as I learn webmastering. For awhile I was trying to establish my own server, using some of hubby's old equipment but had trouble and …

ok, well i know sql well but i am new to MySQL, learned that(mysql) few months back. however i have installed a new software called Altova DatabaseSpy to make my work much easier. Its working with all other databases Oracle, MSACCESS and all but not running or connecting with MySQL. …

Hi Folks, I am Doug Malsbury, a B.S. degree Chemist and PC compatible Systems Analyst. I am 58 yrs old and getting started learning PHP and MySQL on my own. I will be browsing around here looking for hints and suggestions I can use in my efforts to learn creation …

The expenditure for new s/w company Local panchayat will come to around Rs.250-Rs.300 I read this, I want to know that is it necessary to get licence of software we used or is it possible to start our developement in PHP and MySql since these are open source Rajesh More, …

Suppose I have this two tables; Modules and Student Modules has the following fields [LIST]Module_Code(Primary Key) [/LIST]Module_Name Student has the following fields [LIST]Stud_Number(primary key) [/LIST]Stud_FullName My problem is that I want to include the Stud_Number on the Modules table to make it a primary key. Can anyone show me the …

I am needing help with my final year project for a database which will show students on a specific programme (i.e. Business Studies) in a specific year what events they will have for the week of induction. The problem seems to be with the day, room and time and these …

I NEED HELP PLEASE PLEASE PLEASE THE PROBLEM IS [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/mounted-storage/home23a/sub003/sc21979-KVVZ/www/ghhookup/functions.php[/B] on line [B]28[/B] [PHP]<? $conn_id; $sql_res; $sql_res2; $sql_query; $HTTP_REFERER=$_SERVER["HTTP_REFERER"]; $REQUEST_METHOD=$_SERVER["REQUEST_METHOD"]; function sql_connect(){ global $conn_id,$sql_host,$sql_user,$sql_pass,$sql_db; $conn_id=mysql_connect($sql_host,$sql_user,$sql_pass); mysql_select_db($sql_db); } function sql_execute($sql_query,$wtr){ global $conn_id; $sql_res=mysql_query($sql_query,$conn_id); if($wtr=='get'){ if(mysql_num_rows($sql_res)){ return mysql_fetch_object($sql_res); } else …

I'm trying to create a list to record student grades into the database. I'm able to pull out the names from the database and create a table with textfields in it to input the data into. This is the code i'm using for(int i = 0; rst2.next(); i++){ ....... <th …

I have proposed a final year project on e-commerce .So i want to use a windows xp machine for development of website.Can anyone tell how compatible the apache web server,php, and mysql in wamp5_1.6.4a is and can I use them without facing problems in connectivity of database or have to …

I'm having a problem outputing from a database I'm trying to get a text field from the MySQL data base My input was "Come join us for John's birthday" But the actual out put was "Come join us for John's birthday" How do I fix this? When i do " …

Ive got the code: [php]mysql_query("UPDATE members SET gold=gold+$sellprice WHERE email='$player[email]' ")or die(mysql_error());[/php] To add gold to a users account in the database but this doesn't work every time I run the script instead of adding on the new value to the old one it just sets the gold to zero, …

Im having a problem that my while loop is not finishing even when the conditions have been meet. [php]$turn = "0"; while ($player['health_n'] > "0" OR $opponent['health_n'] > "0" AND $turn < "25"){ $turn = $turn+1; $hitfor = $youatk / $oppdef; if ($hitfor <= "0"){ echo "$turn. $opponent[name] blocked.<br />"; …

I need to come up with a leave application script. For example i have 21days of annual leave. The actual amount will be taken from a database. If i select today from the drop down box and one week later in the other drop down, the script will automaticall minus …

Well I am trying to search a database using ASP. I want to search all the names of persons in a database by their mobile number. The mobile numbers are entered in a textarea and needs to seach them at once. I could not figure out how can this be …

Is there an open source script of some sort, or can how can I make something that takes a backup of a give MySQL Database and every day it daves a .gz of the database toa directory on my server, so it is backed up automatically every day....:cheesy: Thanks for …

I have two tables: tb1: ID USERNAME 1 u11 2 u12 3 u13 tb2: ID USERNAME 2 u12 My question is how to retrieve records from tb1 and exclude one that is in tb2, so the result will be: ID USERNAME 1 u11 3 u13 Any comment? Thanks in advance.

I NEED HELP PLEASE PLEASE PLEASE THE PROBLEM IS [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/mounted-storage/home23a/sub003/sc21979-KVVZ/www/ghhookup/functions.php[/B] on line [B]28[/B] [PHP]<? $conn_id; $sql_res; $sql_res2; $sql_query; $HTTP_REFERER=$_SERVER["HTTP_REFERER"]; $REQUEST_METHOD=$_SERVER["REQUEST_METHOD"]; function sql_connect(){ global $conn_id,$sql_host,$sql_user,$sql_pass,$sql_db; $conn_id=mysql_connect($sql_host,$sql_user,$sql_pass); mysql_select_db($sql_db); } function sql_execute($sql_query,$wtr){ global $conn_id; $sql_res=mysql_query($sql_query,$conn_id); if($wtr=='get'){ if(mysql_num_rows($sql_res)){ return mysql_fetch_object($sql_res); } else …

Hi, I'm currently doing a registration module for my project. When user click submit button, I want to compare all the existing UserName in the database and the UserName enter by user to see if there have any duplication. If the UserName already exist, user is require to change UserName. …

Hello... I have one curiosity that I need to solve. I hope anyone who know the problem tell me reason why is this so. I have done a php/mysql application some time ago and I encounter this problem while testing on using coding with register_global on and register_global off. I …

[B]First Issue: Problem[/B] So on a forum, i've condensed the date of a certain event to $date = $month . " " . $day . ", " . $year; So instead of storing the Month Day and Year in seperate rows on mysql, i store all three under 1. But …

Hi, I run a webserver from home (separate machine from my pc). we have a cisco 2611xm internal router and a cisco 3725 external router with the webserver in the dmz. when browsing the internet from my pc (in the internal lan) I can view everything except any sites hosted …

why does [code]$sql = 'SELECT userid FROM `phplist_user_user_attribute` WHERE `attributeid`= 7 AND `value` LIKE "68104"'; $query = mysql_query($sql);[/code] find 23 records, but [code]$testvalue="68104"; $sql = 'SELECT userid FROM `phplist_user_user_attribute` WHERE `attributeid`= 7 AND `value` LIKE "$testvalue"'; $query = mysql_query($sql);[/code] finds none? Shouldn't they be the same? Can I not use …

Can anyone help..... When I search on my site this is the error I get [QUOTE] [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/mounted-storage/home23a/sub003/sc21979-KVVZ/www/ghhookup/functions.php[/B] on line [B]28[/B][/QUOTE] This is a peice of the code from function.php [QUOTE]if(mysql_num_rows($sql_res)){ return mysql_fetch_object($sql_res); } else { return ''; } …

Hi All. I have a very large single-table database of articles that I want to convert to a multi-table, relational database. The existing single-table database contains fields for article author, article source, and article category, where several 'author', 'source', and 'category' IDs repeat dozens of times for hundreds of different …

I have a simple database for hockey stats for my son. I can enter data into the db and pull it back, but I wanted to have points, which is goals + assists, displayed without entering into the DB. I enter both Goals and assists into the database and display …

Hi! I'm doing a small website with some mysql and php, and have difficulties with doing a login site. I have the form sending the username and password, and this site should check them. Here's the code: [php] <?php session_start(); if(!($connection = mysql_connect("host","user","pass"))) die("Can't connect to database."); if(!(mysql_select_db("db", $connection))) die("ERROR …

Hi, My prob is i need to store a line of sentence onto my SQL SERVER Database. Am using VB.NET as Front End and MS Sql Server as BackEnd for storing just a line with no symbols is perfect going on but lets say eg: The Computer Hasn't got a …

Hello, My site has a error: Parse error: syntax error, unexpected T_STRING in /home/***/public_html/playground/maps.php on line 341 Line 341: $getopp="SELECT * from a_pokemon where Pokemon='$getuser3[Opponent]'"; $getopp2=mysql_query($getopp) or die("Could not get Pokemon from database."); $getopp3=mysql_fetch_array($getopp2); Thanks, Danyal.

Hello, I'm building a website like MySpace, the address is [URL="http://pantarei.awardspace.com/"]http://pantarei.awardspace.com[/URL] the website is wrote in Italian. It has members customizable profiles, internak message system, search user tools, a forum and a chat. I just builded the main forum page but I have a problem that I cannot solve. The …

hello has anyone installed and uploaded phpadmin through dreamweaver. can anyone explain to me how? im a bit stuck