[mysql] Forum Topics

did php support or allow to add many record at one time in MySql Database ?.. i need 2 add all the student mark the same time dis is my php script form.. <?php echo"<form name='kptm' form method='POST' action='3.php'>"; echo"<h1 align='center'> Final Mark</h1>"; echo"<table border='2'>"; echo"<p align='center'>SUBJECT : UNIX SYSTEM …

Hi I would really appreciate some assistance on the following as I suck a bit when it comes to joins i have 3 tables consultants,points,orders all tables have the column id_number I need to run a query that will give me a list of all the consultants with a total …

ello..im a new beginner for pHp script..i have to complete my final project..i used php as my programming language..but,i have a problem rite now..did anybody know,how to insert data from 1 form into multiple tables in MySql Database?.. ok,rite now,i have 2 tables, Client and Client2,k..And from 1 form that …

Hi I am Sriram from India. I am a trainee in web devolpment with PHP and MYSQL. I am happy that i can learn more things from you all and can give my possible help. Thank you.

Hello everybody, I wrote a file using AJAX this is the code I wrote: File.js [CODE]var http = createRequestObject(); function createRequestObject(){ var request_; var browser = navigator.appName; if(browser == "Microsoft Internet Explorer"){ request_ = new ActiveXObject("Microsoft.XMLHTTP"); } else{ request_ = new XMLHttpRequest(); } return request_; } function getInfo(){ http.open('get', 'GtCht.php'); …

hey guys, anyone here familiar with gpix? It's a free pixel ad script (php) that I got from tufat.com. I'm thinking that I could sustain a pixel ad site with Google adwords and a free mysql server or something. Has anyone been able to make any money with gpix yet …

<form action="book_dive.php" method="post"> <input type="submit" value="Submit"> <table border="1" width="75%" cellpadding="2" cellspacing="2"> <tr> <td align="center">BOOK</td> <td align="center">DATE</td> <td align="center">TIME</td> <td align="center">LEAVING FROM</td> <td align="center">BOAT</td> <td align="center">DEPTH</td> <td align="center">DIVE SITE</td> <td align="center">MIN QUAL</td> </tr> <? include("conn.php"); $res=mysql_query("SELECT * FROM dives"); if(mysql_num_rows($res)==0) echo "No data in table"; for($i=0;$i<mysql_num_rows($res);$i++) { $row=mysql_fetch_assoc($res); //mysql_fetch_assoc STORES A …

I made a query that joins 3 tables. Products, parts, and sales invoice tables. The thing is, the common key between the 3 tables is the sales invoice number, but when I try to execute the the query it displays duplicates. One example is when I make a query on …

Hi Everybody! How to upload a image / pdf file in mysql table blob column with ASP pls help me HemantK

Can someone please help, I have this code below and every time i execute it i get this error: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/dbconnect1.php on line 14 I can work out what i am doin wrong. <?php $dbhost = "localhost"; $dbuser = …

Hi everyone I'm looking for advice on building up a database. Any sort of general do's and don't s. The one and only thing that I realize is that putting ALL my info into one table is not a good thing. This is the first database I'll be creating so …

Hi, I need to calculate the number of working days between 2 dates entered in a page using PHP. The dates and the calculated number then need to be put into a MySQL database. I am new to PHP, but understand the linking to the database and basic fnctions within …

[B]Well Guys i really need you guys help. I want to Show (display) Last 10 Categories Here is Sql Table for Categories.what i think is it can be done with 'cat_id',but i am not really getting this .anybody can help me ?[/B] [code]CREATE TABLE `categories` ( `cat_id` int(10) unsigned NOT …

I need a very strong PHP, MySQL programmer for a large Web development job. The freelancer will be required to work at the client site ONLY in the western Chicago suburbs. The project will begin in 2008 with the following high level criteria: 1) The main focus of the project …

Hi all, I'm not sure how to phrase this question... I have a table that requires a foreign key of anything table - this foreign key is automatically generated and the key field in the 'foreign' table. So I have the following situation (kind of): Table Observation [INDENT][B]Time_Stamp[/B] - [I]primary …

please can anybody give me some idea about data warehousing

Im trying to practice writing a small DB that involves three tables-internal users, external users, and a Rep (call rep) table to tie them together so if someone is partial to working with one of us it is notated. Here is what I have so far: Employees (for later down …

I'm trying to keep all my dates and times to a standard GMT (UTC) time when I store it into the database. When I pull the data however, I want to be able to do the timezone adjustment within the query. I've tried something like this with no luck: [CODE] …

Ok, I thought I had gotten all the answers I needed and marked my thread as solved. But now I am having problems trying to put the code into use. I tried to insert the data from my form into my data base and got an error message. I obviously …

I have an html form from which I am trying to insert the data into a MySQL db. I have heard that the date needs to be in a specific format for inserting into the table, I believe it was YearDayMonth (20070612) Is this true? Because of that, I broke …

Hello !! Please, I have a question. I want to [U]create a form [/U]in which the person who fills this form can write: 1. His/her e-mail address 2. That person has [B]one drop menu [/B]in which there are 5 products to choose, he/she has to choose one. 3. There is …

Ok, I am trying to insert the data from a form into a table on my MySQL database. I have been going through some tutorials on how to do this, and have found slightly different answers. I'm assuming that they both kind of do the same thing, but what would …

I am having a complicated problem with the design of a database. Lets Describe the problem This is going to be used in a job tracking system we will have a list of jobs so TABLE 1: JOBS ([U]JOBID[/U],DUE DATE, SHIP DATE, INVOICE DATE, STATUS, CATAGORY) what is category well …

html page <form method="get" action="sort2.php"> <table> <tr> <td>id</td><td><input type="text" name="id"></td> </tr> <tr> <td>From</td><td><input type="text" name="from"></td> <td>To</td><td><input type="text" name="to"></td> <td><input type="submit" name="submit" value="submit"></td></tr> </table> </form> sort2.php <?php $id=$_REQUEST['id']; $to=$_REQUEST['to']; $from=$_REQUEST['from']; $link=mysql_connect($hostname, $username, $password); mysql_select_db($dbid) or die("unable to connect"); $query="(select name,id from member where id=(select day,time from attend where day between '$from' …

Program terminated with signal 11, Segmentation fault. Environment: FreeBSD 6.2, Python 2.4.4, MySQLdb 1.2.2, SQLObject 0.9.1 I faced with an error in our multithreaded, network oriented application, wich interacts actively with MySQL database. Brief information from core dump is below (more detailed one is in the file attached). Though I …

hi i have a form where the user will enter the data based on the user input i want to retrieve data ex 1st textbox one get the standard (class of the student) 2nd & 3rd textbox get the range (ex rank 1 to 10) when the user clicks submit...i …

Hello, I would like to know how to display the totals of fields in a given table using vb or SQL. I have a page that I'd like to display the number of people who have completed training. In my database this is determined by a field called pr_mod8. If …

Hi, A third party development company is creating a third party application for us in PHP and uses a MYSQL database. The app is an extension of our website which is developed in .NET and uses a MSSQL 2005 database. There are some cases where the two databases require connectivity …

Hi all, I'm currently finally starting mysql and am have difficulty getting it up online. what i've done so far is correct but only for this error: Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to MySQL server on 'www.dteeducation.ie' (61) in /usr/www/users/adv123site/home/youruser/public_html//settings/database.php on line 10 Cannot connect to database, check if username, …

Hi, I am trying to create a 'simple' admin page where certain (authorized) people can update data in the database or add new info to it. The issue i've run into is after i created the form and have all the fields how do i tell which one(s) the user …

hi i have two different table,i want to select the name and id(primary key) from the first table..based on the id..i want to select the rest of the data in the second table... the below query is showing error,plz do tell me the bug. $query="select id,name from table1 where id='$id' …

I developed an online store catalog using PHP & MYSQL on Windows. It imports tab delimited data for new products from text files in a folder. While it worked fine on Wndows, when I run it in the MAMP installation on my iMac with Mac OSX it is not working. …

i currently have a database that someone else created a while ago and i have been tasked with speeding up the data entry and search functionality. currently the database is one table with the following field names: bid_id = primary key date_num = date of project proj_nm = name of …

Hello everybody i'm here for the first time n i hope you can help me i have to do a project for web-based course i didn't get the full idea yet my friend told me to do a web site like Hotmail or yahoo but i don't know how to …

hi i have a table where dates and other info are getting inserted... i have a form where the user can select a start date end date.. based on the start date and end date ..i want to retrieve all the content stored between these dates.....

I'm trying to learn php/mysql Read "php and mysql for dummies" and keep getting stuck. Can you get me through this? Regards, Kris [email]m31342@hotmail.com[/email]

Hi! Sorry about my bad grammer and/or spelling. English is not my native language. I don't know if this already have been asked and answered, however... I'm currently developing a program in which it will be possible to select table fields from a database and set various criteria using dropdown-lists. …

Hi all - I'm hoping someone here can help me with this as I have been trying to figure it out for the past 48 hours and have made little progress. I have two table in my database. The Primary Key (Serial) in tblTitles is the Foreign Key(Serial) in tblQuotes. …

I posted this in the html section but I am not sure if it will be that simple. I have a .php form that populates from info in a MySQL DB. Anyway, I want to have the ability to email the form(whatever happens to be displayed at the moment) to …

Am trying to develop a front-end to Mysql database. I do not intend to use it for web purposes so I do not need PHP. which slanguage can I use?

hi i am not able to update my table.plz do tell me the bug in my code..... when update link is clicked in the first page..the table should get updated [B][COLOR="Green"]page 1[/COLOR][/B] $link=mysql_connect($hostname, $username, $password); mysql_select_db($dbid) or die("unable to connect"); $x = $_GET['name']; $result=mysql_query("SELECT * FROM table1 where name='$x'") or …

Hello! I have a query with multiple table joints and where clauses. Tables are huge and query runs for a very long time. I need to run another query, which is exactly the same apart for one Where clause (first time price = "P", second time price = "S"). I …

Hi I am new to php and most other things, I am trying to make a form on my website to take users details for membership purposes. This data will be stored in a mysql database. What I have at the moment is a plain html form that posts the …

I have a .php form that populates from info in a MySQL DB. Anyway, I want to have the ability to email the form to a not predetermined email address. Any ideas? Our default email program is TBird if it matters. Thanks DS

Hi, I am using a JSP from to collect data from user and then inserting those values into a table in MySQL.But it is returning 'null' always.I am able to query the DB and view the entire table and everything else is fine. But the INSERT is not working somehow!!! …

hi i have a table which has uname,pss,type fields now i want to check the login (ie is username and password) and if the type is administrator then redirect to a different page... if the type is a user then redirect him to another page... in this apllication there are …

I really don't have the patience for this but I'm trying to learn php/mysql and really could use some tutors. The online tutorials are a fair introduction. But I've got a big project I need to make progress on quickly. If anyone here would be willing to give me some …

Example: Navigate: PHP Code Library > PHP > Sub1 > Title V Any ideas, tutorials no how to do that using php & mysql ? each category should be able to have items and more categories under it. It should use a single table to store all the category titles. …

I have a cgi/perl site and would like to convert everything over to php/mysql, then start customizing it, that or just integrate the two. I'd really like someone to hold my hand as I learn these languages and attempt to improve my web site. Even CSS gives me problems. Basically, …

Hi, I am very new to PHP, teaching myself at the moment. I am using online tutorials to teach myself, so I am at their mercy of what information they provide. I have found some decent scripts, but they don't show me how to link them together. I am trying …