39,316 Topics
 | |
| | I am making a mysql fulltext search. my database table article1 has ~18000 articles, article2 has ~7000 articles, article3 has ~13000 articles. FIELD cat is a INDEX field Now I want to make a union search. there are 5 groups words put into 3 table, match out the results. But … |
| | I keep getting this error when I try to run and print out the results of my database query. I know that this error usually mean that my query failed but i can't figure out what is wrong with it. [CODE=PHP] $genre=readline("Enter Genre: "); $query = "SELECT movie_title FROM movie …  |
| | [code=php] $conn=odbc_connect('mobshopDB','',''); if(!$conn){ exit("Connection Failed: " . $conn); } $query="INSERT INTO users(uid,pass,fname,lname,pmm) VALUES('$username','$password','$fname','$lname',$pmm)"; $rs=odbc_exec($conn,$query); [/code] this query gives me this error Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression., SQL state 22005 in SQLExecDirect in C:\Program Files\EasyPHP-5.3.6.0\www\mobshop\registered.php on line 39 ..please suggest a … |
| | hope you guys can help with this, i`m getting this error within my error log: PHP Warning: implode() [<a href='function.implode'>function.implode</a>]: Invalid arguments passed in /home/myname/public_html/mysite.com/formmail.php on line 17 here is line 17: $temp = implode(",<br />", $_POST['licences']); I`m trying to pass a multiple selectbox to the email body, heres the … |
| | hi to all, I'm new in mysql and I have a problem regarding deleting rows. I have 38 tables in database and I want to delete rows in all tables with specific ID that is executed in just 1 click. For example, I executed ID number 1 then it will … |
 | hi, although, database is connected and admin table of my database consist of 2 rows of data, I still get 0 value for $numRow=mysql_num_rows($result); And mysql_fetch_array doesnt fetch values properly plz can any body help me thx in advance [code]<?php //include_once 'config.php'; /* 1. Got the username and password from … |
