Posts by urtrivedi

get html code of the url, paste it here, then we can try some regex on it for price

where will come first, and order by later
SELECT * FROM questions WHERE (evaluationid=".$evaluationid.") ORDER BY id ASC LIMIT 1"

http://www.w3schools.com/php/php_mysql_select.asp

look at this, try your code and then tell your problem

if you want to display one by one in sequece like 1,2,3
then i will suggest you to find next

intitially pass 0 as id

$id=0;//this must be not part of fetch script, it may be passed in post or get

now search next maximum active id from pass id

$nextid="select max(id) from websites where active=1 and userid=$id";
$query="select * from websites where active=1 and userid=$nextid";

now run query and return result to your div, and also save nextid in some another div or hidden field

so next time page refreshed, pass that hidden field your fetch script as id

I hope i explained it well

all 2-4 questino you answered is not what i expected

answer 2
give me sample data
like
product_id product_name product_image product_ info
1, abc, abc.jpg,its is abc prodcut
2, pqr, pqr.jpg,its is pqr prodcut

answer 3,4 (first take hourly)
i m not asking where u diplay, i want to know HOW u want to display. write sample output here, that what u expect from above table data.

hourly, daily, weekly is time related things, and your table do not have any date time column

one method is

export mysql in csv format
using sql develolper import csv files to oracle tables

do u have mail server configured in ur network,
you need to set smtp mail server in php.ini file for sending mail

try to add following css styles to ur footer

bottom:0px;
z-index:50;
position:fixed;

You have written select * .....
NOW * MEANS it will select columns itself and php array is case sensitive, look into your mysql table and see case of all column, it am sure it is no Hw_tag.

just use rows['case sensivite spelling as same in mysql ']

OR

manauly write column name in select query like select Hw_tag..... like that

http://www.w3schools.com/php/php_file_upload.asp?output=print

1 what is table structure?
2 what are records?
3 how you want to display that records?
4 what do u mean by hourly, another daily, and other weekly (all in one query or u want in different pages?)

client upload one file, that file is having some name, that name (client file name to be uploaded) is stored in file['name']

http://www.w3schools.com/php/php_file_upload.asp?output=print

when u upload any file, from your computer say c:\abcfolder\myfile.doc
so myfile.doc will be saved in variable file['name']

when you submit file to upload, this file is copied to temp folder on server say /tmp/xyzzfile

this is stored in file['tmp_name']

u can move this file from temp folder to folder of your choice on ur server by using

move_uploaded_file(file[tmp_name],'/server/myuplodfolder/myfile.doc');

http://nivo.dev7studios.com/

you need to learn JSON

1) in showdat return data in json format
2) take xmlhttp.responseText in some object
3) evaluate json object and copy fields to html fields

http://www.w3schools.com/json/default.asp

inner join not need, just make ur where proper

UPDATE Table3.newone p, Table1 a, Table2 b
SET p.ID = a.ID
WHERE a.Title = b.Title

I assume you have only 3 columns as u said name, last and comments, so you can try following

if($tdcount==1)
    $width="30px";
else if ($tdcount==2)
    $width="50px";
else if ($tdcount==3)
    $width="100px";
else
    $width="50px";



echo "<td ".$tdclass."style='padding:.4em';width:'{$width}' >" . htmlspecialchars($cell) . "</td>"; 
            $tdcount++;

I hope this helps

if (s[1] != null ||  s[2] != null || s[3] != null)
{
    String sql="Delete from student where ";
    String andsql="";



    if(s[1] != null)
    {
        sql=sql+"stu_id='"+s[1]+"' ";
        andsql=" and ";
    }

    if(s[2] != null )
    {
        sql=sql+andsql+"stu_name='"+s[2]+"' ";
        andsql=" and "; 
    }



    if(s[3]!= null)
    {
        sql=sql+andsql+"Blood_group='"+s[3]+"'";

    }

    pst=conn.prepareStatement(sql);
    pst.execute();  
}

