Cristianh21

	Echo out two values from database 10 Years Ago 10 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hi, i'm trying to select two values from my database. $nc ='North Carolina'; $t ='Hello'; $q = 'SELECT COUNT(state, title) AS c FROM all WHERE state = "' . mysql_real_escape_string($nc) . '" AND title = "' . mysql_real_escape_string($t) . '"'; $rq = mysql_query($q); $fetch = mysql_fetch_assoc($rq); $count = $fetch['c']; echo … Web Development count database echo php values 0 3 277
	echo a picture from your folder file 10 Years Ago 10 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hello, I'm having a problem with my code. It seem to only echo out the picture name from my database and not the picture. This is my code search.php $result = mysql_query("SELECT * FROM all WHERE (`title` LIKE '%".$query."%') OR (`add_type` LIKE '%".$query."%')") or die(mysql_error()); if(mysql_num_rows($result) > 0) { while($results … Web Development echo folder php picture 0 3 279
	Count the number of post from database 10 Years Ago 10 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Im having a problem with this. I want to echo out the number of post from every city in N.C Example: Wilmington (24) <--*24 is the number of post. Charlotte (35) Raleigh (15) include "connect.php"; $wil ='Wilmington'; $cnt = mysql_num_rows(mysql_query("SELECT add_city FROM dbAdd WHERE $add_city='$wil' ")); echo $cnt; This is … Web Development count database number php 0 4 295
	Submit form to create a new page 10 Years Ago 10 Years Ago Share on Facebook Share on Twitter Share on LinkedIn THIS CODE IS TO DISPLAY THE DATA FROM THE DATABASE AFTER THE FORM HAS BEEN SUBMITTED. THE PROBLEM I'M HAVING HERE IS THAT WHEN I SUBMIT THE FORM THE LINK IS NOT WORKING. IT GIVES ME THIS : http://yourweb.com/test2.php?id= INSTEAD OF : http://yourweb.com/test2.php?id=23 HOW CAN I FIX THIS? THANK YOU! … Web Development php 0 4 256