theonly

hello all; scratching my head because I have no clue why this query doesn't work. php5, mysql 5.1 [code]INSERT INTO cats (title,type,cat_parent,cat_descr) VALUES ('Category Name', '0','0','Category Description')[/code] BASIC insert query. and the error I get ad infinitum is this: [CODE]Error: You have an error in your SQL syntax; check the …

Hey guys I'm new to this I bought this script yesterday and on my site I keep getting this Warning need help!!! Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\Hosting\6967501\html\config.php on line 13 [CODE]<?php // Provide Values for Database $dbhost="MYHOST"; $dbname="DB_NAME"; $dbuser="DB_USER"; $dbpass="DB_PASSWORD"; //Don't change …

addproduct.php snippet (there are lots of other inputs, not sure if that matters): <form method="POST" action="add.php" enctype="multipart/form-data"> <p>Picture:<input type="file" id="pic_upload" name="pic" /> <input type="submit" /> </form> add.php: if(isset($_FILES["pic"])) { if($_FILES["pic"]["error"]==0) { $name = explode(".",basename($_FILES["pic"]["name"])); $target = realpath(dirname($_SERVER['PHP_SELF']))."/images/".$name[0].session_id().".".$name[1]; $temp = $name[0].session_id().".".$name[1]; if(!move_uploaded_file($_FILES["pic"]["tmp_name"],$target)) { add_error("Picture specified did not upload"); } $_POST['pic']=$temp; } …

Hi fellow programmers, i am designing a Student management system with PHP MySQL and using dreamweaver for editing. I need to do audit trails; that is to capture every operation any users does on my website. I was able to capture the logging in using the codes below but i …

hello, i'm a newbie in database and php. I'm having a difficulty of retrieving images that have been uploaded to my database. Actually I'm wondering if the image is been saved on the database, help me! [icode]while($row = mysql_fetch_array( $result2 )) { // Print out the contents of each row …

hey guys, i am working on coordinates in one program and there is a line such as this one: [CODE]int xx =Math.round((int) getWidth() * 100 / 768);[/CODE] can somebody tell me what calculation is actually taken before the value is set to int xx thanks a lot for any suggestions

Hi, i'm looking to learn a programming language, but i don't know which. Can someone help me? I did some Pascal, C, C++ and Fox Pro in highschool and some HTML, PHP, MySql in faculty. [B]What do you guys advise me to do?[/B]

I need it to read all three of the numbers and up them back least to greatest. As of right now all it prints is 0.0 for all 3 and true. How do I get it to not print true and 0.0 and print the acual numbers. [CODE]public class Floating …

Hi, I am pretty new to HTML and brand new to PHP. I am trying to put together a simple internal website on a Linux box to keep track of some inventory. I would like to be able to click a link in the sidebar and have it display that …

I'm currently in HS and is going to be applying to an university in Fall 2011 (Graduate HS in 2012). I like math and computers, and hope to get into this field. I need to choose between CS and CE. I've been told by people (who definitely do not come …

Hey there. I'm 19 years old and I'm currently a student at a local community college. I came into college thinking I wanted to be an engineer, but after a few engineering-specific courses (Statics) I decided that engineering is not for me. Now I am looking into computer science and …

build an FA that accepts the language of words tha do not contain the substring ba

Everything I have tried doesn't seem to work so I thought I would stop in here to see the experts. Is it possible to write the following into a $whatever = ''; ? I had some people try and while they sort of got it to work they broke the …

My file below checks if the user is ! logged in, and redirects to login page, or does nothing if user is logged in. [CODE]<?php if(isset($_COOKIE['SID'])) { $sid= $_COOKIE['SID']; $uid = $_COOKIE['User']; $lastip = $_COOKIE['Cname']; $_POST['SID']=$sid; $check = mysql_query("SELECT * FROM users WHERE SID = '".$_POST['SID']."'")or die(mysql_error()); while($info = mysql_fetch_array( …

Hi there. I am early in learning PHP and have been reading your forum with great interest and also admiration for how great you all are helping out newbies and even looking over their code for them. And you're so logical and organized in your explanations. It's a beautiful thing …

I created a php page. this is my code. [CODE]$con=mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $sql = mysql_query("SELECT * FROM $tbl_name WHERE (Order = '" . $_POST['order'] . "')") or die(mysql_error());[/CODE] But its showing error like this You have an error in your SQL syntax; check the …

Hi People, I have this problem, i have created an upload form which includes some text fields and also an image upload which then gets sent to a server. I haven't yet got any validation or sanitisation on there at the moment. Im abit new to PHP and can code …

Hi, I am looking to create a Jobs Board Database which will work with PHP 5 and PayPal, but I am having trouble figuring out the relationships: I know I might have a table for Company details and another one for Job Details but what do I do with regard …

I am trying to build a Standings page for a hockey pool site that shows Wins, Losses, Ties, etc. I am struggling with the Tie section. If two teams have the same number of points (PF=PA) the team gets one point. I can get this part to work. However, at …

I have created a login system based in PHP and MySQL, where upon registration, users enter the information required in the form. However, there is another page where they can review their information once they have logged in. I am new to PHP but I would like to know the …

Hi all, I have three inputs required at a prompt in the index file below which requires the following data a number which will be the title code such as tt0892318 and a number that will be prefixed with tt and be interpreted as the title code such as 0892318 …

HI Guys, I am trying to make a Result Management Sytem for our department on PHP. This system will add results online as well show up results. I have downloded a PHP inventory system named PHP Inventory 1.2 I want to change it into a Result System like I want …

Hi all, I wish to present a user with a text field that can take any of these inputs: The URL such as [url]http://www.imdb.com/title/tt0892318/[/url] or a number which will be the title code such as tt0892318 and a number that will be prefixed with tt and be interpreted as the …

so, im working on an online shopping site. the problem is , i have already made an html site, but i have to run it on xampp localhost, what i do is, since i already made an html file, i just copy it to new php file and save it, …

Hey, guys. I'm building a really simple member register / login, based off some other code. I added it to the server and set up the DB properly, and now I'm having an issue. Whenever I go to register a new user, it says the user field is not filled …

How do i accept picture uploads unto a php webpage from a user?

Hi, I was wondering is there a way to password protect a directory. Here is my problem. My site require a login using php and mysql. This works, however I want to protect a certain directory that only lets a user who login previously to download files from it. I …

You could say I bit off more than I could chew... However, what's done is done and I'm pulling the rest of my hair out and looking to the DaniWeb community for help... I am building a site that people can log in to and select classes that are owned …