Member Avatar for ishlux
ishlux -3 Junior Poster
Error:data source name not found

Hi all,

I have an jsp code for registration page... i have used ms access for storing the data.......but after running, ,,,, its giving an error....
data source name not found,,,no default driver is found........how to overcome with this problem.........pls do reply........


Thanks in advance
ishlux

Web Development java-jsp
Member Avatar for ishlux
ishlux -3 Junior Poster
Re: class not found exception

Hi,

As you said, i got it but i am not able to find where is the jar file in mysql download...please tell me how to proceed with this error.

Thanks,
ishlux

Web Development java-jsp
Member Avatar for ishlux
ishlux -3 Junior Poster
class not found exception

Hi all,

I have connected the mysql database......but if i run my jsp code,
it is giving an error..........whats the main reason for this.

I have gone through some cases based on database connection, in that they said we have to copy mysqlconnector.jar file in lib folder of jdk.... but i dint find jar file in mysql.......please give the suggestion how to proceed with this problem.


Thanks,
ishlux

Web Development java-jsp
Member Avatar for ishlux
ishlux -3 Junior Poster
Problem:mysql

Hi all,

I have downloaded mysql, please tell me how to create database,
and tables in mysql, .. just forward me the queries for how to create table, database,

and how to make database connection in my jsp code...........reply me soon pls..........
give me example code,,,, i wil try to fallow it ...........


Thanks
Ishlux

Web Development java-jsp mysql
Member Avatar for ishlux
ishlux -3 Junior Poster
mysql:Help me out

Hi all,

I am New to jsp, i want to create database,, i have ms access, but it does not store more data, so i want to mysql database , give me the link , which version wil be better for my jsp application ......reply soon pls...and tel how to make settings after downloading... i mean setting classpath everything


thanks
ishlux

Web Development java-jsp mysql
Member Avatar for ishlux
ishlux -3 Junior Poster
Re: java.lang.ClassNotFoundException: sun:jdbc:odbc:JdbcOdbcDriver

Hi all,
I have that jsp syntax in my code.... but some one said to load the driver , means what should i do........and to set class path for jar file..............i dint understand how to proceed, please tel me..
i am still getting this error.

Thanks
ishlux

Web Development java java-jsp
Member Avatar for ishlux
ishlux -3 Junior Poster
java.lang.ClassNotFoundException: sun:jdbc:odbc:JdbcOdbcDriver

Hi all,

I am getting this error:java.lang.ClassNotFoundException: sun:jdbc:odbc:JdbcOdbcDriver .

when i run my jsp code

<html>
<head><title>registration page</title></head>
<body>
<%@ page import="javax.sql.*,java.sql.*,javax.servlet.*,javax.servlet.http.*"%>
<%! String firstname1;String lastname1;String email1;String address1; String state1; String password1; int phno1;String cpassword1;%>
<% String firstname1 = request.getParameter("fname"); %>
<% String lastname1 = request.getParameter("lname"); %>
<% String email1 = request.getParameter("email"); %>
<% String phno1 = request.getParameter("phno"); %>
<% String address1 = request.getParameter("address"); %>
<% String state1 = request.getParameter("state"); %>
<% String password1 = request.getParameter("password"); %>
<% String cpassword1 = request.getParameter("cpassword"); %>

<%
   try
   {
	   Class.forName("sun:jdbc:odbc:JdbcOdbcDriver");
	   Connection con=DriverManager.getConnection("jdbc:odbc:Ldsn","","");
	   PreparedStatement ps;
	   	 Statement stmt = con.createStatement(); // to create a statement
		 ResultSet rs = stmt.executeQuery("select * from registration_tabl " ); // to execute a query 
                                        
	   String stm = "insert into registration_table values(?,?,?,?,?,?,?,?)";
	   ps = con.prepareStatement(stm);
	   ps.setString(1,"firstname1");
	   ps.setString(2,"lastname1");
	   ps.setString(3,"email1");
	   ps.setString(4,"phno1");
	   ps.setString(5,"address1");
	   ps.setString(6,"state1");
	   ps.setString(7,"password1");
	   ps.setString(8,"cpassword1");
	   int x=ps.executeUpdate();

	  		rs.close();
			con.close();
			stmt.close();

		}	
	
	
	catch(Exception e)
	{
	       out.println(e);
	}
     
	%>

  		<h1 align="center" style="color:blue">successfully  registered</h1>
                		<br><a href="index.html"><h3 align="center" >click here to login</h3></a><br>
                			
 
