10,932 Topics
![]() | |
[B]hi , i got an error.pls help me to correct. my code is[/B] [CODE] <form action="return.php" method="post"> <table width="200" border="0"> <tr> <td><h3 align="center">RETURN</h3></td> </tr> </table> <p align="center"> </p> <table width="41%" height="254" border="0"> <tbody> <tr> <td width="34%">Author:</td> <td width="66%"><p> <input type="text" name="author1" /> </p></td> </tr> <tr> <td>Title:</td> <td><p> <input type="text" name="title1" /> … | |
I am sorry but I am just starting and I suck. I've been spending the last hour on the site trying to use others' threads and the FAQ to fix this but I simply have not been able to do so. This is real simple. All my code is.. [CODE] … | |
I have a function C++ file, created in VS 2005. But I am not sure how to register that function in mysql, so that it get stored somewhere in mysql database and when the query runs, it should retrieve the func definition from the database itself.. Please guide me with … | |
Hi I'm facing a problem. I want to join two table which are in the following format. Table 1 id - - name 1 - - xx 2 - - yy 3 - - zxz Table 2 id -- xx -- yy 1 -- 1 -- 1 2 -- 2 … | |
hello there, i'm having a bit of trouble about this. im making a regiter page for our project and im using PHP, and im having a little problem, it says that: Could not execute the insert query.. but i got all my fields right?.. [ICODE]<?php include("config.php"); if(isset($_POST['submit'])) { $fname = … ![]() | |
[CODE] <?php //LOAD USER $result = mysql_query("SELECT * FROM event"); while ($data = mysql_fetch_array($result)){ ?> <tr> <td><?php echo $data['event'];?></td> <td><?php echo $data['tempat'];?></td> <td><?php echo readDate($data['mulai']);?></td> <td><?php echo readDate($data['selesai']);?></td> [/CODE]> I have this error: Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\php_template2\event_manager.php on line 206 Line 206 … | |
Hello, Despite much searching, I've hit a wall with trying to get a varying number of records inserted into a database. Here's what I'm trying to do..... I'm building an online sign on site for races at a sailing club. For the sign on page, I want to make it … | |
I have two date field in a table. Start and End I need to run a query to find out which records in a period. For example, in database have two date fields (event_start and event_end) I want to find out all activities include in 13/8 to 15/9. Not use … | |
I found an old thread that had never been answered here - [url]http://www.daniweb.com/software-development/vbnet/threads/330981[/url] Basically, the guy was asking how to retrieve database names and/or table names from a MySql database with vb.net. Here's my answer to that. Yes, I still use vb6 because vb.net is not much better and I … | |
Hello Everyone I have a simple form posting to mysql database. I set one of the fields to be Text Area. I have and HTML Link Code that needs to be in that field. When I upload he data to the db, my " gets hashed out a \ gets … | |
Alright, I have a members area, area.php, and I used mysql to find the userlevel and display content depending on the userlevel, 1 for user, 2 for admin. I made it, but it displays both the user and admin for 1, and 2. [CODE]<?php // Members Area // session_start(); $usernamee … | |
Hello, I'm trying to display a table in PHP that uses multiple MySQL tables with some repeated field names. [U]Master table field names:[/U] Name, Student Major, Course Major, Course #, Credits, Course Name This is what I have so far...but the variables in the loop are not working and I'm … ![]() | |
I have been trying to run a command from the SQL view I'm getting a syntax error [CODE] CREATE VIEW TopLevelCust AS SELECT Customer.CustomerNum, Customer.CustomerName, Customer.Street, Customer.Balance, Customer.CreditLimit FROM Customer WHERE (((Customer.[CreditLimit])>=10000)); [/CODE] | |
Table A(line_key,transaction_no,transaction_amt) Which is the o/p of the following query?? Select line_key,transaction_no,sum(Transaction_amt)From A; Ans 1. all the rows from the above table 2.no rows at all 3.error post your reply soon | |
I'm looking to be able to have users register on my site or the forums (or vice versa) and be able to login to either with the same details. Is this possible? I sure as damn hope it is!! Hellppp! Also, how do I have users register? myBB comes with … | |
I have a form with checkboxes [CODE]<input type="checkbox" name="yo[1]" value=1 <input type="checkbox" name="yo[2]" value=1 <input type="checkbox" name="yo[3]" value=1[/CODE] I want to to insert values into db exactly like this create table tablename yo1 tinyint default 0 , yo2 tinyint default 0, yo3 tinyint default 0 insert into table set yo1=value, … ![]() | |
hi, how can i trigger an update query on a certain record if that record was not update within last say: 1 minute???/ can i doit without using any scripting? if can't then php. | |
Hi, i was just wondering how I get user details from a user table from a mysql database. Ive already worked out how to connect to the server, im just wondering how to import the data into a datagrid. Thanks Heres my current code [CODE]Imports MySql.Data.MySqlClient Module sql Dim Connection … | |
Ok, working on a blog engine. Small and somewhat unimpressive, basically following along with a tutorial. The tutorial basically has me write a little MySQL to query some test fields that we filled in manually. And here is what I get. (see attachments) The first one shows the read out … | |
Hi, I have a MySQL database and an array with ID's. For example: $q = array(4,7,9,34,12,3,...etc); The ID count in array can be over 100. What's the best way to select only those rows matching those ID's in array? The usual SELECT * FROM table WHERE ID = '$q[0]' OR … | |
[CODE]update companystatistic set ReferencePrice = (select ClosedPrice from companystatistic WHERE CompanyID= 310 and ResultedDate = CURDATE() - 1) where ResultedDate = CURDATE() and CompanyID= 310 [/CODE] I have a same code. But it's not work.. help me..! thanks all | |
I don't know am i asking right question or not but my question is: I want to create a simple search site so I've team with different jobs. I have its database part to handle. I should create its database and i have not idea what should i do. I'm … | |
hi pros am new at C# and under graduate student. am stuck several hours. i have latitude,Longitude values from a server or gps device, they appear in textboxes and stored in mysql at the same time. i want to use the same latest values to map directly to google earth. … | |
my work is stop here dont know how to do this i want to store numbers of images in mysql. after thar i want to reterive those products images with description and price. how it will be done? secondly if i click on category number 1 those images with detail … | |
Hi all, Likewise in SQL Server, after every transaction, an error number is set to the global variable @@ERROR. So we easily make a check in SQL SERVER stored procedure, [CODE]IF @@ERROR = 0 SELECT 'SUCCESS' ELSE SELECT 'FAIL'[/CODE] How can I do the similar thing in MySQL. How can … | |
i have created a database on a temp site and i am making a form where uses can add or update information to the database that will then be displayed on a page in the site. Here is the code for the form: [CODE]<form action="leaderboard.php" mehtod="POST" /> <p>Points: <input type="text" … | |
Hi Everyone, Does anyone know how to set the schema so that it can stores chinese character. Thanks. | |
Hi guys, I'm in the process of learning PHP. I know the dribs and drabs and can kind of understand code when I read it, but I'm not to the point of being able to write an advanced script from scratch. I've been interested in chatbots and the concept AI … | |
Ok, I feel like I'm so close, but could use some help. I am trying to retrieve data from mySQL database via use of a form with checkboxes. This form is working somewhat except that it is only pulling one selection, not all that are selected. Can someone look at … ![]() |
The End.