then dont use stud id, just use only condtion
blood_group='B+'

more condtion u add, less record will be deleted, if u add stud_id in condtion only 1 record will delete

delete must be done on primary key only, if you dont have primary key, then u must add one, i guess stud_id is good choice for pk,

then use only stud_id in where condtion to delte record

Pass this.value not this.form to showuser (line 35 in your code above in post 1)

<select name="users" onchange="showUser(this.value)" width="80" style="width:80px" class="autoconvert contain" datasrc="inventory.php">

where is code for testtwopart1.php, post it here

bitbit, I was looking at his tables and meanwhile you posted that query. and we both gave same soultion.

I assume that you are using mssql 2005 or above

select test1, test2 from 

(SELECT row_number() OVER (ORDER BY Db1.Col_1) AS RowNumber, Db1.Col_1 AS 'test1' FROM Db1, Db2 WHERE DB2.Col_2=DB1.Col_2 AND DB2.Col_1 < 5) a
full outer join 
(SELECT row_number() OVER (ORDER BY Db1.Col_1) AS RowNumber, Db1.Col_1 AS 'test2' FROM Db1, Db2 WHERE DB2.Col_2=DB1.Col_2 AND DB2.Col_1 > 5) b 

on a.rownumber=b.rownumber

DB2.Col_2=DB1.Col_1

you are joining letter to number, it will never return any result

select Db1.Col_1 AS 'test1'

here you selecting col_1 in query and in expected result you showing col_2 ouput, its totally confusing.

Modify your requirement, so tell us just in simple english what u want from db1 and db2

1) you can creat binary column in table and store image in binary format in table itself
2) you can create column with file name/path reference only and store actual file as os file in some folder

In my view Second approach is better.

Yes you need to install certificate on your server. The vendor will provide steps and support.

you need to subscirbe to service provided by vendor like verisign, they will issue certificate for your webserver, to make commnuction to your website as secure communication.

after price put comma before number (1,2.. etc)

Try to cover $_POST in {} as shown below

if(isset($_POST['submit'])){    
    $nypost = mysql_query("INSERT INTO arkentider (typ) VALUES('{$_POST[typ]}')")
    or die("Kunde inte lägga till ny räkning:<br />".mysql_error());
    }

change line number 13 with follwing line, comment your if condtion

if (in_array($loc_con1[$j], $loc_con))

<!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>Stocklist update</title>
<link href="../css/gallery_submit.css" rel="stylesheet" type="text/css" />
<link href="../css/template.css" rel="stylesheet" type="text/css" />
<body>
   <div class="span4">
      <p>Remove Livestock</p>
   </div>

<?php
      include 'connect.php';

      if ($_SERVER['REQUEST_METHOD'] == 'POST')
      {
         if (isset($_POST['next'])) 
         {
            $selected_radio = $_POST['delete'];
    ?>
       <form class='form' action='remove2.php' method='post' enctype='multipart/form-data' name='stockupdate_form' id='stockupdate_form' style='margin-bottom:0px;'>;
          <?php
         //   if ($selected_radio == 'boids') 
            {
                $data = mysql_query("SELECT * FROM $selected_radio  ORDER BY id DESC")
                       or die(mysql_error());

                       while($info = mysql_fetch_array( $data )) 
                       { 
                          echo "<span class='span2'>";
                          echo $info['species'];
                          echo ' : ';
                          echo $info['year'];
                          echo ' : ';
                          echo $info['sex'];
                          echo ' : ';
                          echo '£';
                          echo $info['price'];
                          echo "<input type='checkbox' name='check[{$info['id']}]' />";
                          echo '<br />';
                          echo "</span>";

                       }
            }

         }
      }
      ?>
   <input type='submit' name='remove' value='Remove' />
   </form>

</body>
</html>

Have a look at the link
http://www.tuxradar.com/practicalphp/10/1/0