</body>
</html>

i am using ms access as my database ....so how to debug this error...i dint set any classpath for this.


thanks

Web Development java java-jsp
Member Avatar for ishlux
ishlux -3 Junior Poster
Xamp installation

Hi all,

i am trying to install xamp on my pc which is Xp. but its showing setupXamp.bat is not found how to proceed ,

thanks
ishlux

Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
ERROR:Tomcat5.5

Hi all,

Tomcat5.5 is not working, http://localhost:8080....if i write this its giving resource not found 5.5.28......i have made all the set as mentioned in this link
http://www.coreservlets.com/Apache-Tomcat-Tutorial/tomcat-5.5.html#Start-Server
but still i am not finding any difference.........pls help me out


thanks
ishlux

Web Development java-jsp
Member Avatar for ishlux
ishlux -3 Junior Poster
Re: where to write JSP file in tomcat5.5 folder

Hi,

I have created the folder structure.... but tell me out to write the classpath, i dont know...

one more doubt i have my servlet program given below.

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class valid extends HttpS ervlet
{
   public void doGet(HttpServletRequest req, HttpServletResponse res)throws IOException,ServletException
	{
	   res.setContentType("text/html");
	   PrintWriter out = res.getWriter();
	   String name = req.getParameter("name");
	   String password = req.getParameter("password");
	   out.println("<html>");
	   out.println("<head>");
	   out.println("<title> login page </title>");
	   out.println("<body>");
	   out.println("Name "+ name);
	   out.println("<br>");
	   out.println("your password is " + password );
	   out.println("</body>");
	   out.println("</html>");
	   out.close();
	} //end of service

} //end of class

and my index.html file given below

<html>
<head><title>Login Page</title></head>
<body>
<form method=get action="/Library/login">
<table>
 <tr>
  <td>Name: </td>
  <td><input type="text" Name="name"></td>
</tr>
 <tr>
 <td>Password:</td>
 <td><input type="password" Name="password"></td>
 </tr>
 <tr>
 <td><input type ="submit" value="submit"></td>
 <td>&nbsp;</td>
 </tr>
 </table>
 </body>
 </html>

and my web.xml code
<web-app>
<servlet>
<servlet-name>Library</servlet-name>
<servlet-class>valid</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Library</servlet-name>
<url-pattern>/Library/login</url-pattern>
</servlet-mapping>
</web-app >

how to write xml mapping,,,,,,,,i am getting an error,, Library/login not found and i am able to open index.html file , when i write http://localhost:8080 and after that i wil get above mentioned error......my folder structure is.......in webapps, i have created Library and in library, html file folder, WEB-INF and lib folders and index.html is their and in WEB-INF , src , classes and web.xml folders are their is this write and exactly where should be my jsp folder.................please reply .............its URGENT

Web Development java-jsp
Member Avatar for ishlux
ishlux -3 Junior Poster
where to write JSP file in tomcat5.5 folder

Hi all,

I want to run jsp programs, where should i place the folder in tomcat5.5 and how to run it.
please help me out.

Thanks

Web Development java-jsp
Member Avatar for ishlux
ishlux -3 Junior Poster
xml mapping in tomcat 5.5

Hi all,
how to do xml mapping in tomcat5.5
i have an xml code here just tell me what should be thier in blank space

<web-app>
<servlet>
<servlet-name>firstservlet</servlet-name>
<servlet-class>........</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>firstservlet</servlet-name>
<url-pattern>.............</url-pattern>
</servlet-mapping>
</web-app >

