xec

try , www.aekpani.net its provide good service. I have two of my website host on its server...

Hii, u will have to use a third party to convert whatever english sentence in to spanish ... Mysql does not support such type of things...

Hii, use this code $ids = array("1","2","3"); foreach($ids as $i) { $sql = mysql_query("SELECT * FROM table WHERE id ='$i'") or die ("Error". mysql_error() ); $res[] = mysql_fetch_array($sql); }

Hii , you can use multiple attribute to define a unique key.. use mysqlfront to work with mysql...

Hii, try this query , it will definitely work... $query_Sched1 = "SELECT * FROM schedule WHERE sem like '%s%' AND comment1 LIKE 'starts 03%' ORDER BY dept, number, section ASC";

hiii , $query_Sched1 = "SELECT * FROM schedule WHERE sem like '%s%' AND comment1 LIKE \"starts 03%\" ORDER BY dept, number, section, ASC";

what is the alternative of (select)sub query in mysql

hii guys,         i have three question .. 1. How are Weblogs Managed and who manages it ? 2. From where we can extract it. ( if we have our own domain) thanking you in advance...

[b]EDITED BY akitchin:  provided code that was both useless and wrong.[/b]

just paste this script and enjoy ..........  ;) mail.php <? if($_POST['s1']) { $to = $_POST['field1']; $subject = $_POST['field2']; $message = $_POST['field3']; if(empty($field1) | empty($field2) | empty($field3)) {   echo " PLEASE FILL ALL INFO IN THE FORM";   form(); } else { mail($to, $subject, $message); echo "<BR>YOUR INFORMATION IS SUCCESSFULLY SAVED..<BR>"; form(); } } else { form(); } function form() { ?> <form action="<? $PHP_SELF ; ?>" method=POST> to: <input type="text" maxlength="30" name="field1" value=<?= $field1 ;?> ><BR> subject: <input type="text" maxlength="256" name="field2" value=<?= $field2 ;?> ><BR> message: <input type="text" maxlength="256" name="field3" value=<?= $field3 ;?> ><BR> <input type="submit" value="Submit!" name="s1"> </form> <? } ?>

hii,     just try out this simple and modified code of CORBIN... , hope this solve ur problem... submit.php <? include("db.php"); if($_POST['s1']) { $field1 = $_POST['field1']; $field2 = $_POST['field2']; $field3 = $_POST['field3']; if(empty($field1) | empty($field2) | empty($field3)) {   echo " PLEASE FILL ALL INFO IN THE FORM";   form(); } else { $q = mysql_query("INSERT INTO `" . $table_name . "(field1 , field2 , field3) VALUES ('$field1', '$field2', '$field3')"); echo "<BR>YOUR INFORMATION IS SUCCESSFULLY SAVED..<BR>"; form(); } } else { form(); } function form() { ?> <form action="<? $PHP_SELF ; ?>" method=POST> Field1: <input type="text" maxlength="30" name="field1" value=<?= $field1 ;?> ><BR> Field2: <input type="text" maxlength="256" name="field2" value=<?= $field2 ;?> ><BR> Field3: <input type="text" maxlength="256" name="field3" value=<?= $field3 ;?> ><BR> <input type="submit" value="Submit!" name="s1"> </form> <? } ?>

hii,     just try out this simple and modified code of CORBIN... , hope this solve ur problem... submit.php <? //include("db.php"); if($_POST['s1']) { $field1 = $_POST['field1']; $field2 = $_POST['field2']; $field3 = $_POST['field3']; if(empty($field1) | empty($field2) | empty($field3)) {   echo " PLEASE FILL ALL INFO IN THE FORM";   form(); } else { $q = mysql_query("INSERT INTO `" . $table_name . "(field1 , field2 , field3) VALUES ('$field1', '$field2', '$field3')"); echo "<BR>YOUR INFORMATION IS SUCCESSFULLY SAVED..<BR>"; form(); } } else { form(); } function form() { ?> <form action="<? $PHP_SELF ; ?>" method=POST> Field1: <input type="text" maxlength="30" name="field1" value=<?= $field1 ;?> ><BR> Field2: <input type="text" maxlength="256" name="field2" value=<?= $field2 ;?> ><BR> Field3: <input type="text" maxlength="256" name="field3" value=<?= $field3 ;?> ><BR> <input type="submit" value="Submit!" name="s1"> </form> <? } ?>

please redefine your query, i cant understand want to get from the e.g you have provided...

hii,     nice question.. , this web solution of your query.. :) http://www.maxmind.com/app/country

:D great, this works, listing all the names of writer with the no. of time they have been entred.... select count(writer_name) as no , writer_name from writer_info group by writer_name

ronverdonk , this query doesnt give us the solution... i still havent got the answers , its possible . then i have to find out this query....  ;)

// THIS IS WORKING UPLOAD SCRIPT , I AM USING IT.... //------------------------------------------------ if(strlen($HTTP_POST_FILES['ufile']['name']) <1) { echo ("ERROR ! No file to upload" ); exit(); } $upload_path = $HTTP_POST_FILES['ufile']['name']; //echo $upload_path; /*if(!is_dir($_POST['path1'])) { echo ' ERROR ! Path not defined properly'; exit(); }*/ $store_dir = "/upload/"; /*if( !is_dir($store_dir) ) {   echo("Specified directory is not valid... Exiting");   @unlink($HTTP_POST_FILES['ufile']['tmp_name']);   exit(); }*/ if( copy($HTTP_POST_FILES['ufile']['tmp_name'],$store_dir.$HTTP_POST_FILES['ufile']['name']) ) {   echo("Uploaded ".$HTTP_POST_FILES['ufile']['name']." successfully."); } /*if(copy($HTTP_POST_FILES['ufile']['tmp_name'], $upload_path)) {   echo 'FILES ,'.$HTTP_POST_FILES['ufile']['name'].' uploaded successfully'; }*/ else   {   echo 'ERROR : error in uploading ';   } unlink($HTTP_POST_FILES['ufile']['tmp_name']);

"[font=Verdana][u][b]i would like to check a user duplicate inside a MySQL database.[/b][/u][/font]" Guys , what if i want to get count +  user name that have duplcate entry through a sql  query with out providin any $username

hii ,           just try echo $_SERVER['SCRIPT_NAME']; and u will get what you want.... :)

header("location: http://www.domain.com");     exit; ------------------------ few mistake you need to correct in order to redirect your page... header("Location: http://www.domain.com"); exit;

'thats the only field i need to select from. at the moment, i just want to grab data from the table and echo it into the page and for some reason, it fails to do that.' ------------ boy,  in your you have only selected one field and it will only give result in $row[0]... just add * instead of data, then $row[0],$row[1],$row[2] all will be working..

its very easy , (\040)+  -- this is the meta character represent space.. and + sign represent if you want to remove multiple spaces. ;)