How can I use two parameters for a URL?
I have set a link like so:
<a href="blog.php?id=<?php echo $row_rs_blog['blog_id']; ?>-<?php echo $row_rs_blog['blog_url']; ?>">
So, in the address bar it will look like this:
http://website.com/blog.php?=1-this_is_my_record_title
Is it possible to pass two variables into a recordset, and if so, how do I set the SELECT so I am using two variables? Currently I am getting: 'Query was empty'.
This is how I have set my recordset on the detail page, but obviously something is wrong:
$colname_rs_blog = "-1";
if (isset($_GET['id'])) {
$colname_rs_blog = $_GET['id'];
}
mysql_select_db($database_PowerCMSConnection, $PowerCMSConnection);
$query_rs_blog = sprintf("SELECT * FROM tbl_blog WHERE blog_id = %s AND blog_url = %s", GetSQLValueString($colname_rs_blog, "text"));
$rs_blog = mysql_query($query_rs_blog, $PowerCMSConnection) or die(mysql_error());
$row_rs_blog = mysql_fetch_assoc($rs_blog);
$totalRows_rs_blog = mysql_num_rows($rs_blog);