thanks

Web Development java-jsp xml
Member Avatar for ishlux
ishlux -3 Junior Poster
Xml validation disabled

Hi all,

I have deployed my folder in tomcat5.5, while running its giving error
xml validation disabled.

so please help me how to run my program..

regards
ishlux

Web Development java-jsp xml
Member Avatar for ishlux
ishlux -3 Junior Poster
ERRor:Requested Source not available

Hi,

I have deployed my folder called Library in web apps tomcat5.5, i can find my folder in the tomcat manager, but when i click its showing this error: requested source in not available (Library)
As i am new to this i dont know how to proceed please help me out.


i given my code below.
in folder library
i have created 2 more folder WEB-INF and html file
In WEB-INF- src,classes,web.xml

so in html file the fallowing code is written
<html>
<head><title>Login Page</title></head>
<body>
<form method=get action="/servlets/login">
<table>
 <tr>
  <td>Name: </td>
  <td><input type="text" Name="name"></td>
</tr>
 <tr>
 <td>Password:</td>
 <td><input type="password" Name="password"></td>
 </tr>
 <tr>
 <td><input type ="submit" value="submit"></td>
 <td>&nbsp;</td>
 </tr>
 </table>
 </body>
 </html>

in src file the following code is written

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class valid extends httpservlet
{
   public void doGet(HttpServletRequest res, HttpservletResponse res)throws IOException, ServletException
	{
	   res.setcontent type("text/html");
	   PrintWriter out = res.getWriter();
	   String name = req.getParameter("name");
	   String password = req.getParameter("password");
	   out.println("<html>");
	   out.println("<head>");
	   out.println("<title> login page </title>");
	   out.println("<body>");
	   out.println("Name "+ name);
	   out.println("<br>");
	   out.println("your password is " + password );
	   out.println("</body>");
	   out.println("</html>");
	   out.close();
	} //end of service

} //end of class

in web.xml the fallowing code is written

<web-app>
<servlet>
<servlet-name>firstservlet</servlet-name>
<servlet-class>valid</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>firstservlet</servlet-name>
<url-pattern>/login</url-pattern>
</servlet-mapping>
</web-app>
Web Development java-jsp
Member Avatar for ishlux
ishlux -3 Junior Poster
how to run my files in web browser

Hi all,

I have installed tomcat 5.5 , now i want to run a simple servlet programme, on web browser, how do i deploy my folder into tomcat 5.5.....i am giving http://localhost:8080. its giving page cannot be displayed.........

please help me out.

Web Development java-jsp
Member Avatar for ishlux
ishlux -3 Junior Poster
Re: setting classpath

Thanks a lot i got it...........


With Regards,
ishlux

Software Development java
Member Avatar for ishlux
ishlux -3 Junior Poster
Tomcat5.0

Hi all, give me the link to download tomcat5.0


Thanks
Lakshmi

Web Development java-jsp
Member Avatar for ishlux
ishlux -3 Junior Poster
setting classpath

Hi all,
i have installed jdk1.7 , now i want to set the class path.. because i am compiling my program its giving an error.....javac is not recognized as an internal or external commond.
please help me to set the class path.......and how to able to run my program.

Software Development java
Member Avatar for ishlux
ishlux -3 Junior Poster
java installation

Hi all,

I am new to java i want to download, jdk1.5 as my guide specified ,,
but i dont know the link......so please help me out........and tell me out to install it on my pc.


Thanks,
ishlux

Software Development java
Member Avatar for ishlux
ishlux -3 Junior Poster
Re: Installation of php,mysql,apache

Hi ,,

yes what u said was right..... i am running it in windows vista.......so how should i proceed

Thanks
ishlux

Web Development apache mysql php
Member Avatar for ishlux
ishlux -3 Junior Poster
Re: Installation of php,mysql,apache

Hi cwarn23,


I dowloaded xamp, but still i am getting an error.. while installing
the error is......
windows cannot find setup_xamp.bat file, please type the name correctly and then try again

