Okay here is the full code. Now I got this code off a friend! In this first
section to display the data that is grabbed from the db.
?php
$db = mysql_connect(localhost, user, pass);
mysql_select_db(db_select,$db);
$result = mysql_query(SELECT `nickname` FROM tipping
WHERE 1
Hi there everyone,
I have a little problem, I could do this with 2 seperate queries but if I
can do it with 1 then even better ;-)
I have to list items in numeric order IF the field isn't empty (ie: 0 comes
at the top, followed by 1 etc ) and that isn't an issue as PHP with
MySQL makes
Hi there,
I tried something similar:
$query = SELECT * FROM videos WHERE videomakers_website_url = '$x' AND
privatepublic = 'public' AND producer_website LIKE '%$x%' OR
videomakers_website_url LIKE '%$x%' ORDER BY videomakers_site_position ASC,
video_title ASC LIMIT $offset, $item_perpage;
JeRRy wrote:
Okay here is the full code. Now I got this code off a friend! In this first
section to display the data that is grabbed from the db.
?php
$db = mysql_connect(localhost, user, pass);
mysql_select_db(db_select,$db);
$result = mysql_query(SELECT `nickname` FROM
Chris Payne wrote:
Hi there,
I tried something similar:
$query = SELECT * FROM videos WHERE videomakers_website_url = '$x' AND
privatepublic = 'public' AND producer_website LIKE '%$x%' OR
videomakers_website_url LIKE '%$x%' ORDER BY videomakers_site_position ASC,
video_title ASC LIMIT $offset,