mjahkoh

This how its done. Pass the id concerning that guy only but u need to create functions as below. That all as below Under "$num=mysql_numrows($result);" put this function PersonalInfo($username){ /*SELECT CASE property.propertytype WHEN 1 THEN 'Apartment' WHEN 2 THEN 'House' ELSE 'House' END as type,property.propertytype,constituency.constituency, property.property_hd_id,property.constituency_hd_id,property.area_hd_id,property.noofrooms,property.electricity,property.goodroads,property.playground,property.privacy,property.security,property.internaltoilets,property.water,property.facilities,property.rent,property.terms,CASE property.leaser WHEN 1 THEN 'Broker' WHEN 2 THEN 'Family Member' WHEN 3 THEN 'Goverment Agencies' WHEN 4 THEN 'Lawyer' ELSE 'Owner' END as leaser,property.name,property.users_hd_id,property.parking , area.area,property.picture1url,property.picture2url,property.picture3url,login.username FROM property Inner Join constituency ON property.constituency_hd_id = constituency.constituency_hd_id Inner Join area ON property.area_hd_id = area.area_hd_id Inner Join login ON login.users_hd_id = property.users_hd_id WHERE property.property_hd_id = 112 and login.username = 'mjahkoh' */ $query="SELECT * from login where username ='". $username ."'"; //echo $query .'<br>'; $result = mysql_query($query); /* Error occurred, return given name by default */ if(!$result || (mysql_numrows($result) < 1)){ return NULL; } /* Return result array */ $dbarray = mysql_fetch_array($result); return $dbarray; } /*-------------------------------------------------------*/ in the body of the html use this to call the function and retrieve values $Info = PersonalInfo("username"); echo $Info ['name']; //name is a field in the database

It goes lke this 1) assume the form above is named help.php 2) that the results form is named helpresults.php 3) in help.php post to helpresults.php 4) in helpresults.php before anything <? //we first test wether anything was posted if (!count($_POST['radiobutton']) ) { header("Location: help.php"); //Relocate back to main page } //echo 'radiobutton'.count($_POST['radiobutton']).'<br>'; //print_r ($_POST); ?> 5) Somewhere in the body of results page <? if ($_POST['radiobutton']='Green') { //generate code using javascript to display images. Note that ../images is a directory echo "<img src=\""."../images/myimage.jpg\"></a></td>"; } elseif ($_POST['radiobutton']='Blue') { //generate code using javascript to display images } else { } ?> U now know why the Maasai kill lions

Use a combination of javascript and php

This works $time = time(); $password ="mypassword"; $userlevel ="1"; $email ="[email protected]"; $username ="myusername"; $query = "insert into login ( `password`,`userlevel`,`email`,`timestamp`,`username`,`active` ) values ( '".$password."', '".$userlevel."', '".$email."', '".$time."', '".$username."', '".'1'."' )"; echo '$query '.$query.'<br>'; return mysql_query($query, $link);

How do you expect top be assisted when u dont show the codes. R u using Jpmaster77 login framework?

Can do fluent coding in php,vb6, javascript using Oracle & Mysql databases

What i mean is to have a website that can be searched,indexed,have menusand a database etc just like the 'PHP Manual CHM Edition'

What do i need to make a website similar to the php manual but with a database to be distributed to the clients in a CD.

http://www.randomsnippets.com/2008/10/05/how-to-convert-mysql-timestamp-to-php-date-type/

Don waste time linking tables manually. use navicat

select * from mytable group by stock# thats it

Try This Assuming you have month,finyear,id in a table named calendar select month,finyear,id, CASE month when "01" then "January" when "02" then "February" when "11" then "November" when "12" then "December" END from calendar where year = "2005" order by month

this works. Just tested it select * from seasons_dt WHERE date_format(datefrom,'%e-%b-%Y') < now() or date_format(datefrom,'%e-%b-%Y') > now()

Try Tthis Assuming you have month,finyear,id in a table named calendar select month,finyear,id, CASE month when "01" then "January" when "02" then "February" when "11" then "November" when "12" then "December" END from calendar where year = "2005" order by month

try loop where u divide the loop value with 2. if the result has a remainder then that was an odd number then do x. if no remainder that was an even number then do y. or search for modulus in php

With Navicat or Mysql yog is a breeze

I am using Jpmaster77 login system and Upload File Class from Jeffrey M. Johns The error I am getting when updating the database after uploading is below. Somehow $session->username is not even available in upload.php where it uploads in the root Dir instead of the logged in usernames directory error Fatal error: Call to a member function updatePictureUrl() on a non-object in C:\xampp\htdocs\KukBuz\include\upload.php on line 618 //index.php include "include/session.php"; if (trim($_FILES['property1']['tmp_name']) ) { include "include/upload.php"; $upload_class = new Upload_Files; include "uploads/uploadinclude.php"; } //end of index.php //start uploadinclude.php //include "include/session.php"; $upload_class->StartUploadfiles(); //end uploadinclude.php //start procUploadValid function in upload function procUploadValid($fieldname,$fileNo){ //$upload_class->temp_file_name = trim($_FILES['mypassport']['tmp_name']); //$upload_class->file_name = trim(strtolower($_FILES['mypassport']['name'])); //$upload_class->upload_dir = "images/passports"; //$upload_class->upload_log_dir = "uploads/upload_logs/"; $this->max_file_size = 5242880; $this->banned_array = array(""); $this->ext_array = array(".jpg",".jpeg"); $this->Imagedim_array = array("200","200"); $this->upload_class->Imagedim_array = array("200","400"); $upload_files= $this->upload_file_with_validation(true,true,true,true); if ($upload_files!='true') { $result =$upload_files. "Your file could not be uploaded!"; } else { $extension = strtolower(strrchr($_FILES['mypassport']['name'],".")); $database->updatePictureUrl("mjahkoh","picture1url","fgfgfg"); $result =$result. "file uploaded."."\n"; } return true; } //end procUploadValid

I have a table with a varchar field. The field has integers and alphanumerics. Is there a way to select numbers only

Anybody with such a script Thanks

Anybody tell me where i can get a cool script to search the database Thanks

How in Javascript? Any links Thanks

Anybody show me how to upload with a progress bar Thanks

Someone show me how to encode or encrypt Get variables in links eg Name=myname to Name=huudn43543v43 and back

Done that. now wondering wether such a site needs clients to send their links to a central database or should i go nutch way (search html docs). The client needs an alibaba photocopy. Thanks

<?php if($a == 'sendmsg' && $_POST['type'] == 1){ $headers = "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/plain; charset=iso-8859-1\r\n"; $headers .= "To: ".trim($_POST['to'])."\r\n"; $headers .= "From: ".trim($_POST['from'])."\r\n"; $headers .= "Reply-To: ".trim($_POST['from'])."\r\n"; @mail(trim($_POST['to']), trim($_POST['subject']), $_POST['message'], $headers); echo("Mail sent to ".trim($_POST['to']) ); } ?>