Web Development apache mysql php
Member Avatar for ishlux
ishlux -3 Junior Poster
Installation of php,mysql,apache

Hi all,
i am new to php, i dont know how to run the php files, i am going through some tutorials, but not able to install it on my pc.
i have dowloaded . . but dont know how to proceed further
so please help me out ......

regards,
ishlux

Web Development apache mysql php
Member Avatar for ishlux
ishlux -3 Junior Poster
Re: flash player

Hi all,

In flash player the images keeps on changing , i want to do that .......pls help me out

Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Re: flash player

Hi all,
i have this code for flash player but how to proceed with this code........i dont have any idea regarding this code..........do we need to download flash player or what.........please suggest
me how to proceed..........

<tr>
    <!--<td width="25" background="http://www.rajtravels.com/commonimages/lft_bak.JPG">&nbsp;</td>-->
    <td><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=4,0,2,0" width="140" height="100">
        <param name=movie value="http://www.rajtravels.com/raj.swf">
        <param name=quality value=high>
        <embed src="http://www.rajtravels.com/raj.swf" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="140" height="100">
        </embed> 
      </object>  <script language="JScript" type="text/jscript" src="http://www.rajtravels.com/NoIEActivate.js"></script></td>
  </tr>
Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
flash player

Hi everyone,

Does anybody know, how to do the flash player...............

Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Re: Storing checkbox values.............

I used the implode function, but still its not working........................

Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
whats wrong in this code?

Hi all, i am getting this error whats wrong in the following code
Warning: Invalid argument supplied for foreach() in D:\xampp\htdocs\demonew\contractor_testing_checkbox.php on line 24

<?php
session_start();
include('database.php');
$result = mysql_query("SELECT * FROM  autoalto_contractor" );
	
while($row = mysql_fetch_array($result))
 {
	extract($row); 
	$radio = unserialize($service_category); 
foreach($radio as $key )
	{ 
 echo $key." ";  
}
Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Re: Storing checkbox values.............

Hi all,
i used unserialize method but its displaying like this

<td><?echo unserialize($row['service_category']);?></td>

o/p is
emailId zipcode service_category service_type services

ishu@gmail.com 3333 Array N; N;

Instead displaying value its displaying Array so what to do now..........pls help me

Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Re: Storing checkbox values.............

ok where to write unserialize and how to write unserialize method......

Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Storing checkbox values.............

Hi all,
I am storing check box values with comma separated into db like this , the code given below

<?php 	
	include 'database.php';

$servicec = addslashes(serialize($a1)); 
$servicet = addslashes(serialize($b1)); 
$services = addslashes(serialize($c1)); 
		 


$query1 = "insert into autoalto_contractor( 	service_category,service_type,services) values ('".$servicec."',
'".$servicet."','".$services."')";

but while retrieving from the db i am not able to display it properly the code is given below

<?php
session_start();
include('database.php');
$result = mysql_query("SELECT * FROM  autoalto_contractor" );
	
while($row = mysql_fetch_array($result))
 {
	?>
	<tr>
		<td width="5%"></td>
				
		<td><?echo $row['service_category'];?></td>
		<td><?echo $row['service_type'];?></td>
		<td><?echo $row['services'];?></td>

	</tr>
	<tr>
		<td width="5%"></td>			
		<td colspan="4" style="background-repeat: repeat-x;" background="images/dot.jpg" height="0" width="300"></td>
	</tr>
	<?		
}
mysql_close();
?>

its giving the o/p like this

