Code: Select all
<?php
SELECT name, address, smalldescription, type, location, icons, smallpic, blackline
FROM listing
WHERE type = 'coltype' OR address LIKE '%coladdress%'
ORDER BY name ASC
?>thank you in advance
Moderator: General Moderators
Code: Select all
<?php
SELECT name, address, smalldescription, type, location, icons, smallpic, blackline
FROM listing
WHERE type = 'coltype' OR address LIKE '%coladdress%'
ORDER BY name ASC
?>Code: Select all
$i = $_GET['query_num']; // if getting from a url
switch ($i) {
case 1: // if $_GET['query_num'] was 1
// do query 1
break;
case 2: // if $_GET['query_num'] was 2
// do query 2
break;
case 3: // if $_GET['query_num'] was 3
// do query 2
break;
}