It is ready made tool in php mysql, just , you need to download zip folder, unzip at ur server and then follow installation instructions.

This is photogallery managment link, you may like to see
http://coppermine-gallery.net/

you can write query without ` and purely in mysql rather than using part of php

$query = "SELECT * FROM  Humeur_log WHERE  prenom =  '".$prenom."' AND  nom =  '".$nom."' AND   current_timestamp >= date_add(datelog,interval 24 hour) ";

Method 1) I assume that you must be having job_master table, so you can join that table on job_id and display job description from job_master table (hope fully same as "Shipping" and "Marketting Man"

Method 2) If you dont have job master table you can use case when then clause

select full_name, 
case when substr(job_id,1,2) ='SH' THEN 'Shipping' 
     when substr(job_id,1,2) ='MK' THEN 'Marketting'
end job_description
from employees

It looks like class assignment so I will not write full query. You try on your own.

Also you need not to use group by or having clause, try to use simple where clause.

I think following library is simple to manage mails with attachment
After uploading file to your server, you can add it path to attachment in email.

here is the link
http://phpmailer.worxware.com/

executenonquery()

what have you tried so far?

post it here

this may run only once when u brink mouse pointer on the div and not multiple time as it was in case of mousemove

<div id="main-wallinfo" onmouseover="javascript:loadcomms()">

I guess you want search records based on some selected value in dropdown

conventional post/get method

1) you create html page as u did tried in ur first post with form elements
2) on submit form, all form elements posted to action page
http://www.w3schools.com/php/php_post.asp
3) set action page to say process.php
4) in process.php, you use posted form parameters to filter you sql result
5) display filter result
http://www.w3schools.com/php/php_mysql_where.asp

now a days jquery is used to fetch result from server and display in part of page without submiting whole page, but you learn above method first.

you can use jquery for it. Scroll bar doesnot look good option, rather you can set button or linke for next or previous kind of navigation

user mouseover() instead of mousemove()

onmousemove="javascript:loadcomms()

this is causing repeat execution, so remove this.
when u move mouse over div it will execute.
you want to call it once, then just at the end of page write this lines

<script lang='javascript'>
    loadcomms();
</script>

Problem is not clearly stated.

$result = mysql_query("SELECT courses.id AS cid, courses.title, courses.subjectsid, subjects.id AS sid, subjects.subjectname,  requestrecord.status
FROM courses JOIN subjects ON courses.subjectsid = subjects.id 
LEFT JOIN requestrecord 
ON courses.id = requestrecord.coursesid AND requestrecord.accountsid=".$_SESSION['id']." 

WHERE requestrecord.status!='accepted' ");


                                                                                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^      

I have replaced AND with WHERE in last line, if you put AND, it will become part of your left join condition, to filter record, you must give condition in WHERE clause.

You said "practicing a MLM Project". Personally I feel MLM is really complicated kind of data and calcuations, having lots of scope for error if db not designed properly.

I would like to know that have u pracitsed (insert, update, calculate) on normal database table structures, if not you start with simple things in php mysql, then you practise on complex databases.

And if you are trying to learn complex if conditions then you can do it by using switch statement like following

$leftleg="60";
$rightleg="30";

$landr=$leftleg.",".$rightleg;

switch ($landr)
{
    case  "1,1":
        echo "You are fresher & Your Commission is 500/-"
        break;


    case  "60,30":
    case  "30,60:
        echo "You are JUNIOR PLATINUM MEMBER & Your Commission is 4444/-"
        break;
.
.
.
.
.
}

Javascript selection bunch of fiels and creating zip in harddisk, then uploading to server, It looks securit issue. It will depend on users permissions in brwoser.

Don not tamper system for users. Educate them. Majority users are foolish, we can not drive as they say always.

Line 16 above add price in select list

"SELECT `id`,price FROM `edit`  WHERE `id`='$searchid'"

line 34 use $search_row

echo $searchid, ': The price is ', $search_row['price'], '<br />';