number of visits: $visitcount"; // <--- Should be zero.
I think that there is one visitdate (NULL), so one row is returned.
HTH,
Tobey Wheelock
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Wed, Dec 17, 2003 at 07:43:50PM -, Shaun wrote:
> I need to retrieve the data and column names from a single row in a table,
> i.e. 'SELECT * FROM Table WHERE Field_ID = 1'
Maybe something like this:
$result = mysql_query ("SELECT * FROM Table LIMIT 1",$db);
$my_row = mysql_fetch_array ($r
On Mon, Dec 15, 2003 at 03:49:31PM -0700, Jas wrote:
> $sql = mysql_query("SELECT hostname FROM $table WHERE vlan =
> $_POST[dhcp_hosts]",$db)or die(mysql_error());
Maybe like this?
$sql = mysql_query("SELECT hostname FROM $table WHERE vlan = '".
$_POST["dhcp_hosts"]."'",$db)or die(mysql_error()