10,940 Topics
 | |
 | hello, need help from you guys. ok, i have create a prompt box that will ask user to enter a password, and this prompt box will take user to secured page. [CODE] <script type="text/javascript"> function show_prompt() { var name=prompt("Please enter your password","Fill Here"); if (name!=null && name!="") { location.href="index.php"; } … |
 | I have code like this, it shows data when tehre is data but if there is no data i want to say "no records" where am i going wrong? [CODE]<?php require_once('db_conf.php'); $sql = "SELECT * FROM tbl_holidayspecials WHERE fld_country = '$countryname' AND fld_state = '$statename' AND fld_city = '$cityname'"; $result … |
| | So.. I dont know why i cant find a specific tutorial / tip on this, so i'll ask you guys. I'm trying to get $date to get the current date and insert it as the query executes. [CODE]$result=mysql_query("INSERT INTO articles (`loginid`,`title`,`author`,`body`,`date`,`category`) VALUES ('$loginid','$title','$author','$body','$date','$category')") [/CODE] this is my Database. [CODE]CREATE TABLE … |
| | I am trying to update a mysql entry. Getting this error; [CODE]Insert Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('loginid='15',title='Test',author='Sorcher',body=' Yeah just testing this aga' at line 1[/CODE] [CODE]if ($_GET['edit']){ $getedit … |
| | Good day all: Is there a mechanism through which I can have a button on my html form which on click calls a script that converts the form (or the html page) into a pdf file and inserts the file into mysql table with a specified name originating from the …  |
| | It wont work, the script might be messed up, please help / give a hint, i'll rep any help. [CODE]<?php session_start(); error_reporting(E_ALL); //////POST STATEMENTS/////////// $loginid = $_POST['loginid']; $title = $_POST['title']; $author = $_POST['author']; $body = $_POST['body']; $category = $_POST['category']; $dbLink = new mysqli('xxxxx.xxxxxx.com', 'xxxxxxx', 'xxxxxxx', 'xxxxxxx'); if(mysqli_connect_errno()) { die("MySQL connection … |
| | getting the problem ~ mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /studhome/1/0803087/public_html/RSS.php on line 14 trying to create a RSS feed no idea what is wrong, so can anyone help [CODE] <? // Connect to database DEFINE ('DB_USER', '******'); DEFINE ('DB_PASSWORD', '********'); DEFINE ('DB_HOST', '*****'); DEFINE … |
| | I get this error message: Insert Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'testing this thing again' at line 2 NOTE: the 'testing this thing again' is $body This is my … |
| | I get the error #1005 - Can't create table 'db1.#sql-9e8_2c1' (errno: 150) (<a href="server_engines.php?engine=InnoDB&page=Status&token=3947cba14f7c39305d6f460b76698c5e">Details...</a>) I have 2 tables that I want to connect as a 1-1 relationship. table1:[U] a ,b[/U] ,c ,d table2: [U]a ,b[/U] the plan is that table2 will hold the keys of some of the records that … |
| | Hi, I am fetching date from the database which is submitted by user while form filling. The date came from database 2011-11-15. What i want to do,show date in below format. 2011-dec-15 or dec 15 2011 need help?? |
| | Please I need help, I don't know what I'm doing wrong here, [CODE] $query=( "UPDATE $tblname SET totwrong =".$wrongAnswers."', SET Test_score ='".$percentage."' WHERE UserName = '".$UserName."'"); [/CODE] It does not update the table, please please  |
| | Does anyone know how I would go about storing something from my database into a variable to use elsewhere on my PHP code? |
| | Hi, I am fetching current date from mysql database by using curdate() function. 16-06-2011 what i want to do.. 16-june-2011 how it is possible in mysql Need help?????? |
| | Hi, I'm building out a social network system, and when trying to pull user info for a user's friends, I'm stumbling into a problem with the query. The issue is I'm trying to keep the lookup table from listing redundant entries. For instance, [CODE]FRIENDS TABLE ------------- uid | fid ------------- … |
| | Hi, I have 3 feilds in my invoice processing Table. [LIST=1] [*]Submet [*]Return [*]Resubmitted [/LIST] Now I am using this query [CODE=mysql]SELECT `SRNo` , `VenName` , `Submet` , TO_DAYS( NOW( ) ) - TO_DAYS( `Submet` ) AS Days FROM `invmain` WHERE `Status` = 'SENT TO PAYABLE' AND `Submet` != '0000-00-00' … |
| | Hello, I am building a stock market website and i want to show all commodities prices rise fall even charts later .first of i want to know whether it is possible or not.If yes please guide me through.Please help any kind of help appreciated |
| | Hey, the data in my DB isn't going to be in english, and I'm wondering if I should name the tables and the fields not in english as well, or there might be problems later when using the names in PHP or SQL code? any one had experience with that? |
| | table: hometeam awayteam homepoints awaypoints leeds man u 3 0 leeds man u 3 0 man u leeds 0 3 i want to calculate how many points each team has. with the above data leeds should have 9 and man u 0. i have come up wth the following sql … |
| | Ok so let me start off by saying I am not a NOOB. There... So i need help trying to figure out an export of just my 2 colums from a table. Got it done. Now i need to make sure that I only export from a date range and … |
| | Hello, I have a form from which I post some data into 3 tables: when I click on the submit button I don't get any error message from mysql_error(); but when I look to my 3 tables I see no one of them has received the data I just posted … |
| | I have an issue with an insert statement not producing what I think it should produce... Here are the relevant parts of the code: [CODE] $free_pos[0][0] = $free_pos[1][0] = $left_top = $row[0];// value is 10000002 $free_pos[0][1] = $free_pos[1][1] = $left_step = $row[1];// value is 1 $free_pos[2][0] = $free_pos[3][0] = $right_top … |
 | Hi there. Thinking about creating a membership registration-enabled website, that will store people names and some info about them, after they register, but what i can't begin to make is a PHP code that whenever, a user searchs ( In a search box ) a name of another user, that … |
| | I have two tables: CDDemographics and CBTechProviderData. Both have 200,000+ rows. A common column between these tables is CensusBlockID, of which the first 5 integers are the fips code - in this case I am defining that code as 55001. I am trying to sum the population of CensusBlockIDs where … |
| | Morning,afternoon,evening and av a great night to all, solution needed plaese. secnario. players eneter log on screen and enter name ,password, (id is index on base) then go to check_logon.php if happy end up at logon_success.php this run ok :) am now trying to display players id number on logon_success.php. … |
| | Hi, mysql_query() expects parameter 1 to be string, object given in C:\xampp\htdocs\livesearch\livesearch\ajax-search.php on line 18 need help [CODE]<?php include_once ('database_connection.php'); if(isset($_GET['keyword'])){ $keyword = trim($_GET['keyword']) ; $keyword = mysqli_real_escape_string($dbc, $keyword); $query = "SELECT * FROM register WHERE subject LIKE '%$keyword%'"; echo "SELECT * FROM register WHERE subject LIKE '%$keyword%' "; //echo … |
| | Hello to everyone. I have an old flat database with a couple of hundred entries that I want to convert to a relational design. It was a user database for simple login and some preferences. I would like to know if there is a simple way to convert from one … |
| | hey there, I am doing testing to my site and i need to make over 60 rows to check paging. Is there any possible way to just copy rows over and over again? Thank you, |
| | Hi all, I have a table with multiple apps listed on it. The table is auto populated with the all available apps. The admin then has a options to assign user permissions e.g. user, admin or none. I have attached a pic of my table. I wanted to know how … |
| | HI there.. I've spend almost a day looking for a script for image upload but unfortunately, i see none. so, I consider writing a thread here at daniweb so the advance programmer there will help me with my problem. Please help me in creating a script that will enable the … |
 |
The End.