I have query with anchor tag in php mysql?

If i click on city link give data order by city.same for username

Expand|Select|Wrap|Line Numbers

 
<html>

<body>
 
<p>

<a href="searchorderby.php" >User Name</a> &nbsp;&nbsp;

    <a href="searchorderby.php" >City</a>

</p>

<p></p>

<table border="1">

<tr>

<td>userid</td>

<td>usernmae</td>

<td>userpassword</td>

<td>address</td>

<td>gender</td>

<td>city</td>

<td>Birthdate</td>

</tr>
 
<?php 

$link=mysql_connect("localhost","root","");

mysql_select_db("login");
 
$queryfirst="SELECT * FROM userinfo ";
 
$result=mysql_query($queryfirst) or die(mysql_error());
 
while($row=mysql_fetch_array($result))

{

?>

<tr> 

<td><?php echo $row['userid']; ?></td>

<td><?php echo $row['username']; ?></td>

<td><?php echo $row['userpassword']; ?></td>

<td><?php echo $row['address']; ?></td>

<td><?php echo $row['gender']; ?></td>

<td><?php echo $row['city']; ?></td>

<td><?php echo $row['Birthdate']; ?></td>

</tr> 

<?php 

}

?>
 
</table>

</body>

</html>

Dec 11 '10 #1

Subscribe Post Reply

4115

johny10151981

1,059

1GB

you did nothing to be ordered as User name or as city name

here is a piece of suggested

Expand|Select|Wrap|Line Numbers

  
<a href="searchorderby.php?order=user" >User Name</a> 

&nbsp;&nbsp;

<a href="searchorderby.php?order=city" >City</a>
 
<?php

 $link=mysql_connect("localhost","root","");

 mysql_select_db("login");
 
 if(isset($_GET['order'])==false) 

  $queryfirst="SELECT * FROM userinfo ";

 else if($_GET['order']=='user')

    $queryfirst="SELECT * FROM userinfo Order By UserName";

    else if($_GET['order']=='city')

    $queryfirst="SELECT * FROM userinfo Order By City";

    else

$queryfirst="SELECT * FROM userinfo ";
 
?>

Dec 12 '10 #2

by: Jochem | last post by:

Hello, Lately I came accross this problem a couple of times, and I know there must be a clever solution. However, I did not find it untill now. When I add a entry to my mysql database from a...

PHP

SQL query help , MySQL 4.1

by: Alexei Vladychevski | last post by:

i have 2 tables forumMsg forumTopic id idTopic Text idUser Views id Topic TopOrder -------------------------------------- ...

MySQL Database

General Query Log mysql

by: WhatsPHP | last post by:

Hi I have this MySql and PHP installed on the same machine. The Mysql general query log was started with mysqld --log, to log all the queries that will be received by the mysql server. This does...

PHP

Query inconsistency (MySQL vs PHP)

by: svein.tjonndal | last post by:

I have the following query: select DATE_FORMAT(accountingdate,"%c") as month,sum(totalprice - freightcost - insurancecost - vat2 - vat3 - vat4) as totalprice from invoice where cancelled=0 and...

PHP

Erratic performance for a specific query in MySQL

by: umangjaipuria | last post by:

I have two job queues doing complimentary work and writing their output once a minute into a file. The files for each minute have to processed in pairs - one from the first job queue and one from...

MySQL Database

Query 2 MySQL databases in 1 statement

by: noor.rahman | last post by:

I was wondering how it may be possible to query 2 MySQL databases using one query statement from PHP. For instance: SELECT database1.tableA.field1 UNION database2.tableB.field2. My concern...

PHP

Query inconsistency (MySQL vs PHP) -> DATE_FORMAT

by: laverdir | last post by:

<? $query = "SELECT " . $this->tabela3 . ".id, " . $this->tabela3 . ".naziv, " . $this->tabela3 . ".spisatelj, " . $this->tabela3 . ".najava, " . " DATE_FORMAT(" . $this->tabela3 ....

PHP

transpose result of query from mysql

by: danielbl | last post by:

I need of result below in different way Thanks any help! QUERY: SELECT t.`trafego_data`, u.`uf_sigla`, sum(t.`trafego_qtd`) as trafego_qtd

MySQL Database

i need a hibernate query for mysql query

by: hridya | last post by:

I am new to hibernate can any one help me to make a hibernate query for ths mysql query select distinct hremployee1_.id as id8_1_ from hr_emp_attendance hrempatten0_ inner join ...

MySQL Database

how to insert a query into MYsql Db residing on my local host

by: koti688 | last post by:

Hi Guys, I am a beginner to perl. I need a perl package which will perform basic DB operations like select , insert,update,delete operation MySql DB. i Have a Mysql DB which resides on my local...

Perl

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

I have query with anchor tag in php mysql?

Similar topics