| | the below code is to updata a database with calculated taxes and days late. It results in the message:[QUOTE]error: Maximum execution time of 60 seconds exceeded in C:\xampp\htdocs\invoice[/QUOTE]. Can someone help with this? [CODE]<?php $stat = mysql_connect("localhost","root",""); $stat = mysql_select_db("oodb"); $query = "SELECT invnum FROM oocust WHERE payrec = 'R' … |
| | Can anyone explain what the $PHP_SELF global variable does in the following script? <html> <body> <?php $db = mysql_connect("localhost", "root"); mysql_select_db("mydb",$db); $result = mysql_query("SELECT * FROM employees",$db); if ($myrow = mysql_fetch_array($result)) { do { printf("<a href=\"%s?id=%s\">%s %s</a><br>\n", $PHP_SELF, $myrow["id"], $myrow["first"], $myrow["last"]); } while ($myrow = mysql_fetch_array($result)); } else { echo … |
| | I have some image, in my page, code: [CODE]<img src="/path/to/the/upload/folder/<?php echo $filename; ?>"/>[/CODE] Can you help me display it as link, ex: [CODE]<img src="http://imagelink.jpg"/>[/CODE] if you have free time, teach me how to display multi image with code above. Thank you so much  |
 | Hi every1, I have a recursive function for building dynamic menu, and it gives me this error: "Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 261900 bytes)" Any ideas? |
| | hi i want to check off a checkbox while i'm typing. for an example if i'm typing "oranges are good" and i have oranges, apples, and blueberry under my check box. i want oranges to be checked of as soon as i type oranges in my phrase "oranges are good". … |
| | Hi, I'm a bit new to SQL and this is my question... Do I need to filter user input that has no connection with SQL database, e.g. $x=$_GET['pageno']; if ($x == 'help4') { print "This is help page no4."; <some mysql queries goes here> } |
| | In mysql, the table consist of informationtype, status and informationno , [CODE] $information = mysql_query("SELECT * FROM table WHERE informationtype='message' AND status='waiting'"); $row = mysql_fetch_assoc($information); $result=($row['informationno']); [/CODE] The query result are 4 rows. The informationno are 11001; 11002; 11007; 11009; If I intend to express the results in term of … |
| | This script adds a backslash to content added to description when saved. single quote becomes ' while double quote becomes \" I want to remove the backslash. i have tried stripslashes but still couldn't get it to work. <?php defined('_JEXEC') or die('Restricted access'); $newjob = $this->newjob; $editor = & JFactory … |
 | Hi, I don't get why my funcion finds the string even if it doesn't exist in textfile: [CODE] function name_exists($name) { $f = fopen($this->path, "r"); //echo $this->path; while ( $line = fgets($f) ) { if(strcmp($line,$name == 0)) { echo 'exists'; fclose($f); return TRUE; //we found it and can stop the … |
| | I would like to have a picture covered up with another image then I would set a countdown and the top image would be slowly disappearing, pixel by pixel till the bottom image is fully visible, any ideas? I did try a few scripts related to: imagesetpixel imagelayereffect imagealphablending but … |
| | [CODE]<html> <head> <h1>Welcome</h1> <h2>back</h2> <form action='get.php' method='GET'> Name: <input type='text' name='fname' /><br> Age: <input type='text' name='age' /> <input type='submit' value ='clik here' /> </form> </head> </html> <?php $fname = $_GET['fname']; $age = $_GET['age']; if ($fname && $age) echo "your name is. $fname , and your age $age <br>"; echo date … |
| | Hi there. I have a problem: I want send every image to every div and display. My code: all.php [CODE]<? $files = glob("output/*.*"); for ($i=1; $i<count($files); $i++) { $num = $files[$i]; print $num."<br>"; echo '<img src="'.$num.'" alt="random image" />'."<br><br>"; } ?>[/CODE] index.php [CODE]<img src="all.php" alt="image">[/CODE] So, I don't know how … |
| | hi i am a new user of webdevelopment. i work with php mysql and load site about 8 months ago i face a problem that google not search my sites. how i overcome from this problem. as i search on google how to do its but not working. please sugeest … |
| | Hi! I have a page and it's on 000webhost.com. But they don't allowed to add upload script. So, I thought, is it possible to make a php script that will upload file to one other server (this other server doesn't have installed php). Is this possible? If so, how? Thanks … |
| | |
| | hi I want to set an authentication in two different computers if the master is logedin then the slave authentication can login else the slave authentication on the other computer in a network can not enter to the authentication page. [B]I can not use database to store the authentication as … |
| | hi i would like to do like this +2007 +2008 -2009 +BCA-I +BCA-II -BCA-III Advance Web PRogramming.pdf JAVA.pdf OB.pdf +PGDCA +M.Sc. +2010 like this code i want as when user click on + then open like 2009 example and open classes like BCA etc. and after click on bca than … |
| | 1.<?php 2.session_start(); 3.$con = mysql_connect("localhost","root","") or die(mysql_error()); 4.$db = mysql_select_db("registration", $con)or die(mysql_error()); 5.function mss($value){ 6. return mysql_real_escape_string(trim(strip_tags($value))); 7.} 8.function s($value){ 9. return stripslashes($value); 10.} 11.function topic($input){ 12. return nl2br(strip_tags(stripslashes(htmlentities(htmlspecialchars($input))))); 13.} 14.if($_SESSION['uid']){ 15.if(mysql_query("UPDATE signup SET gender='".$_POST['gender']."',status='".$_POST['status']."',date='".$date."',option='".$_POST['option']."',religion='".$_POST['religion']."',description='".$_POST['description']."',political='".$_POST['political']."',location='".$_POST['location']."',home='".$_POST['home']."',other='".$_POST['other']."' WHERE id='."$_SESSION['uid']."'")){ 16.echo"<p>updated successfull</p>"; 17.} 18.} 19.else { 20. if (!$_SESSION["uid"]){ 21. header("Location:unregistered.php"); 22. exit(); … |
 | This contact.php will process the data and send it to my email. I want to achieve this effect, when user submit the form correctly, it will display a alert, and then redirect the page to : thankyou.html. When there is some error, it will display another alert, and then redirect … |
 | Hey guys, I am wanting to find to see if a variable is in the array: Here is my code: [CODE] $domainlist = array(".com.au",".com",".co.nz",".net.au",".net",".net.nz",".org.au",".org",".org.nz"); $serverlist = array( ".co.nz=whois.srs.net.nz|220 Available", ".com=whois.crsnic.net|No match for", ".net=whois.crsnic.net|No match for", ".org=whois.publicinterestregistry.net|NOT FOUND", ".com.au=whois.aunic.net|No Data Found", ".net.au=whois.aunic.net|No Data Found", ".org.au=whois.aunic.net|No Data Found", ); foreach ($serverlist as … |
| | Hi there This is my problem: - Upload image (not important) - Store its in [filename].php - Show [filename].php like image.jpg in show.php (gallery) Can you solve? Thank you so much |
| | i have a hyperlink that when i click then will show me an output of listed names. i want to have this list arranged from A to Z in . thanks. um using PHP. |
| | i've been attempting to execute this code , all i got was an error. [CODE]<?php $connect = mysql_connect("localhost","root","") or die ("connection failed!"); mysql_select_db("users") or die (mysql_error()); echo "connected!" $extract = mysql_query("select * from member order by id ASC") or die mysql_error(); ?>[/CODE] and this error appeared : [ICODE]Parse error: syntax … |
| | can somebody check my code...i really don't know what's the problem is... <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title></title> <style type="text/css"> <!-- body { margin-top: 50mm; } --> </style> <script src="gen_validatorv4.js" type="text/javascript"></script> <script type="text/javascript"> function upperCase() { var x=document.getElementById("specification").value; document.getElementById("specification").value=x.toUpperCase(); … |
The End.