welbyobeng

I have a fix code below [code=php] $values=array( "advertisement1" => 34, "advertisement2" => 45, "advertisement3" => 16, ); [/code] I want to take some information from my database and output the same way I have the code above but am getting an error. I am using [code=php]$sql = "SELECT advertisement.adver_name, …

I am trying to extract a 67gb tar and I get this error tar: This does not look like a tar archive tar: Skipping to next header tar: Archive contains obsolescent base-64 headers tar: Error exit delayed from previous errors

I have a script where it convert regular file such as mpg to flv. Now when I upload mpg it converts to flv fine. but when I upload avi it does not convert probably and the size of the file is 0. Here is the encoding part of the script. …

Hey how will I write a text file to setup a database with the information below Database set-up: Members Table: id - int primary key auto_increment. username - varchar 15. password - varchar 32. will be a md5 and sha1 hash of the password then the username. e-mail - varchar …

I have a table called "users", in the table it contain a column/ field name "reg_date" how would i run an query to say: For all the users, if their feild "reg_date" is blank put "20th December 2008"

I have a table called "users", in the table it contain a column/ field name "reg_date" how would i run an query to say: For all the users, if their feild "reg_date" is blank put "20th December 2008"

I have two file one called show.php and one is show.tpl. On show.php it has this code //----------------------------------------- // Fetch Media //----------------------------------------- $db->query("SELECT files.*, categories.*, users.id, users.username FROM categories, files LEFT JOIN users ON files.mid=users.id WHERE $search_addon files.category_id=categories.category_id AND files.type != 'plug' AND $v $ss ORDER BY files.featured DESC, files.$sort …

Hi i have a php script that retrieves all data from one database to be transferred to another database. The problem is that the database I am retrieving has 2,778 total rows and after i run my script the new database has 2,658 total rows. Whats going on? Here is …

Hi i am trouble adding NO CAPS and no spaces in the username on the code below I want the username to be character from 3 to 30 I want to restrict members from adding spaces or caps //----------------------------------------- // Check valid user name //----------------------------------------- if ( !$username OR strlen($username) …

Hi what sql query will I use to checks the "users_theme" table and finds all the user_id's which exist in this table and not the "users" table. Once I have those id's that exist in the user_theme table that does not exisit in the users table I want to delete …

Hi, I am trying to create a script which checks the "users_theme" table and finds all the user_id's which exist in this table and not the "users" table. Once I have those id's, I want to run a foreach loop to delete all rows with that user id from the …

I am using mysql and I have a table called "users". how will i get it to show only rows that have duplicate emails in the "email" field. I want the emails in order. what sql query will I use?

Hey I am a newbie in java and I was wondering if someone can help me. Where would I place [QUOTE]int [] qDifference = new int [3]; for(int i = 0; i < 3; i++) { qDifference[i] = q[i + 1] - q[i]; }[/QUOTE] in the code below to show …

I am trying to create a java password code where the password is at least 6 characters Long, at least 1 UPPERCASE, & at least 1 lowercase & at least 1 Digit.Here is an example: Passw3 Can someone help me because it is not working. Here is the code private …

How can I create a trigger to UPDATE this for me when a new record is inserted. I want to create a column called "fullthumb" where by default it has the words "http://example.com/thumbs/" and add the words in "thumb" column. In syntax: [code]UPDATE files SET fullthumb = CONCAT('http://example.com/thumbs/', thumb);[/code] I …

How to create a trigger to UPDATE this for me when a new record is inserted. I want to create a column called "fullthumb" where by default it has the words "http://example.com/thumbs/" and add the words in "thumb" column. UPDATE files SET fullthumb = CONCAT('http://example.com/thumbs/', thumb);

