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/...
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 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...
We have following configuration at our server.
Hardware: Dual Processor, 4 GB RAM
Software: PHP 5.0, Mysql version: 5.0.51a
We have Product and Category database tables. Currently we have arou...
http://www.experts-exchange.com/Database/MySQL/Q_23537144.html
I need to search a tab delimited file for a matching SKU number ( regardless of Case, spaces, dashes, decimal points, etc... similar to the SQL LIKE command) and have the PHP print out all the mat...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_11455938.htm...
Zones:
PHPDate Answered: 10/04/2000 Grade: A Views: 0
ok, im probably not going to explain this very well being a mySQL/PHP newbie but il give it my best shot and hopefully someone can help me out here...
basically im setting up a site based around...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/...
hi i created a login page where the username and password is stored in the database.
and after the user have successfully logged in he is redirected to the main content of the site.
this is a ...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/...