a:3:{i:0;s:18:"vehicle Inspection";i:1;s:14:"batteryservice";i:2;s:10:"oil canhge}
i want only vehicle inspection , battery service like this...........can anybody help me pls...........i am trying this from long time.

Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Re: Submit

what does it mean

action="<? $_SERVER ?>

<form id="form2" name="cusregistration" method="post" 
								   action="<? $_SERVER['PHP_SELF'] ?>" onSubmit="return validatecr(this);">
Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Submit

Hi all,
I have two buttons, submit and back......after clicking the submit it will go to the action part,
but i have another button back , if i click on the submit it has to go to previous page so how to do. as i think we can only one action for button, here i have two what to do how to proceed.
help me out..............

Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Problem in displaying deleted items from inbox and sent items

Hi all, this is for trash, i am facing some problem, here if the user deletes inbox items or sent items it should come and sit in trash. here i am able select the flag='1' i mean deleted items but i want display them. which ever is deleted either from trash or sent it should come n sit in trash.how to do it. pls help , just go through the code u can understand my problem.

<table 	style="border:1px solid #EDEDED;background-color:#f6f6f6" 
  border="0" width="100%">
		<tr	>

			<!--<td width="5%"></td>-->
			<td background="images/auto_alto_car_repair_login_silver_boxR1C1.jpg" width="20%" ><b><font size="3"><span style="color:005D95">From</span></b></td>
			<td background="images/auto_alto_car_repair_login_silver_boxR1C1.jpg" width="20%" ><b><font size="3"><span style="color:005D95">To</span></b></td>
			<td background="images/auto_alto_car_repair_login_silver_boxR1C1.jpg" width="40%"><b><font size="3"><span style="color:005D95">Subject</span></b></td>
			<td background="images/auto_alto_car_repair_login_silver_boxR1C1.jpg" width="20%"><b><font size="3"><span style="color:005D95">Date</span></b></td>
		</tr>


<?
session_start();
include('database.php');
$page_name="contractor_trash.php";
//$limit=sql_quote($_GET['limit']); // Read the limit value from query string.
$limit=$_GET['limit'];
//$start=sql_quote($_GET['start']); // To take care global variable if OFF
$start=$_GET['start'];
if(!($start > 0))
{ // This variable is set to zero for the first page
$start = 0;
}

$eu = ($start - 0); 
if(!$limit > 0 )
{ // if limit value is not available then let us use a default value
$limit = 4; // No of records to be shown per page by default.
} 
$this1 = $eu + $limit; 
$back = $eu - $limit; 
$next = $eu + $limit; 
//**************************************************************************/
$result = mysql_query("SELECT * FROM autoalto_mail as a1, autoalto_contractor_sentitems as a2 where a1.flag='1' AND a2.flag='1'  limit $eu, $limit" ); 

//code for paging
//************************************************************************** 
//SELECT * FROM autoalto_mail as a1, autoalto_contractor_sentitems as a2 where a1.flag='1'=a2.flag 
$selcount = "SELECT * FROM autoalto_mail as a1, autoalto_contractor_sentitems …
Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Problem with next link:help

Hi this is the code for showing the inbox........

<table 	style="border:1px solid #EDEDED;background-color:#f6f6f6" 
  border="0" width="100%">
		<tr	>

			<!--<td width="5%"></td> -->
			<td background="images/auto_alto_car_repair_login_silver_boxR1C1.jpg" width="20%" ><b><font size="3"><span style="color:005D95">From</span></b></td>
			<!--<td class="tcat" ><b><font size="3"><span style="color:005D95">Subject</span></b></td>-->
			<td background="images/auto_alto_car_repair_login_silver_boxR1C1.jpg" width="40%" ><b><font size="3"><span style="color:005D95">Subject</span></b></td> 
			<td background="images/auto_alto_car_repair_login_silver_boxR1C1.jpg" width="20%"><b><font size="3"><span style="color:005D95">Date</span></b></td>
		</tr>


<?
session_start();
include('database.php');
$page_name="contractor_inbox.php";
//$limit=sql_quote($_GET['limit']); // Read the limit value from query string.
$limit=$_GET['limit'];
//$start=sql_quote($_GET['start']); // To take care global variable if OFF
$start=$_GET['start'];
if(!($start > 0))
{ // This variable is set to zero for the first page
$start = 0;
}

$eu = ($start - 0); 
if(!$limit > 0 )
{ // if limit value is not available then let us use a default value
$limit = 4; // No of records to be shown per page by default.
} 
$this1 = $eu + $limit; 
$back = $eu - $limit; 
$next = $eu + $limit; 
//*****************************************************************/
$result = mysql_query("SELECT * FROM autoalto_mail where flag!='1'  limit $eu, $limit" ); 

//code for paging
//************************************************************************** 
$selcount = "SELECT * FROM autoalto_mail ORDER BY primarykey column name DESC" ;
$selcount =  "SELECT * FROM autoalto_mail where flag!='1'" ;
$result2=mysql_query($selcount);
$nume=mysql_num_rows($result2);
//echo $nume;
//session_register("nume");
//$nume = $_SESSION['nume'];
//session_register("nume");
$_SESSION['nume']=$nume;

//echo "<table>";
//**************************************************************************
while($row = mysql_fetch_array($result)) 
{?> 
<tr class="sectiontableentry2" ><!--<td width="5%"></td>-->
<td><? echo $row['From_user'];?></td> 
<td><a href="contractor_inbox.php?start=<?=$start?>&limit=<?=$limit?>&mail_id=<?=$row['mail_id'];

//session_register("mail_id");
//session_register("mail_id");
?>">
<?echo $row['subject'];
$subj=$row['subject'];
session_register("subj");?> </a></td>
<td><?echo $row['date'];?></td>
</tr>
<!--<tr class="sectiontableentry1"></tr>

<!--<tr class="sectiontableentry1"><td width="5%"></td>
<td colspan="4" style="background-repeat: repeat-x;" background="images/dot.jpg" height="0" width="300"></td></tr>-->
<?
}?>
</table>
<?
if($nume > $limit)
{
//Counting no of pages and the current page.
$totnumofpages = round($nume/$limit);
$i=0;
$l=1;
for($i=0;$i …
Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Re: Next button:Help

No its not like that, see if the current mail is 2nd and if i click on the next link it should be possible to open the 3rd mail. which ever i open , if i click on the next link. it should be possible to open the next mail corresponding to the opened current mail.

Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Next button:Help

Hi all,
I have an inbox, if i click on the inbox which will display list of mails. now i have next button,
if i click on the next button it should be possible to display the next mail with respect to the current opened mail.
how to do this . Pls help me out.

Thanks in advance

Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Upload file

Hi all,
I have the code for uploading the file......but to store the uploaded file in database
and how to retrieve the uploaded file......
i want the code and logic

Thanks in advance

Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Problem...in page navigation

Hi, here is the code for page navigation, its working fine but , if there are 4 pages , each page is displaying 3 records per page, if we go to 3rd page, and click on the subject it will display the contents but it will automatically come to the 1st page,,,,,,i dont want it to come to the first page. i want it to be remain in the same page where the user has clicked .......because i my code in half page i am showing records, if he click on some subject , in the second half of the page it is displaying contents as soon as he clicks.....so if he goes to 4th page and clicks on some subject it will show the contents but the first half portion of the page where i am displaying the records will automatically go to first page,,,,,,,,,,the second part will remain same......so help me out
here is the code..

<?
session_start();
include('database.php');
$page_name="contractor_inbox.php";
//$limit=sql_quote($_GET['limit']); // Read the limit value from query string.
$limit=$_GET['limit'];
//$start=sql_quote($_GET['start']); // To take care global variable if OFF
$start=$_GET['start'];
if(!($start > 0))
{ // This variable is set to zero for the first page
$start = 0;
}

$eu = ($start - 0); 
if(!$limit > 0 )
{ // if limit value is not available then let us use a default value
$limit = 4; // No of records to be shown per page by default.
} 
$this1 = $eu + $limit; 
$back = $eu - …
Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Correct Syntax

Hi all,

$selcount = "SELECT * FROM autoalto_mail as a1, autoalto_contractor_sentitems as a2 where a1.flag=a2.flag='1' " ;
Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Re: Can i use two tables in a single query

HI
is this correct.

SELECT * FROM autoalto_mail as a1, autoalto_contractor_sentitems as a2 where a1.flag='1'=a2.flag
Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Can i use two tables in a single query

Hi all,
I have created inbox, sent and Trash......now
The deleted items in inbox is going to trash,,,,i mean i written the query only concerned with inbox......but now i want the deleted items of sent should also go to trash......
how can i write that query...........

I have written like this for inbox deleted items

$selcount = "SELECT * FROM autoalto_mail where flag='1' " ;

so what sent .......pls help me out.......

Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Re: Problem in displaying inbox

Hi i wrote this statement but still its not working ..........i want the recent date which has entered should appear first............

$selcount = "SELECT * FROM autoalto_mail ORDER BY date DESC" ;
Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Problem in displaying inbox

Hi all,
I have created an inbox......which will show list of values......
if some new data added in inbox......it will be the last in the inbox table. i want the new entries
should appear first.

can u help me out...........

Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
IS the where condition is correct.

Is the where clause is correct.......

$query1="SELECT * FROM  autoalto_mail where mail_id='".$mailid1."' AND where flag='1'";

I am getting this error after executing this statement.
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\xampp\htdocs\demonew\contractor_trash.php on line 220

Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Re: Retrieving value from session

Yes I got it thanks............

Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Retrieving value from session

Hi all, i am storing the value in session but while retrieving its showing the some other value.....totally i want this stored value in the next page .........can u help me...........
This is the code i am storing the value in session

<? 
session_start();
include('database.php');
$mailid1 = $_GET['mail_id']; 
session_register('mailid1');
echo $_GET['mail_id'];

$query1="SELECT * FROM  autoalto_mail where mail_id='".$mailid1."'";
$result = mysql_query( $query1 );
//echo mysql_num_rows($result) ;
while($row = mysql_fetch_array($result))
{ 
    echo $row['contents'];
}
mysql_close();
?>

This is the code where i am retrieving value from the session

<? 
session_start();
include("header.php"); 
include('database.php');

$mailid1 = $_SESSION['mailid1'];

echo $mailid1;


$query1="UPDATE  autoalto_mail SET flag='1' where mail_id='".$mailid1."'";
$result = mysql_query( $query1 );
//echo mysql_num_rows($result) ;

mysql_close();
?>
Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
A small problem in page navigation

Hi, here is the code for page navigation, its working fine but , if there are 4 pages , each page is displaying 3 records per page, if we go to 3rd page, and click on the subject it will display the contents but it will automatically come to the 1st page,,,,,,i dont want it to come to the first page. i want it to be remain in the same page where the user has clicked .......because i my code in half page i am showing records, if he click on some subject , in the second half of the page it is displaying contents as soon as he clicks.....so if he goes to 4th page and clicks on some subject it will show the contents but the first half portion of the page where i am displaying the records will automatically go to first page,,,,,,,,,,the second part will remain same......so help me out


First part of the page to display the records.

<?
session_start();
include('database.php');
$page_name="contractor_inbox.php";
//$limit=sql_quote($_GET['limit']); // Read the limit value from query string.
$limit=$_GET['limit'];
//$start=sql_quote($_GET['start']); // To take care global variable if OFF
$start=$_GET['start'];
if(!($start > 0))
{ // This variable is set to zero for the first page
$start = 0;
}

$eu = ($start - 0); 
if(!$limit > 0 )
{ // if limit value is not available then let us use a default value
$limit = 3; // No of records to be shown per page by default.
} 
$this1 = …
Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Re: Serialize method.

Hi all
what is the syntax of the implode fuction how to use it.....in my application

Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Re: Page navigation problem:urgent

Thank You very much................I got it..........

Web Development php
Member Avatar for ishlux
ishlux -3 Junior Poster
Serialize method.

Hi all,

$a1 = $_POST["a"];
$servicec = addslashes(serialize($a1));

i used this code to store the check box values in db with comma seperated
it has stored like this....a:5:{i:0;s:18:"vehicle Inspection";i:1;s:14:"batteryservice";i:2;s:10:"oil canhge";} but while retrieving its displaying in the same manner
but i want dont want to display like this.....i want it to be displayed normally,,, what to do.......

Web Development php