I have just finished a java code and I am having trouble with displaying each division increase or decrease from previous quarter and also a company increase or decrease from the previous quarter. Can someone help import javax.swing.JOptionPane; import javax.swing.JTextArea; import java.text.DecimalFormat; public class twoarray { /** * @param args …

On this code `$appendPath` was created for `myFieldName['filename']` How would I add `$appendimagePath` to this code for `myFieldName['visual']` ? $result = mysql_query($sql); //print $sql; if($result){ $line = mysql_fetch_assoc($result); $myFile = $line[$myFieldName['filename']]; if(file_exists($myFile)){ pushfile($myFile, $action); } else { echo ("&retval=error 1 : file doesn't exist"." ".$_REQUEST['theID']); } } else { echo …

Is it possible to make a column on my database that automatically copy another column on the same table string together with another url? for example on my database "ewelby_k5" I want to create a new column called (fullthumb) on table "files" where "fullthumb" stores "http://k5live.com/thumbs/ + column "thumb" " …

I attached the 2 script I have a script that retrieves a file from my database with an option of providing a path Now the appendPath Will "tack on" the contents of appendPath to the front of the file name. For example, :if appendPath is set to: $appendPath = 'http://www/path/to/'; …

Ok am new in java programming and I am trying to conduct a simple class called Area. If anyone know anything about java you can help me. I am writing a class that has three overloaded static methods for calculating the area of the following geometric shapes. circles rectangles cylinders …

My dream weaver is giving me an error reporting I have Expanding Box Problem! Dreamweaver says "Any content that does not fit in a fixed-width or -height box causes the box to expand to fit the content rather than letting the content overflow." I have tried everything but i see …

There is a script I am using....A Media Gallery...everytime I put in a javascript, it does not work. When I put [quote]<script type="text/javascript" src="[URL]http://www.example.com/js/swfobject.js[/URL]"> </script> <script language="javascript" src="[URL]http://www.example.com/js/player.js[/URL]"> </script> <script language="javascript"> var config = new Array(); config["width"] = 400; config["height"] = 300; config["clientId"] = "example"; config["bgColor"] = "#FFFFFF"; config["playList"] = …

I NEED HELP PLEASE PLEASE PLEASE THE PROBLEM IS [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/mounted-storage/home23a/sub003/sc21979-KVVZ/www/ghhookup/functions.php[/B] on line [B]28[/B] [PHP]<? $conn_id; $sql_res; $sql_res2; $sql_query; $HTTP_REFERER=$_SERVER["HTTP_REFERER"]; $REQUEST_METHOD=$_SERVER["REQUEST_METHOD"]; function sql_connect(){ global $conn_id,$sql_host,$sql_user,$sql_pass,$sql_db; $conn_id=mysql_connect($sql_host,$sql_user,$sql_pass); mysql_select_db($sql_db); } function sql_execute($sql_query,$wtr){ global $conn_id; $sql_res=mysql_query($sql_query,$conn_id); if($wtr=='get'){ if(mysql_num_rows($sql_res)){ return mysql_fetch_object($sql_res); } else …

I NEED HELP PLEASE PLEASE PLEASE THE PROBLEM IS [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/mounted-storage/home23a/sub003/sc21979-KVVZ/www/ghhookup/functions.php[/B] on line [B]28[/B] [PHP]<? $conn_id; $sql_res; $sql_res2; $sql_query; $HTTP_REFERER=$_SERVER["HTTP_REFERER"]; $REQUEST_METHOD=$_SERVER["REQUEST_METHOD"]; function sql_connect(){ global $conn_id,$sql_host,$sql_user,$sql_pass,$sql_db; $conn_id=mysql_connect($sql_host,$sql_user,$sql_pass); mysql_select_db($sql_db); } function sql_execute($sql_query,$wtr){ global $conn_id; $sql_res=mysql_query($sql_query,$conn_id); if($wtr=='get'){ if(mysql_num_rows($sql_res)){ return mysql_fetch_object($sql_res); } else …

Can anyone help..... When I search on my site this is the error I get [QUOTE] [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/mounted-storage/home23a/sub003/sc21979-KVVZ/www/ghhookup/functions.php[/B] on line [B]28[/B][/QUOTE] This is a peice of the code from function.php [QUOTE]if(mysql_num_rows($sql_res)){ return mysql_fetch_object($sql_res); } else { return ''; } …