I want to select a field value from the database and surround it with a link, but do it within the query not after!
Ie.
$sql = "SELECT foo as foo FROM mytable WHERE this_id = $id";
Output:...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/...
I am doing a db query, and using pagination.
When setting limit in mysql query it is not working. Instead of displaying 50 results per page it is displaying thousands.
I know that my set limi...
http://www.experts-exchange.com/Database/MySQL/Q_23454607.html
How do i write the end of this query.
if $cid_query is null/empty search records COMPANIES.COMPANY_ID BETWEEN 7000 and 7228
if $cid_query has numeric value search single record COMPANIES.COMPAN...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/...
1) I am not sure if I have this syntax correct, specifically lines 5 and 6.
2) Also, in line 6 I want it to search all region_ids if null, otherwise search specific region_id. Is line 6 doing th...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/...
I'm using PHP generated by Dreamweaver in an online form, and it WAS working fine, up until I removed some of the required fields, both from the code and the db.
I've triple checked all the field...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_22932803.html
I have an UPDATE command in my PHP for MYSQL. The confusing fact is that when I shorten the string that contains the UPDATE command string it works without an error.
Here is the string that r...
http://www.experts-exchange.com/Database/MySQL/Q_23039224.html
Hi, I'm trying to build a form which include a couple of text fields and check boxes, the purpose of the form is basically for reporting, data can be save and retrieve:
text fields such as: first...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/...
I have a loop that pulls data from a mysql database using php. I know how to parse to make a bit of data shorter... i.e. if a zip code is 10 digits, I can use
$LEGALZIPGOOD = substr("$LEGALZIP"...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/...
I have two data fields, Phone and Zip... currently, they DO NOT include dashes.
I want them to include dashes.
How do I take the phone number of 1234567890 and run a query on the entire datab...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/...
Each month, I run a script that adds up data from our clients' accounts and the volume they run through our system. In a certain table, for example, I have a client number that identifies the clien...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_23312061.htm...
